Power Pivot Fundamentals

CPA Members only

CPA Australia has partnered with the Corporate Finance Institute (CFI) to curate a collection of professional development courses exclusively for CPA members. CFI courses have an emphasis on hands-on, practical learning and skills acquisition. They teach in-demand industry practices, tools and techniques that help accounting and finance professionals build confidence, stand out from the competition, and make a positive impact on their careers.

Discover the full potential of Excel with this Power Pivot course, designed to elevate your data analysis and presentation skills. Youll learn how to utilize the Power Pivot add-on to create sophisticated business intelligence dashboards with PivotTables and PivotCharts. This course offers step-by-step instructions on setting up dashboards, covering essential functions and best practices that cater to both beginners and experienced users.

As the course progresses, youll engage in a hands-on project using provided data sets, applying your newfound skills to build a comprehensive dashboard. By the end of this journey, youll have the knowledge and confidence to construct your own Excel dashboards. These skills will enable you to effectively analyze data, track key performance indicators (KPIs), and make compelling time-period comparisons, transforming data into actionable insights.

Softweare requirements: As of 2020, Power Pivot functionality is not available for the Mac version of Excel. Because of this learners must use Windows to complete this training.

CPA Australia handles your personal information in accordance with the CPA Australia Privacy Policy. By proceeding you will be redirected to an external website to access the course.

Our Privacy Policy includes the following statement under the subsection Links to other websites:

• We may provide links to websites operated by third parties. 
• We are not responsible for the privacy practices or the content of such websites which will be governed by their own privacy policies to which you are advised to refer. 

Your satisfactory completion of the training module may be recorded against your CPD hours.

CFI programs will be supplied to CPA Australia members as standalone courses for 12 months from the date of purchase and as such, any associated CFI certifications are not able to be supplied. Refunds or extensions for purchases of CFI courses will only be available in exceptional circumstances and will be based on CPA Australia and CFIs cancellation terms