Excel Conditional Formatting Basics
Do you know What is excel conditional formatting? Learn the basics, few examples and see how you can use it in day to day work in this installment of spreadcheats.
Excel Links of the Week – Free E-Book Edition
Find out how you can get a free e-book on excel and charting in this week’s excel links.
RSS Icon using Donut Charts – Because it is Weekend
RSS Icon using Donut Charts – Because it is Weekend
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.
2009 Calendar Template in Excel – Now with week starting on Monday
Stružák, one of the commenters on the 2009 Excel Calendar Template post asked me if I can rearrange the cells in the calendar so that the week could start on Monday. Since I didn’t have access to internet for a while, I have asked him to make the necessary changes and mail it to me […]
Brick Charts in Excel – an Alternative to Gridlines
Grid lines provide great help in understanding values in a chart. Here is a handy trick you can use in the next bar chart to spice it up. Here is how you can get this type of chart (we will call it a brick chart) First we will make a regular bar chart Now, let […]
Free Excel Calendar Template for year 2009 (and all years up to 9999)
Free excel calendar template for year 2009 (well, it works for any year all the way up to 9999)
Go ahead and download it, change the year number in the first sheet to 1981 or something and see the magic.