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 Occurrence of a Word in a Sentence

March 29, 2016| No Comments

Occurrence of a word in a sentence

This is a one odd problem that I was asked that how can we find occurrence of a word in a sentence. A simple formula can do it..

Let’s see how

Read More

Create Class Intervals in Excel – 3 Ways

March 25, 2016| No Comments

Class Interval in Excel

The word ‘Class Interval‘ takes me back to the math class in school. Trust me, I had a tough time understanding Class Intervals and Frequency Distribution jargons. Several years later (now) when I finally believe I have understood its meaning and application, I want to keep it really simple for you and talk about 3 different ways to create it in Excel

All English and no Jargons.. promise!

Read More

Remove background color from your pictures (powerpoint trick)

March 22, 2016| No Comments

Remove Patches from your Pictures

Quite often we have to get rid of background patches in the images that we use in our presentations. Let’s take an example of Goodly logo with a white background patch visible when placed on a grey box. Is there a way to remove that patch and have a clean logo?

Of course there is and I am going to be sharing 2 ways to do it..

Read More

Infographics Charts in Excel – Part 2

March 18, 2016| No Comments

Infographic Chart in Excel Part 2

In Part 2 of Infograhic Charts, I’ll share with you to create this interesting infograhic in Excel. Here we have a single human icon, which dynamically gets filled depending on the value chosen in the drop down

Here is how it is created..

Read More

Infographics Chart in Excel Part 1

March 15, 2016| No Comments

Infographics Chart in Excel
The source of inspiration for this chart came when Shuttershock was charging me for downloading a similar infographic chart. I din’t buy, I am thrifty 😉 It helped me save a couple of bucks and also come up with a way to make an infographic chart in Excel

Let’s do this together! Shall we?

Read More
© Goodly