Ultimate Excel PivotTables Tutorial: Beginner to Advanced - 3.5 Hours!

✅ Download the free course demo files to follow along
➡️ www.simonsezit.com/pivottable...
We've combined some of our very best Excel PivotTables tutorials in this training video to take you from beginner to expert in under 4 hours! We've split this tutorial into 4 comprehensive topics to make sure we got you covered.
We start off with the basics with Getting to Grips with Pivot Tables in Excel, where we teach you what PivotTables are and why they are useful. We'll go over understanding data and Excel tables before creating your very first Pivot Table. We'll show you how to analyze data using a Pivot Table and some basic formatting, including creating a Pivot Chart.
We then move on to Advanced PivotTables in Excel, where we give you a quick PivotTables recap and look at formatting values, sorting and filtering pivot data, and summarizing values. We'll then teach you more about working with Pivot Charts, slicers, and calculated fields.
Next, we introduce you to Using the Data Model to Create a Pivot Table, where we look at what a data model is and provide an example of a basic PivotTable report. We'll teach you how to get and transform data from a folder, work with the Power Query editor, create relationships between tables, create a consolidated Pivot Table, and more.
Finally, we discuss Charts and Dashboards in Excel, where we teach you how to build dashboards using PivotTables and Pivot Charts. Learn how to create a beautiful-looking dashboard with some top Excel design tips, add interactive elements like slicers, make your Pivot Charts and graphs display exactly what you want using filters, and link your graphs and charts to a single slicer.
We've even included downloadable course files so you can follow along in this course. This will help you put what you are learning into practice and master PivotTables in Excel.
✅ www.simonsezit.com/pivottable...
📝 Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead!
00:00:00 - Getting to Grips with Pivot Tables in Excel
00:53:19 - Advanced Pivot Tables in Excel
01:51:52 - Using the Data Model to Create a Pivot Table
02:34:08 - Charts and Dashboards in Excel
🌍 Get unlimited training with Simon Sez IT’s 160+ courses ⏩ www.simonsezit.com/courses/
🚀 Level up your skills with a free 30-day trial to our complete training library of 8,500+ videos ⏩ www.simonsezit.com/ssit-first...
💻 Watch more free popular training tutorials from Simon Sez IT:
🔥Check out our FREE 300+ hour training course playlist here ➡️
• Simon Sez IT Long Trai...
✅ Check out our free video playlist for PivotTables 👉 • How to Use Pivot Table...
✅ Pivot Tables - All you can Eat playlist here 👉 • Pivot Tables - All you...
✅ Microsoft Excel Tips and Tricks 👉 • Microsoft Excel Tips a...
✅ Advanced Pivot Tables in Excel here 👉 • Advanced Pivot Tables ...
💬Stay in touch!
SimonSezIT.com: www.SimonSezIT.com/
LinkedIn: / simon-sez-it
FaceBook: / simonsezit
🔔 Subscribe to our channel:
kzbin.info...
If you enjoyed the video, please give a thumbs up 👍🏽 ;-)

[@SimonSezIT]

We have additional free Excel training here 👉 kzbin.info/aero/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI and here 👉 kzbin.info/aero/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u and Excel Tips and Tricks Training 👉 kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc 🔥Check out our FREE 300+ hour training course playlist here 👉kzbin.info/aero/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

[@sallyho146]

Thank you for the video Simon. How to make unit sold in negative number in pivot table? In the value field setting, summarize value field by used ‘count’. If I put negative 1 as cancel sales, the pivot table picked up as positive 1 instead of negative 1. Therefore the total sales is increased by 2 instead of reduced by 1, i.e: became 20 instead of 18. How do I fix that?

[@taneshiadunn3435]

Debbie, I just wanted to let you know what an awesome instructor you are. I've taken very many online classes and tutorials, and I must say that you are by far one of the best instructors. Thank you so much!

[@SimonSezIT]

Wow, thank you!

[@N7eptune]

Really I find it easy just create a table then insert a Recommended Pivot Tables and accept any suggested one then just play with it until you get what you want. Easy.

[@ecast1500]

i am at the 24 minute mark and have learned more then the last 20 or so video gurus talking about pivot tables, This expert is actually reading the minds of the students. back to the presentation

[@power-reconcile]

Amazing Tutorial! Thank you for sharing!

[@Zai488]

The best tutor for excel so far. Big up Ashby

[@babatundeegbeyemi9168]

worldwide web madam Ashby. Transforming peoples life with microsoft empowerment. I really can't thank you enough. E seun ma (yoruba language from Nigeria)

[@SimonSezIT]

I'm glad you enjoyed it. Thanks for watching! 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 kzbin.info/aero/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaR

[@a.achirou6547]

Amazing Tutorial! Thank you for the effort you put in.

[@yohannesabraham7472]

What a contentfull video delivered in a detailed and clear manner by the legend Debs.. I can't believe that we are getting such a valuable full-blown course on Pivot table for FREE... Thank you so much and may God bless you guys !!

[@SimonSezIT]

Glad you enjoyed it

[@ARIFSAIFIFARHAN]

Thanks deb, I enjoy your session and also this one. This session will add some additional tone in my skills ahead.

