Learn how to use PivotTables in Excel with this step-by-step tutorial for beginners. Find out how to insert pivot tables and how to use recommended pivot tables. Learn what filter, column, row, and value mean. See how to use calculated fields to quickly analyze data in a pivot table. See how to summarize and show your values in different ways. Lastly, learn how to insert pivot charts, what defer layout update means, and how to access Excel for free online using office.com.
In this tutorial, I use Excel that comes with Office 365; however, this should also work with all previous versions of Excel, like Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007, and Excel 2003.
👋 Resources called out in this video:
Access the sample data in the spreadsheet: https://1drv.ms/x/s!AmxrofZZlZ-wg_xUE4vA3D_5qdbRjA
📃 Watch related playlists and videos
– Excel: https://www.youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
🚩 Connect with me on social:
– LinkedIn: https://www.linkedin.com/in/kevinstratvert/
– Twitter: https://twitter.com/kevstrat
– Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818
– TikTok: https://www.tiktok.com/@kevinstratvert
🔔 Subscribe to my YouTube channel
https://www.youtube.com/user/kevlers?sub_confirmation=1
🎬 Want to watch again? Navigate back to my YouTube channel quickly
http://www.kevinstratvert.com
source
✅ Access the sample data in the spreadsheet here: https://1drv.ms/x/s!AmxrofZZlZ-wg_xUE4vA3D_5qdbRjA
⏭ Other Excel Videos & Tutorials: https://www.youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
🧙♂️ Advanced Pivot Table Tips & Tricks: https://youtu.be/3g1CSG5zvQ0
very helpful . very easy to learn excel for my switch over. i just need few doubts. i am using in excel in online but in pivot table i am not getting data and analyse button. whether i have to go to premium only i can get that ?
Hey Kevin; thanks for a great video.
Mr.Keiven stratvert you're just amazing beautifully, clearly, & smoothly you explain I am scratch starter I request you if you proved some practice lesson sheet it could help more to practice and get perfect now from your a basic we learned next I required to prepare practically to practice myself & get perfect myself & get confidence within myself so for that I need some mock practice data sheet hope u understand it thank very much Mr. Keiven once again for making this video for zero scratch starters
Oh I mr. Kievin I found the practice data sheet linke below I haven't seen it now I came across now it's helpful for me to practice my own self thank you very much
Great Video.. Normally people drag their video a lot. However, your video is short but content rich. Thanks
Your monitor looks good, which model is it?
So glad I found your channel. You’re a wealth of knowledge! I appreciate your teaching style which is easy to listen to! 😊
great content – very easy to use. Do you have a more advanced tutorial on pivot tables? I would also like to learn more about general excel functions and lookup
Great tutorial that introduced me to pivot tables. Thank you.
He just had to make it known that he works for Microsoft
You're literally going to get me through my MSc data analysis this year 😭
God bless you Kev🤞🏽
Thank you!
Thank you so much kevin, the video very useful
very good this was very helpful
Very good explanation! Thanks!
My Excel sheet thanks you (as do I).
Helpful and easy to follow instructional on pivot tables. Thanks!
Can i make multiple pivotchart?
very informative
I dont know why when i drag the price into the values field and turned it into ‘sum’, the values changed to zero😅 Do you know why it happened that way?
This is so well done! the bags under his eyes alone, are enough proof that he knows exactly what he is doing and has extensive knowledge
What version of excel are you using? I tried to add the analysis toolpak, but it does not give me the option to insert calculated field.
Thank you
Thanks!
*relief
Thank you for helping me to understand this !
Thanks a lot for the content produced – it was very helpful as beginner or refresher added value. I appreciate, you were knowledgeable, easy to understand, diction and this was a good example. Thanks from California.
Thanks Kevin!! I am ready to create a pivot table tomorrow. Great example make it easy to understand. I am a subscriber now.
Thanks man.
Why when i drag cost to the values, it shows as just count of price , when i select sum of price , it turns into just zero for all make???
Thank you Kevin. I start a job in Supply Chain tomorrow and will be using Pivot Tables so this tutorial is really helpful.
Always remember we must repent of our sins (sin is transgression The Law Of Yahuah The Father in Heaven. The Law are The Books: Genesis, Exodus, Leviticus, Numbers, & Deuteronomy). We must repent of our sins and Have Belief On Yahusha The Messiah. HE Died and Rose three days later so that we can be forgiven of our sins!
Come to HIM🙂