Using Excel 2010 Functions

Sorted by:  

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

Excel Text Functions You'll Find Helpful

Excel's text functions are very helpful when you're working with names, addresses, customer lists, or any other text-based data. Here is list of Excel functions associated with text, along with a description [more…]

Adding Up with Excel 2010's SUM and SUMIF Functions

In Excel 2010, 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 criteria you specify. These [more…]

An Overview of Excel 2010's Database Functions

You can use Excel 2010's database functions to calculate statistics, such as the total, average, maximum, minimum, and count in a particular database field when the criteria that you specify are met. For [more…]

Conditional Counting in Excel 2010 with COUNTIF

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

Crunch Numbers with Excel 2010's AVERAGE, MAX, MIN, and MEDIAN Functions

Excel 2010'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…]

Counting Cells in Excel 2010 with COUNT, COUNTA, and COUNTBLANK

Excel 2010 offers an assortment of counting functions — including COUNT, COUNTA, COUNTBLANK — in the Statistical category that enable you to count the number of cells that contain numeric values, that [more…]

Planning Ahead with Excel 2010's TODAY, DATE, and DATEVALUE Functions

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

Deconstructing Dates in Excel 2010 with DAY, WEEKDAY, MONTH, and YEAR

The DAY, WEEKDAY, MONTH, and YEAR date functions in Excel 2010 all return parts of the date serial number that you specify as their argument. You can access these functions on the Date & Time button's [more…]

Planning Your Day with Excel 2010's NOW, TIME, and TIMEVALUE Functions

Excel 2010'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. Three common time functions are NOW, TIME, and [more…]

Deconstructing Time with Excel 2010's HOUR, MINUTE, and SECOND Functions

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

How to Use Logical Functions in Excel 2010 Formulas

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

Calculating Loan Payments with Excel 2010's PMT Function

Excel 2010'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…]

Examining Investment Value with Excel 2010's PV and FV Functions

The most common financial functions in Excel 2010 — 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…]

Using Excel 2010's IS Information Functions

Excel 2010'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…]

Looking Up Data in Excel 2010 with HLOOKUP and VLOOKUP

The most popular of the lookup functions in Excel 2010 are HLOOKUP (for Horizontal Lookup) and VLOOKUP (for Vertical Lookup). These functions are located in the Lookup & Reference category on the Formulas [more…]

An Overview of Excel 2010's Reference Functions

The reference functions in Excel 2010, 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…]

Rounding Numbers in Excel 2010 with ROUND, ROUNDUP, and ROUNDDOWN

The mathematical functions ROUND, ROUNDUP, and ROUNDDOWN are included in the Math & Trig category in Excel 2010. You'll find these by clicking the Math & Trig button on the Ribbon's Formulas tab or in [more…]

How to Install the Excel 2010 Analysis ToolPak

The Analysis ToolPak is an Excel 2010 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…]

Applying Functions in Excel 2010

Excel uses functions for math that's more complicated than simple arithmetic. Functions often use one or more cell references or ranges and can perform a wide variety of math, including calculating averages [more…]
Learning anything is easy with For Dummies eLearning!

Sign Up for RSS Feeds

Computers & Software