In this course we teach you how to make the most of this powerful data analysis function.

We begin with a PivotTable refresher before moving on to some of the advanced features of this tool. Advanced Sorting, Slicers, Timelines, Calculated Fields, Pivot Charts, and Conditional Formatting are just a few of the subjects included in this PivotTable deep-dive.

 You will learn to:

• Efficiently import and prepare raw data from diverse sources like text files and Access databases, employing powerful cleaning and transformation techniques.
• Master advanced calculations, including summarizing values differently, creating calculated fields and items, understanding solve order, and utilizing the GETPIVOTDATA function.
• Implement sophisticated sorting and filtering methods, from standard options to custom lists and applying multiple criteria simultaneously for precise data isolation.
• Add interactive elements like Slicers and Timeline Slicers to build dynamic, user-friendly reports and connect them to multiple data visualizations.
• Create impactful PivotCharts, including different chart types like line, bar, column, doughnut, and even specialized ones like Map Charts and Sparklines, along with comprehensive formatting techniques.
• Apply conditional formatting rules to visually highlight key trends and outliers within your pivot tables and charts.
• Bring all your skills together to design and build comprehensive, interactive dashboards that communicate complex information clearly and effectively, and learn how to easily update them with new data.

This course is perfect for intermediate users of Excel who are comfortable using the PivotTable function. We don’t recommend this course for people brand new to Excel.