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

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

Find the Shift Timing [Excel Challenge]

June 14, 2016| 22 Comments

Find the correct shift timing - Excel challenge

Last week I reached out to a few readers asking them if they are struggling with anything in Excel. One of the readers (Malclom) wrote a very interesting problem about finding shift timings

Let’s see if you can knock it down! Ready for it?

Read More
© Goodly