Excel Pivot Table EXPLAINED in 10 Minutes (Productivity tips included!)
Вставка
- Опубліковано 31 тра 2024
- Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
Discover how to create a pivot table in Excel. Ideal for anyone looking to quickly analyze data, create reports, or gain insights without complex formulas. Pivot Tables make data analysis accessible and efficient.
⬇️ Download the file I used in the video from here: pages.xelplus.com/pivot-table...
Learn hidden productivity tips when working with Excel Pivot Tables. At first Pivot Tables might seem like a complex tool but they are one of Excel's EASIEST features to work with. They help you summarize data really FAST.
What You'll Learn:
▪️ Setting Up Data for Pivot Tables: Learn how to prepare your data for Pivot Tables, including organizing it in a tabular format and converting it into an official Excel table.
▪️ Creating Pivot Tables: Understand the basics of inserting Pivot Tables, including using the 'Recommended PivotTables' feature for a quick start.
▪️ Customizing Pivot Tables: Dive into sorting values, changing number formats, adding filters, and adjusting the design and layout of your Pivot Tables.
▪️ Advanced Pivot Table Features: Explore how to show values as percentages of grand totals, connect slicers to multiple Pivot Tables, and ensure automatic updates with new data.
We'll also cover how to add Pivot Slicers to get a professional visual to apply filters to our Pivot Table.
00:00 How to Create Pivot Table in Excel?
01:35 Convert Data to Excel Tables
02:46 Create Pivot Table
04:08 Change aggregation in Pivot Table to average or count
04:40 Adjust number format in Pivot Table
05:10 Add filter to Pivot Table
05:28 Add column fields to Pivot Table
05:50 Removing Grand Totals and Sub Totals in Pivot Table
06:27 Update Pivot Table layout and design
07:14 How to bring back Pivot Table Fields dialog box
07:42 Update Pivot Table column header without errors (pivot table field name not valid)
08:33 Sort values in Pivot Table
08:41 Lock column width on Pivot Table refresh
09:00 Add Value as percentage of grand total in Pivot Table
10:22 Add Pivot Table Slicers to Filter Data
11:10 Connect Slicer to multiple Pivot Tables
11:50 Refresh Pivot Tables
12:40 Benefits of Pivot Tables
➡️ Join this channel to get access to perks: / @leilagharani
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#excel
Grab the file I used in the video from here 👉 pages.xelplus.com/pivot-tables-basics-file
As a pivot table user, I can definitely say that I can point anyone who has zero knowledge in Pivot table, and he/she would be able to learn how to use Pivot table proficiently just by watching this 10min video. Awesome, I wish I had seen this video when I started learning about Pivot table. :)
I've been using pivot tables in Excel for close to fifteen years, but 80% of this video covered stuff I didn't know before. This short video is jam-packed with so much useful information!
@@mattiaklaudi9800 Well, genius, why do you think I'm watching Excel tutorials?
@@tom_something your right 🙌
What would I do if everything turns gray when I first hit the button?
Reading the comments from seasoned Excel users, I am glad this is the first video I’ve come across, to learn about Pivot Tables
I just did my first pivot table for my new employer. Thank you for this video! I learned it could be done when I didn't have the data to work with. I decided to give it a try, under a timeline. Simply amazing! That is all I can say. Other than my sincere thanks to you for your teaching it so well!
My head just exploded. I have been working in Excel for YEARS and this is brand new information. I am thinking of all of the time I could have saved if I had known this sooner. Thank you!
All 50 pages of a book have been presented just in 13 Minutes! Bless you and thank you***
My pleasure :)
ua-cam.com/video/HOa5r2IavRY/v-deo.html
EXCEL SLICER FOR PIVOTS9
I paid heavily just to be trained on the Pivot table yet I didn't get value for my money, but I got loaded in 13min 21sec. A class act from a genius!
Fantastic! I’m going to check your courses, I’m hoping you have an excel course from start to advanced, and not just tutorials. You are a great teacher!
Amazing video.... great training, easy to follow, friendly, encouraging,. I like that you include, not only the technical aspects, but also your personal tips/bias/favourites.... saves me having to "reinvent the wheel" in terms of best practices.
One of the most educative channels on UA-cam. I feel lucky being part of your subscribers.
😘
I feel that way too mate 👍
Me too 😊
@@LeilaGharani hi there, im really needs your help...how can i turns the summarize value in pivot table by min to the smallest number instead of zero...looking forward for your assistance
I completely agree
This is one of the most informative and easy to understand tutorials on this subject I've ever seen! Thank you.
Hello Leila, I just want to say thank you for all your Excel videos. This summer I started my first Accounting internship and I must say that all your videos have allowed me to do data analysis much more easier and faster and this has gained me favor with my superiors. Keep up the amazing work.
Of all of the channels I subscribe to, this is by far the most helpful & useful! The Excel tutorials have helped me with my job tremendously! Thank you!
Been using pivots since the last 15 years but your tutorial made me fall in love with it allover again. Very nice explanation 👍
The way you explain things is incredible. I love that you go direct to the point and keep it simple. Congrats and thank you for sharing your knowledge with us :)
I really love how this teacher educates us. Makes everything easy and simple . Thank you!
Glad you think so!
One of the best presentations on Pivot table. I've learnt a few tricks. Thanks, Leila!
Thank you so much for making Excel so easy to understand. Your pace and ability to deliver the learning in a concise & digestible way is very much appreciated.
my Goodness-i HATED pivot tables and Vlookups-thats why i started my own business and will never be employed again as an accountant-ARGHHHH
You explain Excel very well in my opinion. I like how you anticipate some things AND I really appreciate how you explain the "Why" a part of a feature works the way it does. Great Job Leila
This is super helpful! The report layout part was the most helpful. I can't recollect how many painful hours I have lost trying to manually (with multiple lookups) I had to organise data in the past - worked for payroll at the time. This info helps me so much. THANK YOU!!
I swear , this has been the best video I've come across that explains Pivot table. Thank you so much 😁❤️
This actually helped me more than a commercial class I attended. Thanks!
Very nice explanation on Pivot. I learned a lot from this video. I am very new to Pivot and this video covers a lot of details.. Thanks Leila for your videos.
Okay, I’ve got to hand it to you: this is good stuff. One of my biggest pet peeves is people using a spreadsheet as a database, and that’s still a really bad idea; but this feature is actually a pretty good argument for why someone might want to export data to Excel. There’s nothing here that a real database-driven application couldn’t do, but the fact that the average user can do it on the fly is pretty dang impressive.
You did an absolute FANTASTIC job explaining Pivot Tables in this video. Thank you so much for sharing!!
This was quick and to the point. You can learn a lot in a short amount of time. These are the kinds of tutorials I like. Thank you!😊
You're very welcome!
Clean, concise, neat and simple explanation! I am so grateful that I found your channel, Leila. Thank you a bunch! 👏🏻😌
12😂A31R1AR😂😅WEEE!😅😂×AND 😅😂😂³😅A3😅
Clear, precise and to the point. I learn a lot from your tutorials. Thank you so much.
so calm, succinct and easy to follow. great video!
Great video, as always. One thing to consider is that copying one pivot table to make another one means you will be using the same pivot cash, just like you said, which also means you will keep your file considerably smaller if you have a big data set.
tip: it's "cache" , not "cash" - guess we borrowed the term from the French...
@@sgarcata Thank you, I completely missed that ;-)
What a wonderful tool that I've never used... Thank you, I'm looking forward to it!!
I've been watching 2 or 3 of your videos at random each week, and I'm always impressed to learn some random and useful trick. You rock!
Awesome, thank you!
She is literally one of the best on UA-cam. The examples are real world and the explanations are surprisingly easy to follow. At least twice a week I send someone a link to her channel when asked how to do something in excel.
Thank you, Leila. You are a gifted instructor.
Wow! Amazing! I learned more in 10 minutes than what I could have learned with an hour of messing around on my own. Thanks, for sharing!
Leila, I just wanted to let you know how much I love your channel! Your explanations and pedagogy are outstanding, and you truly “excel” at making complex topics easy to understand. Keep up the great work!
This video is so good. They look so easy, and I appreciate that you speak slowly and give examples. There are instructional videos that race through topics and show that "X" can be done in 3 minutes, but they have more demonstration value than teaching value.
Leila. You are very good teacher. Right voice pitch, speed, learnings, time duration. Thank you for your gr8 efforts in preparation of such learnings to all.
Your videos are so concise! I have had to learn a lot of excel for my work, and you have by far been the best resource. I recommend your channel to everyone I know who uses excel at all. Thank you for your high quality content!
Wow, thank you Brianna!
your clap was like a magician starting the next act
Haha, Pivot magic 😁
@@LeilaGharani I'll echo what Rajan said. The clap was awesome!!
Also love the clap! And the content. That's the first time I've ever felt like I fully understood pivot tables. Thank you!
Great tutotial on pivot tables, thank you leila! You made it clear and easy to follow 👍😁
Brilliant tutorial. I have been told for years by various people how good Pivot Tables are, but every time I asked for a demo or training session nothing happened. Today I finally thought to myself . . . . . 'Google, help me !' and in less than 15mins thanks to Leila and UA-cam I have found the answer to my question 'How can PT's help me', and I have within the next 15mins I have applied your tutorial to a copy of my existing sandboxed data as successful tests. It was lucky for me that for years I have created data sheets using a formalised manner that worked for me 'out of the box' to implementing Pivot Tables. A big thank you.
Leila, you're so amazing!! Thank you for sharing this knowledge with your subscribers. I thought I was the excel queen but after watching your vids I see that I'm not even an excel princess yet..😆 Just want you to know how much I enjoy your vids and learning from you. Kudos to you! Keep em' coming!🥰
Thank you 🤗
This is BY FAR the best video about pivot tables. Other videos left me feeling overwhelmed by the amount of information leading up to the creation of a pivot table. Your checklist of required info before creating a pivot table is so helpful, and I especially like how you explained the importance of turning the data set into a table first. I was never taught this before. I also like how you showed the "Recommend PivotTables"feature. Thank you so much for creating this video!
Glad it was helpful, Rob!
Thank you Leila, this is something that I didn't knew when learning pivot table in other platform.
Glad it was helpful!
Dammmn I should have known this earlier. Going to finish my final year in data analytic and I just learned this masterpiece today. 😭😭😭😭😭😭
Senior citizen here. Knew the basics long ago, but just started new job and realized how far behind I am. Thanks for creating a thoughtful, paced easy to understand tutorial. I'll be right back in the saddle after I finish your amazing classes!
Great! Good luck with the new job!
Thank you for this fantastic video. Excellent crash course on Pivot Tables. A great refresher and yet even better at teaching new to-me features and functions. Thanks again, Leila!
Indeed useful... pivot table is really amazing tool to effortlessly get variety of information from raw data. Thanks Leila and team for enlightening us.
Thank you very much Leila for this video, I love how you break down concepts for easy understanding.God bless you
You are so welcome John!
Your skill set is something to aspire to. Very knowledgeable, and even more important in this role, an Excellent teacher and communicator. Very much appreciated!
Wow, thank you Bill!
My honest comment, I have tried a lot of yout tube channels, but never seen any instructor like you.
You are making my job easy in my company... Thanks a lot 😊😊😊
Thank you so much for all the amazing content you do. I started a new accounting role last month and your videos help me bring new ideas to the table
"Become pro" instantly
Thank you so much
Well, I learnt a lot. Would like to see such more sessions.
I love the way you simplify stuff for the viewers. Apart from the fabulous content, what really stands out is the tempo of your videos. They are just right for learners. Thank you!!
I appreciate that!
thank you! you could teach us in a light way! we appreciate it.
Excellent tutorial: clear, concise and informative. You rock!
As the art continues, can't wait to see you start a new series for PowerBI and go deep in data modeling and analysis.
Good luck Leila
She is awsome....I usually never subscribe to any one but after watching incredible lessons....i al Impressed.....
What an amazing tutorial, glad I have found you and your other tutorial. You are a complete gift! Thank you so much for your efforts in making easy to follow guides for us 🤗🤗🤗
I’ve never tried changing the data to a table so that it automatically updates the pivot with new rows. That was great! Also the sliver tip for multiple pivots.
Glad it was helpful!
This was so so good and well explained. Though I've done your advanced courses, but still it was a great watch Leila. Lots of 'claps' ;)
Awesome, thank you!
Advance course link please
Thanks for this and all your other videos. Always shy away from PT, this has been so easy to follow
Thank you very much Leila. This where the best productive 10 minutes you provided us. You are the best.
THIS WAS AMAZING. OH, WOW.
Came for the pivot table, stayed for the wholesomeness of this channel. Congrats on the million followers. Glad I clicked your page first, I definitely learned a lot more. 👍
my Goodness-i HATED pivot tables and Vlookups-thats why i started my own business and will never be employed again as an accountant-ARGHHHH
Explained in simple language. Thanks. Comprehended!!!!
Thank you very much. I learnt so much from you. Everything was very clear and super easy to understand :)
Great to hear!
Now I know!
Everybody around me in Germany pronounces it "piv-oh", as if it was a French word, because words ending with "-ot" just look French to us. I've always wondered if it wasn't just supposed to be the English "pivot".
Thank you!
It actually is French....
it is still french though
But in French the '-t' would be silent
Maybe Germans think it's named after Polish beer.
that "connect pivot to a slicer" making me blush!!!!! hahaha
Me too😊
Leila, I have using Pivot Tables for a good while but you just educated me on some great features I was not aware of. Thank you, I will definitely be watching more of your videos and yes I am subscribed.
Thanks, short, clear, understandable and to the point.
My favorite Excel-tabletype: Pivot-Coffee ☕ with a cloud of milk on top 😋
Cool video! I loved the "sections" on the video playback timeline, they're so helpful!
Could you help me with a quick question? If I have a table with 100 rows, and I want to paste a new report that has 80 rows, is there any way to do that without leaving those previous 20 rows at the end? Right now I delete everything in the table before pasting a new report.
Thanks!
Hey Ricardo! Let's assume you have your data in range A2:F101 (first row is the header). Just paste your new report on A102:F182 and then delete the first report (rows 2:101). That way, your table still references the correct dataset and you only need to refresh the pivot.
What you're asking can probably be achieved via VBA, but I don't think it's worth the hassle.
One of the best teacher for Excel teaching in very simple way, and especially making small topics helps me grasps quickly.
This is a really great tutorial on pivot tables, thank you! You made it clear and easy to follow.
It's like machine talk, press 2 for 2nd floor.... 😂
Hello Leila, I found our tutorials really useful. I'm following you since 2 years ago and i never found fake instructions, so go ahead!
Absolutely, amazingly simplified. Thanks.
Excellent video , very helpful. Thanks Leila !!
Leila - you rock, this was very helpful yet concise - appreciate the content!
Completed, thank you so much!!!
This was really good, right off the bat, BOOM, TABLES. Easy listen. Thank you!
Glad you liked it!
Thank you so much for the immaculate explanation. I have seen a number of videos about creating and using Pivot Tables but non of them compares to yours!
The most enlightening channel that teaches everything from needle to thread.
Also add how to fix the size of the pivot table.
Waiting for the next video.
This explained all I wanted from Pivot Tables. Thank you
Thank you Leila, your videos are very helpful.
Wow! Clear and precise! I wish I know these earlier! Thank you!
Hello,
Your every vidoe inspries me and get knowledge in depth .
Thankyou so much
This is very very helpful I understood it better than the supposedly "Begginers" Pivot Table in LinkedIn I took last week. Thanks so much!
Very nice! Very straightforward.
Thank you for posting this helpful video! Your info on tables was new to me and really helped!!
Very good way of teaching meaning you really want users to learn. Thank you.
So yours is probably the 30th Excel YT video I've watched. It's the 4th or 5th one on Pivot Tables. I had to stop at the 3:45 mark to tell you that yours is BY FAR the most informative, easiest to understand--and most importantly, you don't assume the viewers already know about half the information as almost every other presenter assumes. You act as if you truly want viewers to understand the content. Crazy approach, but I'll go along.
Thank you for the effort and clarity
Thank you for the kind feedback! I definitely do want you to understand the content :)
Really valuable video. STAY BLESSED!!!
Excellent tutorials! Easy to understand. Thank you!
So so so helpful! Thank you so much Leila
I have watched several tutorial videos on pivot tables. Yours is the best!! Thank you.
Your videos are fantastic! Thank you.
Thank you !!!! My new job (dream job!) has me using Excel Pivot tables soooo much and you have helped for me to keep my dream job. You make it easy to learn and explain in plain language.