Close this search box.

Details about our Power Pivot Course [and a video for those of you not interested]



Hello folks,

If this article was a person, they would be schizophrenic. You see, it has 2 purposes:

  • Give you all the details about my upcoming Power Pivot course
  • Give you a solution to last week’s vacation days problem

Details about Power Pivot Course

In case you are not interested in this course, skip to the solution video.

What is this course?

Power Pivot, an Excel add-in makes it easy to connect, analyze & visualize massive amounts of data. This course aims to teach you how to use Power Pivot to analyze data, create advanced reports & prepare dashboards all from familiar interface of Excel.

Who should go for this course?

This course is ideal for data analysts, reporting & MIS professionals, business analysts, managers & dashboard makers.

Please note that you should be familiar with Excel & Pivot Tables and running at least Excel 2010 to enjoy this course.

Course topics, methodology & full details:

I made a short video explaining how this course works, benefits for you, topics covered and more. Please watch it below

(click here in case you are not able to see the video in email or feed reader)

Download Power Pivot course brochure

Click here to download our course brochure.

Use it to,

  • Ask your company / boss to sponsor your for this course
  • Understand topics & benefits of the course
  • Learn how our course works
  • Know about Chandoo – your instructor
  • Find out how to get in touch with me if you have doubts or questions
  • See what our earlier students think about us


  • Enrollment for course begins on: 6 Feb 2013 (Wednesday)
  • Enrollment closes on: 15 Feb 2013 (Friday)
  • Classes begin on: 18 Feb 2013 (Monday)

Demo lessons

For free demo lessons on Power Pivot, click here.

Questions or doubts?

If you have any questions or doubts about our course, please email me at chandoo.d@gmail.com or call me at +91 814 262 1090.

Solution to Vacation Days problem

On Friday, we posted a home work problem for you – Calculate vacation days using formulas. There were quite a few interesting solutions in the comments.

Today, let me explain how to solve these problems using Excel formulas.

Watch below video:

Download solution workbook

Click here to download the solution work book & see the formulas.

Not interested in either of them?!?

Then what are you doing here? Go out and enjoy the sun, sip some coffee or play with your kids 🙂

PS: Once power pivot and regular pivot were in a bar bragging to each other. Power Pivot says, “I am so awesome I can turn data in to insights in no time.”, After thinking long and hard, Pivot table says, “I don’t know, I can’t really measure.”


Share this tip with your colleagues

Welcome to Chandoo.org

Thank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME.

Read my storyFREE Excel tips book

Chandoo is an awesome teacher

– Jason

From simple to complex, there is a formula for every occasion. Check out the list now.

Calendars, invoices, trackers and much more. All free, fun and fantastic.

Still on fence about Power BI? In this getting started guide, learn what is Power BI, how to get it and how to create your first report from scratch.

Announcing Power BI Dashboard Contest 2024

Announcing Power BI Dashboard Contest (win $500 prizes!)

Hey there, I have a SUPER exciting announcement! April is about to get a whole lot sweeter with our Power BI Dashboard Contest! Your mission, should you choose to accept it: Craft the most EPIC dashboard for the Awesome Chocolates CEO with sales & financial insights! Winners stand a chance to score up to $500 in Amazon Gift Cards, plus some serious bragging rights!

4 Responses to “Details about our Power Pivot Course [and a video for those of you not interested]”

  1. Hi Purna,
    You can add me power pivot waiting list.
    Mustafa ASLAN

  2. Javkhaa says:

    How to install power pivot in excel?

  3. Arie says:

    In the 2nd question for the vacationdays calculation video you are missing the case where the starts before the startdate and ends after the end date (not happening in the example, but possible in real life). A better solution is to count all cases where the vacation starts before the end date and ends after the startdate:
    =countifs(vacations[Start Date],"<="&end,vacations[End Date],">="&start)

  4. Brenda says:

    Can you notify me of the next Power Pivot course?
    Thank you,

Leave a Reply