Current Status
Not Enrolled
Get Started

What's Included In This Course

Many people are afraid of PivotTables, but in this course I’ll quickly have you building your own PivotTables with confidence. Once you understand the key ingredients of a PivotTable, you’ll wonder what all the worry was about.

I know your time is valuable, which is why the complete course is just under 1.5 hours long with tutorials broken into short videos (on average 5 minutes long).


  • Ideal Data Layout for PivotTables – get this wrong and you’ll have nothing but trouble
  • Creating PivotTables
  • Formatting, Grouping Data and Sorting
  • Aggregation Options and Show Values As
  • Pivot Charts
  • Filters, Slicers and Timelines
  • Adding New Data and Refreshing
  • Troubleshooting – what causes problems and how to fix them
  • Conditional Formatting
  • Calculated Fields and Items
  • Introduction to the Data Model
  • PivotTable Options and Settings

This course is for you if:

  • You want to learn about Pivot tables functionality or usage.
  • You currently use Excel, this course will take you to the next level.
  • You have been looking for an affordable program or reporting tool that will bring your data to life and make it readily available to your audience.
  • You want to ramp up your skills so you’re ready to take on that analyst role, or tame some big data.
  • Requires Excel 2007 or later. The course was filmed in Excel 2019/Office 365.
  • Prices are +GST for Australian customers.
  • If you purchase the Online + Download option, course videos will be available for download after the 30 day Money Back Guarantee period ends.
  • Membership and access to the training materials is for one person only. Logons are not to be used by multiple people.
  • Downloaded videos are to be used only by the registered member, they are not to be transferred/shared amongst other people.
  • You can request a refund provided that no more than 30% of the course videos have been watched.

Reviews & Instructors

Have a look to who is teaching this course and what are the learners views, it's always good to know what you think about this course.


There are no reviews yet. Be the first to review.

About the Instructors

Treacy M, is a qualified accountant and has been working with Excel since 1995, and sharing her knowledge on her Excel blog since 2010. In 2014 she was awarded Microsoft Excel MVP for her contribution to the Excel community. She also teaches several highly acclaimed Excel courses including an Excel Dashboard Course and Excel Expert course . Her courses incorporate real business scenarios drawn from her accounting background and work experience in multi-national companies in London. Her teaching style is to the point with practical examples and files you can download for reference later on. She doesn't waffle on just to make the course long. She'd rather get you up to speed quickly because she knows that what you really want is to know how to do this stuff, not spend hours watching videos.


There are no reviews yet. Be the first to review.