Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Excel Pivot Tables Tutorial - From Basics to Advanced Techniques

Learnit Training via YouTube

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
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.

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

Reviews

5.0 rating, based on 1 Class Central review

Start your review of Excel Pivot Tables Tutorial - From Basics to Advanced Techniques

  • Profile image for Sarah Kozel
    Sarah Kozel
    This was a very thorough training. Will be sure to come back for more! Loved the ability to work alongside the modules in the practice files. Also appreciated that he pointed to where each thing was making sure it was apparent to the viewer.

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.