Excel 2007's new table feature eliminates the need to copy formulas; once you define a data range as a table, Excel will do it for you! Tables are new to Excel 2007 ...

Excel functions, or formulas, lie at the heart of the application’s deep well of capabilities. Today we’ll tackle IF statements, a string of commands that determine whether a condition is met or not.

Over the last few months, I’ve written several articles about Excel’s newish dynamic array functions. In many cases, they can replace older, more complex expressions. The new functions do all that ...

If you use Microsoft Excel, you probably know the popular spreadsheet tool automatically numbers each row in a spreadsheet outside the columns of the sheet itself. But often you want to have a column ...

When analyzing grades (especially for a large class) the COUNTIF function in Excel can be extremely helpful. For example, suppose you have entered your final letter grades, and you need to report how ...