Master Excel's powerful Pivot Tables feature in this comprehensive tutorial designed for Excel users seeking to enhance their data analysis skills. Learn to create, modify, and update Pivot Tables and charts, transforming large datasets into easily digestible information. Explore data mining techniques, VLOOKUP for related data, and advanced features like filtering, slicing, and refreshing Pivot Tables. Dive into Pivot Charts, table-based Pivot Tables, and customizing layouts and styles. Discover the Power Pivot add-in, create data models, establish relationships, and utilize DAX expressions for complex calculations. By the end of this 1 hour 49 minute tutorial, gain the expertise to efficiently analyze and present data using one of Excel's most versatile tools.
Overview
Syllabus
Start
Data Mining
Adding Related Data Using VLOOKUP
Inserting Pivot Tables
Setting Up Pivot Tables
Building Pivot Tables
Filtering and Slicing Pivot Table Data
Changing Source Data and Refreshing Pivot Tables
Inserting Pivot Charts
Using Tables to Build Pivot Tables
Finding Correct Layouts for Reports
Setting Default Layouts for Reports
Using Pivot Table Styles
Subtotals and Grand Totals
Creating Report Pages
Adding the Power Pivot Tab to Excel
Creating Tables for the Data Model
Adding Relationships with Power Pivot
Using DAX Expressions with Power Pivot
Creating Pivot Tables with Power Pivot
When to Use Power Pivot
Conclusion
Taught by
Learnit Training
