Teknimedia is a provider of Computer Training & Literacy courses
Login
PC151-2003

PC151-2003 - Intermediate Spreadsheets 1
Teaches intermediate skills for working with spreadsheets
(Based on Microsoft Excel 2003)

  • 17 Lessons
  • 10 Exercises
  • 2 Quizzes

Table of Contents
Click on the underlined sections to view them.

1.

Introduction

16.

Commonly Used Functions

2.

Auto Fill

17.

Inserting Functions in Formulas

3.

Ex-Auto Fill

18.

Ex-Inserting Functions in Formulas

4.

Editing Data Efficiently

19.

Modifying Formulas & Functions

5.

Ex-Editing Data Efficiently

20.

Ex-Modifying Formulas & Functions

6.

Inserting & Deleting Cells

21.

Copying Formulas & Functions

7.

Ex-Inserting & Deleting Cells

22.

Ex-Copying Formulas & Functions

8.

Inserting & Deleting Rows & Columns

23.

Formula & Function Errors

9.

Ex-Inserting & Deleting Rows & Columns

24.

Ex-Formula & Function Errors

10.

Data Fitting Errors

25.

Organizing Worksheets

11.

Spelling Check

26.

Ex-Organizing Worksheets

12.

Find & Replace

27.

Templates

13.

Quiz 1

28.

Quiz 2

14.

Formulas Containing Multiple Operators

29.

End

15.

Ex-Formulas Containing Multiple Operators