Table of Contents
|
|
|
|
|
|
|
1.
|
Introduction
|
16.
|
Commonly Used Functions
|
|
2.
|
Auto Fill
|
17.
|
Inserting Functions in Formulas
|
|
3.
|
Exercise-Auto Fill
|
18.
|
Exercise-Inserting Functions in Formulas
|
|
4.
|
Editing Data Efficiently
|
19.
|
Modifying Formulas & Functions
|
|
5.
|
Exercise-Editing Data Efficiently
|
20.
|
Exercise-Modifying Formulas & Functions
|
|
6.
|
Inserting & Deleting Cells
|
21.
|
Copying Formulas & Functions
|
|
7.
|
Exercise-Inserting & Deleting Cells
|
22.
|
Exercise-Copying Formulas & Functions
|
|
8.
|
Inserting & Deleting Rows & Columns
|
23.
|
Formula & Function Errors
|
|
9.
|
Exercise-Inserting & Deleting Rows & Columns
|
24.
|
Exercise-Formula & Function Errors
|
|
10.
|
Data Fitting Errors
|
25.
|
Organizing Worksheets
|
|
11.
|
Spelling Check
|
26.
|
Exercise-Organizing Worksheets
|
|
12.
|
Find & Replace
|
27.
|
Templates
|
|
13.
|
Quiz 1
|
28.
|
Quiz 2
|
|
14.
|
Formulas Containing Multiple Operators
|
29.
|
End
|
|
15.
|
Exercise-Formulas Containing Multiple Operators
|
|
|
|
|
|
|
|