[@lnprv]

Thank you! Great tutorial!

[@MichalKatD]

Great tutorial!!

[@nashonamele5687]

Good work Deborah, you are one the best I have met online

[@SimonSezIT]

Thank you! 😃

[@alimansimov1929]

01:28:30(average, count of sales),, 01:34:20(calculated field(additional calculate)),, 01:40:25 (dashboard)

[@johannpauldalingay7329]

Thank you!!! 😄

[@ablodiallo4020]

amazing thank you.

[@SimonSezIT]

Glad you liked it! 😃 Learn more Microsoft Excel Tips and Tricks here ➡️ kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc

[@tubeexpose]

Thanks a lot Ashby.. You are really Great Tutor..👍👍

[@SimonSezIT]

You are most welcome

[@Kingco245]

This tutorial is value-packed. Learning so much “tips and tricks.” How did you change the default fill color of the pivot field header and total row?

[@ExcelServicios]

Excelente, Video

[@user-rq9hv6jm5l]

Awesome! Thank you so much

[@SimonSezIT]

Glad you enjoyed it. Thanks for watching! 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 kzbin.info/aero/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Level up your Excel skills with free training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzbin.info/aero/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZbin Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzbin.info ♥️ We appreciate your support!

[@eibnakaesh325]

thank you so much

[@kabirfayez2010]

Fantastic

[@SimonSezIT]

Thanks for watching. We're glad you enjoyed it 😊 🔥Check out our FREE 300+ hour training course playlist here 👉 kzbin.info/aero/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Level up your Excel skills with free training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzbin.info/aero/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZbin Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzbin.info ♥️ We appreciate your support!

[@AJ-et3vf]

Awesome video! Thank you!

[@SimonSezIT]

Glad you are enjoying the training. 😀

[@rabeehaithamrashid942]

Great, thank you! :)

[@SimonSezIT]

You are very welcome! Thanks for watching 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 kzbin.info/aero/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Level up your Excel skills with free training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzbin.info/aero/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZbin Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzbin.info ♥️ We appreciate your support!

[@ashutoshpoudyal2705]

Thank You so much

[@SimonSezIT]

You are very welcome! Thanks for watching 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 kzbin.info/aero/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

[@joelmanhede5670]

Excellent

[@SimonSezIT]

Thank you so much 😀

[@microsoftsarker]

Thank you.

[@SimonSezIT]

Welcome!

[@anhlenguyen404]

Thank you! Great lessons. I would like to you to clarify one thing: at the end of the second part (Advanced), the title should be "Sales by Country" instead of "Sales by Product"? It makes me confused a bit. Thank you

[@georgesaab7609]

Thank you for the help! I have one concern however: when combining the two "binary" files using the Power Query, it was failing to combine them giving me a DataFormat.Error.. how can this be fixed?

[@saludares888]

Its a big help...great tutorial

[@SimonSezIT]

Glad you think so! 😊

[@lindsayk3599]

Cant get file get 404 file. Will go to pragmatic no issues there.

[@user-vy6nj7cm3w]

Hi how to delete a preceding date and retain the last date in excel for example 2006/03/08 to 2026/08/28

[@gozieprince9530]

I'm in London, I need go teacher like Debbie

[@user-my5ez6gz7x]

please help me with the training files.

[@dragonflylifestyle-travelm3565]

Debbie, i did not receive the sales data worksheet showing Store Data & July Data. You use this workbook in the initial stage of the video. what do I do? Kindly assist, many thanks.

[@SimonSezIT]

Hi! It's there in the free demo files download named Getting to Grips with PivotTables demo file.

[@tanweerabbasabbas649]

email for sample data never arrives!!. why not just directly give accesss here!. lovely video though

[@SimonSezIT]

Have you checked your spam folder? We just tested it and it works fine.

[@jignasajoshi27]

i am getting same problem.... i have checked my spam folder too.@@SimonSezIT

[@abeybrams2366]

Thank you so much for these helpful tutorials.

[@SimonSezIT]

You are very welcome :-)

[@falconeye577]

Well, I will sit here and learn as I want this to be something I can use but I was told it would not work for me I hope they were wrong

[@kishan0705]

Ma'am sales 2020 data are not found in downloaded files, btw great pivot tutorial ❤

[@SimonSezIT]

It's saved under the subfolder Using the Data Model to Create PivotTables demo files

[@Stache987]

If you find a pivot table exciting, you must have a nerdy or dull life

[@ShivamRai-xo8fu]

I understand what you say and respect your age but you should not be so negative minded. This video helps to reduce work life by 60percent. World has changed by the time you retired, Sir. Take Care.

[@Stache987]

@@ShivamRai-xo8fu I quoted her, goodbye 👋

[@ShivamRai-xo8fu]

she really said that? Lol. put the time stamp before going mr 28subs

[@jaroslavjurisin2715]

As Matt Parker once said: "I can't believe some people don't use spreadsheets recreationaly." 😊

[@numeroVLAD]

Why so long and so much beating around the bush

[@MK-lh3xd]

What? This is probably the most non-fluff, to the point video I have seen.

[@user-cf6mg2lo5v]

Facebook