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.

Sort by Birthday [Quick tip]

Sort by Birthday [Quick tip]

Lets say you have a list of employees and their birthdays. Now you want to sort this list, based on their birthday, not age. How would you do it?

Continue »

Last day for enrollments – Join our Power Pivot class & become awesome analyst

Hurry up, Enrollments for Power Pivot online classes closing in few hours - Join nowHi folks,

I have a quick announcement & a creative dashboard to share with you. First the announcement.

Only few hours left to join our Power Pivot course…

As you may know, I have opened enrollments for our 2nd batch of Power Pivot course few days ago. The aim of this course is to make you awesome in Excel, Advanced Excel, Dashboards, Power Pivot & Advanced Power Pivot.

We will be closing the doors of this program at midnight, today (11:59 PM, Pacific time, Friday, 16th of August).

If you want to join us, click here and enroll now.

Continue »

How to find the lowest value? [Quick tip]

How to find the lowest value? [Quick tip]

Lets say you are the head of purchasing department at Big Corp Co.

You are obviously very busy. Every day starting with a large cup of coffee and ends with a big smile, as you save your company thousands of $s by negotiating best deals, finding best providers and being awesome.

Today, let me share a small Excel tip with you that will make you even more awesome.

Continue »

How to create a Then vs. Now interactive chart in Excel?

How to create a Then vs. Now interactive chart in Excel?

You have been there before.

Trying to compare last year numbers with this year, or last quarter with this quarter.

Today, let us learn how to create an interactive to chart to understand then vs. now.

Demo of Then vs. Now interactive chart

First, take a look the completed chart below. This is what you will be creating.

Continue »

Power Pivot online classes – now open for you

Power Pivot online classes – now open for you

Hi friends, readers and supporters,

I am very glad to announce that our Power Pivot & Advanced Power Pivot classes are now open for you. If you are ready, Click here to join us.

Those of you new to this, read on.

What are these classes?

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.

Continue »

Excel Links for you – Busy busy edition

Excel Links for you – Busy busy edition

As the launch date for our 2nd batch of Power Pivot class nears, my plate looks fuller than ever. Fine tuning the course details, preparing our online classroom for new batch of students and coordinating with Rob for video recording etc.

But I wanted to take a few mins today and share with you some really useful Excel tricks, ideas and examples from web. I found these really useful and inspiring. I am sure you will learn from these links as much as I learned.

Continue »

Details about upcoming Power Pivot course (and a bonus tip on dashboards)

Details about upcoming Power Pivot course (and a bonus tip on dashboards)

Hello friends..,

I have 2 things for you:

  • Details about our upcoming Power Pivot courses
  • A short video about designing better dashboards.
Continue »