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.

CP019: 6 Tips for Best Practice Modeling – Interview with Danielle from Plum Solutions

CP019: 6 Tips for Best Practice Modeling – Interview with Danielle from Plum Solutions

In the 19th session of Chandoo.org podcast, lets talk about modeling best practices.

What is in this session?

I am very happy to interview my good friend, blogger, author, excel trainer & business-women – Danielle Stein Fairhurst for this session. I first met Danielle when I went to Sydney, Australia in April 2012. Our friendship & collaboration grew a lot in the last 2.5 years. She is a great speaker & trainer. This episode is loaded with her trademark style commentary, explanation & tips for better modeling. I hope you will enjoy it.

In this podcast, you will learn,

  • Introduction to Danielle & her work
  • 6 Tips for Best Practice Modeling
    • Write consistent formulas
    • Avoid hard-coding
    • Smart referencing
    • Ditch the bad habits
    • Document assumptions
    • Format & label things
  • Resources for learning more
Continue »

Quickly convert numbers stored as text [tip]

Quickly convert numbers stored as text [tip]

Here is a quick tip to start the week.

Often, we end up with a situation where a bunch of numbers are stored as text.

In such cases, Excel displays a warning indicator at the top-left corner of the cell. If you click on warning symbol next to the cell, Excel shows a menu offering choices to treat the error.

Continue »

CP018: Dont be a Pivot Table Virgin!

In the 18th session of Chandoo.org podcast, lets loose your Pivot table virginity.

Note: This is a short format episode. Less time to listen, but just as much awesome.

CP018: Don't be a Pivot Table Virgin! - Introduction to Excel Pivot Tables - Chandoo.org Podcast

What is in this session?

Pivot tables are a very powerful & quick way to analyze data and get reports from Excel. But surprisingly, not many use them. Today, lets bust your pivot table virginity and understand the concepts like pivoting, values, labels, filters, groups and more.

In this podcast, you will learn,

  • Announcements
  • What is a Pivot Table?
  • Example of business data & reporting needs
  • Key pivot table terms to understand
  • Creating your first pivot table
  • Learning more about pivot tables
Continue »

Convert fractional Excel time to hours & minutes [Quick tip]

Convert fractional Excel time to hours & minutes [Quick tip]

Time for another quick Excel tip.

Lets say the park near your house rents tennis courts by hour. And they charge $10 per hour. At the end of an intense tennis playing week, Linda, the tennis court manager called you up and said you need to pay $78 as rent for that week.

How many hours did you play?

Of course 78/10 = 7.8 hours.

But we all know that 7.8 hours makes no sense.

We also know that 7.8 hours is really 7 hours 48 minutes.

So how to convert 7.8 hrs to 7:48 ?

Continue »

What is the average speed of this road trip? [Solution & Discussion]

What is the average speed of this road trip? [Solution & Discussion]

Last week, we had an interesting homework problem – What is the average speed of this road trip?

We received more than 150 answers. But to my surprise, 57 of them are wrong. So today, lets learn how to calculate the average speed correct way.

Continue »

CP017: Top 10 non-Excel MS Office tips for you – Interview with Paul Woods – Office MVP & Blogger

CP017: Top 10 non-Excel MS Office tips for you – Interview with Paul Woods – Office MVP & Blogger

In the 17th session of Chandoo.org podcast, lets leave Excel aside and talk about other MS Office apps.

Thats right. We will be learning 10 tips on how to use Word, Power Point, Outlook etc. Ready?

In this podcast, you will learn,

  • About Paul
  • Ten tips for MS Office
  • 1. Use Excel to communicate instead of just calculations
  • 2. Paste Special
  • 3. Double click trick!
  • 4. Inserting screenshots
  • 5. Turning off notifications
  • & more…
Continue »

Mapping relationships between people using interactive network chart

Mapping relationships between people using interactive network chart

Today, lets learn how to create an interesting chart. This, called as network chart helps us visualize relationships between various people.

Demo of interactive network chart in Excel

First take a look at what we are trying to build.

Looks interesting? Then read on to learn how to create this.

Continue »