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

Make a Chart from this Data – Charting Exercise

May 7, 2016| 11 Comments

I generally don’t read news papers but I have subscribed to 2 of them…Why?

  • I take a look at all the charts and visualizations and steal ideas from the good ones and come up with ideas to improve the bad ones
  • As far as the noise (news) is concerned, it will find a way to reach me if it is important enough!

In a similar chart browsing sessions last week, I found a bad chart! Take a look..

Make a Chart from this Data (Task)

It appeared in MINT (4th May) on Page 24 and talked about the hot topics of social media (and other channels) region wise.

I don’t think this is an example of a good chart

Read More

Highlight Parts of a Line Chart

May 6, 2016| 2 Comments

How to Highlight Parts of a Line Chart

The other day I was gazing at a business metric (a line chart) and I felt the need to just select a part of the line chart and focus on what happened during that time frame.

So I fired up some geeky stuff in Excel and created a chart to do that exact thing! Let’s jump right into it! Interested ?

Read More

Make your Vlookup Robust

May 3, 2016| 3 Comments

Make your Vlookup Robust

Typical technical (Excel) interview happens like this

  • To Be Boss : “How would you rate yourself in Excel ?”
  • You (thinking, I guess I am pretty good) : “I’ll rate myself 8”

Alright Alright.. guess the next question

  • To Be Boss : “Do you know Vlookup ? “
  • You (hah!) : “I’ll know Robust VLOOKUPs”
  • To Be Boss (a bit scared now) : “Alright, you are hired, but you’ll have to teach me as well” 

😀

Today, I am going to take your VLOOKUP skills and make them more robust. Take a look at a short video [10 mins]

Read More

5 Charting Hacks to Help You Work Faster

April 22, 2016| 1 Comment

5 Charting Hacks to help you work faster 5

Here are my top 5 charting hacks that have saved me a ton of time. They are incredibly simple and equally powerful!

Read More

Customized Scroll Bar in Excel

April 19, 2016| No Comments

Customized Scrollbar in Excel

When I got bored with the old scroll-bar and their tricks, I thought of inventing a new one on my own. In this post I am going to share everything (including pros and cons), about making a customized scroll-bar in Excel.

Caution : This is a meaty post.

Recommendation : Sit with a latte and enjoy! 😀

Read More
© Goodly