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!
An inappropriate charting anecdote..
I was on a flight to bangalore, gazing people around. The next second, the front row passenger swung his hands behind the head rest!
I felt disgusted – Wondering why? then you probably haven’t clicked on ‘his hands’ link
So I grabbed the news paper stuck in front of my seat and I felt even more disgusted. I saw the chart above!Read More
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