Course Overview

This course dives deep into one of the most powerful data presentation tools available in Excel.  At the end of this course, you should feel confident in producing quality PivotTables, PivotCharts and PivotTable dashboards that will efficiently provide solutions for data analysis. 

Financial Skills

What you will learn

This course highlights key mistakes and design aspects to avoid when creating PivotTables, providing insight into the design approaches needed to ensure that your PivotTables are not only robust, but also efficiently highlight trends in data.  

You will also learn what sort of Tables to create based on the kind of data you are working with, plus how to format and set value fields, apply filters, groupings and slicers, generate PivotCharts and develop an interactive dashboard. 

Course Structure

Delivered: Online, enrolment for 12 months.   

Course prerequisites: While there are no entry requirements, a basic understanding of Microsoft Excel is recommended.   

Assessment: Yes (Quizzes)   

Outcome: A completion certificate is issued by SumProduct upon successful completion of the course.  

Digital badge: You’ll be eligible for a digital badge, issued by FINSIA and Credly, available upon request. 

Enrolment information: Your details will be shared with SumProduct within 1 business day of enrolment.   

SumProduct will process your enrolment within 2 business days of receiving this information and will provide login details to access your learning via email. For any assistance, please contact our team at [email protected]. 

FINSIA member exclusive 

FINSIA members enjoy a 10% discount on SumProduct’s suite of online courses.*

 

*This discount has been applied to the member pricing displayed.