What if Excel saved you 10 hours every week? Join my FREE webinar on Thursday, Jan 16, to learn 3 secrets to work less and achieve more. Spots are limited-grab yours now! 👉 event.webinarjam.com/register/13/roovru4
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. :)
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!
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!
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
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!
Thanks for the many videos about Excel. Excel is by far my favorite application. It’s also the most frequently used in my work. I’ve learned so much from your tutorials, making my work so much more efficient and more effective.
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!
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.
Leila...as a non-Pivot Table user, this revelation was amazing. Your explanation was clear and concise and extremely easy to follow. I wish I knew how to use this when I was in management. Now retired, I use it to track my food delivery side hustle. Many, many thanks!!!
@@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
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.
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 TH-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.
She is literally one of the best on TH-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.
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 video provides so much useful function even for beginner like me and I can construct Pivot Table well by learning on this video and I Pass the Excel test in my 1st interview and now I got the new Job. I learned your videos only one night , I studied especially this Pivot lessons and "IF" lessons. Heartfelt thanks to you.
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 :)
Best ever explanation to pivot tables, I was always scared of using Pivot tables, don't know why, but your 10 minutes video makes me comfortable using pivot tables. Thanks...
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!
I have run from Pivot tables for years! I even learned databases to avoid them. DB's turned into a lucrative profession but had no clue Pivot tables were this easy!!! Maybe they were harder back in the early 90's, not sure. Thank you!!!
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!
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 😊😊😊
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!
I know 80% things and some i learnt from here. But what i like most that it was very well organized and explained. Seems what i learn was already on available. Very infromative video. Thanks for uploading.
It was very helpful for me. After a long time I have tried to learn the Pivot Table. As a beginner it helps me a lot. Thanks for your valuable efforts.
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.
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.
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!
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.
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!
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.
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!🥰
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!
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.
Wow, thank you so much, I'm trying to learn more to get a better job. I'm from Tijuana, B.C. Mexico. I finally understood what we call TABLAS DINAMICAS in my country. You are the BEST!!!
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!
hiw do you get past the first part tho? I don't get the menu to create a pivot table it just crashes excel, then the reccomended pivot table button does nothing but make a ding sound
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. 👍
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.
Leila..you are inspirational..had it been possible to have thanked you and show my gratitude in person..then i would..Thanks for provisioning such excellent educational tutorials....
Actively looking for a new accounting manager position after being away from the work force for 5 years away from Excel. I love your videos. I also didn't know the xlookup was added! Thanks!!
Leila!!! You're more than awesome, by my heart, honestly i have no words to express gratitude to you, this video really helps me a lot! it's really helpful, i just update my sheet by watching this video and actually it works..!!! More following :) God Bless you!!!
What if Excel saved you 10 hours every week?
Join my FREE webinar on Thursday, Jan 16, to learn 3 secrets to work less and achieve more.
Spots are limited-grab yours now! 👉 event.webinarjam.com/register/13/roovru4
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. :)
Im about to put that theory to the test, I have an interview for accounting tmr were I need to use pivot tables
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!
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?
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 :)
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!
Reading the comments from seasoned Excel users, I am glad this is the first video I’ve come across, to learn about Pivot Tables
Thanks for the many videos about Excel. Excel is by far my favorite application. It’s also the most frequently used in my work. I’ve learned so much from your tutorials, making my work so much more efficient and more effective.
Thank you!
Thanks!
Thank you!
All 50 pages of a book have been presented just in 13 Minutes! Bless you and thank you***
My pleasure :)
th-cam.com/video/HOa5r2IavRY/w-d-xo.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!
All most latest upgrades first in TH-cam available in this channel, I am very happy to say that you teaching is by your heart ❤️
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!
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.
Wonderful! Thank you for the kind feedback.
How to use I FOR REFRESHING DATA, I HAVE USING BUT NOT AMY RESPONSE
PLZ HELP ME ANYONE
Leila...as a non-Pivot Table user, this revelation was amazing. Your explanation was clear and concise and extremely easy to follow. I wish I knew how to use this when I was in management. Now retired, I use it to track my food delivery side hustle. Many, many thanks!!!
Glad it was helpful!
One of the most educative channels on TH-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
Thanks!
That's very kind. Thank you!
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.
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 TH-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.
unfortunately she skips many steps and goes way too fast to understand this feature!
She is literally one of the best on TH-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.
Thanks
Thank you!
This is one of the most informative and easy to understand tutorials on this subject I've ever seen! Thank you.
This is the most informative, easy to follow Pivot Table tutorial I've seen on TH-cam. Thank you.
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
She is awsome....I usually never subscribe to any one but after watching incredible lessons....i al Impressed.....
This actually helped me more than a commercial class I attended. Thanks!
This video provides so much useful function even for beginner like me and I can construct Pivot Table well by learning on this video and I Pass the Excel test in my 1st interview and now I got the new Job. I learned your videos only one night , I studied especially this Pivot lessons and "IF" lessons. Heartfelt thanks to you.
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 :)
Love this tutorial Leila and Pivot Tables rock Excel 👍
Great to hear!
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!
Best ever explanation to pivot tables, I was always scared of using Pivot tables, don't know why, but your 10 minutes video makes me comfortable using pivot tables. Thanks...
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!
I have run from Pivot tables for years! I even learned databases to avoid them. DB's turned into a lucrative profession but had no clue Pivot tables were this easy!!! Maybe they were harder back in the early 90's, not sure. Thank you!!!
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!
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 😊😊😊
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!
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!
One of the best presentations on Pivot table. I've learnt a few tricks. Thanks, Leila!
One of the greatest presentations of all times. thanks.
Wow, 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 👍
I know 80% things and some i learnt from here. But what i like most that it was very well organized and explained. Seems what i learn was already on available. Very infromative video. Thanks for uploading.
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!
It was very helpful for me. After a long time I have tried to learn the Pivot Table. As a beginner it helps me a lot. Thanks for your valuable efforts.
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.
Just want to let you know, you are awesome and your videos have changed the way i work, you have my deepest gratitude!
Wow, thank you!
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
I've been using Excel so many years and there are new things that I have discovered from your vid. Thank you!! :)
Glad you like it. There is always more to learn :)
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!
Holy cow this is one of the best (if not the best) videos on pivot tables. You’re my hero
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 ;-)
This is amazing, Leila. Jazakumullahu khairan!
I really love how this teacher educates us. Makes everything easy and simple . Thank you!
Glad you think so!
A great video, really advanced. The most profitable 10 minutes I have ever had watching a tutorial.
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!
I have watched several tutorial videos on pivot tables. Yours is the best!! Thank you.
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.
Thank you very much, it is very easy to understand, you even list out chapters so that we can have quick recap and return to find it quickly
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😅
I have used Pivot Tables in the most recent months and your video is a complete game changer! Thank you so much for the educational videos 💕💕💕
You are so welcome!
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 🤗
Thank you very much Leila. This where the best productive 10 minutes you provided us. You are the best.
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!
Dear Leila,
Many thanks for your effort you put on your videos, perfect explaning by your side, easy understanding by us.
Again an amazing video.
Many thanks!
Well, I learnt a lot. Would like to see such more sessions.
And here I was thinking I know everything about Pivot tables...
You are a rockstar Leila....Thanks !!
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!
Thanks for this and all your other videos. Always shy away from PT, this has been so easy to follow
"Become pro" instantly
Thank you so much
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.
Excellent tutorial: clear, concise and informative. You rock!
I almost watch your excel tutorial everyday. Very useful channel. Thanks master excel
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
Wow, thank you so much, I'm trying to learn more to get a better job. I'm from Tijuana, B.C. Mexico. I finally understood what we call TABLAS DINAMICAS in my country. You are the BEST!!!
that "connect pivot to a slicer" making me blush!!!!! hahaha
Me too😊
Leila I just found you channel. You are the bomb! I love the way you explain things. Making my life so much easier. You rock
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.
How much information in a single video! You're amazing, Leila! The best teacher ever :)
hiw do you get past the first part tho? I don't get the menu to create a pivot table it just crashes excel, then the reccomended pivot table button does nothing but make a ding sound
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
THIS HAS NOW CHANGED MY LIFE.. Thank you!!!
THIS WAS AMAZING. OH, WOW.
One of the best teacher for Excel teaching in very simple way, and especially making small topics helps me grasps quickly.
My favorite Excel-tabletype: Pivot-Coffee ☕ with a cloud of milk on top 😋
I started learning Excel yesterday and you are making it easy for me. Thank you so much.
Happy to help!
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.
The intro actually put a smile on my face. Nice one. Keep up the good work
Glad you enjoyed it.
It's like machine talk, press 2 for 2nd floor.... 😂
Quality of content is excellent. Concise and to the point.
I love you Leila…. You are a great teacher
Thank you. This is very helpful😊
Very Very useful to my new profile Leila. You teaching techniques are awesomly fluid and smooth.
Excellent Leila! Took the mystery out of Pivot Tables!!
👍
Leila..you are inspirational..had it been possible to have thanked you and show my gratitude in person..then i would..Thanks for provisioning such excellent educational tutorials....
Leila ..... you (once again) just save my day ..... thanks for the guidance !
Happy to help :)
THANK YOU! This is so easy to understand. I'm having an interview tomorrow so this is indeed helpful.
Actively looking for a new accounting manager position after being away from the work force for 5 years away from Excel. I love your videos. I also didn't know the xlookup was added! Thanks!!
Leila!!! You're more than awesome, by my heart, honestly i have no words to express gratitude to you, this video really helps me a lot! it's really helpful, i just update my sheet by watching this video and actually it works..!!!
More following :) God Bless you!!!
Bless You ❤🎉
Your teaching are highly recommended am really happy.
Glad to hear that.
Thanks Leila for this valuable lesson. God bless.
My pleasure!
You are a literal saint I wish nothing but prosperity for you.
Oh my..I did not know I could just make it a table! Just 2 minutes in- and you have saved me so much time!!!
Happy to help :)