Building Formulas in Excel 2010

Sorted by:  

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

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

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

Using Parentheses to Change the Order of Operations in Excel 2010 Formulas

Many formulas that you create in Excel 2010 perform multiple operations. Excel follows the order of operator precedence when performing each calculation. This natural order of arithmetic operations is [more…]

Using Absolute and Relative References in Excel 2010 Formulas

You can use three types of cell references in Excel 2010 formulas: relative, absolute, and mixed. Using the correct type of cell reference in formulas ensures that they work as expected when you copy them [more…]

How to Insert Subtotals in an Excel 2010 Worksheet

You can use Excel 2010's Subtotals feature to subtotal data in a sorted list. To subtotal a list, you first sort the list on the field for which you want the subtotals, and then you designate the field [more…]

How to Join Text Strings in Excel 2010 with the & Operator

In Excel 2010, you can use the ampersand (&) operator to concatenate (or join) separate text strings together. For example, in a client list worksheet that includes the last names in column A and the first [more…]

Referring to Values or Formulas in Other Cells in Excel 2010 Formulas

Linking formulas are formulas in Excel 2010 that reference a location in the same worksheet, same workbook, or even a different workbook. When you create a linking formula, it brings forward the constant [more…]

How to Build an Array Formula in Excel 2010

An array formula is a special formula that operates on a range of values in Excel 2010. When you build an array formula in a worksheet, you press Ctrl+Shift+Enter to insert an array formula in the array [more…]

Creating Complex Formulas in Excel 2010

Excel can calculate complex formulas where you want to combine adding, multiplication, division, and more, but you have to write your formulas carefully so Excel understands the end result you're looking [more…]
Learning anything is easy with For Dummies eLearning!

Sign Up for RSS Feeds

Computers & Software