Pivot Table Excel Tutorial



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

This Post Has 32 Comments

  1. ramya c

    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 ?

  2. Omer sharief

    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

  3. Omer sharief

    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

  4. Mohamed Nasheeth

    Great Video.. Normally people drag their video a lot. However, your video is short but content rich. Thanks

  5. Ami’s Chair

    So glad I found your channel. You’re a wealth of knowledge! I appreciate your teaching style which is easy to listen to! 😊

  6. Andrew De Bona

    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

  7. E. Yucel

    Great tutorial that introduced me to pivot tables. Thank you.

  8. Chad Pezza

    He just had to make it known that he works for Microsoft

  9. You're literally going to get me through my MSc data analysis this year 😭
    God bless you Kev🤞🏽

  10. Maria Tefa

    Thank you so much kevin, the video very useful

  11. Jonathan Owen

    Helpful and easy to follow instructional on pivot tables. Thanks!

  12. Airel Iqi

    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?

  13. Danny Funez

    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

  14. Lorie Zimmerman

    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.

  15. chusexy29

    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.

  16. elaineyho818828

    Thanks Kevin!! I am ready to create a pivot table tomorrow. Great example make it easy to understand. I am a subscriber now.

  17. Simin Akhlaghi

    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???

  18. Pól Réamonn

    Thank you Kevin. I start a job in Supply Chain tomorrow and will be using Pivot Tables so this tutorial is really helpful.

  19. 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🙂

Leave a Reply