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!




How to work with Custom Data Validation

November 4, 2016| No Comments

custom-data-validation-5

Custom Data Validation is one of the lesser used features in Data Validation. It can accept a formula to validate a cell input. Let’s take a look at how custom data validation works and then explore 2 of its applications

Read More

How to select small data points in the Chart ?

October 26, 2016| 7 Comments

select-small-data-points-in-the-chart

2 things are pretty evident from this Chart

  1. Most Indians don’t eat non-veg on Tuesdays (by the way..I have no reservations !)
  2. Therefore it becomes very hard to select small data points in the chart.. unless you want to keep trying all day with the mouse

 

By selection I mean just clicking on the bar the represents Customers for Tuesdays. The selection could be for any reason (putting it up on the secondary axis, formatting the data series, adding data labels… etc etc)

Read More

Find the lowest scoring subject – Excel Challenge

October 20, 2016| 31 Comments

find-the-lowest-scoring-subject-excel-challenge

I got through a few interesting formula challenges in the Round 2 of Excel World Champ. One of the formula based question was similar to this Excel Challenge

Let’s see if we can knock this down!

Read More

I am participating in Excel World Champ

October 12, 2016| 4 Comments

olympics-visualization
and this was the chart that I presented as my contest entry

 

Quick brief and Listicles (for random visitors and not so Goodly people ;D)

  1. This year I got to know about this contest (I guess from some twitter feed) organised by Microsoft
  2. There is no fee to participate in the contest. It started on 3rd Oct 2016
  3. There are 4 rounds. Trials, Qualifying Heat, Semis and Finals
  4. As of date the 1st Round is over and I am headed towards Round 2 – Qualifying Heat

 

For all Goodly folks and friends, below is a more meaty and a real time talk!

Read More

5 Extremely Useful Array Formulas

October 7, 2016| 3 Comments

5-extremely-helpful-array-formulas-6

Often there are tasks in excel that seem impossible to perform. Array formulas can handle a lot of that impossibility and do miraculous things. The problem is that array formulas is one difficult topics in Excel

“With great formula power comes great complexity”

Chandeep’s lame claim to fame 😀

For that very fact I am going to discuss with you 5 extremely helpful array formulas that I find myself using very often.

  • Cool fact 1 – You can just copy & paste the formula to make it work in your own scenario
  • Not so cool fact 2 – Make sure you confirm the formula in the cell by pressing CTRL+SHIFT+ENTER. Array formulas don’t work without that
Read More

Download Smart Ebooks on
Excel and PowerPoint Presentations

© Goodly