Word 2003


Word Advanced 2003


Excel 2003


Excel Advanced 2003


PowerPoint 2003


Access 2003


Outlook 2003

Introducing Word 2003
Screen Components
Navigation Tools
Creating Documents
Opening, Saving and Closing
Task Panes
Smart Tags
Moving and Copying Text
Basic Text Formatting
Automated Formatting
Formatting Paragraphs
Formatting with Tabs
Working with Columns
Page Design
Working with Templates
Template and Design Gallery
Working with Styles
Outlining Documents
Macros
Clip Art
Borders and WordArt
Drawing Tools
Watermarks
Proofing Tools
AutoCorrect
Find and Replace
Printing Documents
Envelopes and Labels
File Management
Creating Web Pages
Documents and Email
Working with Tables
Formatting Tables
Headers and Footers

• Identify the Function of Word
• Start Word
• Work with Toolbars
• Distinguish Page View Buttons
• Identify the Title Bar
• Use and Tailor Menus
• Work with Toolbars
• Display Screen Tips
• Define Status Bar Components
• Distinguish Page View Buttons
• Scroll Bar through a Document
• Use the Browse Object Button
• Work with the Go To Command
• Move Around using Shortcut Keys
• Create a New Document
• Enter Text using Click and Type
• Insert a Date and Time field
• Work with the Show/Hide Feature
• Use Insert and Overtype modes
• Select and De-select and Delete Text
• Undo and Repeat Actions
• Define Open Box Components
• Open an Existing Document and Retrieve a Recently used Document
• Save a File with the Save and Save As commands
• Close a Document and using the Close All command
• Exiting Word
• Use Task Panes
• Use the File New Task Pane
• Format text with the Styles and Formatting Task Pane
• Copy and Cut to the Clipboard Task Pane
• Find items with the Search Task Pane
• Understand Search vs. Find
• Activate Smart Tags
• Context-Sensitive and Paste Options Smart Tags
• Implement Autocorrect Options Smart Tags
• Turn off Smart Tags
• Differentiate Cut and Copy
• Move and Copy Text using the Toolbar and Shortcut Menu
• Use the Paste Special Feature
• Collect and Paste Multiple Items
• Arrange Open Windows
• Drag and Drop Text
• Apply Bold, Underline and Italics
• Align Text
• Use the Highlight Feature
• Modify Font Type and Size
• Change Case
• Work with the Font Box
• Use the Format Painter Feature
• Create Bullet and Numbered Lists
• Insert Symbols
• Apply a Theme to a Document
• Work with the Style Gallery
• AutoFormat a Document
• Apply Styles to Text
• Indent Paragraphs using Ruler
• Modify Indents using Toolbar
• Use Shortcut Keys to Indent Text
• Work with the Paragraph Box
• Copy Paragraph Formatting
• Format with Tabs
• Use the Centre Tab
• Use the Right Tab
• Use the Decimal Tab
• Use the Tabs Box
• Apply Dot Leader Tabs
• Move and Clear a Tab
• Use the Show/Hide Command
• Create Columns using the Toolbar
• Modify Column Structure
• Work with Columns in Print Layout
• Identify a Section Break
• Fully Justify Columns
• Use the Columns Box
• Adjust Page Margins using the Ruler
• Modify Margins using Page Setup
• Identify a Soft Page Break
• Add a Hard Page Break
• Change Line Spacing
• Identify the Use of Templates
• Open an Existing Template
• Create a New Template
• Use the Template Wizard
• View a Template at Full Screen
• Use the Template Gallery
• Access Design Gallery Live
• Download Templates from the web
• Understand Styles
• Create Styles
• Apply A Custom Style
• Edit A Style
• Identify the Use of an Outline
• Change to Outline View
• Work with Outlining Toolbar
• Enter a New Outline
• Promote & Demote Outline Levels
• Show & Hide Formatting
• Record Macros
• Run Macros
• Edit a Macro
• Work with the Clip Art Gallery
• Search for Clip Art Pictures
• Use the Pop-up Menu
• Insert Clip Art using the Menu
• Drag & Drop Clip Art into a File
• Size and Move Objects
• Use the Wrap Text Options
• Apply Fill Styles to a Picture
• Insert a Border around a Picture
• Add Drop Capitals to Text
• Activate the Drawing Toolbar
• Change Text Effects using WordArt
• Identify Drawing Toolbar Buttons
• Add a Straight Line
• Generate Rectangles and Squares
• Create Ovals, Circles and Shapes
• Apply a Shadow Effect
• Flip and Rotate an Object
• Resize and Move an Object
• Select and Group Drawing Objects
• Delete a Drawing Object
• Create Watermarks
• Position a Watermark
• Soften a Watermark
• View a Watermark
• Identify Spelling & Grammar Errors
• Amend Spelling using Shortcut Menu
• Hide Spelling and Grammar Errors
• Check the Spelling of a Document
• Work with the Grammar Checker
• Use the Thesaurus
• Enter and Correct Text Automatically
• Work with AutoCorrect Options
• Add Items to the AutoCorrect List
• Create an AutoText Entry
• Expand AutoText Entries
• Activate the Find and Replace Box
• Search for Words in a Document
• Display and Hide More Options
• Use the Find Next button
• Replace Single Occurrences of Text
• Use the Replace All Button
• Modify Zoom Settings
• Print Preview a Page and Multiple Pages
• Change to Full Screen View
• Print a Document and working with Print Options
• Select a Different Printer
• Using the Envelopes & Labels Feature
• Add an Envelope Delivery Address
• Include a Return Address
• Work with the Envelope Options
• Print an Envelope
• Create a Label
• Locate Files using Filenames
• Display & Change File Properties
• Delete Files
• Add Files to the Favorites Folder
• Use Advanced Search Criteria
• Sort Files and Folders
• Define the Internet
• Identify Internet Services
• Preview a Document in a Browser
• Publish Documents in Web Format
• Open Documents in a Browser
• Edit a Web Page
• Send Documents to E-Mail Recipients
• Enter E-Mail Header Details
• Send an E-Mail Message
• Open a Sent Message
• Create a Table
• Use the Tables Toolbar
• Enter Text into a Table
• Move between Cells
• Apply Table Selection Techniques
• Use the AutoFit Feature
• Change Column Widths
• Add and Remove Rows and Columns
• Merge Cells
• Change Text Direction in a Table
• Align Table Text
• Align an Entire Table
• AutoFormat a Table
• Add Bold and Italics to Table Text
• Modify Font Type and Size of Text
• Add Cell Borders and Fill Styles
• Identify Headers and Footers
• Add a Header
• Work with Header & Footer Toolbar
• Insert AutoText
• SwITC Learningh to the Footer Section
• Number Pages
• Suppress Headers and Footers
• View Headers and Footer

