Completed
Preparing Data for Analysis
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel Pivot Tables Tutorial - From Basics to Advanced Techniques
Automatically move to the next video in the Classroom when playback concludes
- 1 Start
- 2 Introduction
- 3 What are Pivot Tables?
- 4 Preparing Data for Analysis
- 5 Pivot Table Components
- 6 Building Pivot Tables to Show Different Values
- 7 Adding Fields to Pivot Tables
- 8 Using Built-In Filters
- 9 Filtering Data with Slicers
- 10 Displaying New Values from Data Sources
- 11 Inserting Pivot Charts
- 12 XLOOKUP
- 13 Joining Data Sets with XLOOKUP
- 14 Introduction to Advanced Pivot Tables
- 15 Inserting Pivot Tables from Tables
- 16 Calculated Fields
- 17 Using the Timeline Tool
- 18 Report Filter Pages
- 19 Pivot Table Layouts
- 20 Creating Pivot Table Designs
- 21 Adding Power Pivot Tabs to the Ribbon
- 22 Adding Tables to Power Pivot Data Model
- 23 Creating Table Relationships
- 24 Creating Columns with DAX Expressions
- 25 Displaying New Source Data in Power Pivot Tables
- 26 Data Mining with Flash Fill
- 27 Conclusion
