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

Flight Schedule Dashboard

March 22, 2017| 1 Comment

Flight Schedule Dashboard

Recently while browsing I found a list of flight information for one of the most popular Indian Airlines Company (Indigo Airlines)

I thought instead of dumping this in Excel, I certainly can do a much better job of visualizing this data and I came up with this Flight Schedule Dashboard

Read More

Excel Keyboard Shortcuts for Mac

March 14, 2017| No Comments

Excel Keyboard Shortcuts for Mac Users

Recently, I found that there is a minority of our readers using a Mac and I don’t want those people to be left out. So after all this while I thought of writing about Excel Keyboard Shortcuts for Mac Users

Read More

Excel Formula Crossword Puzzle

March 5, 2017| 5 Comments

Excel Formula Crossword

Inherently Excel is a quite boring topicI thought of making it a bit interesting by not positing yet another “How to” tutorial.

Let’s play a crossword puzzle! I am sure you already know how to do that but this time you have got to find the correct excel function depending on the clue

Read More

Prevent user from deleting rows or columns in Excel

March 2, 2017| 5 Comments

Prevent user from deleting rows or columns 1

When you are creating a Dashboard or a Report, you may have felt the need to prevent the user from deleting either rows or columns

This is how it should work – When the user tries to delete a row/column, Excel should return an error or shouldn’t let that task happen

Read More

Random Function Tricks in Excel

February 24, 2017| 5 Comments

Random Function Tricks

This post is about the RAND and the RANDBETWEEN functions of Excel and how can we play with these to

  • Generate random Alphabets (+ its variations) or
  • Generate random numbers (+ variations)
  • Generate random names from a ranges
  • Generate random cell addresses
  • Generate random dates


There will be a lot more things that you can generate randomly after you read this post. Let’s get going!

Read More
© Goodly