Sorting Paragraphs and Lists
Headers and Footers
Index and Table of Contents
Footnotes and Endnotes
OLE, Bookmarks and Hyperlinks
Creating Forms
Saving Forms as Templates
Creating and Modifying Tables
Formulas in Tables
Tables and Charts
Formatting Tables
Group Editing
File Management
Mail Merge
Advanced Mail Merge
Creating Web Pages
Documents and Email

• Space Paragraphs
• Sort Paragraphs
• Sort Tabulated Lists
• Sort a Table
• Identify Headers and Footers
• Add a Header
• Work with Header & Footer Toolbar
• Insert AutoText
• SwITC Learningh to the Footer Section
• Number Pages
• Suppress Headers and Footers
• View Headers and Footers
• Build a Table of Contents
• Navigate a File using Table of Contents
• Delete a Table of Contents
• Update the Table of Contents
• Build Indexes and Mark Index Entries
• Delete an Index
• Create Footnotes and Endnotes
• Read Footnotes and Endnotes
• Delete Footnotes and Endnotes
• Converting Footnotes
• Create and Go To Bookmarks
• Create Hyperlinks to Web Sites
• Create Hyperlinks to other locations inside the document
• Embed and Link an Excel workbook inside a Word document
• Create Form Fields
• Add Text Form Fields
• Set Form Field Options
• Set Drop-Down Form Fields
• Add Default Text to a Form Field
• Create Check Box Form Fields
• Hide and Show Form Field Shading
• Protect the Form
• Create and Go To Bookmarks
• Create Hyperlinks to Web Sites
• Create Hyperlinks to other locations inside the document
• Embed and Link an Excel workbook inside a Word document
• Insert Tables
• Use Tables and Borders Tools
• Use the Draw Table Button
• Navigate Tables
• Enter Table Data
• Select Cell Contents
• AutoFit Table Contents
• Insert Rows and Columns
• Delete Rows and Columns
• .Merging Table Cells
• Use Formulas in Tables
• Sum a Column
• Use AutoSum
• Display Field Codes
• Repeat a Value in a Cell
• Enter Formulas
• Recalculate Formulas
• Use Tables and Charts
• Embed Objects
• Re-size Charts
• Move Charts
• Delete Charts
• Change Text Direction in a Table
• Align Table Text
• Align an Entire Table
• AutoFormat a Table
• Add Bold and Italics to Table Text
• Modify Font Type and Size of Text
• Add Cell Borders and Fill Styles
• Group Editing
• The Reviewing Toolbar
• Insert Comments
• Read a Comment
• Edit Comments
• Navigate to Comments
• Track Document Changes
• Accept or Reject Revisions
• Locate Files using Filenames
• Display & Change File Properties
• Delete Files
• Add Files to the Favorites Folder
• Use Advanced Search Criteria
• Sort Files and Folders
• Mail Merge
• Create a Form Letter
• Create a Data Source File
• Create Merge Records
• Select Mail Merge Recipients
• Insert Merge Fields
• View Merged Data
• Merge Files
• Mail Merge to Labels
• Select Mailing Labels
• Select Alternate Data Sources
• Manually Insert Merge Fields
• Update Labels
• Preview Labels
• Specify a Range of Records
• Use Smart Tags
• Print Labels
• Define the Internet
• Identify Internet Services
• Preview a Document in a Browser
• Publish Documents in Web Format
• Open Documents in a Browser
• Edit a Web Page
• Send Documents to E-Mail Recipients
• Enter E-Mail Header Details
• Send an E-Mail Message
• Open a Sent Message

