Excel 2010: Complex Formulas

http://www.GCFLearnFree.org

Excel is a spreadsheet application that can help you calculate and analyze numerical information for household budgets, company finances, inventory, and more. To do this, you need to understand complex formulas.

In this lesson, you will learn how to write complex formulas in Excel following the order of operations. You will also learn about relative and absolute cell references and how to copy and fill formulas containing cell references.

Simple formulas have one mathematical operation, such as 5+5. Complex formulas have more than one mathematical operation, such as 5+5-2. When there is more than one operation in a formula, the order of operations tells us which operation to calculate first. In order to use Excel to calculate complex formulas, you will need to understand the order of operations.

Watch the video to learn about the order of operations in complex formulas.

Category:

Education

Tags:

• Microsoft Excel
• MS Excel
• tutorials
• spreadsheet
• workbooks
• Excel
• formulas
• how to
• Excel 2010
• computer help
• video tutorials
• Excel tutorials
• complex formulas

[gcflearnfree]

@jan29pawan We use Camtasia to create our screencasts.

[jan29pawan]

thank you and which software have u used for the making?

and how to calculate this number.... squareroot( square of 3 + square of 9) ?