Teknimedia is a provider of Computer Training & Literacy courses
Contact us
PC151XP

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

  • 14 Lessons
  • 10 Exercises
  • 2 Quizzes

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

1.

Introduction

14.

Commonly Used Functions

2.

Auto Fill

15.

Inserting Functions in Formulas

3.

Ex-Auto Fill

16.

Ex-Inserting Functions in Formulas

4.

Editing Data Efficiently

17.

Modifying Formulas & Functions

5.

Ex-Editing Data Efficiently

18.

Ex-Modifying Formulas & Functions

6.

Inserting & Deleting Cells

19.

Copying Formulas & Functions

7.

Ex-Inserting & Deleting Cells

20.

Ex-Copying Formulas & Functions

8.

Inserting & Deleting Rows & Columns

21.

Formula & Function Errors

9.

Ex-Inserting & Deleting Rows & Columns

22.

Ex-Formula & Function Errors

10.

Data Fitting Errors

23.

Organizing Worksheets

11.

Quiz 1

24.

Ex-Organizing Worksheets

12.

Formulas Containing Multiple Operators

25.

Quiz 2

13.

Ex-Formulas Containing Multiple Operators

26.

End