Learn Excel Pivot Tables in 1 Hour!
- 1x (Normal)
Why Pivot Tables?6:20
Excel Tables & Tabular Format5:57
Creating your first Pivot Table6:03
Formatting a Pivot Table3:57
Summarize Values By: Sum, Average, Count2:32
Show Values As: Year to Date & Variance7:16
Grouping Your Data7:02
Inserting Pivot Charts2:19
Creating a Dashboard with Slicers & Pivot Charts4:12
BONUS: Pivot Table Tips!9:40
About This Class
DOWNLOAD THE EXCEL WORKBOOKS FROM THIS VIDEO: Downloadable Excel Workbooks
No matter if you are a Beginner or an Advanced user of Excel, you are sure to benefit from this 1 hour tutorial which goes through the most important tools that are available in an Excel Pivot Table. The course is designed for Excel 2007, 2010, 2013 and 2016.
You will learn about using an Excel Table for your data source, inserting a Pivot Table, Formatting, Summarizing and Analyzing data, Grouping, Slicers, Pivot Charts, Excel Dashboards and lots of Excel and Pivot Table Tips!
So go ahead and learn the power of Excel Pivot Tables... every hour you delay is delaying your professional progress ...
Class Projects 1 See All
17 of 17 students recommendSee All
An extremely helpful guide to learning just what Pivot Tables are and the power they hold. The content is presented in easily digestable chunks, and is really easy to follow with the provided materials. My mind has been blown by what I've learned here.
Carpe the Diem!
Hello fellow Excel lovers/beginners/experts/users!
My name is John Michaloudis and I am the founder and Chief Inspirational Officer at MyExcelOnline.com and long time lover of Excel.
I hold a bachelors degree in Commerce (Major in Accounting) from La Trobe University in Melbourne, Australia and speak English, Greek and Spanish.
My journey in to Excel began after I graduated and have since helped many of my colleagues around the world understand this underutilized but powerful tool. Now its my turn to teach the rest of the world with these high quality and easy to understand tutorials!
I am currently living in the North of Spain and I´m married and have one cheeky boy. You could describe me as a football lover, wine & beer drinker, food indulger and occasional gym goer.
Free Excel Blog Tutorials >> http://myexcelonline.com/blog/
Make sure to Subscribe to receive FREE weekly Excel lessons!
Excel Podcasts >> http://www.myexcelonline.com/podcast/
Get the Excel insights from the Excel experts!