View:
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 Sales Forecasting Functions
Give these sales forecasting functions in Excel a good baseline and you can get a handle on future sales business. Some Excel forecast functions and their actions appear in the following chart — keep it [more…]
The LINEST Function in Excel Sales Forecasting
The LINEST (or linear estimate) function in Excel sales forecasting uses formulas to calculate a regression equation and related statistics. This chart shows the information the Excel LINEST function will [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…]
