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!




Highlight Parts of a Line Chart

May 6, 2016| 2 Comments

How to Highlight Parts of a Line Chart

The other day I was gazing at a business metric (a line chart) and I felt the need to just select a part of the line chart and focus on what happened during that time frame.

So I fired up some geeky stuff in Excel and created a chart to do that exact thing! Let’s jump right into it! Interested ?

Read More

Make your Vlookup Robust

May 3, 2016| 3 Comments

Make your Vlookup Robust

Typical technical (Excel) interview happens like this

  • To Be Boss : “How would you rate yourself in Excel ?”
  • You (thinking, I guess I am pretty good) : “I’ll rate myself 8”

Alright Alright.. guess the next question

  • To Be Boss : “Do you know Vlookup ? “
  • You (hah!) : “I’ll know Robust VLOOKUPs”
  • To Be Boss (a bit scared now) : “Alright, you are hired, but you’ll have to teach me as well” 

😀

Today, I am going to take your VLOOKUP skills and make them more robust. Take a look at a short video [10 mins]

Read More

5 Charting Hacks to Help You Work Faster

April 22, 2016| 1 Comment

5 Charting Hacks to help you work faster 5

Here are my top 5 charting hacks that have saved me a ton of time. They are incredibly simple and equally powerful!

Read More

Customized Scroll Bar in Excel

April 19, 2016| No Comments

Customized Scrollbar in Excel

When I got bored with the old scroll-bar and their tricks, I thought of inventing a new one on my own. In this post I am going to share everything (including pros and cons), about making a customized scroll-bar in Excel.

Caution : This is a meaty post.

Recommendation : Sit with a latte and enjoy! 😀

Read More

Creating Phases in a Line Chart

April 15, 2016| No Comments

Create Phases in a Line Chart

Line charts are most often drawn for time series analysis and it would be interesting to divide our line chart into phases. In this tutorial, I am going to show you how can you divide the line chart into phases.

Read More

Download Smart Ebooks on
Excel and PowerPoint Presentations

© Goodly