Tech Support
Contact Us
PCIC3B-2005-Key Applications

176 Lessons, 114 Exercises, 19 Quizzes

 

6 Reading Supplements, 3 Tests

Estimated Duration: 57 Hours

Money Back Guarantee.
Click here for details.

Table of Contents

Unit 1-Basic Word Processing

Unit 2-Intermediate Word Processing 1

Unit 3-Intermediate Word Processing 2

Unit 4-Basic Spreadsheets

Unit 5-Intermediate Spreadsheets 1

Unit 6-Intermediate Spreadsheets 2

Unit 7-Basic Presentations

Unit 8-Intermediate Presentations

Unit 1-Basic Word Processing

B

Introduction

B1.27

Ex-Repeat

B1

Unit 1-Basic Word Processing

B1.28

Quiz 1-2

B1.1

Getting Started-Word

B1.29

Find & Replace

B1.2

Entering Text

B1.30

Ex-Find & Replace

B1.3

Ex-Entering Text

B1.31

Spelling & Grammar

B1.4

Editing Text 1

B1.32

Ex-Spelling & Grammar

B1.5

Ex-Editing Text 1

B1.33

Margins

B1.6

Editing Text 2

B1.34

Ex-Margins

B1.7

Ex-Editing Text 2

B1.35

Page Orientation & Paper Size

B1.8

Saving Documents

B1.36

Printing-Word

B1.9

Ex-Saving Documents 1

B1.37

Ex-Printing-Word

B1.10

Ex-Saving Documents 2

B1.38

Time Saving Tips-1

B1.11

Creating a New Document

B1.39

Ex-Time Saving Tips-1

B1.12

Ex-Creating a New Document

B1.40

Time Saving Tips-2

B1.13

Opening Documents

B1.41

Ex-Time Saving Tips-2

B1.14

Ex-Opening Documents

B1.42

Saving Files to a Floppy Diskette

B1.15

Viewing Documents

B1.43

Task Pane-Word

B1.16

Quiz 1-1

B1.44

Office Clipboard

B1.17

Formatting Text

B1.45

Ex-Office Clipboard

B1.18

Fonts-Word

B1.46

Getting Help

B1.19

Ex-Fonts-Word

B1.47

Ex-Getting Help

B1.20

Alignment-Word

B1.48

RS-Getting Help

B1.21

Ex-Alignment-Word

B1.49

RS-Managing Print Jobs

B1.22

Character Case

B1.50

RS-Common Print Problems

B1.23

Ex-Character Case

B1.51

RS-Common File Problems

B1.24

Utility Functions

B1.52

Quiz 1-3

B1.25

Ex-Undo & Redo

B1.53

Unit 1 End

B1.26

Ex-Format Painter-Word

 

 

Unit 2-Intermediate Word Processing 1

B2

Unit 2-Intermediate Word Processing 1

B2.20

Footnotes

B2.1

Character & Line Spacing

B2.21

Ex-Footnotes

B2.2

Ex-Character & Line Spacing

B2.22

Endnotes

B2.3

Indenting Paragraphs

B2.23

Pictures

B2.4

Ex-Indenting Paragraphs

B2.24

Ex-Pictures 1

B2.5

Bullets & Numbering

B2.25

Ex-Pictures 2

B2.6

Ex-Bullets & Numbering

B2.26

Hyperlinks

B2.7

Tabs

B2.27

Inserting Symbols & Special Characters

B2.8

Ex-Tabs

B2.28

Ex-Inserting Symbols

B2.9

RS-Tabs

B2.29

Superscript & Subscript

B2.10

Rulers

B2.30

Ex-Superscript & Subscript

B2.11

Quiz 2-1

B2.31

Displaying & Hiding Toolbars

B2.12

Page Breaks-Word

B2.32

Document Statistics

B2.13

Ex-Page Breaks-Word

B2.33

Ex-Document Statistics

B2.14

Header & Footer-Word

B2.34

Document Outlines

B2.15

Ex-Header & Footer-Word

B2.35

Templates

B2.16

Page Numbers

B2.36

Ex-Templates

B2.17

Ex-Page Numbers

B2.37

Formatting Marks

B2.18

Section Breaks

B2.38

Quiz 2-2

B2.19

Ex-Section Breaks

B2.39

Unit 2 End

Unit 3-Intermediate Word Processing 2

B3

Unit 2-Intermediate Word Processing 2

B3.18

Selecting Table Rows & Columns

B3.1

Text Borders & Shading

