Excel 2019 Pivot Tables Tutorial

Excel 2019 Pivot Tables Tutorial

Get Ad-Free Training by becoming a member today!

Who it's for: Anyone who uses Excel and wants to learn one of the most powerful tools Excel offers.

What it is: Pivot Tables helps you easily take a very large dataset and create a table that only displays the information you need.

What you'll learn: You’ll learn how to easily create, modify, and update Pivot Tables and charts.

For ad free training and certificates please join Learnit Anytime:

Enroll in our live, instructor-led Excel classes:

For Private Group Trainings please visit:

Start 0:00
Introduction 0:03
Data Mining 2:40
Adding Related Data Using VLOOKUP 13:35
Inserting Pivot Tables 26:23
Setting Up Pivot Tables 30:51
Building Pivot Tables 36:56
Filtering and Slicing Pivot Table Data 42:21
Changing Source Data and Refreshing Pivot Tables 48:23
Inserting Pivot Charts 55:17
Using Tables to Build Pivot Tables 59:28
Finding Correct Layouts for Reports 1:05:37
Setting Default Layouts for Reports 1:11:03
Using Pivot Table Styles 1:14:25
Subtotals and Grand Totals 1:18:03
Creating Report Pages 1:20:31
Adding the Power Pivot Tab to Excel 1:27:13
Creating Tables for the Data Model 1:30:36
Adding Relationships with Power Pivot 1:34:32
Using DAX Expressions with Power Pivot 1:40:18
Creating Pivot Tables with Power Pivot 1:42:21
When to Use Power Pivot 1:46:03
Conclusion 1:47:33

#Excel

(C) 2021 Learnit, Inc.
Any illegal reproduction of this content will result in immediate legal action.

[richardcamilomorales]

Thank you Faz ... Thank you Learn It ... You guys deserve a Nobel!!

[peterengesser]

It always amazes me how you guys make learning so much fun! Thanks to Faz and everyone at Learnit. My boss has been bugging me for so long to gain insight on Pivots. And now I did - thanks to you! Regards from sunny Switzerland - Nicole

[muhunthanharinath]

Guys at the Learnit Training team, thank you so much. This tutorial was really useful, taught simply and at the right pace.

[lisag]

I had a really hard time finding the worksheet for the lesson starting at 1:27:13. The tab was labeled "Adding Related Data_VLOOKUP", not "Data Model Basics" as is shown in the video. Other than that, I think everything taught in this video was really explained well and easy to follow. Thank you!

[sushobhon_ROY]

Outstanding course that is available on YouTube much required course for all the analytics role, love from Kolkata, India🤗

[debbiegallegos]

This is my favorite EXCEL Table tutorial I have found. Learned alot!

[divineasem]

You are a super teacher. Very detailed explanation. My best experience so far with learning excel online.

[robw]

What a great presentation! Thank you so very much as this will be a resource I come to time and again!!!

[basharatmsts]

Sir, I am really grateful to you for such knowledgeable training

[Silas]

Great Video. Pivot Tables are probably my favorite function of Excel. Thank you for the detailed course!

[neelapenmatsa]

Detailed explanation regarding the utilization of the excel pivot tables was helpful. Thank you.

[leanne]

Thank you very much, I am starting a new job role next week. It is a role where I will have to use pivot tables and that isn't something that I have done before. Using your tutorial has enabled me to build my confidence with using them and some of the formulas that you can use in Excel. I really think my Excel skills will improve through doing this role.

[BrendaATovar]

Thank you very much for your time for creating this video. The explanation was very clear and professional. Definitely your videos are highly recommendable for people that wants to built more knowlege on their resumes like me.

[Anglegirl]

Hi, I had difficulty locating the Data Model sheet, so I just created a dup sheet from your Adding Related Data VLookup and was able to get it done. Love how you explain step by step. I have not used Pivot or Vlookup in so long, I just needed, a brush-up and, it all came back to me. The bonus was the Power Pivot. Thank you.

[CHENYUNKE]

What a great course. Now I know a lot about the topic. Thanks Faz & learnit team!

[ishish]

You do really good tutorials. I watched the excel advanced tutorial and it really helped me out a lot. Great job man

[jcm]

Very clear and easy to follow, well done!

[elijahd.spragueph.d]

You are a brilliant instructor, keep up the great work.

[thandarwin]

Thanks Faz. It is surely useful. Except a little big long video, it is quite impressive to learn. I can see your skill of conducting lessons clearly.

[patwhittome]

Super training - very clear and concise with good examples. Thank you!