Chandeep Chhabra

Become Unbelievably "Excel"lent !

Hi, My name is Chandeep!

Since 2013, I have been training, consulting and blogging to help people become quicker and smarter with Excel

Let me get you started by sending you smart ebooks on Excel and Powerpoint!

Let's Get Started!

Dynamic Pie Charts in Excel

November 13, 2017| 4 Comments

Dynamic Pie Chart in Excel

I am sure it has been written over a million times in the excel/charting community that Pie Charts are severely overrated than their actual utility but still people seem to have a heart for them.. at times by their own choice or because of their “pie loving” bosses.

Nonetheless, if you happen to use a pie chart for whatsoever reason, let me teach you how to spice it up i.e. How to Make your Pie Chart Dynamic

Read More

Use Slicers as Selection Buttons

November 9, 2017| No Comments

Excel Slicers as Selection Buttons

This is a Chart-Pro’s tip!

If you have been tired of using drop downs or selection buttons (form-x/active-x controls) in your dashboard/charts then it is time that you learn something really cool and fancy

You can instead use Slicers as Selection Buttons!

Read More

Scroll 2 Excel Files Simultaneously

October 31, 2017| 1 Comment

Scroll 2 Excel Files Simultaneously

This post is about one of those times when you realized that you just need to look into the raw data (rather than creating a pivot) and let’s say from 2 or more files.

In order to save you from continuously hitting ALT+TAB you can scroll two or more excel files simultaneously. Yes Seriously..!

Here is how it works

Read More

Running Total Tricks in Excel Tables

October 3, 2017| 1 Comment

Running Total Tricks in Excel Tables

A few days ago one of our readers Micheal, asked me a question.

Running Total Tricks in Excel Tables 1

The original question was pertaining to running total if the data is converted into a table. I took it a bit further and added 2 interesting variations to it. These are very practical issues that you might have faced in the past.

Take a look!

Read More

Facebook Dashboard in Excel

September 25, 2017| 7 Comments

Facebook Dashboard in Excel

While casually playing around with PowerQuery, I was able to connect my personal Facebook page with Excel and bring in all the data (posts, likes, comments etc..) into excel

I was like this : “Dude this is Gold!” and then the Facebook Dashboard happened !

Read More

Download Smart Ebooks on
Excel and PowerPoint Presentations

© Goodly