Interested in attending? Have a suggestion about running this course near you?
Register your interest now
Microsoft Excel is one of the most important computer applications for accountants and finance professionals at all levels.
Power Query (Get & Transform in Excel 2016 and newer versions) and Power Pivot within Microsoft Excel lets you connect, gather, transform, and combine data very efficiently, which will enable any finance, accounting, tax professionals to automate processes that are very manual and repetitive.
This is an introductory workshop that will help you develop the basic skills to start transforming and analyzing data with Microsoft Excel Power Query and Power Pivot. After completing this workshop, you will be able to get data from various sources, prepare and analyze large amount of data efficiently using Power Query and Power Pivot. With his background in Accounting and Tax, the Trainer will be using Profit and Loss, Balance Sheet or POS data in the examples and hands-on exercises. This will facilitate learning and allow you to directly apply your knowledge learned in the workplace.
A more advanced workshop in Power BI will be conducted subsequently if you wish to take your skills on M and DAX further after this session.
By the end of the workshop, you will :
Connect and transform data using Power Query
Advanced data transformation techniques (M)
Data modeling and DAX
Analyze and visualize data using Power Pivot
You are required to bring along an internet-enabled laptop (Windows only)*.
Your laptop should be installed with one of the following Microsoft office products*
* Please note Power Pivot is NOT available in the following subscriptions:
To check which Office product is installed on your laptop:
John is a US Certified Public Accountant licensed in New York State. He leads the business intelligence service practice of A Tax Advisor Pte Ltd, and provides a variety of solutions (e.g., technology and data strategy, data transformation and integration, process improvement and automation, and data analytics services) and business process outsourcing services to corporate finance and tax departments.
John utilizes over fifteen years of combined experience in corporate financial reporting and analysis, corporate tax compliance and provision, executive financial dashboard management, technology and performance improvement, data modeling and warehousing, and ERP integration to assist corporate finance and tax functions with improving performance and managing business risk using business intelligence.
Before joining A Tax Advisor Pte Ltd, John was part of EY’s Tax Technology and Transformation group (formerly known as Tax Performance Advisory) in Washington, New York City and Singapore.
Prior to joining EY, John was a financial analyst in charge of the development of Business Objects tools, data modeling and warehousing, and executive financial dashboard management for a global manufacturing company in the United States.
This is a face to face event, to be conducted on 19 November 2020