Excel 2019 Pivot Tables Tutorial

Excel 2019 Pivot Tables Tutorial
Get Ad-Free Training by becoming a member today!
/ @learnittraining
Exercise Files: bit.ly/3wn3xLT
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:
www.learnitanytime.com
Enroll in our live, instructor-led Excel classes:
bit.ly/33ub9n0
For Private Group Trainings please visit:
www.learnit.com/private-group...
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.

[@richardcamilomorales1948]

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

[@LearnitTraining]

Thank you for the kind words Richard! An extra big thank your for subscribing it helps a lot!

[@peterengesser5295]

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

[@LearnitTraining]

Great to hear!

[@basharatmsts]

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

[@ishish1]

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

[@heavens988]

Very Good Tutorial, revived me the basics & advanced features, thanks a lot!

[@CHENYUNKE]

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

[@LearnitTraining]

Thank you for all praise iphrank! We hope you are learning alot!

[@muhunthanharinath7486]

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

[@LearnitTraining]

Glad it was helpful!

[@patwhittome6583]

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

[@LearnitTraining]

You're very welcome!

[@shashankkumar6206]

It was really an amazing session, Loved it.

[@LearnitTraining]

Glad you enjoyed it!

[@habibsicttutorials6684]

This is very useful learning. I've done any tutorials in pivot yet but will be soon.

[@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.

[@LearnitTraining]

You're very welcome!

[@jacobm7026]

Seriously, guys, amazing work here. Thank you for doing all these videos on here.

[@LearnitTraining]

Our pleasure!

[@jessicawillie6094]

Great tutorial! Good for refresher or those just learning. Thank you!!

[@LearnitTraining]

You're very welcome!

[@sushobhon_ROY17]

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

[@LearnitTraining]

Thank you for watching Sushobhon!

[@Anglegirl713]

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.

[@LearnitTraining]

You are very welcome!

[@lisag3359]

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!

[@ibbzy8629]

I know is been months, but U had to download the whole files from their website, not only the first part of the session. If u did download all of them, check where u saved them and open the files(it has 3files).

[@debbiegallegos5116]

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

[@LearnitTraining]

Glad it was helpful!

[@divineasem6197]

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

[@LearnitTraining]

Wow, thank you!

[@ashokbabuvelupula]

Thank you Faz It was very helpful for me to learn Pivot Tables.

[@LearnitTraining]

You are welcome! Also thank you for subscribing!

[@relivevideosdisusanfa7863]

This tutorial is great! thank you, even though i knew many of them but I still leant a lot of new hacks! thank you very much.

[@LearnitTraining]

You're welcome!

[@MsjAlexandria]

Thank you! This was easy to follow and soooooo helpful.

[@LearnitTraining]

You're so welcome!

[@Silas832]

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

[@LearnitTraining]

You're very welcome!

[@robw874]

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

[@LearnitTraining]

You are so welcome!

[@rajatkumar706]

Strongly recommend this channel

[@LearnitTraining]

Thank you Rajat!

[@marianaochoa9923]

THANK YOU, easy to understand

[@LearnitTraining]

Glad it was helpful!

[@gnm800]

Faz Karim, Thank you very much! You are an excellent instructor. The course helped me a lot. I have one question: in the Vlookup formula, is it really necessary to highlight the table_array before hitting the F4 to lock it?

[@tiffanybloke9076]

This was SUPER helpful. Great tutorial.

[@LearnitTraining]

Glad it was helpful!

[@leanne3308]

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.

[@LearnitTraining]

Best of luck!

[@ryanmagalong1857]

THIS IS FANTASTIC TUTORIAL! I'VE LEARNED A LOT! :)

[@LearnitTraining]

Awesome, thank you!

[@MdImranMozomder]

Thanks a lot for the video and grateful to you for the lesson.

[@LearnitTraining]

Our pleasure!

[@almerjm5936]

Cant wait to see and learn it.

[@armelchiza3771]

Amazing course. Thank you so much!

[@LearnitTraining]

You're very welcome!

[@neelapenmatsa8907]

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

[@LearnitTraining]

You are very welcome Neela!

[@mjxbb1983]

Amazing Tutorial！ Thanks so much!

[@LearnitTraining]

You're welcome!

[@isawhittaker9523]

Thank you Faz this is an excellent tutorial on pivot Table - God bless

[@LearnitTraining]

You're very welcome!

[@jcm6476]

Very clear and easy to follow, well done!

[@LearnitTraining]

Thank you so much JCM 64! Your support helps us to continue to make new videos!

[@luciamoreira9676]

Excellent tutorial Faz! excited to apply it to my work now :) Just one question, why do we "activate the windows"? Thanks!