Introducing Excel 2003
Moving, Copying and Saving
Formulas, Functions and Ranges
Formatting Techniques
Working with Large Spreadsheets
Proofing and Printing Spreadsheets
Charting
Web Tools

• Starting Excel and Office Assistant
• Screen Components
• Navigating Workbooks
• Creating Worksheets
• Moving and Copying Cells
• Opening, Saving and Closing
• Formulas and Functions
• Working with Ranges
• Relative & Absolute References
• Paste Functions
• Toolbar Formatting
• Menu Bar Formatting
• Additional Formatting Features
• 3-D Workbooks
• Previewing and Printing
• Splitting, Freezing and Hiding
• Proofing Tools
• Page Breaks and Previewing
• Page Setup Options
• Print Areas and Printing
• Creating and Modifying Charts
• Working with Chart Objects
• Creating a Web Page
• Worksheets and Email

Macros and Custom Toolbars
Named Ranges and Lookup Functions
Working with Data
Consolidation and Linking
Group Editing
Audit, Scenarios, Views and Reports
Data Filters, Goals and Pivot Tables

• Working with Macros
• Custom Toolbars
• Working with Named Ranges
• Lookup Functions
• Importing Data
• Conditional Formatting
• Data Validation
• Outlining
• Creating a Workspace
• Consolidating Data
• Linking Workbooks
• Sharing and Protecting
• Working with Comments
• Tracking Changes
• Auditing Tools
• The Scenario Manager
• Custom Views
• The Report Manager
• Data Forms
• Filtering Data
• Sorting and Sub-totals
• Goal Seeker and Goal Solver
• Pivot Tables
• Pivot Tables on the Web

Introducing PowerPoint 2003
Creating, Saving & Closing Files
Slide Design
Templates and Drawing Tools
Presentation Masters
Slide Shows and Printing

Objectives:

• Starting PowerPoint
• Screen Components
• View Buttons
• Creating New Presentations
• Opening, Saving and Closing
• Using Existing Presentations
• Slide View
• Outline View
• Arranging Slides
• Slide Layout
• Templates
• Drawing Tools
• Creating Charts
• Enhancing Charts
• Tables
• Working with Slide Shows
• Spell Checking and Printing
• Publishing Web Presentations
• Emailing Presentations

Introducing Access 2003
Working with Tables
Working with Forms
Working with Queries
Working with Reports

• Access Screen Components
• Opening Database Objects
• Data Entry and Navigation
• Creating Tables
• Modifying the Table Design
• Working with Records
• Importing Data
• Table Relationships
• Creating and Using Forms
• Modifying Forms
• Formatting Forms
• Creating and Running Queries
• Joining Tables
• Action and Crosstab Queries
• Creating a Report
• Previewing and Printing
• Report Modification

Introducing Outlook 2003
Sending and Receiving Mail
Items, Folders and Documents
The Calendar
Contacts List and Customising
Task List, Journal and Notes

• Starting Outlook
• Screen Components
• Outlook Folders
• Printing in Outlook
• Creating and Sending Messages
• Working with Existing Messages
• Message Handling Tools
• Signatures
• Stationery and Templates
• Customising Address Books
• Viewing Items
• Finding Items
• Working with Folders
• Archiving Folders
• Using Documents
• Entering Appointments
• Viewing and Arranging Items
• Planning Meetings
• Adding Events
• Saving as Web Page
• Adding Contacts
• Using the Contacts List
• Additional Contacts Tools
• Customising Outlook
• Creating Tasks
• Working with Existing Tasks
• Delegating Tasks and AutoCreate
• The Journal
• Notes