B3.19

Inserting & Deleting Table Rows & Cols

B3.2

Ex-Text Borders & Shading

B3.20

Ex-Inserting & Deleting Table Rows & Cols

B3.3

Styles-Word

B3.21

Resizing Table Rows & Columns

B3.4

Ex-Styles-Word

B3.22

Ex-Resizing Table Rows & Columns

B3.5

AutoText

B3.23

Splitting & Merging Table Cells

B3.6

Ex-AutoText

B3.24

Ex-Splitting & Merging Table Cells

B3.7

Thesaurus

B3.25

Table Borders & Shading

B3.8

Themes

B3.26

Ex-Table Borders & Shading

B3.9

Ex-Themes

B3.27

Table AutoFormat

B3.10

Graphics

B3.28

Ex-Table AutoFormat

B3.11

Ex-Graphics

B3.29

Sorting Table Data

B3.12

Text Wrapping

B3.30

Converting Text to a Table

B3.13

Ex-Text Wrapping

B3.31

Ex-Converting Text to a Table

B3.14

Drawing-Word

B3.32

Document Comments

B3.15

Quiz 3-1

B3.33

Track Changes

B3.16

Creating Tables

B3.34

Quiz 3-2

B3.17

Ex-Creating Tables

B3.35

Unit 3 End

Unit 4-Basic Spreadsheets

B4

Unit 4-Basic Spreadsheets

B4.17

Formatting Cells

B4.1

Spreadsheets Overview

B4.18

Fonts-Excel

B4.2

Getting Started-Excel

B4.19

Alignment-Excel

B4.3

Entering Data

B4.20

Ex-Fonts & Alignmentt-Excel

B4.4

Ex-Entering Data

B4.21

Number Formats

B4.5

Editing Data

B4.22

Ex-Number Formats

B4.6

Ex-Editing Data

B4.23

Format Painter-Excel

B4.7

Formulas

B4.24

Ex-Format Painter-Excel

B4.8

B4.25

Resizing Rows & Columns

B4.9

Functions

B4.26

Ex-Resizing Rows & Columns

B4.10

Exercise-Functions

B4.27

Printing-Excel

B4.11

Saving Workbooks

B4.28

Exercise-Printing-Excel

B4.12

Exercise-Saving Workbooks

B4.29

Task Pane-Excel

B4.13

Creating New Workbooks

B4.30

Office Clipboard-Excel

B4.14

Opening Workbooks

B4.31

Getting Help-Excel

B4.15

Ex-Creating & Opening Workbooks

B4.32

Quiz 4-2

B4.16

Quiz 4-1

B4.33

Unit 4 End

Unit 5-Intermediate Spreadsheets 1

B5

Unit 5-Intermediate Spreadsheets 1

B5.15

Commonly Used Functions

B5.1

Auto Fill

B5.16

Inserting Functions in Formulas

B5.2

Ex-Auto Fill

B5.17

Ex-Inserting Functions in Formulas

B5.3

Editing Data Efficiently

B5.18

Modifying Formulas & Functions

B5.4

Ex-Editing Data Efficiently

B5.19

Ex-Modifying Formulas & Functions

B5.5

Inserting & Deleting Cells

B5.20

Copying Formulas & Functions

B5.6

Ex-Inserting & Deleting Cells

B5.21

Ex-Copying Formulas & Functions

B5.7

Inserting & Deleting Rows & Columns

B5.22

Formula & Function Errors

B5.8

Ex-Inserting & Deleting Rows & Columns

B5.23

Ex-Formula & Function Errors

B5.9

Data Fitting Errors

B5.24

Organizing Worksheets

B5.10

Spelling Check

B5.25

Ex-Organizing Worksheets

B5.11

Find & Replace

B5.26

Templates

B5.12

Quiz 5-1

B5.27

Quiz 5-2

B5.13

Formulas Containing Multiple Operators

B5.28

Unit 5 End

B5.14

Ex-Formulas Containing Multiple Operators

 

 

Unit 6-Intermediate Spreadsheets 2

B6

Unit 6-Intermediate Spreadsheets 2

B6.19

Ex-Header & Footer-Excel

B6.1

Wrap Text

B6.20

Hiding Rows & Columns

B6.2

Ex-Wrap Text

B6.21

Ex-Hiding Rows & Columns

B6.3

Data Orientation

B6.22

Sorting Data

B6.4

Ex-Data Orientation

B6.23

Ex-Sorting Data

B6.5

Borders

B6.24

