Boost your productivity with

Smart Ebooks on
Excel & PowerPoint Presentations




Hi, Welcome to Goodly! My name is Chandeep

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

RIO Olympics Visualization in Excel

August 30, 2016| 13 Comments

Rio Olympics Visualization 2
Visualization 1 – Change in Rankings

 

Rio Olympics Visualization
Visualization 2 – Overall

 

Recently the Olympics have been the talk of the town! Personally I have been following Olympics for just 2 reasons

  1. To see the medal count for India
  2. To be astonished by the performance of US

 

When the Olympics ended I thought why not make a Dashboard and feed people with analytics of RIO and may be even compare it to London Olympics. Both of these are unlocked, rip them apart and see how did I put them together

Read More

25 Excel Formula Hacks for Everyday Use

August 29, 2016| 2 Comments

25 Formula Hacks for everyday use main

Often times when you work with excel you can use these hacks (simple formulas) in your larger formulas to ease your work. I could think of 25 of them but I am sure there are many. Why don’t you go through these and add to list the ones that you use most often..

Read More

Threshold Chart in Excel

August 23, 2016| 6 Comments

Threshold Chart in Excel 1

The reason why I call this as a Threshold Chart is because the lower point can only be equal to the threshold and not exceed it!

Although I am using Asset Depreciation Data for this chart but a threshold chart can be applied to multiple places. I’ll talk about its applications in a bit more detail in a while… but first the chart

Read More

Create Dynamic Text Boxes in Excel

August 16, 2016| 1 Comment

Create Dynamic Text Boxes in Excel

I am sure you would have worked with the text boxes in Word or PowerPoint or even Excel but the trick I am going to share with you will make the text boxes dynamic.. in simple terms the text can change as per the situation

The applications of this technique in Dashboards, Charts and Visualizations is pretty helpful

Read More

Make a Dashboard in 15 Mins – [Case Study]

August 9, 2016| No Comments

Make a Dashboard in 15 Mins

Last week I received an email and this is what it said..

Make a Dashboard in 15 Mins - 3

This mail got me thinking of writing something exclusively on (how tos about) Dashboards. Just out of curiosity, I additionally reached out to a few people and asked them their biggest challenge for making quick and smart dashboard.

2 major responses popped up!

  1. “Chandeep, making a dashboard is difficult”
  2. “Chandeep, it’s time consuming”

 

So now I understand the problem. In this post I am going to solve both these problems and teach you to make simple and yet powerful dashboards in just 15 mins. And the good part is that the concept will apply on most data sets

Read More
© Goodly