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

Total at the end of Line Chart

October 8, 2014| No Comments

Total of Line Chart

Line charts are used to depict trends across time. It is quite useful (and equally cool) to add a total bubble at the end of the line chart. Let’s see how that can be done

Read More

Creating Interdependent Dropdowns

October 4, 2014| No Comments

The other day I encountered (and solved 😎 ) a creative problem while making interdependent drop downs in a dashboard. If one Item has been chosen in the first list then it should not appear in the second list and vice versa !!

Interdependent drop downs

Check it out.. it is pretty cool !!


We start with a list of names

Interdependent drop downs1–> Let’s say we have six salesmen

Read More

5 Quick Data Formatting Tips

October 3, 2014| No Comments

Quick formatting tips

Today let’s talk about some real quick and amazing formatting tricks to make your data look more presentable and I have 5 of them for you here! Enjoy 🙂

Read More

Cells Modes – Insanely Simple and Unnoticed!

September 29, 2014| No Comments

Cell Modes 0


Let’s play a game today! Open your excel sheet and I will ask you to do some tasks, If you do it, you’ll get a point else I’ll get one. OK ready with your excel ? 😛

Read More

Suffering from VLOOKUPhobia?

September 20, 2014| 1 Comment


Oh God .. please make this VLOOKUP work !! I promise to visit you every week 😡

Do you pray that your VLOOKUP formula should work ? 😯 Let me rescue you from the top 3 common mistakes while writing VLOOKUP function and save our prayers for more crucial things in life!! 😆

Read More
© Goodly