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

Make a Dashboard Using Advanced Filter

September 22, 2016| 3 Comments

advanced-filter-dashboard-1

This post is an advanced application of the previously written posts on

  1. Advanced Filter and
  2. Automation of Advanced Filter using VBA

If you have not read the above 2 posts I strongly recommend reading them before you dive into this

Read More

Perform faster VLOOKUP on Large Data

September 12, 2016| 8 Comments

perform-faster-vlookups-on-large-data

While applying VLOOKUP on large data (let’s say 100k rows or more) you often get beaten down by extremely slow spreadsheets or even sometimes by this sweet notification..

perform-faster-vlookups-on-large-data-2

Yeah I know we say all types expletives.. #$%k me!, Oh Jeez..

One of the other ways to speedup is to use PowerPivot (which is heavenly!!) but lets say for some reason you still have not made a transition to PowerBI suite in that case let’s together explore this little trick..

The incredible part is that it is insanely simple!

Read More

Find the Total Hours – Excel Challenge

September 8, 2016| 15 Comments

Find the Total Hours - Excel Challenge 1

Last week Leslie, one of our readers asked a very interesting question! At the first glance it looked pretty simple but then I got trumped when I deep dived into the question.

This is what she wrote

find-the-total-hours-excel-challenge-3
This weekend I want you to solve this for Leslie! Are you ready?

Read More

Use Camera Tool to make Dynamic Charts in Excel

September 5, 2016| 2 Comments

Use the Camera Tool to make Dynamic Charts

Excel has some pretty kick ass unique features and one of them is the Camera Tool. On the face of it, it looks like no big deal. But the camera tool when combined with a formula and options buttons, can help you make a pretty awesome dynamic chart

Let’s get right into it!

Read More

RIO Olympics Visualization in Excel

August 30, 2016| 13 Comments

Rio Olympics Visualization 2
Visualization 1 – Change in Rankings

 

Rio Olympics Visualization
Visualization 2 – Overall

 

Recently the Olympics have been the talk of the town! Personally I have been following Olympics for just 2 reasons

  1. To see the medal count for India
  2. To be astonished by the performance of US

 

When the Olympics ended I thought why not make a Dashboard and feed people with analytics of RIO and may be even compare it to London Olympics. Both of these are unlocked, rip them apart and see how did I put them together

Read More
© Goodly