Print Area

B6.6

Ex-Borders

B6.25

Ex-Print Area

B6.7

Backgrounds

B6.26

Print Scaling

B6.8

Ex-Backgrounds

B6.27

Ex-Print Scaling

B6.9

Styles-Excel

B6.28

Printing Titles & Gridlines

B6.10

Ex-Styles-Excel

B6.29

Ex-Print Titles & Gridlines

B6.11

AutoFormats

B6.30

Creating Charts

B6.12

Clip Art

B6.31

Ex-Creating Charts

B6.13

Ex-Clip Art

B6.32

Modifying Charts

B6.14

Drawing-Excel

B6.33

Ex-Modifying Charts

B6.15

Quiz 6-1

B6.34

Interpreting Data & Charts

B6.16

Page Breaks-Excel

B6.35

Quiz 6-2

B6.17

Ex-Page Breaks-Excel

B6.36

Unit 6 End

B6.18

Header & Footer-Excel

 

 

Unit 7-Basic Presentations

B7

Introduction

B7.25

Fonts

B7.1

Presentation Program Overview

B7.26

Alignment

B7.2

Getting Started

B7.27

Ex-Fonts & Alignment

B7.3

Entering Text in a Slide

B7.28

Bullets & Numbering

B7.4

Ex-Entering Text in a Slide

B7.29

Ex-Bullets & Numbering

B7.5

Adding New Slides

B7.30

Format Painter

B7.6

Ex-Adding New Slides

B7.31

Ex-Format Painter

B7.7

Moving Between Slides

B7.32

Adding Notes

B7.8

Ex-Moving Between Slides

B7.33

Ex-Adding Notes

B7.9

Editing a Slide's Text

B7.34

Quiz 2

B7.10

Ex-Editing a Slide's Text

B7.35

Displaying a Slide Show

B7.11

Saving a Presentation

B7.36

Ex-Displaying a Slide Show

B7.12

Ex-Saving a Presentation-1

B7.37

Saving a Slide Show

B7.13

Ex-Saving a Presentation-2

B7.38

Print Setup

B7.14

Creating a New Presentation

B7.39

Ex-Print Setup

B7.15

Ex-Creating a New Presentation

B7.40

Print Preview

B7.16

Opening a Presentation

B7.41

Ex-Print Preview

B7.17

Ex-Opening a Presentation

B7.42

Printing

B7.18

Viewing a Presentation

B7.43

Ex-Printing

B7.19

Organizing Slides

B7.44

Task Pane

B7.20

Ex-Organizing Slides

B7.45

Office Clipboard

B7.21

Quiz 1

B7.46

Getting Help

B7.22

Formatting a Presentation

B7.47

Quiz 3

B7.23

Slide Backgrounds

B7.48

End

B7.24

Ex-Slide Backgrounds

 

 

Unit 8-Intermediate Presentations

B8

Introduction

B8.21

Ex-Adding Drawings

B8.1

Text Boxes

B8.22

Modifying Drawings

B8.2

Ex-Text Boxes

B8.23

Ex-Modifying Drawings

B8.3

Tabs

B8.24

Adding Tables

B8.4

Ex-Tabs

B8.25

Ex-Adding Tables

B8.5

Header & Footer

B8.26

Adding Charts

B8.6

Ex-Header & Footer

B8.27

Ex-Adding Charts

B8.7

AutoCorrect

B8.28

Inserting Movies and Sounds

B8.8

Spelling Check

B8.29

Quiz 2

B8.9

Ex-Spelling Check

B8.30

Changing Slide Layouts

B8.10

Find & Replace

B8.31

Ex-Changing Slide Layouts

B8.11

Ex-Find & Replace

B8.32

Slide Master

B8.12

Formatting Placeholders

B8.33

Ex-Slide Master

B8.13

Ex-Formatting Placeholders

B8.34

Templates

B8.14

Quiz 1

B8.35

Ex-Templates

B8.15

Inserting Clip Art

B8.36

Slide Transitions

B8.16

Ex-Inserting Clip Art

B8.37

Ex-Slide Transitions

B8.17

Ex-Modifying Clip Art

B8.38

AutoContent Wizard

B8.18

Inserting Pictures

B8.39

RS-Presentation Design Tips

B8.19

Ex-Inserting Pictures

B8.40

Quiz 3

B8.20

Adding Drawings

B8.41

End

 

B9.1

Test 1

B9.2

Test 2

B9.3

Test 3

 

Product Categories

  Main Menu