Dummies.com - Making Everything Easier
Functions
View:
Sorted by:
Looking Up Data in Excel 2007 with HLOOKUP and VLOOKUP
The most popular of the lookup functions in Excel 2007 are HLOOKUP (for Horizontal Lookup) and VLOOKUP (for Vertical Lookup). These functions are located in the Lookup & Reference category on the Formulas [more…]
How to Install the Excel 2007 Analysis ToolPak
The Analysis ToolPak is an Excel 2007 add-in program that adds extra financial, statistical, and engineering functions to Excel's pool of built-in functions. The tools included in the Analysis ToolPak [more…]
Using Logical Functions in Excel 2007 Formulas
Excel 2007 uses seven logical functions — AND, FALSE, IF, IFERROR, NOT, OR, and TRUE — which appear on the Logical command button’s drop-down menu on the Formulas tab of the Ribbon. All the logical functions [more…]
Adding Up with Excel 2007's SUM and SUMIF Functions
In Excel 2007, you use the very familiar SUM function to total values in your worksheets. Use the SUMIF function when you want to total only the numbers in a range that meet a criteria you specify. These [more…]
Counting Cells with Excel 2007's COUNT Functions
Excel 2007 offers an assortment of counting functions — including COUNT, COUNTA, COUNTBLANK, and COUNTIF — in the Statistical category that enable you to count the number of cells that contain numeric [more…]
Rounding Numbers in Excel 2007 with ROUND, ROUNDUP, and ROUNDDOWN
The mathematical functions ROUND, ROUNDUP, and ROUNDDOWN are included in the Math & Trig category in Excel 2007. You'll find these by clicking the Math & Trig button on the Ribbon’s Formulas tab or in [more…]
Switching Vertical and Horizontal Data with Excel 2007's TRANSPOSE Function
Excel 2007's TRANSPOSE function enables you to change the orientation of a cell range (or array). You can use this function to transpose a vertical cell range where the data runs down the rows of adjacent [more…]
Deconstructing Dates in Excel 2007 with DAY, WEEKDAY, MONTH, and YEAR
The DAY, WEEKDAY, MONTH, and YEAR date functions in Excel 2007 all return parts of the date serial number that you specify as their argument. You can access these functions on the Date & Time command button’s [more…]
Calculating Loan Payments with Excel 2007's PMT Function
Excel 2007's PMT function calculates the periodic payment for an annuity, assuming a stream of equal payments and a constant rate of interest. The PMT function uses the following syntax: [more…]
Using Functions in Excel 2007 Formulas
In Excel 2007, functions are like built-in 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…]
Powers and Roots in Excel 2007: The POWER and SQRT Functions
In Excel 2007, you use the POWER function to raise a number to a certain power, and SQRT to find the square root of a number. These functions are located with the Math & Trig functions on the Ribbon’s [more…]
Planning Ahead with Excel 2007's TODAY, DATE, and DATEVALUE Functions
Excel 2007 contains a number of built-in date functions that you can use in your worksheets. Three common date functions are TODAY, DATE, and DATEVALUE, and they can come in very handy when you're trying [more…]
Fixing Capitalization with Excel 2007's UPPER, LOWER, and PROPER Functions
Excel 2007 includes several Text functions (such as UPPER, LOWER, PROPER, VALUE, TEXT, and DOLLAR) that enable you to perform operations on text entries in a worksheet. These functions are located in the [more…]
Examining Investment Value with Excel 2007's PV and FV Functions
The most common financial functions in Excel 2007 — PV (Present Value) and FV (Future Value) — use the same arguments. The key to using these financial functions is to understand the terminology used by [more…]
Crunching Numbers with Excel 2007's AVERAGE, MAX, MIN, and MEDIAN Functions
Excel 2007's Statistical functions — including AVERAGE, MAX, MIN, and MEDIAN — are found on a continuation menu accessed from the More Functions command button’s drop-down menu on the Formulas tab. Excel [more…]
Planning Your Day with Excel 2007's NOW, TIME, and TIMEVALUE Functions
Excel 2007's time functions enable you to convert text entries representing times of day into time serial numbers so that you can use them in calculations. Some common time functions include NOW, TIME, [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…]
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…]
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…]
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…]
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…]
Order of Operations in Excel
Knowing the order that mathematical operations are performed (operator precedence) is key to writing formulas and getting correct results in Excel. Use the catch phrase, “ [more…]
Inside Dummies.com
THANKSGIVING: DINNER IDEAS & RECIPES
|
BUSINESS & CAREER STRATEGIES
|
