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

Presentation Rework Series – 04

February 26, 2016| 4 Comments

Presentation Rework - Bitcoin Banner

Introduction to Presentation Rework

I have written and read many posts about making awesome presentations and surprisingly ALL of them (including mine) fail to make a “real impact”, the impact of changing a raw presentation and converting it into a beautiful, thought provoking and impactful display of information

Do you know why?

Because creating an awesome presentation is much more than

  1. Picking up a beautiful template and filling it up
  2. Dumping colors, fonts and pictures and expecting the presentation to come out great
  3. Knowing 100 + features of PowerPoint

So I wanted to do something different..

Rather than just writing piles of text on “How to stuff..” I thought of taking a random but real Presentation and reworking it to make it awesome

I will give you downloadable files (pre and post rework), videos and commentary about my thought process and more importantly the reason(s) behind why I chose something over the other. Hopefully this will give you insights on what works and more importantly what doesn’t

Read More

Customizing Markers in a Chart

February 23, 2016| 4 Comments

Customizing Markers in a Chart

An icon of a car feels so cool when you are talking about cars in a chart. Isn’t so? Let’s see how can we do that!

Read More

7 Date Formulas that make life easy

February 21, 2016| 2 Comments

7 Date Formulas

At times managing dates can be tricky. Here are 7 Date Formulas and tips to make your life super easy

  1. How to find the exact age ?
  2. How to find the last Friday & Second Saturday of the month ?
  3. How to find the Quarter number and Indian Financial Year Quarter ?
  4. How to convert dates (as text) from mm-dd-yy format to dd-mm-yy format ?
  5. How to calculate the Project End Date ?
  6. How to calculate Project Days ?
  7. Cool Bonus Tips on Dates
Read More

Quick Tip – Use Snipping Tool to crop images

February 15, 2016| No Comments

Snipping Tool

Words come to life with images and we all do add plenty of images in our presentations. Don’t we? At times we even have to pick these images from the web.

So assume that you have to incorporate a company logo from a website into your presentation. To do this most of us would first save the image on our desktop and then import it into our presentation. Which is not bad but a bit time consuming!

Today I have for you a smart way to copy images and place it into your slides

Read More

Quick Tip: New Window Tool in Excel & PowerPoint

February 2, 2016| No Comments

New Window 0

Assume for a moment that you are working with an Excel File which has 10 Sheets or may be more!

New Window

Now What if,

  1. Some of your data is kept on Sheet 1 and rest is kept on Sheet 10
  2. And you have to do a to and fro (again and again) between Sheet 1 and Sheet 10

How would you navigate between the sheets faster?

Would you

  1. Keep using the mouse to flip between the sheets ? or
  2. Use the shortcut Ctrl PgUp or Ctrl PgDn to move back and forth ?

Let me introduce you to something called as New Window. It is simple and extremely effective way of navigation

Read More
© Goodly