[@shochibalfatih8821]

Thanks a lot. I appreciate it

[@thandarwin5348]

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.

[@LearnitTraining]

Glad it was helpful!

[@alang4127]

Great training! Keep up the good work!

[@LearnitTraining]

Will do Alan!

[@ndelpurg]

thank you for excellent teaching

[@LearnitTraining]

You are welcome!

[@elijahd.spragueph.d8905]

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

[@LearnitTraining]

Thank you so much 👍

[@Exambay]

Thanks , learnt a lot from your videos.

[@LearnitTraining]

Thank you for watching!

[@dianaabiemo5177]

Great Instructor. Thanks!

[@LearnitTraining]

You are welcome! Thank you for watching!

[@ThinkFutureAcademy]

Thank you very much for such a nice turotial on pivot tables.

[@LearnitTraining]

You are welcome!

[@yasminelmarasy4134]

This is just SUPER, Thank you for that

[@LearnitTraining]

You are very welcome Yasmin!

[@lallitarim8286]

Thank you so much Learnit

[@LearnitTraining]

You are welcome!

[@user-ii3qb6lw4j]

it was awesome! congratulations and thanks from brazil!

[@LearnitTraining]

You are very welcome!

[@dibyanshyadav281]

Nice tutorial

[@hamishreil5202]

Thanks Faz, This is very helpful and informative and I learned a lot super. ❤️❤️❤️

[@LearnitTraining]

Glad you enjoyed it!

[@annadankina5360]

Many thanks for that course!

[@LearnitTraining]

Very welcome!

[@Moalraheemy.]

Thank you Karim...marvelous ...i haven't got lost. One of the best.good job 👍

[@LearnitTraining]

Thank you for watching Mohamed!

[@rajatmishra1561]

Amazing tutorial ❤️.. Thank u

[@LearnitTraining]

You’re welcome 😊

[@JhayzBoy2012]

Thank you! It surely was helpful.

[@LearnitTraining]

You are very welcome!

[@Kranthi233]

Awesome explanation and content

[@LearnitTraining]

Thank you for the kind words Kranthi!

[@yagnyeswarsatapathy2429]

Thank you. It was helpful.

[@LearnitTraining]

You're welcome!

[@shoppersdream]

Very Nice! Thanks

[@LearnitTraining]

Our pleasure!

[@fredrickkenamoah9757]

Always on point Faz... Thanks boss

[@LearnitTraining]

Thank you for watching Fredrick!

[@hanrytahnok7513]

NICE video!!!, really helpful!!

[@LearnitTraining]

Thank you for the kind words Hanry!

[@hmbird47]

Thank you, Mr. Faz!

[@LearnitTraining]

Thank you for watching Hesham!

[@mss9466]

Awesome step by step tutorial. You make it so easy to understand and learn. Thank you!

[@LearnitTraining]

You're very welcome!

[@alexxgalindo8557]

You are amazing, thank you

[@LearnitTraining]

You are welcome!

[@lindab675]

Hi Faz this is an exceptional tutorial I had no idea there was so much to Pivot Tables. I have learned so much and I cant thank you enough🙏 . I just have one tiny gripe, could you please ease up on the AL RIGHTY PLEASE? 😂

[@LearnitTraining]

Glad it helped!

[@benedictndinemenu5846]

Thank you for a job weldone Faz

[@LearnitTraining]

So nice of you!

[@babuumakantvuppala9598]

Nice teaching techniques. Very good teacher indeed. A student's delight.

[@pb1209]

How do I find the power pivot on a mac? I'm using the most recent version of excel right now. Also, you have been a lifesaver, Faz. I've watched the beginning, advanced and now this video the last few days. It has been invaluable to me.

[@LearnitTraining]

Thank you for watching pb1 and we are glad we could help you out!

[@John36987193]

thank you very much

[@karinasahalian8643]

Thank you very much!!!!!!

[@LearnitTraining]

You're welcome!

[@shaantanuasthana969]

thanks a lot sir for this.

[@LearnitTraining]

Most welcome!

[@andredad559]

excellent tutorial

[@LearnitTraining]

Thank you! Cheers!

[@monicachau4416]

Thank you!

[@LearnitTraining]

You're welcome!

[@hakanaltintas1]

Super useful!

[@LearnitTraining]

Glad to hear!

[@emmanuelabiola7107]

Great tutorial

[@LearnitTraining]

Thank you for watching!

[@RebeccaPetropoulos]

