Welcome to Chandoo.org. New here?

Thank you so much for visiting us & taking first step to become awesome in Excel. Please use below links to navigate our site.

Power Pivot course is now open, Please join to become awesome

Power Pivot course is now open, Please join to become awesome

Hi friends & readers of Chandoo.org,

I am happy to tell you that my latest online course – Power Pivot class is now open for your consideration. Please take a few minutes to read about this course and how it can help you. If you are ready to join, please click here.

Continue »

What is your favorite Excel book? [open thread]

What is your favorite Excel book? [open thread]

Today lets talk about Excel books. The question is simple.

What is your favorite Excel book? Please share your answers using comments.

My favorite books are..,

Continue »

Details about upcoming Power Pivot course

Details about upcoming Power Pivot course

As we are getting ready to open enrollments for my upcoming Power Pivot online class, I am having a very busy and exciting time. Today, let me share few more details about our course.

First about the Power Pivot

Power Pivot adds world-class Business Intelligence (BI), Reporting and analysis capabilities to plain old Excel. It lets you connect, analyze and visualize massive amounts of data with ease.

While this technology is hugely empowering it is also has a steep learning curve for many of us. So in 2013 I started an online class to teach Power Pivot. So far I have trained more than 800 people on Power Pivot. Most people (and businesses) have transformed the way they analyze data and present results once they discovered what Power Pivot can do.

And now, I am very glad to tell you that my Power Pivot course along with Rob Collie’s Advanced Power Pivot course (aka Power Pivot University) is open for new session.

We are opening these courses for enrollment on 10th of February (Next Monday) for your consideration.

Continue »

Combine pie and xy scatter charts – World Polls chart revisited

Combine pie and xy scatter charts – World Polls chart revisited

Few days ago, we learned how to create a pie+donut combination chart to visualize polls around the world in 2014. It generated quite a bit of interesting discussion (47 comments so far). One of the comments was from Roberto, who along with Kris & Gábor runs The FrankensTeam an online library of advanced Excel tricks, charts and other mind-boggling spreadsheet wizardry.

I really liked Roberto’s comments on the original post and a charting solution he presented. So I asked him if he can do a guest post explaining the technique to our audience. He obliged and here we go.

Over to FrankensTeam.

Continue »

Thank you and Excel, We have a new car

Thank you and Excel, We have a new car

Hi friends, readers & fans of Chandoo.org,

I want to share a happy news with you all.

On Saturday (1st of February), we bought a new car. It is Toyota Innova.

Read on to know more about the car, why we bought and a special thank you message to you.

Continue »

How to select a random sample from all your data [trick]

How to select a random sample from all your data [trick]

The other day, I got a text message (SMS) from one of our readers. It read,

So today, let us learn a very easy trick to select random sample from your data.

Continue »

5 reasons why you should learn Power Pivot

5 reasons why you should learn Power Pivot

Power Pivot for Excel has come a long way since it was introduced in late 2009. In the last 4 years not only has the technology matured, but also became a standard reporting platform in many businesses. As a smart analyst (or manager), you will gain a lot of mileage by adding this vital skill to your resume.

Today, let me show 5 reasons why you should learn Power Pivot this year.

Continue »