### Excel 2010: Complex Formulas

http://www.gcflearnfree.org/excel2010Excel 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.If you are interested in learning more about this topic, please visit our site to view the entire tutorial on our website. It includes instructional text, informational graphics, examples, and even interactives for you to practice and apply what you've learned.

Length:
05:21