Excel School online training program - become Awesome in Excel from Chandoo

Demo Lesson

Thank you for your interest in Excel School program. Please watch this demo lesson to get a feel. If you like my style and want to learn more, sign up using the links below.

Advanced Pivot Table tips & tricks

Most of us know Pivot Tables. They are a very powerful and useful feature of Excel. In this, learn how Pivot tables work in modern Excel, concepts of relationship & data model and how to create, customize and work with pivot tables.

What is in this lesson?

  • Pivot tables in modern Excel
  • Pivot table layout and design
  • Grouping, hierarchies
  • Slicers, filters and more

Watch this lesson [33 mins]

Download the workbooks:

Download Workbooks for this lesson

Your teacher - Chandoo

My name is Chandoo and I will be your teacher in Excel School program. I have been training people on Excel, Power BI, Power Pivot and analytics for over a decade. My teaching is practical and hands-on with several real world examples. I have taught more than 20,000 people to date (online and offline) and I would love to help you. I live in coastal city of Wellington in New Zealand with my beautiful wife and two kids.

0
Excel School students to date

8 reasons why

  • Step-by-step instruction
  • 20 hours + video content
  • 50+ Example workbooks
  • 24x7 online access
  • Download HD quality videos
  • 2 years validity
  • Secure classroom
  • 30 day money-back guarantee