Intermediate Spreadsheets 1

Table of Contents

1.

Introduction

20.

Inserting Functions in Formulas

2.

Filling Cells 

21.

Ex-Inserting Functions in Formulas

3.

Ex-Filling Cells 

22.

Modifying Formulas & Functions

4.

Editing Data Efficiently

23.

Ex-Modifying Formulas & Functions

5.

Ex-Editing Data Efficiently

24.

Copying Formulas & Functions

6.

Inserting & Deleting Cells

25.

Ex-Copying Formulas & Functions

7.

Ex-Inserting & Deleting Cells

26.

Formula & Function Errors

8.

Inserting & Deleting Rows & Columns

27.

Ex-Formula & Function Errors

9.

Ex-Inserting & Deleting Rows & Columns

28.

Organizing Worksheets

10.

Data Fitting Errors

29.

Ex-Organizing Worksheets

11.

Spelling Check

30.

Templates

12.

Ex-Spelling Check

31.

Ex-Templates

13.

Find & Replace

32.

Time Saving Tips

14.

Ex-Find & Replace

33.

Ex-Time Saving Tips

15.

Quiz 1

34.

RS-Save Formats

16.

Formulas Containing Multiple Operators

35.

Ex-Save Formats

17.

Ex-Formulas Containing Multiple Operators

36.

Quiz 2

18.

Commonly Used Functions

37.

End

19.

Ex-Commonly Used Functions