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

Charting Exercise Solution – (Internet, News, Tweets..)

May 10, 2016| 3 Comments

Charting Exercise Solution 1

If you missed participating in last week’s question. Here is a quick recap.

DOWNLOAD THIS DATA and

  • Give your best shot in creating a chart from it
  • Paste the snapshot of your chart in the comments

You can read the full story here !

Don’t scroll down to see my solution before you submit yours 😀 !

Read More

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
© Goodly