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

Picture Vlookup

March 12, 2015| 6 Comments

Picture Vlookup

Looking up pictures can be interesting and can possibly be used in different scenarios. Here is a quick sneak peak into how can you do a Picture Vlookup!!

Read More

Dependent DropDowns!

March 8, 2015| 2 Comments

Dependent Dropdowns1

Sometimes you may have a need to create a dropdown list which should be dependent on another dropdown. For instance in the above example depending on the company that you choose (A, B or C) in the Company dropdown, the respective products appear in the products dropdown.

Trust me its not difficult but just a couple of logics combined together to make this dropdown pudding. Let’s do it.. Shall we?

Read More

Quick Chart Formatting Tip

February 24, 2015| 1 Comment

Chart Formatting Tip1

Here is a fun and also really quick way to replicate formatting in your charts

Read More

Format Painter Tip in PowerPoint

February 18, 2015| No Comments

Format Painter Tip1

We all have used the Format Painter once in a while, It is really simple. Lets take a look a 2 simple tricks with the format painter

Read More

Calculated Fields in Pivot Tables – A Case

February 10, 2015| No Comments

Calculated Fields

One of the less known and extremely awesome feature of Pivot Tables is its ability to create calculated fields with in the Pivot Table

Read More
© Goodly