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

Quick Tip : Turning off GETPIVOTDATA function

January 27, 2015| 1 Comment

Quick Excel Tip

Recently I was getting a model vetted from my girl friend! She saw a set of pivot tables and asked: How do you turn off the irritating GETPIVOTDATA function?

I traded off the quick tip with some awesome stuff ! 😆 And for you my friend.. it is on the house 😎

Read More

Getting the Tray look in PowerPoint

January 19, 2015| No Comments

Tray in PowerPoint



I recently worked on a consulting project where I had to deliver a corporate presentation. The client had to impress its peers in Singapore. I thought what better way than creating some interesting animations and one of them was to display the logos in a tray like look 😎

Read More

A Check Button Chart !

January 11, 2015| 1 Comment

Check Button Chart

I guess I don’t have to say much to get your interest!! Interested..? Ok lets begin!  🙂

Read More

4 Quick custom number formats for dates!

January 4, 2015| No Comments

Quick custom date formats


A while ago I wrote a post on how to use custom formatting in excel. Let’s take a look at some interesting custom formatting codes for dates

Read More

Numbers in Indian Currency Words!

January 1, 2015| 1 Comment

Numbers in words

I have got this request a zillion times: How can I convert a number into Indian Currency? Ok not a zillion times but at least a 100 times 😛 In the pain of those countless minutes spent in manually typing (which is also prone to mistakes) the numbers into words, I hereby present a Macro (VBA Code, which is not mine)! Simple, Quick and Sexy!

Read More
© Goodly