Often when you’re working with Excel you will use a calculation that is not available as a built-in Excel function. If you make this calculation repeatedly, you can save having to write the ...

Functions are the driving force of any Microsoft Excel spreadsheet, generating a single value or an array of results based on certain arguments you input. However, combining—or nesting—functions ...

How to Use the IF Function in Excel 2007 With Absolute References. Cells in Excel are referred to using relative or absolute references. A formula with relative references changes when the cell's ...

Excel 2007 introduces a number of useful new functions, such as ISERROR and AVERAGEIFS. For presentation work we now have themes to help in the selection of complementary colors for Excel reports.

How to Change the Case in Excel 2007. Unlike Microsoft Word, Excel 2007 does not include a Change Case feature for quickly converting capitalization styles. However, Excel does have functions that ...

Excel’s Text functions are a major time saver if your job entails managing massive data, especially data that’s imported from other sources. Fortunately, all ASCII data is easily imported, but ...