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

Find the Shift Timing [Excel Challenge]

June 14, 2016| 22 Comments

Find the correct shift timing - Excel challenge

Last week I reached out to a few readers asking them if they are struggling with anything in Excel. One of the readers (Malclom) wrote a very interesting problem about finding shift timings

Let’s see if you can knock it down! Ready for it?

Read More

Create a Dot Chart in Excel

June 10, 2016| 10 Comments

Dot Chart

The other day while helping someone out to create a visualization from a performance rating data, I thought of creating a Dot Chart, where dots get filled depending on the score. I really liked what finally came out and thought it would be of much use to you as well!

So, here we go !

Read More

16 Life and Time saving Pivot Table Tricks

June 7, 2016| 4 Comments

Pivot Table Tricks and Hacks 1

Today let me share with you 16 gold nuggets that will help you save your time while crunching numbers with pivot tables! Excel hacks are equivalent to gold nuggets for people like us.. aren’t they? Lets get started

Read More

How to pick up the Right Chart – Guide

June 2, 2016| No Comments

How to pick up the right chart

Often a wrong type of a chart for your data won’t communicate the right message. Charts are made for easier & faster interpretation of data and a wrong chart can do the opposite

I wanted to pour my heart out to help gain the skill of picking up the right chart. I suggest you should bookmark this because I am going to make this pretty comprehensive and awesome!

Read More

Funnel Chart Visualization – Tutorial

May 30, 2016| No Comments

Funnel Chart Viz

In this tutorial I am going to take you through a funnel chart visualization. Surprisingly this visualization is not any type of a chart rather it is made up of formulas that have been smartly formatted make it look like a chart.

Let’s get into it!

Read More
© Goodly