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!

Allot the correct shift – Excel Challenge

January 10, 2017| 11 Comments


I few weeks ago I conducted a training session for a large manufacturing company in India and faced an interesting question during the training program.

I want you to take a look at the problem and try knocking it down

Read More

How to Publish an Online Dashboard using Excel

January 2, 2017| 9 Comments


If you are reading this in early January of 2017, wish you a very happy new year! This being the first post in 2017, let’s try something new !

In this post I am going to show you how to publish your report or dashboard (that you have created in Excel) online.

By publishing it online I mean that once you have created the spreadsheet in your computer you can then create a shareable link and multiple users can access that report. And sure enough the report will be dynamic with all the slicers, buttons and fancy controls working in sync.

The only difference(s)

  • You work looks more smart and light (since you send a link and not a 50 MB attachment)
  • The users just get to see the smart dashboard and not the heavy duty workings that you have put in at the back-end
  • And possibly a brownie point for your promotion.. may be??
Read More

Combine Text in Multiple Rows into a single cell using TEXTJOIN Function

December 12, 2016| No Comments


Often times you may have the need to perform unusual tasks in Excel. One of such tasks is combining text in multiple rows into a single cell.

Here is a snapshot of a question asked from a friend!

At the first glance it looks like a simple Concatenate function but it is not! Because you’ll have to refer each cell separately in the concatenate function which is as good as doing manual work. Psss..

Here is an interesting way to get this done!

Read More

POLL : Why is Learning Excel Becoming all the more Important ?

November 22, 2016| 11 Comments


Image – Designed by Freepik

A while ago I met a guy (at my friend’s place) and we were talking about random shit. Here is some meaningful bit of that conversation

I : Hey dude, What’s up! How was your day?
He : It was okay man! I had an interview at Snapdeal
I : How did it go?
He : They handed me with 30k rows of dealer data and asked me to make sense from it
I : Do you need any help? (I had told him earlier about what I do)
He : Thanks Bro, but I have submitted my report. If only I learned Excel and basic math I would have been able to do much better. None of what I learned in my “MBA” mattered.

2 Quick Conclusions

  • Well I don’t agree that MBA is complete waste of time
  • But I do agree that having solid excel skills matter. It matters a hell lot!

Let me share with you some real time instances which reinforced that same conclusion over and over again

Read More

Find the Top ‘x’ Items [Pivot Table Trick]

November 9, 2016| No Comments


When you make a pivot table not necessarily we need the summary of all the items, there have been instances where I needed only Top 5 or Top 3 items to be displayed in the pivot table.

Here is a little trick that can help you do it with a few clicks

Read More

Download Smart Ebooks on
Excel and PowerPoint Presentations

© Goodly