Using Excel 2007 Functions

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

Using Logical Excel 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 Excel Formulas tab of the Ribbon. All the logical [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…]

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

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

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


Sign Up for RSS Feeds

Computers & Software