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

5 Classic Animation Styles for Presentations

March 27, 2015| No Comments

Classic Animation Styles4

Animations are a key part in presentations & I use them often, but I abide by one rule for using animations

” Use animations to communicate your message effectively rather than just for artistic purpose “

Of the many animation styles that I use to display data, here are 5 classic ones and definitely with a purpose

Read More

Quick Tip: Border Shortcuts

March 19, 2015| No Comments

Quick Excel TipBorder Shortcuts


Here are a few exclusive border shortcuts

Read More

Automated Filter with Macro!

March 17, 2015| 2 Comments

Automated Filter

A while ago I wrote a post on how to use Advanced Filter? Today let’s delve further into a bit of automation of the advanced filter application

Read More

Picture Vlookup

March 12, 2015| 4 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
© Goodly