Chandeep Chhabra

Become Unbelievably "Excel"lent !

Hi, My name is Chandeep!

Since 2013, I have been training, consulting and blogging to help people become quicker and smarter with Excel

Let me get you started by sending you smart ebooks on Excel and Powerpoint!

Let's Get Started!

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

5 Classic PowerPoint Animations – Free Course! (100th Blog)

July 28, 2015| 5 Comments

5 Classic Animations for stunning presentations

I am feeling super stoked as I pen down the 100th blog on Goodly and to make this equally interesting for you I have produced a set of videos on 5 Classic PowerPoint Animations

Caution: These animations are jaw dropping !

Read More

How to Vlookup similar (but not matching) records ?

July 16, 2015| No Comments

Vlookup similar but not maching records 1

Rare but a very relevant problem! Isn’t it? A quick heads up on how does it arise?

Imagine for a moment that the ERP at Peter Brothers is not very robust, every time a customer comes in (even if the same customer) the MIS guy makes a New Record.

His whims led to too many similar company names and now it is impossible for Vlookup to match similar company names.

I was asked this question by a participant in a training session about 2 years back, knowing that there was no straight answer to that I kept thinking of a Macro (VBA coding) based solution, a few days later to my surprise I found that Microsoft had already thought about it and rendered a beautiful solution. I am writing about it today (better late than never 😛 )

Without reinventing the wheel let’s see what Microsoft has to offer?  Ready for it?

Read More

Beauty Tips for your Excel Reports

July 11, 2015| 2 Comments

How to Beautify your Excel Reports 1

If you tired of making obsolete looking Dashboards/Reports then I have 6 awesome (and equally simple) make over tips for you.

We won’t go overboard in decking up our report until it looks horrible and meaning less but just enough to make it classy and beautiful! Let’s get started.. Shall we?

Read More

Download Smart Ebooks on
Excel and PowerPoint Presentations

© Goodly