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

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.

Watch below video:

Download solution workbook

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

Sign-up for our FREE Excel tips newsletter:

Here is a smart way to become awesome in Excel. Just signup for my FREE Excel tips newsletter. Every week you will receive an Excel tip, tutorial, template or example delivered to your inbox. What more, as a joining bonus, I am giving away a 25 page eBook containing 95 Excel tips & tricks. Please sign-up below:

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)