Excel 2019 Pivot Tables Tutorial
Вставка
- Опубліковано 27 лип 2024
- 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.
Thank you Faz ... Thank you Learn It ... You guys deserve a Nobel!!
Thank you for the kind words Richard! An extra big thank your for subscribing it helps a lot!
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
Great to hear!
Sir, I am really grateful to you for such knowledgeable training
You do really good tutorials. I watched the excel advanced tutorial and it really helped me out a lot. Great job man
Guys at the Learnit Training team, thank you so much. This tutorial was really useful, taught simply and at the right pace.
Glad it was helpful!
This is my favorite EXCEL Table tutorial I have found. Learned alot!
Glad it was helpful!
Very Good Tutorial, revived me the basics & advanced features, thanks a lot!
You are a super teacher. Very detailed explanation. My best experience so far with learning excel online.
Wow, thank you!
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!
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).
Detailed explanation regarding the utilization of the excel pivot tables was helpful. Thank you.
You are very welcome Neela!
Outstanding course that is available on UA-cam ..... much required course for all the analytics role, love from Kolkata, India🤗
Thank you for watching Sushobhon!
What a great course. Now I know a lot about the topic. Thanks Faz & learnit team!
Thank you for all praise iphrank! We hope you are learning alot!
Great Video. Pivot Tables are probably my favorite function of Excel. Thank you for the detailed course!
You're very welcome!
Super training - very clear and concise with good examples. Thank you!
You're very welcome!
This is very useful learning. I've done any tutorials in pivot yet but will be soon.
What a great presentation! Thank you so very much as this will be a resource I come to time and again!!!
You are so welcome!
Very clear and easy to follow, well done!
Thank you so much JCM 64! Your support helps us to continue to make new videos!
Seriously, guys, amazing work here. Thank you for doing all these videos on here.
Our pleasure!
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.
You're very welcome!
It was really an amazing session, Loved it.
Glad you enjoyed it!
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.
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.
You are very welcome!
You are a brilliant instructor, keep up the great work.
Thank you so much 👍
This was SUPER helpful. Great tutorial.
Glad it was helpful!
Great tutorial! Good for refresher or those just learning. Thank you!!
You're very welcome!
Cant wait to see and learn it.
Thank you Karim...marvelous ...i haven't got lost. One of the best.good job 👍
Thank you for watching Mohamed!
Strongly recommend this channel
Thank you Rajat!
Thank you Faz It was very helpful for me to learn Pivot Tables.
You are welcome! Also thank you for subscribing!
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.
Glad it was helpful!
it was awesome! congratulations and thanks from brazil!
You are very welcome!
Thank you! This was easy to follow and soooooo helpful.
You're so welcome!
Thank you very much for such a nice turotial on pivot tables.
You are welcome!
Thank you so much Learnit
You are welcome!
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.
You're welcome!
THIS IS FANTASTIC TUTORIAL! I'VE LEARNED A LOT! :)
Awesome, thank you!
I learn more than 100 ways to say "go ahed" than I couldn't even focus on the real tutorial 😂😂
👍
Thanks , learnt a lot from your videos.
Thank you for watching!
Amazing course. Thank you so much!
You're very welcome!
THANK YOU, easy to understand
Glad it was helpful!
Thanks a lot. I appreciate it
Thank you. It was helpful.
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?
Thanks a lot for the video and grateful to you for the lesson.
Our pleasure!
Thank you Faz this is an excellent tutorial on pivot Table - God bless
You're very welcome!
Many thanks for that course!
Very welcome!
Great Instructor. Thanks!
You are welcome! Thank you for watching!
Amazing Tutorial! Thanks so much!
You're welcome!
thank you for excellent teaching
You are welcome!
excellent tutorial
Thank you! Cheers!
Thank you, Mr. Faz!
Thank you for watching Hesham!
Great training! Keep up the good work!
Will do Alan!
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? 😂
Glad it helped!
Excellent tutorial Faz! excited to apply it to my work now :) Just one question, why do we "activate the windows"? Thanks!
thanks a lot sir for this.
Most welcome!
This is just SUPER, Thank you for that
You are very welcome Yasmin!
very good video. you talked at a pace i could keep up with. most others talk way to fast.
Glad you liked it!
Super useful!
Glad to hear!
Thanks Faz, This is very helpful and informative and I learned a lot super. ❤️❤️❤️
Glad you enjoyed it!
Nice tutorial
Thank you! It surely was helpful.
You are very welcome!
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.
Thank you for watching pb1 and we are glad we could help you out!
Awesome step by step tutorial. You make it so easy to understand and learn. Thank you!
You're very welcome!
Always on point Faz... Thanks boss
Thank you for watching Fredrick!
thank you very much
NICE video!!!, really helpful!!
Thank you for the kind words Hanry!
Thanks!
Thank you so much Nick! Your support allows us to keep creating videos!
Amazing tutorial ❤️.. Thank u
You’re welcome 😊
You are amazing, thank you
You are welcome!
Awesome explanation and content
Thank you for the kind words Kranthi!
Great tutorial
Thank you for watching!
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 (•-•)
Hahaha! We are definitely letting Faz know this!
Thank you very much!!!!!!
You're welcome!
Thank you! I watched the whole video and I learned a lot here more than in school. Please keep doing something like this.
Thank you! Will do!
Very good video
Thanks!
Thank you!
You're welcome!
Very Nice! Thanks
Our pleasure!
Very good´ thanks
Thank you very much!
Thank you for a job weldone Faz
So nice of you!
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.
Thanks for the tip!
Nice teaching techniques. Very good teacher indeed. A student's delight.
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.
Great suggestion!
Please, make a video about powerpivot!!!
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?
Great tutorial, easy to follow........I watched it, "And You Should Too". 👍
Awesome, thank you!
how do I download the instructor file? please
Do you have any tutorial for Pivot Tables for Inventory?
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.
Updated!
Should I be learning this first or SQL?
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?
Hi Ny Mia! We will dig around and see if we have that laying around somewhere.
Waiting
More pivot table information please
my power pivot doesnt work, it shows "unable to cast COM object..." error
Does the same process work on a Mac laptop?
This article may help: answers.microsoft.com/en-us/msoffice/forum/all/microsoft-excel-for-mac-pivot-tables/d28d9dfd-fb19-4ce3-8040-c9d55b5a65c1
Hello again, the data model basics is not opening after downloading, can you fix that please. Thanks
Hi Abdel! Thanks for letting us know, it has been fixed!
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?
Unhide the 2 tables on the worksheet tab. You'll find 2 tables there.
*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.
Hi great course! Just have one problem don’t know if you know the reason..
at 12.22 when I try to extract the month. I put in the EXACT same formula as you, but my answer always ends in “00” instead of “dec”. Do you perhaps know why? Thanks for a great course in general tho!
Hi Oliver! You can get your question answered at Offsite, our online community - www.offsitebylearnit.com
@@LearnitTraining Thank you so much!