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

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

Creating Phases in a Line Chart

April 15, 2016| No Comments

Create Phases in a Line Chart

Line charts are most often drawn for time series analysis and it would be interesting to divide our line chart into phases. In this tutorial, I am going to show you how can you divide the line chart into phases.

Read More
© Goodly