Advanced Excel & Power Pivot Training Classes Copy

Become a Data Analysis & Dashboarding Pro!

Advanced Excel & Power Pivot Training Classes - What is this course, benefits for you & how to join?

Highlights of this course

Basic to Advanced Excel
Awesome Data analysis, Dashboards & Power Pivot
Focus on practical tips & productivity
150 videos, more than 70 hours lessons
Example workbooks, class projects & more
Available 24×7, Learn at your own pace
30 day money back guarantee
Add to cart

What is this course?

These days almost any job requires data analysis & presentation of results. While anyone can put a list of values in Excel & sum them up, not everyone can do advanced analysis, create charts, make them interactive, summarize data intelligently, present output in an intuitive dashboard or slice & dice data using Pivot tables & Power Pivot. Having these vital skills can make you invaluable to your organization & expose you to new opportunities. Not to mention the amount of time, money & effort you can save by efficiently using Excel.

That is why we have created 3 powerful courses – Excel School, Power Pivot & Advanced Power Pivot classes. Think of these as steps in a ladder.

Excel School program teaches you how to analyze data, create pivot tables, make charts, design interactive dashboards using Excel.

Power Pivot class shows you how to use Power Pivot (an Excel add-in) to connect to your enterprise databases, analyze data, create advanced reports & prepare dashboards right from familiar interface of Excel.

Advanced Power Pivot class takes you in to the depths of data analysis thru measures & brilliant techniques so that you can dig insights out of mountains of raw data.

Good examples, very open and responsive teacher, overall very positive experience

– Greg

Who should go for this course?

All these courses are ideal for data analysts, reporting & MIS professionals, business analysts, managers & dashboard makers.

That said, Excel School is suitable for you if you are a beginner or intermediate level user of Excel.

On other hand, Power Pivot courses are for you if you are an advanced user of Excel & looking for ways to enhance your skills in data analysis, pivoting & reporting areas.

To Enjoy Excel School: You can be a beginner or intermediate level user with Excel 2007 or above.

To enjoy Power Pivot course: You should be familiar with Excel & Pivot Tables and running at least Excel 2010. You must have Power Pivot installed on your computer.

Tip - Bundle courses to save money & become data analysis + dashboard pro

What do our students say about Excel School program

Topics of this course

Excel School Program
Excel School course topics

  1. Introduction to Excel
  2. Basic Excel formulas
  3. Advanced Formulas
  4. Awesome Formatting Tips
  5. Conditional Formatting
  6. Excel Tables
  7. Pivot Tables
  8. Charting Basics
  9. Advanced Charting
  10. Interactive Charts
  11. Data Validation & Sorting
  12. Introduction to Macros & VBA
  13. Dashboard Design
  14. Dashboard Tutorials – 8
  15. Guest Lessons & Bonus Content

Click here to see detailed lesson plan

Download Course brochure for full details - Power Pivot & Excel School courses - Chandoo.org

Power Pivot
Power Pivot course topics in a nut-shell

  1. Introduction to Excel 2010 & 2013
  2. Installation & Set up of Power Pivot
  3. Power Pivot features
  4. Power Pivot Case Study
  5. Using Tables & Structured References
  6. Using Pivot Tables & Slicers
  7. SQL Basics
  8. Power Pivot formulas & DAX
  9. Complex DAX examples
  10. Working with time-intelligence
  11. Disconnected tables & slicers
  12. Simple Power Pivot Dashboards
  13. Form controls & interactivity
  14. Charting & Dashboard Theory
  15. Complex Power Pivot Dashboard
  16. Advanced Concepts & Guest Lectures

Click here to see detailed lesson plan

Download Course brochure for full details - Power Pivot & Excel School courses - Chandoo.org

Advanced Power Pivot
Advanced Power Pivot course topics in a nut-shell

  1. Introduction to Advanced Power Pivot
  2. Working with Multiple Tables
  3. Cube Formulas
  4. Disconnected Slicer Techniques
  5. Standard Time Intelligence
  6. Custom Calendars
  7. Advanced Power Pivot Techniques – Part 1
  8. Advanced Power Pivot Techniques – Part 2
  9. Power Pivot Performance Optimization
  10. Macros for automating Power Pivot work
  11. Bonus Concepts & Guest Lectures

Click here to see detailed lesson plan

Download Course brochure for full details - Power Pivot & Excel School courses - Chandoo.org

Special Bonus Content

Apart from all these lessons, you will also get below mentioned special bonuses

For Power Pivot Courses:

  • Rob Collie’s DAX formulas for Power Pivot e-book
  • Top 10 DAX formulas – Cheat sheet
  • Guest lessons by Bill Jelen (Mr. Excel), Ken Puls, Miguel Escobar, Zack Baresse.

