Teknimedia is a provider of Computer Training & Literacy courses
Contact us
PC151-2007

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

  • 17 Lessons
  • 13 Exercises
  • 2 Quizzes

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

1.

Introduction

17.

Ex-Formulas Containing Multiple Operators

2.

Filling Cells

18.

Commonly Used Functions

3.

Ex-Filling Cells

19.

Ex-Commonly Used Functions

4.

Editing Data Efficiently

20.

Inserting Functions in Formulas

5.

Ex-Editing Data Efficiently

21.

Ex-Inserting Functions in Formulas

6.

Inserting & Deleting Cells

22.

Modifying Formulas & Functions

7.

Ex-Inserting & Deleting Cells

23.

Ex-Modifying Formulas & Functions

8.

Inserting & Deleting Rows & Columns

24.

Copying Formulas & Functions

9.

Ex-Inserting & Deleting Rows & Columns

25.

Ex-Copying Formulas & Functions

10.

Data Fitting Errors

26.

Formula & Function Errors

11.

Spelling Check

27.

Ex-Formula & Function Errors

12.

Ex-Spelling Check

28.

Organizing Worksheets

13.

Find & Replace

29.

Ex-Organizing Worksheets

14.

Ex-Find & Replace

30.

Templates

15.

Quiz 1

31.

Quiz 2

16.

Formulas Containing Multiple Operators

32.

End