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

POLL : Why is Learning Excel Becoming all the more Important ?

November 22, 2016| 11 Comments

why-is-learning-excel-becoming-important-1

Image – Designed by Freepik

A while ago I met a guy (at my friend’s place) and we were talking about random shit. Here is some meaningful bit of that conversation

I : Hey dude, What’s up! How was your day?
He : It was okay man! I had an interview at Snapdeal
I : How did it go?
He : They handed me with 30k rows of dealer data and asked me to make sense from it
I : Do you need any help? (I had told him earlier about what I do)
He : Thanks Bro, but I have submitted my report. If only I learned Excel and basic math I would have been able to do much better. None of what I learned in my “MBA” mattered.

2 Quick Conclusions

  • Well I don’t agree that MBA is complete waste of time
  • But I do agree that having solid excel skills matter. It matters a hell lot!

Let me share with you some real time instances which reinforced that same conclusion over and over again

Read More

Find the Top ‘x’ Items [Pivot Table Trick]

November 9, 2016| No Comments

find-the-top-x-items-1

When you make a pivot table not necessarily we need the summary of all the items, there have been instances where I needed only Top 5 or Top 3 items to be displayed in the pivot table.

Here is a little trick that can help you do it with a few clicks

Read More

How to work with Custom Data Validation

November 4, 2016| No Comments

custom-data-validation-5

Custom Data Validation is one of the lesser used features in Data Validation. It can accept a formula to validate a cell input. Let’s take a look at how custom data validation works and then explore 2 of its applications

Read More

How to select small data points in the Chart ?

October 26, 2016| 7 Comments

select-small-data-points-in-the-chart

2 things are pretty evident from this Chart

  1. Most Indians don’t eat non-veg on Tuesdays (by the way..I have no reservations !)
  2. Therefore it becomes very hard to select small data points in the chart.. unless you want to keep trying all day with the mouse

 

By selection I mean just clicking on the bar the represents Customers for Tuesdays. The selection could be for any reason (putting it up on the secondary axis, formatting the data series, adding data labels… etc etc)

Read More

Find the lowest scoring subject – Excel Challenge

October 20, 2016| 31 Comments

find-the-lowest-scoring-subject-excel-challenge

I got through a few interesting formula challenges in the Round 2 of Excel World Champ. One of the formula based question was similar to this Excel Challenge

Let’s see if we can knock this down!

Read More
© Goodly