Tech Support
Contact Us
PCIC3B-2003-Key Applications

111 Lessons, 63 Exercises, 13 Quizzes

 

3 Reading Supplements

Estimated Duration: 34 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 1-Basic Word Processing

B1

Unit 1-Basic Word Processing

B1.20

Ex-Character Case & Utility Functions

B1.1

Getting Started

B1.21

Quiz 2

B1.2

Entering Text

B1.22

Find & Replace

B1.3

Ex-Entering Text

B1.23

Ex-Find & Replace

B1.4

Editing Text-Part 1

B1.24

Spelling & Grammar

B1.5

Editing Text-Part 2

B1.25

Ex-Spelling & Grammar

B1.6

Ex-Editing Text

B1.26

Margins

B1.7

Saving Documents

B1.27

Ex-Margins

B1.8

Ex-Saving Documents

B1.28

Printing

B1.9

Creating a New Document

B1.29

Ex-Printing

B1.10

Opening Documents

B1.30

Time Saving Tips-Part 1

B1.11

Ex-Creating & Opening Documents

B1.31

Time Saving Tips-Part 2

B1.12

Viewing Documents

B1.32

Ex-Time Saving Tips

B1.13

Quiz 1

B1.33

Task Pane

B1.14

Formatting Text

B1.34

Saving Files to a Floppy Diskette

B1.15

Fonts

B1.35

RS-Common File Problems

B1.16

Alignment

B1.36

RS-Common Print Problems

B1.17

Ex-Fonts & Alignment

B1.37

RS-Getting Help

B1.18

Character Case

B1.38

Quiz 3

B1.19

Utility Functions

B1.39

Unit 1-End

Unit 2-Intermediate Word Processing 1

B2

Unit 2-Intermediate Word Processing 1

B2.15

Footnotes

B2.1

Character & Line Spacing

B2.16

Ex-Footnotes

B2.2

Ex-Character & Line Spacing

B2.17

Hyperlinks

B2.3

Indenting Paragraphs

B2.18

Pictures

B2.4

Ex-Indenting Paragraphs

B2.19

Ex-Pictures

B2.5

Bullets & Numbering

B2.20

Displaying & Hiding Toolbars

B2.6

Ex-Bullets & Numbering

B2.21

Inserting Symbols

B2.7

Tabs

B2.22

Ex-Inserting Symbols

B2.8

Ex-Tabs

B2.23

Section Breaks

B2.9

Quiz 1

B2.24

Ex-Section Breaks

B2.10

Page Breaks

B2.25

Templates

B2.11

Ex-Page Breaks

B2.26

Ex-Templates

B2.12

Header & Footer

B2.27

Page Orientation & Paper Size

B2.13

Page Numbers

B2.28

Quiz 2

B2.14

Ex-Header, Footer & Page Numbers

B2.29

Unit 2-End

Unit 3-Intermediate Word Processing 2

B3

Unit 3-Intermediate Word Processing 2

B3.15

Ex-Creating Tables

B3.1

Text Borders & Shading

B3.16

Selecting Table Rows & Columns

B3.2

Ex-Text Borders & Shading

B3.17

Inserting & Deleting Rows & Columns

B3.3

Styles

B3.18

Ex-Inserting & Deleting Rows & Columns

B3.4

Ex-Styles

B3.19

Resizing Rows & Columns

B3.5

AutoText

B3.20

Ex-Resizing Rows & Columns

B3.6

Ex-AutoText

B3.21

Splitting & Merging Cells

B3.7

Themes

B3.22

Ex-Splitting & Merging Cells

B3.8

Ex-Themes

B3.23

Table Borders & Shading

B3.9

Graphics

B3.24

Ex-Table Borders & Shading

B3.10

Text Wrapping

B3.25

Table AutoFormat

B3.11

Ex-Graphics & Text Wrapping

B.26

Ex-Formatting Tables

B3.12

Drawing

B3.27

Quiz 2 

B3.13

Quiz 1

B3.28

Unit 3-End

B3.14

Creating Tables

 

 

Unit 4-Basic Spreadsheets

B4

Unit 4-Basic Spreadsheets

B4.16

Formatting Cells

B4.1

Spreadsheets Overview

B4.17

Fonts

B4.2

Getting Started

B4.18

Alignment

B4.3

Entering Data

B4.19

Ex-Fonts & Alignment

B4.4

Ex-Entering Data

B4.20

Number Formats

B4.5

Editing Data

B4.21

Ex-Number Formats

B4.6

Ex-Editing Data

B4.22

Format Painter

B4.7

Formulas

B4.23

Ex-Format Painter

B4.8

Functions

B4.24

Resizing Rows & Columns

B4.9

Ex-Formulas & Functions

B4.25

Ex-Resizing Rows & Columns

B4.10

Saving Workbooks

B4.26

Printing

B4.11

Ex-Saving Workbooks

B4.27

Ex-Printing

B4.12

Creating New Workbooks

B4.28

Task Pane

B4.13

Opening Workbooks

B4.29

Getting Help

B4.14

Ex-Creating & Opening Workbooks

B4.30

Quiz 2

B4.15

Quiz 1

B4.31

Unit 4-End

Unit 5-Intermediate Spreadsheets 1

B5

Unit 5-Intermediate Spreadsheets 1

B5.13

Commonly Used Functions

B5.1

Auto Fill

B5.14

Inserting Functions in Formulas

B5.2

Ex-Auto Fill

B5.15

Ex-Inserting Functions in Formulas

B5.3

Editing Data Efficiently

B5.16

Modifying Formulas & Functions

B5.4

Ex-Editing Data Efficiently

B5.17

Ex-Modifying Formulas & Functions

B5.5

Inserting & Deleting Cells

B5.18

Copying Formulas & Functions

B5.6

Ex-Inserting & Deleting Cells

B5.19

Ex-Copying Formulas & Functions

B5.7

Inserting & Deleting Rows & Columns

B5.20

Formula & Function Errors

B5.8

Ex-Inserting & Deleting Rows & Columns

B5.21

Ex-Formula & Function Errors

B5.9

Data Fitting Errors

B5.22

Organizing Worksheets

B5.10

Quiz 1

B5.23

Ex-Organizing Worksheets

B5.11

Formulas Containing Multiple Operators

B5.24

Quiz 2

B5.12

Ex-Formulas Containing Multiple Operators

B5.25

Unit 5-End

Unit 6-Intermediate Spreadsheets 2

B6

Unit 6-Intermediate Spreadsheets 2

B6.16

Header & Footer

B6.1

Wrap Text

B6.17

Ex-Header & Footer

B6.2

Data Orientation

B6.18

Hiding Rows & Columns

B6.3

Ex-Wrap Text & Data Orientation

B6.19

Ex-Hiding Rows & Columns

B6.4

Borders

B6.20

Sorting Data

B6.5

Backgrounds

B6.21

Ex-Sorting Data

B6.6

Ex-Borders & Backgrounds

B6.22

Print Area

B6.7

Styles

B6.23

Print Scaling

B6.8

Ex-Styles

B6.24

Printing Titles & Gridlines

B6.9

AutoFormats

B6.25

Ex-Print Settings

B6.10

Clip Art

B6.26

Creating Charts

B6.11

Ex-Clip Art

B6.27

Modifying Charts

B6.12

Drawing

B6.28

Ex-Creating & Modifying Charts

B6.13

Quiz 1

B6.29

Interpreting Data & Charts

B6.14

Page Breaks

B6.30

Quiz 2

B6.15

Ex-Page Breaks

B6.31

Unit 6-End

 

Product Categories

  Main Menu