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

Quick Tip: Vertical Line Chart in Excel

September 28, 2015| 4 Comments

Vertical Line Chart 1

The Horizontal Line Chart is pretty standard stuff! Why don’t we try making a Vertical Line Chart? Well there isn’t a standard vertical line chart in Excel so we’ll tweak some other type of chart to get this done!

Let’s get started..

Read More

60 PowerPoint Shortcuts

September 22, 2015| 4 Comments

60 PowerPoint Shortcuts

Here are 60 PowerPoint shortcuts that are valuable to boost your productivity while creating presentations

Read More

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
© Goodly