Boost your productivity with

Smart Ebooks on
Excel & PowerPoint Presentations




Hi, Welcome to Goodly! My name is Chandeep

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

Excel Shortcuts for Financial Modeling

January 26, 2017| No Comments

Financial Modeling Excel Keyboard Shortcuts

Last week one our readers asked me to share the most important financial modeling shortcuts that I think can tremendously increase the efficiency and accuracy while making financial models

Financial Modeling Excel Keyboard Shortcuts 2

Although I was just asked to share 10 shortcuts but I thought of making a video (to discuss about 30 shortcuts) and show you where and how exactly do I use these shortcuts to speed up my work while creating financial models

Just to make the learning structured, I divided the shortcuts in 4 main phases of financial modeling

  1. Shortcuts to set up the model
  2. Shortcuts to make the model
  3. Shortcuts to audit the model
  4. A few saving tips in the end 🙂

 

Let’s dive right into this… and this is not just restricted to financial modelers, there are a lot of tips and tricks that a regular excel user can also pick up

Read More

Convert Text Heavy Slides into Beautiful Presentations

January 23, 2017| No Comments

Convert text heavy slides into beautiful presentation

A ton of people face this problem: How to convert text heavy slides into visually beautiful presentations. Often you would hear advice like

  1. Convert your data into chart / graphs
  2. Add pictures and bla bla..

 

This is cool but the problem is

  1. What if the presentation is purely textual with no numbers to be converted into charts ?
  2. And most times you’ll start working on the presentation at the 11th hour which has to be presented at 12th

 

Let me show what I did and share one of my recent presentation project

Read More

The Ultimate VLOOKUP Guide

January 16, 2017| No Comments

The Ulimate Vlookup Guide 1A lot beyond conventional VLOOKUP

“Knowing VLookup is cool but just knowing Vlookup is awful”

Read More

Allot the correct shift – Excel Challenge

January 10, 2017| 11 Comments

allot-the-correct-shift-excel-challenge

I few weeks ago I conducted a training session for a large manufacturing company in India and faced an interesting question during the training program.

I want you to take a look at the problem and try knocking it down

Read More

How to Publish an Online Dashboard using Excel

January 2, 2017| 7 Comments

publish-an-online-dashboard-using-excel-1

If you are reading this in early January of 2017, wish you a very happy new year! This being the first post in 2017, let’s try something new !

In this post I am going to show you how to publish your report or dashboard (that you have created in Excel) online.

By publishing it online I mean that once you have created the spreadsheet in your computer you can then create a shareable link and multiple users can access that report. And sure enough the report will be dynamic with all the slicers, buttons and fancy controls working in sync.

The only difference(s)

  • You work looks more smart and light (since you send a link and not a 50 MB attachment)
  • The users just get to see the smart dashboard and not the heavy duty workings that you have put in at the back-end
  • And possibly a brownie point for your promotion.. may be??
Read More
© Goodly