For Excel School Course:

  • Excel Fromula Cheat sheet
  • Important Keyboard shortcuts – Poster
  • Designing good charts – eBook
  • Master Excel Ribbon – eBook
  • Guest lesson by Debra Dalgleish on “Pivot table tricks”
  • Guest lesson by Mike Alexander on “Connecting Excel to Access”
  • Guest lesson by Robert on “Excel Dashboards & Maps”
Benefits for you

You get 3 kinds of benefits from this course.

1. Course Videos

Power Pivot & Excel School course benefits - outlinedIn Excel School:

  • 12 modules on Excel & advanced Excel
  • 4 modules on Excel dashboards
  • 3 Guest modules by Robert Mundigl, Debra Dalgliesh & Mike Alexander

In Power Pivot course:

  • 10 Modules on Power Pivot
  • 6 Bonus modules on Excel, dashboards & SQL
  • Guest module by Rob Collie
  • Guest module by Ken Puls

In Advanced Power Pivot course:

  • 9 Modules on Advanced Power Pivot taught by Rob Collie
  • Bonus modules on Power BI features
  • Guest modules by Bill Jelen (Mr. Excel), Zack Baresse & Miguel Escobar

2. Downloads

With any course, you get:

  • Excel Workbooks & material
  • HD Quality videos for download

Apart from this, in Excel School:

  • Excel formula cheat sheet
  • Frequent Keyboard shortcuts poster
  • Chart Design e-book

And in Power Pivot course:

  • Rob Collie’s DAX formulas for Power Pivot eBook
  • Top 10 Power Pivot Formulas – Cheat Sheet

In Advanced Power Pivot course:

  • Rob Collie’s DAX formulas for Power Pivot eBook
  • Top 10 Power Pivot Formulas – Cheat Sheet
  • DAX Patterns for Power Pivot – eBook

3. Online Classroom

Once you join this course, you will be able to access our online classroom with below benefits:

  • 12 months access
  • View lessons 24×7
  • Discuss with classmates
  • Ask questions & doubts
  • Home work problems
  • Course completion certificate
  • 30 day money-back guarantee

Join the class
Excel School

What you get?


24hrs on Excel
8hrs on Dashboards
Bonus:eBook & guides

All for just $247

Sign up

Alternative Payment Links

Power Pivot

What you get?


18hrs on Power Pivot
6hrs Bonus modules
Bonus:eBook & guides

All for just $247

Sign up

Alternative Payment Links

Adv. Power Pivot

What you get?


12hrs on Adv. PP
4hrs Bonus modules
Bonus:eBook & guides

All for just $247

Sign up

Alternative Payment Links

Any 2 Courses

What you get?


40hrs+ video
Bonus Modules
Bonus Materials
$47 Savings!

All for just $447

Sign up

Alternative Payment Links

All 3 Courses

What you get?


70hrs+ video
All Special Bonuses
All Bonuns materials
$94 Savings!

All for just $647

Sign up

Alternative Payment Links

Icon - Credit CardMoney Back Guarantee 100% - Burst Badge Green

The progression of the lessons and methodology used to teach the courses is fantastic. Chandoo has put together comprehensive Excel material that is easy to understand and clearly provides all students with the skills to be an advanced Excel User. Thank You!!
– John Geiger
Feedback from our students
Frequently Asked Questions

Q. Can I upgrade to include Power Pivot or Excel School after joining?
Yes, you can upgrade by paying $217 to include either Power Pivot or Excel School course after joining. You will find details about this in the classroom area.
Q. Which version of Excel do I need?
For Excel School course: You need Excel 2007 or above (for Mac users, Excel 2011)
For Power Pivot course: You need Excel 2010 or Excel 2013 Professional Plus or Office 365 with Power Pivot add-in enabled.
Q. Do you have discounts for team enrollments?
Oh yes, we have. Visit team discounts page to know more & enroll with discounted prices.

1. The chapters are arranged in good sequence
2. The topics covered are exhaustive
3. Practical examples are taken from various industry
4. There is index on the start of every chapter for the topics covered
5. I received revert for few of my queries and that helped me in my job
6. The download of chapter can be a ready reference for life long
7. The reference website give for more exploration helped to get detail knowledge on topic

-Shrikant K

Doubts or Questions?

If you have any problem during signup process or still have some un-answered questions, write to me at chandoo.d@gmail.com or call me at +1 216 527 8597 or +91 994 888 9566. I will be very glad to answer your questions.

I hope to see you in Power Pivot & Excel School.