Excel 2007 Formulas & Functions

Sorted by:  

Using AutoSum for Quick Calculations in Excel 2007

To quickly sum a row or a column of values in an Excel 2007 worksheet, you can use the AutoSum button (the one with the on it) in the Editing group of the Home tab of the Ribbon. When you click this button [more…]

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

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

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

An Overview of Excel 2007's Reference Functions

The reference functions in Excel 2007, which are a part of the Lookup & Reference category, enable you to return specific information about particular cells or parts of the worksheet; create hyperlinks [more…]

An Overview of Excel 2007's Database Functions

You can use Excel 2007's database functions to calculate statistics, such as the total, average, maximum, minimum, and count in a particular field of the database or table when the criteria that you specify [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…]

Using Boolean Expressions in Data Analysis with Excel 2007

Excel 2007 data analysis tools include Boolean expressions, of course. To construct a Boolean expression, such as when you filter criteria, use a comparison operator and then a value in the comparison [more…]

Excel 2007 Database Functions

Excel 2007's data analysis tools include a set of database functions for making statistical calculations using information from lists. The following table shows these functions and explains what each does [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…]

Excel Functions You're Likely to Use

Some Excel functions apply to specific subject areas, but others are general and apply to all needs. The following list shows an array of Excel functions used by one and all. Check here for a quickie reference [more…]


Sign Up for RSS Feeds

Computers & Software

Inside Dummies.com