Corporate Training By Zack Academy - PowerPivot Fundamentals

Why Should You Take This PowerPivot Fundamentals Course?

This PowerPivot group class concentrates on how to create powerful pivot tables through multiple table relationships. By the end of the Excel PowerPivot training course, you will feel confident setting up relationships, creating and displaying complex PivotTables and using Calculated DAX columns. This class is perfect for those that have a fundamental understanding of Excel and using Excel Pivot tables and want to see more correlation between data. Those in the financial, real-estate or data analysis field will especially find this class enjoyable.

The Following Topics Will Be Covered:

Why PowerPivot?

• Benefits of PowerPivot
• Installing PowerPivot
• Overview of PowerPivot Ribbon
• Working with different data sources
• Importing Data
• Creating Relationships
• Linking Tables
• Calculated Columns
• Difference between Excel’s Compact Pivot Tables and Power Pivot’s Flat File Tables
• Using Slicers
• Creating 4 or more related pivot tables
• Available functions and their power
• Advanced Filtering
• Asymmetrical Reports
• Other PowerPivot capabilities