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

Use Data Validation Drop Down as On Off Switches

July 19, 2016| No Comments

Use Data Validation as On Off Switches

Have you ever used a regular item for a non regular use? Let’s say using a bangle for opening a bottle of coke or tapping a tea spoon for making noise 😆 Funny indeed but these fixes at times are pretty robust.

On a similar note, let’s take a look at how can you unusually use Data Validation drop down feature for creating ON/OFF (show/hide) switches for your Charts / Calculations

Read More

30 Evergreen Productivity Hacks in Excel

July 18, 2016| 2 Comments

30 Productivity Hacks

There are ton of ways to work faster in Excel and often the little nick-nacks take more time than other things. I am sure that there is no end to the available shortcuts in Excel but for now let’s take a look at a few most commonly done little tasks in excel and ways to do them a lot faster

Read More

Cost Structure Visualization – Chandoo’s Visualization Contest

July 12, 2016| 2 Comments

Last week I participated in Chandoo’s Visualization Challenge, where we were given some raw data and had to make a meaningful visualization (Dashboard) out of it. In this post I am going to share everything about how I went along in creating this dashboard.

Compare Companies View

Overall Market View

Read More

Timeline Chart in Excel

July 9, 2016| No Comments

Timeline Chart in Excel One

Every once in a while I make a timeline in PowerPoint to show how the tasks are scheduled over time. I thought it would be nice to have a template in Excel where I just add events and dates and the chart is created by itself.

So today it is time for a short tutorial on a timeline chart

Read More

Custom Formatting Tricks

July 6, 2016| 4 Comments

10 Custom Formatting Tricks 1

Even if you have no idea what is custom formatting, these tricks will help you win over some common formatting needs for your data

Read More
© Goodly