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

Create a Map Chart for Plotting Cities

August 12, 2014| 28 Comments

Map Chart

Interesting is’nt it?

Often I find managers and analysts making standard charts (or sometimes even pie charts) to map the city wise sales. Here is an interesting way to plot the cities on any country’s map..

Read More

Time Scales in Financial Modeling – Part 1

August 5, 2014| 2 Comments

Hi Guys,

How are you doing? I thought I have been speaking enough about financial modeling (getting started and taking interviews), let me get on to show you a very effective time scale trick and what it can do to our models

Timelines Financial ModelingAccording to changes in the date the revenue and project duration shifts to relevant financial year automatically !

Read More

A comprehensive guide to VLOOKUP + 5 crrraaazzy tricks !

August 4, 2014| 1 Comment

Vlookup Guide 0

Quick VLOOKUP facts/myths that I have witnessed.. pretty interesting

  1. Do you know how to apply a VLOOKUP ? is one of the most asked question in the technical round of excel interview. TRUE
  2. If one knows how to apply VLOOKUP, he knows advanced Excel or he is the master of Excel – MYTH
  3. VLOOKUP is difficult to learn – BIG MYTH
  4. The TRUE/FALSE input at the end of VLOOKUP is the same and gives you the same result – MYTH, we’ll see how and why!
Read More

A rendezvous with my friend – Sourabh Kushwaha on Financial Modeling

July 29, 2014| No Comments

Go ahead listen to the show!

Here I and Sourabh talk about

  • Some his current projects in Financial Modeling,
  • His most challenging model and how he dealt with it
  • Skills for being an excellent financial modeller
  • How much time does it take to develop this skill ?
  • Some recommended resources
  • Suggestions for freshers in this field !
Read More

Know your Charting Arsenal ! (Part 3/3)

July 24, 2014| No Comments

The final part of the arsenal building post delves in the formatting elements of the charts. Lets work on a case to get this started

So we have some data here and its standard column chart

Charting Arsenal 3 - 1

Read More
© Goodly