Install Office
Sign in
United States
Skip to main content
HOME
PRODUCTS
SUPPORT
TEMPLATES
STORE
OFFICE ONLINE
Search all of Office.com
Warning: This site requires the use of scripts, which your browser does not currently allow.
See how to enable scripts.
Skip to search results
PRODUCT
All Products
Word
2013 for Windows
2010 for Windows
2007 for Windows
2003 for Windows
Web App
2011 for Mac
iPad
Excel
2013 for Windows
2010 for Windows
2007 for Windows
2003 for Windows
Web App
2011 for Mac
iPad
PowerPoint
2013 for Windows
2010 for Windows
2007 for Windows
2003 for Windows
Web App
2011 for Mac
iPad
Outlook
2013 for Windows
2010 for Windows
2007 for Windows
2003 for Windows
Web App
Web App Light
Web App for Office 365 for enterprises
Web App for Office 365 for Small Businesses
2011 for Mac
Access
2013 for Windows
2010 for Windows
2007 for Windows
2003 for Windows
Lync
2013 for Windows
Basic 2013 for Windows
2010 for Windows
2013 for Office 365
Web App
Web App for Lync Online
2011 for Mac
admin center
Windows Store app
2010 for Office 365
SharePoint Server
2013 Enterprise
2013 Standard
2013 Central Administration
2010
2007
Office 365
Enterprise
Small Businesses
Enterprise admin
Small Businesses admin
Office 365 Midsize Business
Office 365 Midsize Business Admin
Communicator
2011 for Mac
2007 R2 for Windows
2007 for Windows
2005 for Windows
Live Meeting
2010
2007
2005
OneNote
2013 for Windows
2010 for Windows
2007 for Windows
2003 for Windows
Mac
Web App
iPad
iPhone
Android
Project
Professional 2013
Standard 2013
2010
2007
2003
Project Online
Project Online
Project Server
2013
2010
2007
2003
Publisher
2013
2010
2007
2003
Visio
Professional 2013
2013
2010
2007
2003
Accounting
2009
2008
2007
FrontPage
2003
InfoPath
2013
2010
2007
2003
Dashboard Designer
Dashboard Designer
Search Server
2010 Central Administration
2008
SharePoint Designer
2013
2010
2007
SharePoint Foundation
2013
2013 Central Administration
2010
2010 Central Administration
Windows SharePoint Services 3.0
SharePoint Online
Administration Center
Enterprises (E1)
Enterprises (E3 & E4)
Small Businesses
Public Website
SharePoint Workspace
2010
Groove
Small Business Accounting
2006
Windows SharePoint Services
2.0
More
Expand all
Less
LANGUAGE
United States - English
Choose Language
México - Español
Canada - English
United Kingdom - English
More
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: Use functions in formulas
Video
Learn how to harness the power of Excel by using worksheet functions in your formulas.
Excel 2010
Video: Add and subtract numbers
Video
Learn how to do simple addition and subtraction in an Excel worksheet.
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
PREV
1
2
NEXT
Didn't find what you were looking for?
Search all of Office.com