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!
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 DynamicRead More
This is a Chart-Pro’s tip!
You can instead use Slicers as Selection Buttons!Read More
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 worksRead More
A few days ago one of our readers Micheal, asked me a question.
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
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