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