Master Excel Pivot Tables in this comprehensive 2-hour 23-minute tutorial. Learn to create, modify, and update Pivot Tables, analyze complex datasets, and streamline information into neat tables. Explore Pivot Charts, XLOOKUP, Power Pivot, DAX expressions, and data mining techniques. Discover how to prepare data for analysis, use built-in filters and slicers, insert Pivot Charts, join data sets with XLOOKUP, and create calculated fields. Dive into advanced topics like Report Filter Pages, Pivot Table layouts and designs, Power Pivot Data Models, table relationships, and Flash Fill for data mining. Suitable for Excel users looking to enhance their data analysis skills and leverage one of the most powerful features in Microsoft's spreadsheet application.
Excel Pivot Tables Tutorial - From Basics to Advanced Techniques
Overview
Syllabus
Start
Introduction
What are Pivot Tables?
Preparing Data for Analysis
Pivot Table Components
Building Pivot Tables to Show Different Values
Adding Fields to Pivot Tables
Using Built-In Filters
Filtering Data with Slicers
Displaying New Values from Data Sources
Inserting Pivot Charts
XLOOKUP
Joining Data Sets with XLOOKUP
Introduction to Advanced Pivot Tables
Inserting Pivot Tables from Tables
Calculated Fields
Using the Timeline Tool
Report Filter Pages
Pivot Table Layouts
Creating Pivot Table Designs
Adding Power Pivot Tabs to the Ribbon
Adding Tables to Power Pivot Data Model
Creating Table Relationships
Creating Columns with DAX Expressions
Displaying New Source Data in Power Pivot Tables
Data Mining with Flash Fill
Conclusion
Taught by
Learnit Training
