In this lesson, you will learn how to:
1. Select and Name a RANGE of Cells.
2. Use the Named Range in a formula.
3. Use the Name Manager.
4. Use Defined Names in a formula.
5. Create Conditional Formulas.
6. Identify errors.
This lesson demonstrates options on the Formulas Ribbon.
1. Formulas->Defined Names->Define Name, page 89
2. Formulas->Defined Names->Name Manager, page 93
3. Formulas->Defined Names ->Use in Formula, page 97
4. Formulas->Function Library->Math and Trig -> SUMIF, page 98
5. Formulas->Function Library->Math and Trig -> SUMIFS, page 99
6. Formulas->Function Library->More Functions ->Statistical ->COUNTIF, page 101
7. Formulas ->Function Library->More Functions -> Statistical ->COUNTIFS, page 102
8. Formulas ->Function Library->More Functions -> Statistical ->AVERAGEIF, page 103
9. Formulas ->Function Library->More Functions -> Statistical ->AVERAGEIFS, page 104