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.
Colors in Chart Labels [Quick Tip]
A simple label formatting hack can improve the effectiveness of YoY change charts by adding color to differentiate positive vs. negative growth (or mediocre vs. sky rocketing growth rates). See this example:
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.
Visualizing Search Terms on Travel Sites – Excel Dashboard
Microsoft excel bubble chart based Visualization to understand how various travel sites compete search terms
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
Automatically insert timestamps in excel sheet using formulas
Often when you use excel to track a particular item (like expenses, exercise schedules, investments) you usually enter the current date (and time). This is nothing but timestamping. Once the item is time stamped, it is much more easier to analyze it. Here is an excel formula trick to generate timestamps.
Excel Basics – What are Combination Charts and How to Make One?
A combination chart is when you combine two different charts to make one. A popular example for combination chart is a line & bar graph combination.