Excel Pivot Tables Tutorial

Excel Pivot Tables Tutorial

Get Ad-Free Training by becoming a member today!

Who it's for: Excel users interested in one of the most useful tools Microsoft's spreadsheet app offers.

What it is: A Pivot Table is a powerful feature in Excel that analyzes complex datasets and streamlines that information into neat and tidy tables, displaying only the information you really need to see.

What you'll learn: In this comprehensive course, you’ll learn how to create, modify, and update Pivot Tables in Excel. We'll also show you how to create Pivot Charts and use XLOOKUP. For advanced users, we'll tackle Power Pivot, DAX expressions, data mining, and much more.

Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:

For Private Group Trainings please visit:

Username: manuals
Password: password

Start 0:00
Introduction 0:09
What are Pivot Tables? 1:44
Preparing Data for Analysis 7:18
Pivot Table Components 11:51
Building Pivot Tables to Show Different Values 18:09
Adding Fields to Pivot Tables 23:24
Using Built-In Filters 30:13
Filtering Data with Slicers 36:03
Displaying New Values from Data Sources 42:53
Inserting Pivot Charts 49:24
XLOOKUP 56:15
Joining Data Sets with XLOOKUP 1:04:27
Introduction to Advanced Pivot Tables 1:12:20
Inserting Pivot Tables from Tables 1:13:46
Calculated Fields 1:21:32
Using the Timeline Tool 1:27:22
Report Filter Pages 1:32:38
Pivot Table Layouts 1:39:21
Creating Pivot Table Designs 1:45:45
Adding Power Pivot Tabs to the Ribbon 1:53:11
Adding Tables to Power Pivot Data Model 1:55:54
Creating Table Relationships 2:00:56
Creating Columns with DAX Expressions 2:05:07
Displaying New Source Data in Power Pivot Tables 2:12:33
Data Mining with Flash Fill 2:15:24
Conclusion 2:21:27

#excel #exceltutorial #exceltips #exceltricks

(C) 2024 Learnit, Inc.

Any illegal reproduction of this content will result in immediate legal action.

[yugo]

Thank you so much Mo Jones, I thoroughly enjoyed this. You were very detailed, and you made Pivot tables tutorial look like its A, B, C. You are indeed a great instructor! Bless up!

[MosGel-lj]

This video on Excel pivot tables is excellent. It provides a comprehensive explanation with clear examples. Great work!

[diaashaaban]

I just wanna send love and thanks to the great instructor Trish Connor ❤️

[valeriemac]

All the steps are easy to follow and remember. Thank you so much for this informative tutorial video!!

[samueltafere]

I very much admire you for your presentation

[MicrosoftSolutions]

It seems you have done this work from the heart! Can you give me some tips after looking at my work too?🙏

[klyuvert]

i didn't know anything about power pivot, thanks a lot

[entertaimentoo]

Thanks for this kind of productive course of Excel. Please make more videos about excel we really want to learn Excel from this Channel.
❤ Love from India.

[lwazimthembu]

I believe in this channel, you guys taught me Sharepoint 🙌, I'm still learning thou

[ragulmarley]

😊 really good nice explanation any video for power bi sir

[adamtabor]

Easy explained and for that very useful.👍

[benosborne]

Great. Thanks. Pity it does not update automatically. Must refresh every time

[jeangreen]

This is a wonderful tutorial, thank you so much for the opportunity to learn about pivot tables! May I please ask your opinion on creating a payroll system for 10 employees using pivot tables? Do you see any cons? Thank you again for your expertise and time!

[chukylo-kh]

Why is the Analyze Data shortcut is not popping up when I type the "quick is there somewhere it can be turned on and off?
1- Total sales for state: TX =$17, 647.00
2- Total sales for City: Salem =$21, 152.00
3- # of Production packages sold = 42
4- Total commission earned @5% = $7, 822
5- Commission for Cara Olson = $1, 227
6- Total sales for Q2 IN 2023 =

comment if you arrived at the same value.... T for Thanks..😛

[xxLvlxx]

Hi, I wanted to follow the tutorial but I can't find the Excel options screen. In my ribbon I don't have the files tab next to home. Do you have any idea how to open that? Thanks 🙏

[kirlexff]

Sir i need corel draw tutorial. plzz 🙏🙏