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

IRR Calculations in Excel – Part 3

August 21, 2015| No Comments

IRR part 3

Our journey to conquer the IRR ends here. Part 1 and Part 2 talk about what is IRR and its nuances and different workarounds

I am dedicating Part 3 to talk about Excel’s MIRR (modified internal rate of return) as a robust alternative to IRR. Given the fact that the IRR is not a robust metric, let’s see how can the MIRR function can do a much better job

Read More

How to add Direct Legends to the Chart

August 17, 2015| 18 Comments

How to Add Legends to the Chart

I am dedicating this post to my girlfriend who has taken a “Work From Home” on Monday. We certainly are not going to talk about how much “work” happens from home versus Office. That’s none of my specialization, my specialization is to teach you the following

  1. How to Add a Direct Legend to the Chart (See the Label of the Line – Work From Home/Office)
  2. How to work on Excel and still make your girlfriend happy 😉 Just kidding !! I suck at it

Shall we get started? We’ll take less than 5 mins 🙂

Read More

IRR Calculations in Excel – Part 2

August 13, 2015| No Comments

IRR Part 2

I am assuming that you are carried forward from Part 1 of the IRR series. Where I talked about : What is IRR, Its calculations, IRR based decision making and Interpreting positive or negative IRR, all of that in simple English 🙂

In this post I am going to talk about

  • 4 problems associated with IRR
  • The XIRR function to handle irregular cash flows
  • Why does IRR change when consolidating annual cash flows from quarterly cash flows ?
  • Why is IRR or XIRR is not a very robust metric ?

Some of these problems have solutions and some don’t (or lets say that I don’t know about the solution). Let’s get started!

Read More

IRR Calculations in Excel – Part 1

August 6, 2015| 8 Comments

IRR Calculations 1

I have been delaying this post for quite sometime but I finally got hold of me. I have broken down this post into 3 parts and I discuss everything from from IRR to its nitty-gritties, its loopholes and the workarounds. I have written it in English so that even your kids can understand! Enjoy

Part 1 – Contents

  1. What is IRR ? (A complex and simple definition)
  2. A Case to explain the concept of IRR
  3. How to Calculate IRR (Simple math equation and by using Excel’s IRR function)
  4. Investing or Not Investing in the Business (Case Analysis)
  5. Interpreting Positive and Negative IRR
Read More

The most effective PowerPoint Template that I use

August 4, 2015| 6 Comments

Effective PowerPoint Template 1

A few days ago I wrote why I consider PowerPoint Templates Bull Shit ! They truly are! Today I am writing about the only template that has worked for me for almost all business presentations that I have churned out

Read More
© Goodly