Excel 2007

Creating Complex Formulas

Introduction

Excel is a spreadsheet application and is intended to be used to calculate and analyze numerical information such as household budgets, company finances, and inventory. To do this, you need to understand formulas.

In this lesson, we’ll discuss complex formulas that use multiple mathematical operators, as well as those that use absolute and relative references.