Course
Highlights
- Prepare professional charts and share data with coworkers, customers,
and business partners with Excel.
- Create and share documents through the new, easy-to-use interface
of Word.
- Create presentations with pictures, shapes, animation, and advanced
delivery options in PowerPoint.
- Follow basic and advanced functions of e-mail, planning/scheduling
features, and customizing the interface in Outlook.
- Track and report information with ease, modify pre-built applications,
and share database information with Access.
About This Course
This Microsoft Office 2003 contains customized instruction on the entire
Microsoft Office suite including Excel, Word, PowerPoint, Outlook and
Access. The course topics appeal to all Office users – beginner
through advanced. With multiple levels of instruction, you will walk through
(at your own pace) performing many time-saving tasks in each of these
programs.
With comprehensive lessons and engaging quizzes, new users will be guided
through the fundamentals of the Office interface, while experienced users
will be brought up to speed on the new navigation and functionality of
this popular software.
In Excel, you will learn everything from creating professional-looking
spreadsheets to sharing data and managing your spreadsheets more effectively.
And, you will learn about harnessing the power of Excel with lessons devoted
to cell references, auditing and advanced functions.
Through quick tips and detailed instruction in Word, you will learn how
to capture the strength of this word processing program that lies beyond
typing simple letters and memos. Use this course to go beyond creating
simple documents to working with Mail Merge, tables and master documents.
In PowerPoint, you will learn how to maximize the built-in slide show
features to develop engaging and interactive presentations through topics
that include working with tables, graphics and slide animation.
With a simulated email environment in Outlook, you will learn how to
maximize your productivity using built-in features like maintaining calendars,
tasks, appointments and contacts.
Microsoft Access 2003 is a powerful database solution used to store and
analyze important information such as customer databases, inventory tracking
and enterprise level applications recording hundreds of records. In Access,
you will learn how to use this program to collect, organize and manipulate
data.
There are over 250 lessons in this Office course – all designed
to increase your productivity.
Complete Course Outline
Word 2003: Beginner Level
1.0 Getting Started
1.1 Starting Word 2003
1.2 Touring the Word Window
1.3 Help in Word 2003
2.0 Creating New Documents
2.1 Starting a New Document
2.2 Entering Text, Delete Keys and Capital Letters
2.3 Saving Your Work
2.4 Printing & Closing a Document
2.5 Using a Template
2.6 Using a Wizard
2.7 Exiting Out of Word
3.0 Revising Your Documents
3.1 Opening Documents
3.2 Navigating Documents
3.3 Basic Editing Skills, Click and Type
3.4 Smart Tags
3.5 Adding a Date
3.6 Adding an Envelope
3.7 Multiple Page Documents
4.0 Shortcuts
4.1 Shortcut Menus/Customizing Toolbars
4.2 Keyboard Shortcuts
5.0 Essential Skills
5.1 Selecting Text
5.2 Copying & Moving Text
5.3 Clipboard Task Pane
5.4 Undo, Redo & Repeat
5.5 AutoCorrect
5.6 AutoComplete
6.0 Formatting Text & Paragraphs
6.1 Working with Fonts
6.2 Symbols & Special Characters
6.3 Document Layout and Page Setup
7.0 Proofreading & Printing Documents
7.1 Spelling & Grammar
7.2 Thesaurus & Word Count
7.3 Previewing & Printing a Document
Word 2003: Intermediate Level
1.0 Managing Documents
1.1 Document Views
1.2 Working with Multiple Documents
1.3 File & Folder Management
1.4 Search Task Pane
2.0 Additional Editing Tools
2.1 Find & Replace
2.2 AutoText
2.3 Format Painter
3.0 Page Layout
3.1 Margins & Page Setup
3.2 Page Breaks
4.0 Customizing Word
4.1 Menus & Toolbars
4.2 Changing Defaults
4.3 User Options
5.0 Understanding Formatting in Word
5.1 Formatting Choices
5.2 Reveal Formatting Task Pane
6.0 Paragraph Formatting
6.1 Tabs
6.2 Indents
6.3 Bullets & Numbering
6.4 Line Breaks
6.5 Spacing Before & After
6.6 Styles & Formatting
6.7 Sorting Text
6.8 Borders & Shading
7.0 Document Formatting
7.1 Numbering Pages
7.2 Headers & Footers
8.0 Mail Merge Basics
8.1 Understanding Mail Merge
8.2 Form Letters
8.3 Labels
9.0 Introduction to Graphics
9.1 Inserting Clip Art
9.2 Drawing & Modifying Shapes
10.0 Organizing Content
10.1 Use automated tools for document navigation
Word 2003: Advanced Level
1.0 Tables
1.1 Creating Tables
1.2 Navigating in a Table
1.3 Modifying Tables
1.4 Formatting Tables
1.5 Perform calculations in Tables
2.0 Formatting with Styles & Themes
2.1 Applying Styles
2.2 Styles & Formatting Task Pane
2.3 Creating & Modifying Styles
2.4 Applying a Theme
3.0 Document Templates
3.1 Personalizing Word’s Templates
3.2 Automating & Sharing a Template
3.3 Create and Modify diagrams and charts using data from other sources
4.0 Section Formatting
4.1 Formatting a Section
4.2 Working with Columns
5.0 Long or Complex Documents
5.1 Bookmarks & Cross-references
5.2 Document Map
5.3 Footnotes
5.4 Table of Contents & Index
5.5 Outlines
5.6 Master Documents
6.0 Creating & Using Macros
6.1 Creating & Running Macros
6.2 Editing Macros
6.3 Automatic Macros
6.4 XML
7.0 Collaborating
7.1 Modify track changes options
7.2 Publish and edit Web documents
7.3 Manage document versions
7.4 Protect and restrict forms and documents
7.5 Attach digital signatures to documents
7.6 Customize document properties
Excel 2003: Beginner Level
1.0 The Excel Screen
1.1 Overview � Loading Microsoft Excel 2003
1.2 Screen Elements � Menu and Button Bars
1.3 Screen Elements � Workbook and Spreadsheet Properties
2 .0 Creating Data and Content
2.1 Enter and edit cell content
2.2 Navigate to specific cell content
2.3 Locate, select and insert supporting information
2.4 Insert, position and size graphics
2.5 Saving, closing and opening files
3.0 Analyzing Data
3.1 Filter lists using AutoFilter
3.2 Sort lists
3.3 Insert and modify formulas
3.4 Create, modify, and position diagrams and charts based on worksheet
data
4.0 Formatting Data and Content
4.1 Apply and modify cell formats
4.2 Apply and modify cell styles
4.3 Modify row and column formats
4.4 Format worksheets using AutoFormat
Excel 2003: Intermediate Level
1.0 Collaborating
1.1 Insert, view and edit comments
2.0 Managing Worksheets
2.1 Create new workbooks from templates
2.2 Insert, delete and move cells
2.3 Create and modify hyperlinks
2.4 Organize worksheets
2.5 Preview data in other views
2.6 Customize window layout
2.7 Setup pages for printing
2.8 Print data
2.9 Organize workbooks using file folders
2.10 Save data in appropriate formats for different uses
3.0 Organizing and Analyzing Data
3.1 Use subtotals
3.2 Define and apply advanced filters
3.3 Group and outline data
3.4 Use data validation
3.5 Create and modify list ranges
3.6 Using statistical, date and time, financial, and logical functions
3.7 Add, show, close, edit, merge and summarize scenarios
3.8 Perform data analysis using automated tools
3.9 Create PivotTable and PivotChart reports
3.10 Use Lookup and Reference functions
3.11 Use Database functions
3.12 Trace formula precedents, dependents and errors
3.13 Locate invalid data and formulas
3.14 Watch and evaluate formulas
3.15 Define, modify and use named ranges
3.16 Structure workbooks using XML
Excel 2003: Advanced Level
1.0 Formatting Data and Content
1.1 Create and modify custom data formats
1.2 Use conditional formatting
1.3 Format and resize graphics
1.4 Format charts and diagrams
2.0 Collaborating
2.1 Protect cells, worksheets, and workbooks
2.2 Apply workbook security settings
2.3 Share workbooks
2.4 Merge workbooks
3.0 Managing Data and Workbooks
3.1 Import data to Excel
3.2 Export data from Excel
3.3 Publish and edit Web Worksheets and workbooks
3.4 Create and edit templates
3.5 Consolidate data
3.6 Define and modify workbook properties
4.0 Customizing Excel
4.1 Customize toolbars and menus
PowerPoint 2003: Beginner Level
1.0 Getting started
1.1 What is PowerPoint?
1.2 Starting PowerPoint
1.3 Touring the PowerPoint Window
2.0 Creating a New Presentation
2.1 New Presentation Task Pane
2.2 Creating a Blank Presentation, New Slides, and Slide Types
2.3 Saving and Closing
2.4 Opening an existing presentation
2.5 Creating a presentation using Design Templates
2.6 Creating a presentation using Auto Content Wizard
3.0 Revising Presentations
3.1 Navigating in a presentation
4.0 Getting Help
4.1 Ask a Question Box
4.2 Office Assistant
4.3 PowerPoint Help Window
5.0 Outline View
5.1 Entering Text in an Outline
5.2 Formatting Text
6.0 Inserting and Editing Text Based Content
6.1 Speaker Notes
7.0 Inserting Tables and Diagrams
7.1 Inserting Tables
7.2 Inserting Diagrams
8.0 Inserting Pictures, Shapes and WordArt
8.1 Inserting Pictures
8.2 Inserting Shapes
8.3 Inserting WordArt
9.0 Previewing a Presentation
9.1 Previewing a Presentation
PowerPoint 2003: Intermediate Level
1.0 Formatting Text Based Content
1.1 Formatting Text Based Content
2.0 Formatting Pictures, Shapes and Graphics
2.1 Clip Art, Photographs, and Animations
3.0 Formatting Slides
3.1 Color, Texture, and Templates
4.0 Applying Animation Schemes
4.1 Applying Animation Schemes
5.0 Applying Slide Transitions
5.1 Applying Slide Transitions
6.0 Working with Slide Masters
6.1 Slide Masters
7.0 Tracking, Accepting and Rejecting Changes
7.1 Tracking, Accepting and Rejecting Changes
8.0 Adding, Editing and Deleting Comments
8.1 Adding, Editing and Deleting Comments
9.0 Comparing and Merging Presentations
9.1 Comparing and Merging Presentations
PowerPoint 2003: Advanced Level
1.0 Organizing a Presentation
1.1 Setting up the slide show for delivery
1.2 Rehearsing Timings
2.0 Delivering a Presentation
2.1 Delivering a Presentation
3.0 Preparing Presentations for Remote Delivery
3.1 Preparing Presentations for Remote Delivery
4.0 Saving and Publishing Presentations
4.1 Copying to a CD
5.0 Printing Slides, Handouts and Speaker Notes
5.1 Printing Slides, Handouts and Speaker Notes
6.0 Exporting a Presentation to Another Microsoft Program
6.1 Exporting a Presentation to Another Microsoft Program
Outlook 2003: Beginner Level
1.0 What’s New for 2003
1.1 A tour of Outlook 2003
1.2 Editing the Outlook 2003 Toolbars, Task Panes and Mail Views
2.0 Introduction to MS Outlook
2.1 Creating a message
2.2 Replying to and Forwarding messages
2.3 Deleting messages and emptying the Deleted Items folder
2.4 Using Word as the message editor
3.0 Messaging
3.1 Organizing
3.2 Attaching files
3.3 Create and modify a personal signature
3.4 Modify e-mail message settings and delivery options
3.5 Create and edit contacts
3.6 Creating Personal Folders
3.7 Personal Distribution Lists
3.8 Accept, decline, and delegate tasks
Outlook 2003: Intermediate Level
1.0 Scheduling
1.1 Create and modify appointments, meetings, and events
1.2 Update, cancel, and respond to meeting requests
1.3 Customize Calendar settings
1.4 Create, modify, and assign tasks
Outlook 2003: Advanced Level
1.0 Organizing
1.1 Create and modify distribution lists
1.2 Link contacts to other items
1.3 Create and modify notes
1.4 Organize items
1.5 Search for items
1.6 Save items in different file formats
1.7 Assign items to categories
1.8 Preview and print items
Access 2003: Beginner Level
1.0 Introduction
1.1 Starting Access
1.2 The Access Window, Menu Bar, Tool Bars and Task Pane
1.3 Help in Access
1.4 Creating a Database � Fields, Properties, and
Datasheet View
1.5 Copying Databases
2.0 Working with an Existing Database
2.1 Viewing & Navigating Table Data
2.2 Widening Datasheet Columns and Editing Table Data
2.3 Adding Records to a Table
2.4 Selecting & Deleting Records
2.5 Find & Replace
2.6 Modifying the Appearance of a Datasheet
2.7 Spell-Check & Auto-correct
3.0 Form Basics
3.1 Using a Form Wizard and Moving from Record to Record
3.2 Finding Data
3.3 Sorting Data
3.4 Filtering Data
3.5 AutoForms
4.0 Report Basics
4.1 AutoReports & the Report Wizard
4.2 Zooming In & Out
4.3 Moving from Page to Page
4.4 Viewing Multiple Pages
4.5 Printing
Access 2003: Intermediate Level
1.0 Planning & Designing a Database
1.1 Evaluating Inputs & Outputs
1.2 Normalization
1.3 Creating a Database Using a Wizard
1.4 Creating a Database from Scratch
2.0 Building & Modifying Tables
2.1 Creating Tables Using a Wizard
2.2 Creating Tables without the Use of a Wizard
2.3 Setting Primary Keys
2.4 Field Properties
2.5 Input Masks
2.6 The Lookup Wizard
2.7 Indexes
3.0 Working with Relationships
3.1 Introduction to Relationships
3.2 Types of Relationships
3.3 Referential Integrity
3.4 Indexes & Relationships
3.5 Printing Relationships
Access 2003: Advanced Level
1.0 Designing Simple Queries
1.1 Selecting Fields
1.2 Ordering the Query Result & Refining Queries with Criteria
1.3 Updatability of Query Results
1.4 Queries Based on Multiple Tables
2.0 Building & Modifying Forms
2.1 Adding Controls
2.2 Selecting Controls
2.3 Moving, Sizing, & Deleting Controls
2.4 Aligning Controls
2.5 Changing Control Properties
2.6 Changing the Tab Order Controls
2.7 Form Properties
2.8 Working with Combo Boxes & List Boxes
3.0 Building & Modifying Reports
3.1 Understanding Report Bands
3.2 Working with Controls
3.3 Creating Groups & Total Reports
3.4 Working with Report Properties
3.5 Modifying Selection Criteria
4.0 Managing Databases
4.1 Identify Object Dependencies
4.2 View Objects and Object Data in Other Views
4.3 Import Data to Access
4.4 Export data from Access
4.5 Create and Modify Calculated Fields and Aggregate Functions
4.6 Create a Data Access Page
4.7 Back up a database
4.8 Compact and repair databases
| 
