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

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

How to inverse your data ?

September 18, 2014| No Comments

Reverse you data1

Have you ever had a situation where you wanted to inverse the order of your data? .. If yes then this is just for YOU! Read on..

Read More

Camera Tool in Excel

September 16, 2014| 6 Comments

Camera Tool in Excel1Did you know that Excel has a 50 Megapixel DSLR Camera with 24 -105 mm lens built into it ?

If you have not caught me yet.. Yes I am kidding 😆 but not about the camera feature.. it really has something called as a camera tool.. let’s check it out and get clicked !! 😎 😀 Cheeeseee!!

Read More

Converting a data dump into a visualization!

September 12, 2014| 1 Comment

Data dump visual A while ago one of my acquaintances asked me if there was a way to convert a data dump for salary structures into a chart. I asked – can you please show me the data ? She gave me the following! and I returned her what you see above 😎

A snapshot of Data Dump

Data dump visual 2

Here is how I did it..
Read More

Pivot Tables on steroids with DATA MODELS !! Excel 2013 Feature

September 10, 2014| 3 Comments

DATA MODELS Pivot Tables have been an all time favorite for most analysts and managers, especially for their simplicity and powerhouse utility. Today let’s inject a steroid named DATA MODEL to our standard pivot tables. But these steroids are available only in Excel 2013


What a DATA MODEL can do for you?

A data model can link multiple data sets (converted into tables) and make a single pivot table. It additionally has a few new formulas for advanced analysis.. let’s not just talk about it but experience it!! Ready for the steroid ?

Read More
© Goodly