Building Formulas in Excel 2007

View:  
Sorted by:  

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…]

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…]

How to Build an Array Formula in Excel 2007

Remember that an array formula is a special formula that operates on a range of values. When you build an array formula in a worksheet, you use the Ctrl+Shift+Enter keyboard shortcut to insert an array [more…]

Inserting Subtotals in an Excel 2007 Worksheet

You can use Excel 2007’s Subtotals feature to subtotal data in a sorted list. To subtotal a list, you first sort the list on the field for which you want the subtotals, and then you designate the field [more…]

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…]

How to Print Formulas in an Excel 2007 Worksheet

A basic printing technique you may need in Excel 2007 is how to print the worksheet formulas instead of printing the calculated results of the formulas. You can check over a printout of the formulas in [more…]

Figuring Out the Excel 2007 Formula Bar

The Formula bar in Microsoft Office Excel 2007 displays the cell address and the contents of the current cell. Use the Formula bar to enter or edit formulas and cell entries and assign names to cells. [more…]

Referring to Values or Formulas in Other Cells in Excel 2007 Formulas

Linking formulas are formulas in Excel 2007 that reference a location in the same worksheet, same workbook, or even a different workbook. When you create a linking formula, it brings forward the constant [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…]

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…]

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…]

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…]

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…]

Excel Order of Operations to Keep in Mind

Mathematics dictates a protocol of how formulas are interpreted, and Excel follows that protocol. The following is the order in which mathematical operators and syntax are applied both in Excel and in [more…]

Excel Cell References Worth Remembering

In Excel formulas, you can refer to other cells either relatively or absolutely. When you copy and paste a formula in Excel, how you create the references within the formula tells Excel what to change [more…]

Sign Up for RSS Feeds

Computers & Software
Win $500. Easy. Enter to win now.

Inside Dummies.com

Dummies.com Sweepstakes

Win $500. Easy.