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

A Primer on the INDEX Function !

November 15, 2014| 1 Comment

Primer on Index

Versatile, Robust, Fast, Simple, Elegant .. oh all that is ME 😆 and The INDEX function too. Since you already know me so let me introduce you to the INDEX function

 

 Ladies & Gentlemen here is INDEX

If you have been using VLOOKUP for a while, it is time now to graduate baby! Let’s start simple with the Syntax =INDEX(array, row_num, col_num)

  1. Array is your lookup range. Just like your vlookup range!
  2. Row_num is the row number that you want in your array
  3. Col_num (optional) is the column number that you want in your array
  4. Assuming all the values fed in correctly the INDEX returns the intersection of row and column number in the array. Trust me it is that simple 😎

 

A Case with INDEX

We have here 5 months sales data of different employees (Emp ID) and we want to look up for EMPCD 255 in March

Primer on Index1

Aahaa, it is simple VLOOKUP thingy! But let’s get this done with INDEX

Read More

The REPT Function Chart

November 13, 2014| 5 Comments

REPT function chart

 

The Charts in excel are not just restricted to Chart Objects, we can cleverly use formulas to make Charts.. sounds bizarre and interesting? Lets explore this further with one such function

Read More

A Human Resource Dashboard !

November 12, 2014| 4 Comments

A while ago I trained a bunch of professionals on How to make Business Intelligence Dashboards, and trust me the training was mutual (two way). They were smart, sharp, stumped me with there questions, so I became a bit smarter and learnt a few things while solving their doubts in trail and error

Here is our work – We made this Dashboard from raw data in the session.. take a look

HR Dashboard Front

Read More

5 Steps to boost productivity while making Presentations

November 11, 2014| No Comments

Here are 5 ways (that I personally follow) to help you speed up making Presentations. Note: Its awesome, with a couple of videos. Grab a latte and get started!!

Boost PowerPoint Productivity

Read More

Scrolling list in Excel

November 10, 2014| No Comments

Scrolling List

Presenting an elegant solution to displaying large data via scroll-able list. All you need is a

  • Scrollbar,
  • A list (of course)
  • And formulas to tighten everything together !!

Lets make a killing here

Read More
© Goodly