Identify formulas using Conditional Formatting
[Excel: Formulas]
Summary: Avoid accidentally deleted or overwritten cells containing formulas by set up your worksheet so that all formula cells get a color background. Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007
Calculate the number of days in a month
[Excel: Formulas]
Summary: Calculate the number of days in a month. Excel lacks a function for calculating the number of days in a particular month, so you'll need to construct your own formula. Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007
Calculating a conditional average
[Excel: Formulas]
Summary: Calculate student grades by averaging a series of test scores but omitting the two lowest scores. Or you might want to compute an average that ignores both the highest and lowest values. Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007
Counting Cells According to Case
[Excel: Formulas]
Summary: Using Excel to analyze a group of cells containing text and determine the number of cells that contain uppercase, the number that contain lowercase, and the number that contain mixed case. Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007
Applying Colors to Subtotal level
[Excel: Subtotals]
Summary: Applying colors to subtotal level by changing style. Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003
[ Prev 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 Next ]