This is a great tutorial and I've really learned a lot. One thing worked differently on my workbook though. When I selected the Central region on my Top Selling Salesperson table, then clicked to show the report filter page for Region, I didn't get one new sheet for Central. I got one sheet for each region EXCEPT Central. Is that controlled by a setting?

[@EastSideAussieQuest]

very good video. you talked at a pace i could keep up with. most others talk way to fast.

[@LearnitTraining]

Glad you liked it!

[@nickeax]

Thanks!

[@LearnitTraining]

Thank you so much Nick! Your support allows us to keep creating videos!

[@sonerguney3225]

Very good´ thanks

[@LearnitTraining]

Thank you very much!

[@mmbiographies]

I learn more than 100 ways to say "go ahed" than I couldn't even focus on the real tutorial 😂😂

[@LearnitTraining]

👍

[@jayartracker9546]

Thank you! I watched the whole video and I learned a lot here more than in school. Please keep doing something like this.

[@LearnitTraining]

Thank you! Will do!

[@sunnysengvilay780]

Do you have any tutorial for Pivot Tables for Inventory?

[@couragetamakloe4621]

Thank you, Faz. I've learned so much from watching your videos. With that said, is there a reason why you didn't just d =L2*(1-J2) and copy it down for Price by discount? That seems more straightforward.

[@LearnitTraining]

Thanks for the tip!

[@matthewdufty606]

Very good video

[@LearnitTraining]

Thanks!

[@synthstatic9889]

Should I be learning this first or SQL?

[@alexandrpopov1545]

Please, make a video about powerpivot!!!

[@Knoulech]

Great tutorial, easy to follow........I watched it, "And You Should Too". 👍

[@LearnitTraining]

Awesome, thank you!

[@Arbitraritorian]

A more detailed discussion about the different data fields in pivot tables (column, row, values, filters) would have been helpful for me. Overall, a nice intro.

[@LearnitTraining]

Great suggestion!

[@Nynymia]

Great courses and I love these from Learn it. Only 1 problem for now: the exercise files to download only has 002 and 003, there's no 001 of this Data Model file. could you advise where to get it?

[@LearnitTraining]

Hi Ny Mia! We will dig around and see if we have that laying around somewhere.

[@bloodknottrevelian3396]

Why use vlookup for the discount price when its just a simple calc using columns J and L?

[@NnotAMuggle]

The longer I watch this tutorial, the more I feel like Baymax is teaching me all about it. HAHAHAHHA! Dont know why this dude's voice just reminded me of Baymax's (•-•)

[@LearnitTraining]

Hahaha! We are definitely letting Faz know this!

[@benedictndinemenu5846]

how do I download the instructor file? please

[@redeemedgh]

Thanks a lot for the tutorial, Learnit. It's very educative and informational. The link to the exercise file is not working. Kindly rectify that.

[@LearnitTraining]

Updated!

[@kathyfigueroa4640]

More pivot table information please

[@zlee11]

I’m shopping for video tutorial software for employee trading videos. What software is used in the production of this tutorial? It looks very powerful.

[@LearnitTraining]

Hi Zlee11 - this is Camtasia. We use it for the recordings, the boxes and arrows are from Zoomit

[@josephm.6453]

my power pivot doesnt work, it shows "unable to cast COM object..." error

[@ryandasilva5866]

where can i find the full completed excel sheet

[@amadouanne57]

Hey guys thanks for the good job just wonder where's the "Excel 2019 Pivot Table Data Model file" could not found it

[@LearnitTraining]

Hi Amadou! The link to the exercise files is in the video description!

[@amadouanne57]

@@LearnitTraining Cheers I was too tired to actually see that I was just on the wrong table

[@redeemedgh]

@@LearnitTraining the link to the exercise file is not working. Kindly rectify that. Thank you.

[@nonof9772]

On the Data mining most of your examples did not come right to me for some reason and I tried many times. The FT/PT and the month comes with errors with out defining what the errors are for, but thank you anyway.

[@waikhomriganmani252]

The exercise file does not contain the file (excel 2019 pivot table)you are working on. Please provide the file link.

[@aaronjamesfrancisco7605]

Unhide the 2 tables on the worksheet tab. You'll find 2 tables there.

[@Zackemcee1]

What's the difference between using that method to calculate the price with discount (1 - discount), and multiplying the price with the discount amount ? like for example : price * 0.03 for Doublers... Anyone care to elaborate pls?

[@mephim4232]

price 79.95 and 0.03 is 3% discount. simple math 79.95-(79.5*0.03)=77.55

[@konstantinsuvorov2570]

The excel file with the Data Model Basics is missing. Could you please upload it?

[@aaronjamesfrancisco7605]

Unhide the 2 tables on the worksheet tab. You'll find 2 tables there.