Chandeep Chhabra

Become Unbelievably "Excel"lent !

Hi, My name is Chandeep!

Since 2013, I have been training, consulting and blogging to help people become quicker and smarter with Excel

Let me get you started by sending you smart ebooks on Excel and Powerpoint!

Let's Get Started!

Cost Structure Visualization – Chandoo’s Visualization Contest

July 12, 2016| 2 Comments

Last week I participated in Chandoo’s Visualization Challenge, where we were given some raw data and had to make a meaningful visualization (Dashboard) out of it. In this post I am going to share everything about how I went along in creating this dashboard.

Compare Companies View

Overall Market View

Read More

Timeline Chart in Excel

July 9, 2016| No Comments

Timeline Chart in Excel One

Every once in a while I make a timeline in PowerPoint to show how the tasks are scheduled over time. I thought it would be nice to have a template in Excel where I just add events and dates and the chart is created by itself.

So today it is time for a short tutorial on a timeline chart

Read More

Custom Formatting Tricks

July 6, 2016| 4 Comments

10 Custom Formatting Tricks 1

Even if you have no idea what is custom formatting, these tricks will help you win over some common formatting needs for your data

Read More

Learn 100 Excel Formulas

June 30, 2016| 4 Comments



Recently I conducted a survey, to find out what are your pain points while using Excel in everyday work. I found that a majority of us struggle with writing Excel Formulas. Hmm… So I spent a few days recording ex-plainer videos for about 100 most used functions in Excel.

I have explained each formula

  1. In a very simple manner
  2. Plus given you some must know rules (wherever applicable) that you should keep in mind when you use these formulas
  3. The Downloadable Excel file used as a case in the video


As of now I have completed about 40 of the 100 videos and will wrap the remaining in a few days. AND YOU MUST BOOKMARK THIS PAGE

Read More

Use MIN MAX to Replace IF Function

June 28, 2016| 2 Comments

Use MIN MAX to Alternate IF 1

Take a look at this case and think about how are you going to solve it without using IF / AND or any other Logical function


Case 1

Use MIN MAX to Alternate IF


Case 2

Use MIN MAX to Alternate IF 2

Read More

Download Smart Ebooks on
Excel and PowerPoint Presentations

© Goodly