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.

[@ishish1]

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

[@basharatmsts]

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

[@heavens988]

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

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

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

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

[@patwhittome6583]

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

[@LearnitTraining]

You're very welcome!

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

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

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

[@jacobm7026]

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

[@LearnitTraining]

Our pleasure!

[@shashankkumar6206]

It was really an amazing session, Loved it.

[@LearnitTraining]

Glad you enjoyed it!

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

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

[@debbiegallegos5116]

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

[@LearnitTraining]

Glad it was helpful!

[@jessicawillie6094]

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

[@LearnitTraining]

You're very welcome!

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

[@almerjm5936]

Cant wait to see and learn it.

[@neelapenmatsa8907]

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

[@LearnitTraining]

You are very welcome Neela!

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

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

[@MsjAlexandria]

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

[@LearnitTraining]

You're so welcome!

[@divineasem6197]

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

[@LearnitTraining]

Wow, thank you!

[@Silas832]

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

[@LearnitTraining]

You're very welcome!

[@shochibalfatih8821]

Thanks a lot. I appreciate it

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

[@MdImranMozomder]

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

[@LearnitTraining]

Our pleasure!

[@isawhittaker9523]

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

[@LearnitTraining]

You're very welcome!

[@marianaochoa9923]

THANK YOU, easy to understand

[@LearnitTraining]

Glad it was helpful!

[@ryanmagalong1857]

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

[@LearnitTraining]

Awesome, thank you!

[@armelchiza3771]

Amazing course. Thank you so much!

[@LearnitTraining]

You're very welcome!

[@mjxbb1983]

Amazing Tutorial！ Thanks so much!

[@LearnitTraining]

You're welcome!

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

[@elijahd.spragueph.d8905]

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

[@LearnitTraining]

Thank you so much 👍

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

[@rajatkumar706]

Strongly recommend this channel

[@LearnitTraining]

Thank you Rajat!

[@alang4127]

Great training! Keep up the good work!

[@LearnitTraining]

Will do Alan!

[@mmbiographies]

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

[@LearnitTraining]

👍

[@luciamoreira9676]

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

[@yasminelmarasy4134]

This is just SUPER, Thank you for that

[@LearnitTraining]

You are very welcome Yasmin!

[@Exambay]

Thanks , learnt a lot from your videos.

[@LearnitTraining]

Thank you for watching!

[@hamishreil5202]

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

[@LearnitTraining]

Glad you enjoyed it!

[@Moalraheemy.]

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

[@LearnitTraining]

Thank you for watching Mohamed!

[@user-ii3qb6lw4j]

it was awesome! congratulations and thanks from brazil!

[@LearnitTraining]

You are very welcome!

[@ThinkFutureAcademy]

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

[@LearnitTraining]

You are welcome!

[@ndelpurg]

thank you for excellent teaching

[@LearnitTraining]

You are welcome!

[@dianaabiemo5177]

Great Instructor. Thanks!

[@LearnitTraining]

You are welcome! Thank you for watching!

[@mss9466]

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

[@LearnitTraining]

You're very welcome!

[@dibyanshyadav281]

Nice tutorial

[@John36987193]

thank you very much

[@JhayzBoy2012]

Thank you! It surely was helpful.

[@LearnitTraining]

You are very welcome!

[@babuumakantvuppala9598]

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

[@annadankina5360]

Many thanks for that course!

[@LearnitTraining]

Very welcome!

[@rajatmishra1561]

Amazing tutorial ❤️.. Thank u

[@LearnitTraining]

You’re welcome 😊

[@fredrickkenamoah9757]

Always on point Faz... Thanks boss

[@LearnitTraining]

Thank you for watching Fredrick!

[@hmbird47]

Thank you, Mr. Faz!

[@LearnitTraining]

Thank you for watching Hesham!

[@lallitarim8286]

Thank you so much Learnit

[@LearnitTraining]

You are welcome!

[@shoppersdream]

Very Nice! Thanks

[@LearnitTraining]

Our pleasure!

[@Kranthi233]

Awesome explanation and content

[@LearnitTraining]

Thank you for the kind words Kranthi!

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

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

[@hanrytahnok7513]

NICE video!!!, really helpful!!

[@LearnitTraining]

Thank you for the kind words Hanry!

[@alexxgalindo8557]

You are amazing, thank you

[@LearnitTraining]

You are welcome!

[@monicachau4416]

Thank you!

[@LearnitTraining]

You're welcome!

[@karinasahalian8643]

Thank you very much!!!!!!

[@LearnitTraining]

You're welcome!

[@benedictndinemenu5846]

Thank you for a job weldone Faz

[@LearnitTraining]

So nice of you!

[@yagnyeswarsatapathy2429]

Thank you. It was helpful.

[@LearnitTraining]

You're 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!

[@emmanuelabiola7107]

Great tutorial

[@LearnitTraining]

Thank you for watching!

[@shaantanuasthana969]

thanks a lot sir for this.

[@LearnitTraining]

Most welcome!

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

[@kishafranklin1739]

Thanks!

[@LearnitTraining]

Thank you Kisha! Your applause helps us continue to make great videos!

[@hakanaltintas1]

Super useful!

[@LearnitTraining]

Glad to hear!

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

[@andredad559]

excellent tutorial

[@LearnitTraining]

Thank you! Cheers!

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

[@sonerguney3225]

Very good´ thanks

[@LearnitTraining]

Thank you very much!

[@alexandrpopov1545]

Please, make a video about powerpivot!!!

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

[@Knoulech]

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

[@LearnitTraining]

Awesome, thank you!

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

[@matthewdufty606]

Very good video

[@LearnitTraining]

Thanks!

[@mehedihasan401]

Waiting

[@synthstatic9889]

Should I be learning this first or SQL?

[@sunnysengvilay780]

Do you have any tutorial for Pivot Tables for Inventory?

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

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

[@TomMcMorrow]

*heavy breathing in finance graduate* Seriously, every financial analyst starting job wants me to know this and I learned 0 pivot tables in my degree. I smashed my GPA, joined every honor society, and none of it mattered. They. Want. Pivot. Tables.

[@bloodknottrevelian3396]

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

[@benedictndinemenu5846]

how do I download the instructor file? please

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

[@josephm.6453]

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

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

[@franceslund2098]

It would be nice if the correct exercise files were attached to this video

[@vietcongpornsurfers]

read desc

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