If you are a novice at using Power Pivot, you're not alone. Although it’s one of Excel’s most useful features for accountants, not many of us know what is it or how should we be using it.
Power Pivot is an Excel add-in available in Excel 2010, certain versions of Excel 2013 and later. Power Pivot, with its own DAX functions, can be used to perform complicated data analysis and to create sophisticated data models. This makes it a powerful tool for accountants.
In this course, you will learn to use Power Pivot at an expert level. You will become comfortable with Power Pivot Models, using Pivot tables and charts, as well as carrying out calculations and time intelligence functions.
It is recommended that you have a good understanding of Excel’s standard pivot tables and charts before taking this course. If you are a beginner with Excel we recommend starting with the course, Basic Data Analysis for Accountants in Excel.
CPD: 4 hours
Paula Guilfoyle is a member of the Institute of Certified Public Accountants in Ireland. She practiced in Industry for over 15 years, working with both small and large private companies, before moving on to teach Excel and Power BI to accountants and professionals. Paula has given many talks and presentations in the areas of Excel, spreadsheet use, PowerBI and business intelligence, and has published many articles on the same subjects.
£75 + VAT (Non-members)
ICSA Members and Students get a discount of 10% with the code ICSA101