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!




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

10 AutoSum and Sum Formula Tricks

September 29, 2016| 3 Comments

10-autosum-and-sum-function-tricks-1

Taking a total of cells in Excel is what everyone knows how to do it. But that simple Sum Function can be used in many intriguing ways and for various purposes

Today I have 10 such tricks for you! Check out how many are new for you!

Read More

Filter Data by Selection (Quick Tip)

September 27, 2016| 5 Comments

filter-data-by-selection-1

I mean how cool is that if you could just filter the data by cell selection instead of relentlessly checking and un-checking options in the the filter drop down

Well today’s blog post is going to make your life a hell lot easy! 

Read More

We Won Chandoo’s Contest!

September 23, 2016| 15 Comments

chandoos-vis-contest-results-chandeep

A while ago, Chandoo wrote me an email, stating that we have won the Visualization Contest that was held in June this year! His email caused sweaty palms, spike in heart rate and obviously extreme elation!

Read More

Make a Dashboard Using Advanced Filter

September 22, 2016| 3 Comments

advanced-filter-dashboard-1

This post is an advanced application of the previously written posts on

  1. Advanced Filter and
  2. Automation of Advanced Filter using VBA

If you have not read the above 2 posts I strongly recommend reading them before you dive into this

Read More

Download Smart Ebooks on
Excel and PowerPoint Presentations

© Goodly