Boost your productivity with

Smart Ebooks on
Excel & PowerPoint Presentations

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

Learn 100 Excel Formulas

June 30, 2016| 4 Comments



Recently I conducted a survey, to find out what are your pain points while using Excel in everyday work. I found that a majority of us struggle with writing Excel Formulas. Hmm… So I spent a few days recording ex-plainer videos for about 100 most used functions in Excel.

I have explained each formula

  1. In a very simple manner
  2. Plus given you some must know rules (wherever applicable) that you should keep in mind when you use these formulas
  3. The Downloadable Excel file used as a case in the video


As of now I have completed about 40 of the 100 videos and will wrap the remaining in a few days. AND YOU MUST BOOKMARK THIS PAGE

Read More

Use MIN MAX to Replace IF Function

June 28, 2016| 2 Comments

Use MIN MAX to Alternate IF 1

Take a look at this case and think about how are you going to solve it without using IF / AND or any other Logical function


Case 1

Use MIN MAX to Alternate IF


Case 2

Use MIN MAX to Alternate IF 2

Read More

Shift Between Companies Visualization

June 24, 2016| 7 Comments

Shift Between Companies Vizualization

It is amazing how you can you take learning from others and can transform into something unique of your own. Recently I was taking a look at Roberto Mensa’s Dashboard on US State Migration Data, it was so intelligent to see how had he made a beautiful visualization plotting different cities on a Map. The Dashboard also won Chandoo’s recent Dashboard Contest

Read More

Shift Timing Challenge – Solution

June 22, 2016| No Comments

Shift Timing Challenge Solution

Last week I posted about the Shift Timing Challenge. The problem came from one of our readers, Malcolm. He was finding it challenging to classify the shift timing in one of the following 3 categories

  1. Between 10 PM – 5:59 AM you should write Shift 1
  2. Between 6 AM – 1:59 PM you should write Shift 2
  3. Between 2 PM – 9:59 PM you should write Shift 3

Along with my solution (that I will share with you now) I got some pretty interesting solutions from our readers.

Read More

10 Tips to write better Excel Formulas

June 20, 2016| 4 Comments

10 Tips to write better Excel formulas

Here are some of my awesome tips to help you work faster and write better Excel Formulas!

Read More
© Goodly