Sorted by:  

Understanding Excel 2007's Formula Auditing Tools

Excel 2007 offers some effective formula-auditing tools for tracking down the cell that’s causing your error woes by tracing the relationships between the formulas in the cells of your worksheet. By tracing [more…]

Assigning Names to Constant Values in Excel 2007

Some formulas that you create in Excel 2007 use constant values, such as a 7.5% tax rate or a 10% discount rate. Assign names to these values and then use their names in the formulas that you create. Then [more…]

How to Enter Basic Formulas in Excel 2007

As entries go in Excel 2007, formulas are the real workhorses of the worksheet. If you set up a formula properly, it computes the right answer when you first enter it into a cell. From then on, it keeps [more…]

How to Join Text Strings in Excel 2007 with the & Operator

You can use the ampersand (&) operator to concatenate (or join) separate text strings together in Excel 2007. For example, in a client list worksheet that includes the last names in column A and the first [more…]

Determining Cell Data Types with Excel 2007's TYPE Function

Excel 2007's TYPE function is an information function that returns the type of value in a cell. Aptly named, this function enables you to build formulas with the IF function that execute one type of behavior [more…]

Deconstructing Time with Excel 2007's HOUR, MINUTE, and SECOND Functions

Excel 2007 includes several time functions that you can use in your worksheets. Use the HOUR, MINUTE, and SECOND time functions to extract the hours, minutes, and seconds from a single time serial number [more…]

Editing an Array Formula in Excel 2007

Editing array formulas in Excel 2007 differs somewhat from editing normal formulas. In editing an array range, you must treat the range as a single unit and edit it in one operation [more…]

Simplifying Numbers with Excel 2007's INT and TRUNC Functions

You can use Excel 2007's INT (for Integer) and TRUNC (for Truncate) functions on the Math & Trig button’s drop-down menu to round off values in your worksheets. You use these functions only when you don’t [more…]

Tracing Precedents and Dependents in Excel 2007 Formulas

Excel 2007 formulas may contain precedents and may serve as dependents to other formulas. Precedents are cells or ranges that affect the active cell’s value. [more…]

Avoiding Circular References in Excel 2007 Formulas

A circular reference occurs when a cell in an Excel 2007 worksheet refers to itself, whether directly or indirectly. For example, if =100+A2 is entered into cell A2, then a direct circular reference has [more…]

How to Change the Order of Operations in Excel 2007 Formulas

Many formulas that you create in Excel 2007 perform multiple operations. Excel performs each operation, moving from left to right, in a strict pecking order. This is the natural order of arithmetic operations [more…]

Representing Arrays in Excel 2007 Formulas

An array formula is a special formula that operates on a range of values. If a cell range supplies this range (as is often the case), it is referred to as an [more…]

Depreciating Assets with Excel 2007's SLN, SYD, DB, and DDB Functions

Excel 2007 lets you choose from four Depreciation functions — SLN, SYD, DB, and DDB — each of which uses a different method for depreciating an asset over time. These built-in Depreciation functions, found [more…]

Using Excel 2007's IS Information Functions

Excel 2007's IS information functions (as in ISBLANK, ISERR, ISNA, ISNUMBER, ISTEXT, and so on) are a large group of functions that perform essentially the same task. They evaluate a value or cell reference [more…]

Evaluating and Checking Errors in Excel 2007

The Evaluate Formula dialog box in Excel 2007 walks you through the steps used in calculating a result from a formula. This helps locate errors in formulas that are long, or have precedents. For example [more…]

Deciphering Error Values in Excel 2010 Formulas

You can tell right away that an Excel 2010 formula has gone haywire because instead of a nice calculated value, you get a strange, incomprehensible message. This weirdness, in the parlance of Excel 2010 [more…]


Sign Up for RSS Feeds

Computers & Software