Us vs. Them – Compare Sales Performance using Charts & Form Controls
Today we will learn a little trick to compare 1 value with a set of values, For eg. our sales vs. competitor sales. We will learn how to create a chart like this.
5 Areas where Mouse Kicks Keyboard’s Butt
We are a big advocate of keyboard shortcuts. I think learning a handful of keyboard shortcuts can improve your productivity tremendously, whether you are using excel or firefox.
But using only keyboard shortcuts is like using only right hand. So, we have compiled 5 incredible ways mouse can help you be productive while using MS Excel.
What is Your Opinion on Pie Charts?
Pie charts are one of the most used charts in the world. And for obvious reasons: they are simple to create and easy to understand. When it comes to pie chart, I have no clear opinion. Part of me says use them, the other says avoid them.
What is your opinion on Pie charts ?
“Too Many Worksheets” Driving You Nuts? Read This!
Learn how to create Table of Contents in Excel and other tricks to manage when you have too many worksheets.
Write Your Own Twitter Client using Microsoft Excel
Learn how you can write your own twitter client using Excel. All it takes is excel, internet connection and 5 minutes of spare time.
100 Excel Tips & Resources
Hurray, PHD blog crossed 2000 RSS Subscriber base. This is a very significant milestone for me.
To celebrate this occasion we have a mega post: 100 Excel & Charting Tips, Tricks and Resources for you.
Why No One Likes Your Pie Charts (And What to Do About It)
9 charting tricks you can use to make your pie charts likable