fbpx
Search
Close this search box.

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

Share

Facebook
Twitter
LinkedIn

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

IMPORTANT DATES

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

Facebook
Twitter
LinkedIn

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
5/5

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

Weighted Average in Excel with Percentage Weights

Weighted Average in Excel [Formulas]

Learn how to calculate weighted averages in excel using formulas. In this article we will learn what a weighted average is and how to Excel’s SUMPRODUCT formula to calculate weighted average / weighted mean.

What is weighted average?

Wikipedia defines weighted average as, “The weighted mean is similar to an arithmetic mean …, where instead of each of the data points contributing equally to the final average, some data points contribute more than others.”

Calculating weighted averages in excel is not straight forward as there is no built-in formula. But we can use SUMPRODUCT formula to easily calculate them. Read on to find out how.

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.
    rgs,
    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