Hi, Welcome to Goodly! My name is Chandeep


I do consulting and training on MS Excel, Business Intelligence Dashboards,
Business Plans / Financial Models and PowerPoint Presentations

I am putting together everything about Excel and PowerPoint Presentations
that I have learnt (and still learning) on this blog

Get started here by following these resources

Find the lowest scoring subject – Excel Challenge

October 20, 2016| 21 Comments


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

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


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


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


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
© Goodly