In
this
lesson, you will learn how to:
1. Format data and content.
2. Fill a series with AutoFill.
3. Calculate revenue with a formula.
4. Summarize the data.
5. Identify Relative References.
6. Identify errors and troubleshoot equations.
7. Use the Auditing Tools
This lesson show options on the Home and Formulas
Ribbons.
1.
Home->Number->Date, page 15
2.
Home->Number->Format Cells, page 17
3.
Home->Editing->AutoSum, page 24
4.
Home->Cells->Format, page 27
5.
Home->Cells->Delete, page 29
6.
Formulas -> Formula Auditing->Trace Dependents, page 41
7.
Formulas -> Formula Auditing->Trace Precedents, page 42
8.
Formulas -> Formula Auditing->Show Formulas, page 44
9.
Formulas -> Formula Auditing->Error Checking, page 46 |
|
|
|
