Learn Excel Pivot Tables in 1 Hour! | John Michaloudis MyExcelOnline.com | Skillshare
Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
12 Videos (1h)
    • Welcome Introduction

      1:25
    • Why Pivot Tables?

      6:20
    • Excel Tables & Tabular Format

      5:57
    • Creating your first Pivot Table

      6:03
    • Formatting a Pivot Table

      3:57
    • Summarize Values By: Sum, Average, Count

      2:32
    • Show Values As: Year to Date & Variance

      7:16
    • Grouping Your Data

      7:02
    • Inserting Slicers

      3:57
    • Inserting Pivot Charts

      2:19
    • Creating a Dashboard with Slicers & Pivot Charts

      4:12
    • BONUS: Pivot Table Tips!

      9:40
26 students are watching this class

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

Best of luck :)

John Michaloudis

Chief Inspirational Officer

www.myexcelonline.com

www.myexcelonline.com/blog - Sign Up to receive free weekly Excel lessons

1,085

Students

1

Project

  • --
  • Beginner
  • Intermediate
  • Advanced
  • All Levels
  • Beg/Int
  • Int/Adv

Level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

John Michaloudis MyExcelOnline.com

Stand Out From The Crowd

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 powe...

See full profile

Report class