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.
Пікірлер: 270
You do really good tutorials. I watched the excel advanced tutorial and it really helped me out a lot. Great job man
Very Good Tutorial, revived me the basics & advanced features, thanks a lot!
Sir, I am really grateful to you for such knowledgeable training
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
2 жыл бұрын
Great to hear!
Thank you Faz ... Thank you Learn It ... You guys deserve a Nobel!!
@LearnitTraining
3 жыл бұрын
Thank you for the kind words Richard! An extra big thank your for subscribing it helps a lot!
Guys at the Learnit Training team, thank you so much. This tutorial was really useful, taught simply and at the right pace.
@LearnitTraining
2 жыл бұрын
Glad it was helpful!
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
2 жыл бұрын
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).
What a great course. Now I know a lot about the topic. Thanks Faz & learnit team!
@LearnitTraining
3 жыл бұрын
Thank you for all praise iphrank! We hope you are learning alot!
This is very useful learning. I've done any tutorials in pivot yet but will be soon.
Super training - very clear and concise with good examples. Thank you!
@LearnitTraining
3 жыл бұрын
You're very welcome!
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
3 жыл бұрын
You're very welcome!
Seriously, guys, amazing work here. Thank you for doing all these videos on here.
@LearnitTraining
3 жыл бұрын
Our pleasure!
It was really an amazing session, Loved it.
@LearnitTraining
3 жыл бұрын
Glad you enjoyed it!
Great tutorial! Good for refresher or those just learning. Thank you!!
@LearnitTraining
3 жыл бұрын
You're very welcome!
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
2 жыл бұрын
Best of luck!
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
2 жыл бұрын
You are very welcome!
Thanks a lot. I appreciate it
Cant wait to see and learn it.
This is my favorite EXCEL Table tutorial I have found. Learned alot!
@LearnitTraining
Жыл бұрын
Glad it was helpful!
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
3 жыл бұрын
You're welcome!
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?
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!
Thank you Faz It was very helpful for me to learn Pivot Tables.
@LearnitTraining
3 жыл бұрын
You are welcome! Also thank you for subscribing!
Thank you! This was easy to follow and soooooo helpful.
@LearnitTraining
3 жыл бұрын
You're so welcome!
THIS IS FANTASTIC TUTORIAL! I'VE LEARNED A LOT! :)
@LearnitTraining
3 жыл бұрын
Awesome, thank you!
You are a super teacher. Very detailed explanation. My best experience so far with learning excel online.
@LearnitTraining
2 жыл бұрын
Wow, thank you!
Detailed explanation regarding the utilization of the excel pivot tables was helpful. Thank you.
@LearnitTraining
3 жыл бұрын
You are very welcome Neela!
Amazing course. Thank you so much!
@LearnitTraining
2 жыл бұрын
You're very welcome!
Outstanding course that is available on KZread ..... much required course for all the analytics role, love from Kolkata, India🤗
@LearnitTraining
2 жыл бұрын
Thank you for watching Sushobhon!
Amazing Tutorial! Thanks so much!
@LearnitTraining
3 жыл бұрын
You're welcome!
THANK YOU, easy to understand
@LearnitTraining
3 жыл бұрын
Glad it was helpful!
Very clear and easy to follow, well done!
@LearnitTraining
2 жыл бұрын
Thank you so much JCM 64! Your support helps us to continue to make new videos!
Thank you so much Learnit
@LearnitTraining
Жыл бұрын
You are welcome!
Great training! Keep up the good work!
@LearnitTraining
3 жыл бұрын
Will do Alan!
Thanks a lot for the video and grateful to you for the lesson.
@LearnitTraining
3 жыл бұрын
Our pleasure!
Excellent tutorial Faz! excited to apply it to my work now :) Just one question, why do we "activate the windows"? Thanks!
Thank you Faz this is an excellent tutorial on pivot Table - God bless
@LearnitTraining
3 жыл бұрын
You're very welcome!
Great Video. Pivot Tables are probably my favorite function of Excel. Thank you for the detailed course!
@LearnitTraining
2 жыл бұрын
You're very welcome!
Nice tutorial
thank you very much
This was SUPER helpful. Great tutorial.
@LearnitTraining
2 жыл бұрын
Glad it was helpful!
Thank you. It was helpful.
@LearnitTraining
2 жыл бұрын
You're welcome!
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
3 жыл бұрын
Glad it was helpful!
You are a brilliant instructor, keep up the great work.
@LearnitTraining
2 жыл бұрын
Thank you so much 👍
Strongly recommend this channel
@LearnitTraining
3 жыл бұрын
Thank you Rajat!
thanks a lot sir for this.
@LearnitTraining
Жыл бұрын
Most welcome!
Super useful!
@LearnitTraining
2 жыл бұрын
Glad to hear!
This is just SUPER, Thank you for that
@LearnitTraining
2 жыл бұрын
You are very welcome Yasmin!
Awesome step by step tutorial. You make it so easy to understand and learn. Thank you!
@LearnitTraining
3 жыл бұрын
You're very welcome!
excellent tutorial
@LearnitTraining
2 жыл бұрын
Thank you! Cheers!
Thank you Karim...marvelous ...i haven't got lost. One of the best.good job 👍
@LearnitTraining
2 жыл бұрын
Thank you for watching Mohamed!
I learn more than 100 ways to say "go ahed" than I couldn't even focus on the real tutorial 😂😂
@LearnitTraining
8 ай бұрын
👍
it was awesome! congratulations and thanks from brazil!
@LearnitTraining
11 ай бұрын
You are very welcome!
thank you for excellent teaching
@LearnitTraining
3 жыл бұрын
You are welcome!
Great Instructor. Thanks!
@LearnitTraining
2 жыл бұрын
You are welcome! Thank you for watching!
Very Nice! Thanks
@LearnitTraining
3 жыл бұрын
Our pleasure!
Thanks , learnt a lot from your videos.
@LearnitTraining
2 жыл бұрын
Thank you for watching!
Many thanks for that course!
@LearnitTraining
2 жыл бұрын
Very welcome!
Always on point Faz... Thanks boss
@LearnitTraining
3 жыл бұрын
Thank you for watching Fredrick!
Thank you!
@LearnitTraining
3 жыл бұрын
You're welcome!
Thanks Faz, This is very helpful and informative and I learned a lot super. ❤️❤️❤️
@LearnitTraining
2 жыл бұрын
Glad you enjoyed it!
Thank you, Mr. Faz!
@LearnitTraining
2 жыл бұрын
Thank you for watching Hesham!
Awesome explanation and content
@LearnitTraining
3 жыл бұрын
Thank you for the kind words Kranthi!
Amazing tutorial ❤️.. Thank u
@LearnitTraining
2 жыл бұрын
You’re welcome 😊
Thank you very much for such a nice turotial on pivot tables.
@LearnitTraining
2 жыл бұрын
You are welcome!
Thank you! It surely was helpful.
@LearnitTraining
2 жыл бұрын
You are very welcome!
Thank you very much!!!!!!
@LearnitTraining
2 жыл бұрын
You're welcome!
NICE video!!!, really helpful!!
@LearnitTraining
2 жыл бұрын
Thank you for the kind words Hanry!
Thank you! I watched the whole video and I learned a lot here more than in school. Please keep doing something like this.
@LearnitTraining
3 жыл бұрын
Thank you! Will do!
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
2 жыл бұрын
Glad it helped!
Nice teaching techniques. Very good teacher indeed. A student's delight.
You are amazing, thank you
@LearnitTraining
2 жыл бұрын
You are welcome!
Thanks!
@LearnitTraining
3 жыл бұрын
Thank you so much Nick! Your support allows us to keep creating videos!
Very good video
@LearnitTraining
2 жыл бұрын
Thanks!
Thank you for a job weldone Faz
@LearnitTraining
3 жыл бұрын
So nice of you!
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
3 жыл бұрын
Thank you for watching pb1 and we are glad we could help you out!
Great tutorial
@LearnitTraining
3 жыл бұрын
Thank you for watching!
Very good´ thanks
@LearnitTraining
2 жыл бұрын
Thank you very much!
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
2 жыл бұрын
Hahaha! We are definitely letting Faz know this!
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?
very good video. you talked at a pace i could keep up with. most others talk way to fast.
@LearnitTraining
3 жыл бұрын
Glad you liked it!
Do you have any tutorial for Pivot Tables for Inventory?
Please, make a video about powerpivot!!!
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
2 жыл бұрын
Thanks for the tip!
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
2 жыл бұрын
Great suggestion!
Waiting
Great tutorial, easy to follow........I watched it, "And You Should Too". 👍
@LearnitTraining
3 жыл бұрын
Awesome, thank you!
Why use vlookup for the discount price when its just a simple calc using columns J and L?
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
2 жыл бұрын
Hi Ny Mia! We will dig around and see if we have that laying around somewhere.
how do I download the instructor file? please
my power pivot doesnt work, it shows "unable to cast COM object..." error
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
3 жыл бұрын
Updated!
Should I be learning this first or SQL?
More pivot table information please
*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.
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.
The excel file with the Data Model Basics is missing. Could you please upload it?
@aaronjamesfrancisco7605
3 жыл бұрын
Unhide the 2 tables on the worksheet tab. You'll find 2 tables there.
The exercise file does not contain the file (excel 2019 pivot table)you are working on. Please provide the file link.
@aaronjamesfrancisco7605
3 жыл бұрын
Unhide the 2 tables on the worksheet tab. You'll find 2 tables there.
Please provide the excel file which you are showing in the video tutorial. Download link excel files does not have the same. This exercise files are very important for practice and need to be provided. Request you to provide the link at the earliest.
where can i find the full completed excel sheet