Search Results
11 results for "Peter G. Aitken"

Finding the Correct Function in Excel 2007
The first step to using a function in Excel 2007 is finding the one you need! Even when you know the one you need, you may not remember all the arguments it takes. To find a function, open the Insert Function [more…]
Found in: Functions in Excel 
Using Absolute and Relative References in Excel 2007 Formulas
You can use three types of cell references in Excel 2007 formulas: relative, absolute, and mixed. Using the correct type of cell reference ensures that formulas work as expected when you copy them to another [more…]
Found in: Formulas in Excel 
How to Display All Formulas in an Excel 2007 Worksheet
In Excel 2007, it can be difficult to view your formulas without accidentally editing them. That’s because anytime you are in “edit” mode and the active cell has a formula, the formula might incorporate [more…]
Found in: Managing 
Controlling Excel 2007 Formula Calculations Manually
By default, Excel 2007 calculates your formulas automatically as they are entered or when you modify the worksheet. You can switch to manual calculation when necessary. Leaving the setting on automatic [more…]
Found in: Building Formulas 
Fixing Broken Formula Links in Excel 2007
Formulas in Excel 2007 can reference external workbooks. Links become broken when external workbooks are moved, deleted, or renamed. When a workbook that contains an external reference is opened but cannot [more…]
Found in: Formulas in Excel 
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…]
Found in: Formulas in Excel 
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…]
Found in: Formulas in Excel 
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…]
Found in: Formulas in Excel 
Using Functions in Excel 2007 Formulas
In Excel 2007, functions are like builtin formulas that perform simple to complex tasks. For example, the SUM function sums up numbers, the COUNT function counts, and the AVERAGE function calculates an [more…]
Found in: Functions in Excel 
How to Build Excel 2007 Formulas with the Insert Function Dialog Box
The Insert Function dialog box in Excel 2007 is designed to simplify the task of using functions in your worksheets. The dialog box not only helps you locate the proper function for the task at hand but [more…]
Found in: Formulas in Excel 
Microsoft Office Excel 2007 Formulas and Functions For Dummies Cheat Sheet
To write formulas and functions in Excel 2007 that manage your data, make sure you understand common, text, and array functions and take advantage of some helpful keyboard shortcuts to work quickly. To [more…]
Found in: Formulas & Functions