Excel 2010 Formulas & Functions

Sorted by:  

Deciphering Error Values in Excel 2010 Formulas

You can tell right away that an Excel 2010 formula has gone haywire because instead of a nice calculated value, you get a strange, incomprehensible message. This weirdness, in the parlance of Excel 2010 [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…]

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

Using AutoSum for Quick Calculations in Excel 2010

You can use the AutoSum button in Excel 2010 to quickly sum a row or a column of values in an Excel worksheet. The AutoSum button is located in the Editing group of the Home tab. When you click this button [more…]

Building Excel 2010 Formulas with the Insert Function Dialog Box

The Insert Function dialog box in Excel 2010 simplifies the task of using functions in your Excel worksheets. The Insert Function dialog box helps you locate the proper function for the task at hand and [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…]

How to Enter Basic Formulas in Excel 2010

Formulas are the real workhorses of an Excel 2010 worksheet. If you set up a formula properly, it computes the correct answer when you enter it into a cell. From then on, it keeps itself up to date, recalculating [more…]

Learning anything is easy with For Dummies eLearning!

Sign Up for RSS Feeds

Computers & Software

Inside Dummies.com