Key Applications - IC3 Training Solution

Key Applications



Chapter 1 - Understanding Common Elements



--Understand Personalized Toolbars And Menus

--Use the Office Assistant 

--Understand Common Elements

--Explore Task Panes

--Launch Microsoft Word 2002

--Hide and display toolbars

--Examine The Working Screen Key Applications  

Chapter 2 - Opening, Closing, And Navigating Within Documents



--Close Documents And The Application

--Open Documents --Navigate Documents

--Use The Zoom Feature

--Switch Between Open Documents

--Explore Document Views In Word Key Applications 



Chapter 3 - Exploring Various Sources Of Help And Resolving Problems



--Identify Help Resources

--Explore Help Contents And Index

--Use The Answer Wizard

 --Identify And Solve Common Problems

--Ask Help A Question

--Obtain Help Online

--Examine The Ask A Question Feature Key Applications  



Chapter 4 - Working With Documents And Text



--Select Multiple Text Blocks

--Use the Undo, Redo, and Repeat command

--Cut And Paste Text

--Entering Text In Word

--Save To A Floppy Disk

--Select And Replace Text

--Use Save As

--Examine Cut, Copy, and Paste

--Save Documents

--Delete Text

--Create Documents From Templates

--Copy And Paste Text

--Create New Documents Key Applications  



Chapter 5 - Formatting Text



--Adjust Font Size

--Apply Text Formattin

--Understand Fonts

--Change Fonts

--Apply Character Effects Key Applications



Chapter 6 - Formatting Paragraphs



--Add Shading

--Apply Borders

--Set Left And Right Indents

--Add Hanging And First Line Indents

--Align Tex

--Apply Automatic Numbering

--Set Line And Paragraph Spacing Options

--Understand Alignment

--Insert Bullets Key Applications



Chapter 7 - Using Automatic Formatting Tools



--Copy formats using the Format Painter

--Apply AutoFormats

--Design New Character Styles

--Apply Paragraph Styles

--Add Entries To AutoText

--Create New Paragraph Styles Key Applications  



Chapter 8 - Improving Document Layout



--Work With Tabs

--Insert Page Breaks

--Add Placeholders To Headers And Footers 

--Create Headers And Footers

--Understand Sections

--Create and modify page numbers

--Insert Section Breaks

--Insert Symbols

--Understand Tab Stops Key Applications 



Chapter 9 - Working With Tables



--Insert And Delete Rows And Columns

--Adjust Columns And Rows

--Insert Text Into Tables

--Merge And Split Cells

--Insert Tables

--Draw And AutoFormat Tables

--Apply Borders And Shading To Tables

--Understand Tables Key Applications 



Chapter 10 - Inserting Pictures And Drawn Objects



--Use The Drawing Canvas

--Layer, Group, and UnGroup Drawn Objects

--Understand And Use The Drawing Toolbar

--Insert ClipArt

--Format Graphics With Text

--Insert Graphics

--Adjust Graphics Key Applications 



Chapter 11 - Getting Ready To Print And Printing



--Check Spelling And Grammar

--Preview Documents

--Examine The Print Dialog Box

--Change Margins

--Experiment With Page Orientation And Size

--Find And Replace Text

--Print Documents

--Understand The Spelling Feature

--Identify And Solve Common Printing Problems Key Applications 



Chapter 12 - Getting Started With Excel



--Open Workbooks

--View Worksheets

--Examine The Excel Window

--Go To Specific Cells

--Open Excel Key Applications - 



Chapter 13 - Modifying Worksheet Data And Structure



--Insert And Delete Worksheets

--Insert And Delete Cells

--Hide And Unhide Rows And Columns

--Insert And Delete Columns And Rows

--Fill A Series

--Understand Fills

--Enter Cell Content

--Rename Worksheets

--Modify Column Width And Row Height

--Edit Cell Content Key Applications - 



Chapter 14 - Manipulating Data Using Sorts And Formulas



--Understand Formulas

--Understanding Lists

--Use references (absolute and relative)

--Understand Cell References

--Copy And Edit Formulas

--Use Cell References In Formulas

--Using Mixed Addresses

--Enter A Formula In The Formula Bar

--Perform single and multi-level sorts Key Applications 



Chapter 15 - Using Functions 



--Use AutoSum And AutoCalculate

--Understand Functions

--Calculate Averages Using The Insert Function

--Calculate Sums Using The Insert Function

--Create Minimum Functions

--Understand The Importance Of Checking Data

--Create Maximum Functions

--Use Multiple Functions Within Formulas

--Build Functions Key Applications - 



Chapter 16 - Formatting Worksheets 



--Apply Cell Borders

--Format Numbers

--Apply Shading

--Rotate Text

--Understand Date And Number Formatting

--Modify Text Appearance

--Wrap Text Within Cells

--Change Text Alignment

--Use The Format Painter Key Applications 



Chapter 17 - Using Advanced Formatting Features



--Apply AutoFormats



--Understand AutoFormatting

--Define Styles

--Apply And Remove Styles Key Applications 



Chapter 18 - Adding Charts And Pictures



--Change Chart Types

--Elevate, Rotate, Resize, And Position Charts 

--Insert Graphics

--Use The Chart Wizard

--Edit And Resize Chart Titles

--Move And Delete Graphics

--Examine Charts

--Create And Modify Lines And Graphics Key Applications 



Chapter 19 - Finalizing And Printing Worksheets 



--Print Worksheets And Workbooks

--Create Headers And Footers In Worksheets

--Print Selections

--Change Page Orientation And Scaling

--Select Print Options

--Set, Print, And Clear Print Areas

--Understand Printing

--Insert Page BreaksIC3 Overview

--Benefits of IC3 Certification

--IC3 Certification Promotional Ad

--IC3 Certification Promo

--IC3 Certification Roadmap

Contact Hours: 24