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

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

Learn 100 Excel Formulas

June 30, 2016| 4 Comments



Recently I conducted a survey, to find out what are your pain points while using Excel in everyday work. I found that a majority of us struggle with writing Excel Formulas. Hmm… So I spent a few days recording ex-plainer videos for about 100 most used functions in Excel.

I have explained each formula

  1. In a very simple manner
  2. Plus given you some must know rules (wherever applicable) that you should keep in mind when you use these formulas
  3. The Downloadable Excel file used as a case in the video


As of now I have completed about 40 of the 100 videos and will wrap the remaining in a few days. AND YOU MUST BOOKMARK THIS PAGE

Read More
© Goodly