Skip to search results
PRODUCT
Office.com results
Get to know Excel 2010: Create formulas
Training Learn to use formulas to do math, update formula results automatically, and use predefined formulas (functions) to calculate things like monthly payments.
Excel 2010
Video: Add and subtract numbers
Video Learn how to do simple addition and subtraction in an Excel worksheet.
Excel 2010
Video: Use functions in formulas
Video Learn how to harness the power of Excel by using worksheet functions in your formulas.
Excel 2010
Combine two or more columns by using a function
Article You can merge columns by using a function so that the data in two or more columns is combined into a single column.
Excel 2010, Excel 2007...
Use Excel as your calculator
Article Instead of reaching for your calculator, use Microsoft Excel to do the math! On a worksheet , you can enter simple formulas to add, divide, multiply, and subtra...
Excel 2010
Use Formula AutoComplete
Article To make it easier to create and edit formulas and minimize typing and syntax errors, use Formula AutoComplete. After you type an = (equal sign) and beginning le...
Excel 2010
Evaluate a nested formula one step at a time
Article With the Evaluate Formula dialog box, you can see how a nested formula calculates its result by inspecting its intermediate calculations and logical tests.
Excel 2010
Guidelines and examples of array formulas
Article To become an Excel power user, you ne ed to know how to use array formulas, which can perform calculations that you can't do by using non-array formulas. The fo...
Excel 2010
Create or change a cell reference
Article Show All Hide All A cell reference (cell reference: The set of coordinates that a cell occupies on a worksheet. For example, the reference of the cell that appe...
Excel 2010
Create or delete a formula
Article Learn techniques for unleashing the power of formulas. Start with basics and work your way up. Learn ways to minimize complexity.
Excel 2010
Overview of formulas
Article Learn how Excel formulas work. Troubleshoot common formula problems. Find links to specific help on functions.
Excel 2010, Excel 2007
Count unique values among duplicates
Article Use a filter or functions to count the number of unique values in a range that contains duplicate values.
Excel 2010, Excel 2007
Ways to sum values in a worksheet
Article Excel provides multiple techniques that you can use to sum (add up) numbers. Summing should not be confused with counting the number of cells.
Excel 2010, Excel 2007
Ways to count values in a worksheet
Article Use the status bar for simple counting in Excel, or use functions to count cells that contain data, are blank, or meet specific conditions or multiple criteria.
Excel 2010, Excel 2007
Add numbers
Article There are several ways to add numbers in Excel. You can use a formula, the SUM function, add only the numbers that meet criteria, and more.
Excel 2010
Subtract numbers
Article Use the minus sign operator or the SUM function to subtract numbers in Excel 2010.
Excel 2010
Divide numbers
Article Show All Hide All Let's say you want to find out how many person hours it took to finish a project (total project hours ÷ total people on project) or the actual...
Excel 2010
Use COUNTA to count nonblank cells
Article View an example of how to use the COUNTA function to count cells that are not empty in a range of data.
Excel 2010, Excel 2007...
Change formula recalculation, iteration, or precision
Article Show All Hide All To use formulas (formula: A sequence of values, cell references, names, functions, or operators in a cell that together produce a new value. A...
Excel 2010
Quick start: Use a function in a formula
Article In addition to entering formulas that perform basic math — such as adding, subtracting, multiplying, and dividing — you can use a vast library of built-in works...
Excel 2010
Quick start: Create a formula
Article Formulas are equations that can perform calculations, return information, manipulate the contents of other cells, test conditions, and more.
Excel 2010
Move or copy a formula
Article Show All Hide All It's important to be aware of what can happen to cell references (cell reference: The set of coordinates that a cell occupies on a worksheet. ...
Excel 2010
Calculation operators and precedence
Article Operators specify the type of calculation that you want to perform on the elements of a formula. There is a default order in which calculations occur, but you c...
Excel 2010
Break a link to an external reference
Article Important When you break a link to the source workbook of an external reference, all formulas that that use the value in the source workbook are conver...
Excel 2010
Split names by using the Convert Text to Columns Wizard
Article Use the Convert Text to Columns Wizard to separate simple cell content, such as first names and last names, into different columns. Full name First name    Las...
Excel 2010
PREV12NEXT
Didn't find what you were looking for?Search all of Office.com