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!

5 Crazy Tricks in Excel

September 14, 2015| 2 Comments

5 Crazy Tricks

Deep diving in every nook and corner often finds you something crazy.. Isn’t it? Here are 5 crazy tricks dug from nooks and corners of Excel. Enjoy!

Read More

60+ Excel VBA Keyboard Shortcuts

September 1, 2015| No Comments

Excel VBA Keyboard Shortcuts1

One of the most dreadful things that I find about VBA is its environment. All that you have got is a blank space and your skill to put down the logic in the form of a code.. Phew!!

In order to be a bit more comfortable (and productive) with the VBA environment, one of the first things that I laid my hands on were the VBA Keyboard Shortcuts. I won’t lie, I am still learning them

I have put together a list 60+ VBA Shortcuts that will boost your speed and productivity while using VBA. Be it editing the code, debugging it, navigating the VB window or accessing far off options in the menu bar.. its all in here

Read More

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| 20 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

Download Smart Ebooks on
Excel and PowerPoint Presentations

© Goodly