AtHand Logo

 

COURSE LOGIN
Username:
Password:   
FEATURED CUSTOMERS
FEATURED SOLUTION
AtHand Learning System
Total E-Learning Solution


Built-In LMS
Learning Management
Testing Solutions that address the issues you face now.

Microsoft Office 2003 Essentials

Print Version

These complete courses enable you to master everything from the very basic office functions to the most advanced features provided with Microsoft® Office 2003 including Access, Excel, Outlook, PowerPoint, and Word – the industry standard business applications. Our training ensures that your productivity exceeds the levels necessary to excel in today’s business world. These courses have been instructionally designed to map to the MOS requirements for Basic MOS and Expert MOS Certification.

This MOS set includes:
Access 2003 MOS (3 levels)
Excel 2003 MOS (5 levels)
Outlook 2003 MOS (3 levels)
PowerPoint 2003 MOS (4 levels)
Word 2003 MOS (5 levels)

20 lessons - 534 training modules - 60 learning hours

 

Available Options

SINGLE USER: Microsoft Office 2003 Essentials (20 Lessons)
Makau Course Cover - Box Shot  
DVD-ROMs, e-Study Guides$695.00Add To Cart
1 YR ONLINE, e-Study Guides$695.00Add To Cart
CD-ROMs, e-Study Guides$695.00Add To Cart
DVD-Video, e-Study Guides$695.00Add To Cart
MULTI USER: Microsoft Office 2003 Essentials (20 Lessons)
Makau Course Cover - Box Shot  
DVD-ROMs, e-Study Guides$1,390.00Add To Cart
CD-ROMs, e-Study Guides$1,390.00Add To Cart
DVD-Video, e-Study Guides$1,390.00Add To Cart

Course Instructor: Casey McNeal, Dan Holme, Dennis Taylor, Diane Poremsky, Mitzi Katz

  • Industry Recognized Subject Matter Experts & Instructors
  • Authors of several Microsoft Books and Manuals

Course Outline

Access Level 1
Introduction
  • Database Concepts
  • Tour of Access
Database Wizard
  • Building a Database
Creating Databases from Scratch
  • Using the Table Wizards
  • Tables from Scratch
Database View
  • Changing Records
Table Appearance
  • Cell Effects
  • Managing Appearance of Columns
Filter Techniques
  • Sorting-Finding & Filtering
Query Essentials
  • Relationships
  • Query Wizard
  • Adding Criteria
  • Using Wildcards
Access 2003 Level 2
Form Essentials
  • Using the Form Wizard
  • Creating Forms with AutoForm
Report Essentials
  • Using the Report Wizard
  • Exporting Reports
  • Using the Label Wizard
  • Getting Help
Field Properties
  • Field Size
  • Date and Time
  • Custom Formats
  • Yes & No Fields
  • Default Value & Expression Builder
  • Validation Rule
  • Indexed Fields Unicode & IME
  • Smart Tags
Create a Lookup
  • Inserting a Field
  • Inserting a Lookup Field
  • Adding to the Lookup List
  • Limit to List
Importing & Exporting Data
  • Export to Excel
  • Importing from Databases
  • Importing Data from Excel
  • Linking Data from Excel
  • Creating a Shared Database
Relationships
  • Relationship Concepts
  • Creating Table Relationships
  • Enforcing Referential Integrity
  • Understanding Cascade Options
  • Printing Database Information
Access 2003 Level 3
Advanced Query Techniques
  • Query Desing Tips & Tricks
  • Using Parameter Queries
  • Multiple Parameter Queries
  • Report Bases on a Parameter Query
  • Setting up Calculated Fields
  • Overview of the Expression Builder
  • Creating Summary Queries
Access & HTML
  • Creating & Using Hyperlinks
  • Publish Database to HTML Format
  • Data Access Pages
Merging Access into Word
  • The Mail Merge Wizard
  • Running the Merge
Action Queries
  • Make Table Query
  • Running an Append Query
  • Running a Delete Query
  • Running an Update Query
  • Printing
Database Maintenance
  • Compact & Backup
  • Using Compact & Repair Utility
  • Using Backup & Restore Tool
Advanced Form Design
  • Printing the Selected Records
  • Creating & Using Form Controls
  • Calculated Controls
Advanced Form Modification
  • Selecting Controls
  • Sizing & Moving Controls
  • Adding Fields
  • Saving & Viewing Forms
  • Adjust Tab Order
Advanced Report Design
  • Understanding the Report Design
  • Modifying Controls
  • Adding Controls
  • Softing & Grouping Report Data
  • Working with the Pagebreak Control
Excel 2003 Lesson 1 Beginning
Getting Started
  • Starting Excel
  • Workbooks & Worksheets
  • Task Pane
  • Menu Bar & Shortcut Menus
  • Toolbars
  • Navigation & Mouse Pointer
Entering Data
  • Data Entry
  • Auto-Fill Entry
  • Erasing Data
  • AutoComplete & Preselections
  • Undo & Redo
Saving, Opening & Closing Files
  • File Save & File Save As
  • Opening a File
  • Closing a File
  • Creating a New Workbook
Entering Formulas
  • Methods of Entering Formulas
  • Repeating Formulas in Adjacent Fields
  • Formula Operators
  • Additional Formulas
Basic Excel Functions
  • Totals & Averages
  • Function Overview
Formatting
  • Adjusting Column Widths & Row Heights
  • Formatting Toolbar
  • Numeric Formatting
Changing Worksheet Layout
  • Inserting Columns, Rows & Cells
  • Deleting Columns, Rows & Cells
  • Moving Cells
  • Copying Cells
Printing
  • Using Print Preview & Page Setup
  • Printing Controls
  • Printing
Excel Help System
  • Using Excel Online Help
  • Using Excel Offline Help
Excel 2003 Lesson 2 Intermediate
Additional Formatting
  • Cell Alignment & Orientation
  • Borders
  • Centering Text Across Columns
  • Hiding & Unhiding Columns & Rows
Conditional Formatting
  • Formatting Based on Values & Multiple Conditions
  • Avoiding Overlapping Conditions
  • Using a Formula to Control Formatting
Specialized Numeric Formatting
  • Custom Category
  • Special Category
Cell References
  • Absolute References
  • Mixed References
Range Names
  • Naming & Using Range Names
  • Additional Creation Methods
  • Pasting a List of Range Names in a Worksheet
  • Deleting Range Names
  • Assigning a Name to a Value
Formula Auditing Techniques
  • Using the Formula Auditing Toolbar
  • Tracing Dependent Cells
  • Tracing Precedent Cells
Cell Protection Techniques
  • Locking/Unlocking Selected Cells
  • Protecting/Unprotecting a Worksheet
Find & Replace
  • Matching Entire Cells & Case Factors
  • Formulas & Wildcard Characters
  • Find & Replace by Format
Adjusting Worksheet Views
  • Freeze/Unfreeze Panes
  • Horizontal & Vertical Split Screens
Customizing Toolbars
  • Adding & Removing Buttons
  • Economizing Buttons & Resetting Toolbars
  • Creating New Tool Bars
Excel 2003 Lesson 3 Advanced
The "IF" Function
  • "IF" Functions & Relational Operators
  • Using Text in "IF" Functions
  • Logical Operators ("AND" & "OR") with "IF" Functions
  • Nested "IF" Functions
  • Getting Table Data with "VLOOKUP" Function
Dates & Time
  • Using Dates as Values
  • Entering a Series of Dates
  • Date/Time Techniques
Multi-Sheet Workbooks
  • Renaming Sheets & Coloring Tabs
  • Inserting & Deleting Sheets
  • Moving, Copying & Grouping Sheets
  • Formulas Across Multiple Sheets
Multiple Workbooks
  • Opening & Displaying Multiple Workbooks
  • Moving & Copying Sheets Across Workbooks
  • Linking Formulas Across Workbooks
  • Locating & Maintaining Links
Features & Settings
  • Show/Hide Gridlines & Formulas
  • Recently Used File List & New Workbook Settings
  • Other Settings & Features
Overview of Charting
  • Quick Chart Creation
  • Chart Types
  • Titles, Gridlines & Scaling
  • Formatting Basics
  • Printing & Copying Charts
Overview of Database Features
  • Sorting Data
  • Creating Subtotals
  • Filtering
  • Pivot Tables
Excel 2003 MOS Elements
Excel 2003 Lesson 6 Additional Topics
Templates
  • Saving a Skeleton Workbook as a Template
  • Creating a New Workbook from a Template
  • Editing a Template
Protection
  • Workbook Protection
  • File Password
  • Macro Security
Sharing Workbooks
  • Establishing Sharing
  • Tracking Changes
  • Merging Workbooks
Exporting Data From Excel
  • Exporting to Access
  • Exporting to Word
  • Saving as a Text File
  • Saving as a New Folder
Importing Data to Excel
  • Importing Data Using the File Open Command
  • Importing or Copying External Data
  • Hyperlinks
  • Tools Research
Excel & the Web
  • Importing Web Data
  • Saving Excel Data as a Webpage
Customizing Excel Environment
  • Creating a New Menu
  • Creating a Macro
  • Running a Macro
  • Editing a Macro
Excel 2003 Lesson 7 Special Topics
Functions
  • Statistical Functions
  • Date & Time Functions
  • Financial Functions
  • Mathematical Functions
Formula Troubleshooting
  • Formula Watch Window
  • Evaluate Formula Feature
Data Analysis Tools
  • Goal Seek
  • Solver
  • Scenarios
  • Data Table
Consolidating Data
  • Consolidate By Position
  • Consolidate By Category
Managing a List
  • Creating a List
  • Adding Data to a List
  • Adding Totals
File Properties
  • File Properties
Workbook/Worksheet
  • Worksheet Styles
  • Autoformatting
  • Showing Multiple Worksheets
  • Comparing Workbooks
Outlook 2003 Level 1
Introduction to Outlook
  • Starting Outlook
  • Getting to Know the Outlook Interface
  • Exploring Outlook
  • Using the Reading Pane
  • Creating New Folders
  • Using a Toolbar
  • Using Outlook Today
  • Using Views
Sending Email
  • Composing a New Message
  • Formatting a Message
  • Replying to & Forwarding Messages
  • Redirecting Responses Automatically
  • Message Options
  • Attachments
Using Address Books
  • Adding & Editing a Contact
  • Sending a Message from the Address Book
  • Creating & Using Distribution Lists
  • Importing & Exporting Address Books
  • Displaying Contacts in Various Views
Printing in Outlook
  • Printing Items in Outlook
  • Print Options
Cleaning up Outlook
  • Deleting Items
  • Recovering Deleted Items
Getting Help
  • Getting Help & Online Help
Outlook 2003 Level 2
Using the Calendar
  • Setting Up your Work Schedule
  • Calendar Views & Display Options
  • Additional Display Settings
  • Other Users’ Folders / Shared Calendars
Planning Meetings & Appts.
  • Creating, Editing, & Recurring Appts.
  • Setting Appt. Reminders
  • Meeting Requests
  • Finding an Appointment
Using Tasks
  • Creating a Task
  • Task Request
  • Scheduling Time for A Task
  • Setting Task Default Options
Using the Journal
  • Creating a Journal Entry
  • Creating Automatic Journal Entries
  • Editing a Journal Entry
  • Working with Journal Entry Views
Using Notes
  • Creating & Using Notes
  • Configuring & Viewing Notes
Organizing Messages
  • Using Organize
  • Creating Personal Folders
  • Moving & Copying Messages
  • Automating Your Mailbox
Toolbars
  • Customizing Tool Bars
  • Creating a New Toolbar button
Customizing Views
  • Creating Custom Views
  • Using Views
Using Outlook’s Anti-Spam Tools
  • Enabling Outlook’s Junk Email
Assigning Delegates
  • Delegate Permissions
  • Sharing Folders
Outlook 20003 Level 3
Advanced Mail Message Options
  • Automatic Spell Checking
  • Creating a Signature in Outlook
  • Setting the Default Message Font
  • Setting the Default Stationary
Finding, Recalling, & Resending Messages
  • Finding Mail Messages
  • Using Activities Tab
  • Search Folders
  • Recalling & Resending
Archiving Outlook Data
  • Using AutoArchiving
  • Retrieving Archived Items
  • Disabling AutoArchive
  • Setting Archive Properties for Items
Public Folders
  • Creating a Public Folder
  • Public Folder Conversations
  • Public Folders
Multiple Email Account
  • Creating Additional Email Accounts
PowerPoint 2003 Level 1
Working in PowerPoint
  • Introduction to PowerPoint
  • Customizing PowerPoint
  • Changing Commands
  • Getting Help
Starting a Presentation
  • Blank Presentations
  • Basics of Slide Layout
  • A Visual Overview
Managing Content in the Outline
  • Managing Content
  • Getting Content Just Right
  • AutoCorrect and AutoFormat
  • Importing Outlines from Word
  • Additional Content Tips
PowerPoint 2003 Level 2
Working with Slides-Text-Pictures
  • Introduction to Internetworking
  • Working with Place Holders
  • Working with Text Objects
  • Pictures
  • Compressing Pictures
  • Working with ClipArt
Graphic Objects
  • Drawing Toolbar
  • Editing Objects
  • Formatting Objects
PowerPoint 2003 Level 3
Organization Charts & Diagrams
  • Introduction to Diagrams
  • Creating Charts & Diagrams
  • Creating Free-Form Diagrams
Creating Data-Driven Charts
  • Data-Driven Charts
  • Inserting Charts from Excel
Inserting Data & Text Table
  • Inserting Excel Worksheets
  • Integrating Applications
  • Aligning Text with Tables
  • Embedding a Word Table
Adding Video & Sound
  • Adding Video
  • Adding Sound
Animating PowerPoint Objects
  • Animation Schemes
  • Custom Animation
  • Animating Text
  • Animating Charts
  • Creating Motion Paths
  • Slide Transitions
Customizing Color Schemes
  • Color Schemes
  • Working with Slide Masters
  • Restoring the Formatting
PowerPoint 2003 Level 4
Formatting the Slide Background
  • Formatting the Slide Background
Designs & Masters
  • Designing Masters
  • Master Slides
Preparing a Presentation for Delivery
  • Rearranging & Organizing Slides
  • Creating Custom Slide Shows
  • Summary Slides
  • Configuring Slide Timing
Working with Hyperlinks & Action Buttons
  • Navigating with Hyperlinks
  • Using Action Buttons
Presenting a PowerPoint Slide Show
  • Setup Show
  • Launching & Navigating a Slide Show
  • Marking Up Slides
  • Advanced Presentation Tools
Printing Presentations
  • Printing
  • Printing in Color and B&W
  • Printing Handouts & Notes
  • Exporting a Presentation to Word
Collaborating on a Presentation
  • Reviewing a Presentation with Outlook
  • Reviewing a Presentation without Outlook
Delivering a Presentation Remotely
  • Packaging a Presentation
  • Creating Web-Based Presentations
Word 2003 Level 1
First Steps in Word
  • Starting Word
  • The Word Window
  • Creating Content
  • Fundamental File Operations
  • Working Comfortably in Word
Fundamentals of Working in Word
  • Copy and Paste
  • Select and Do
  • Help
Working Productively in Word
  • Working Productively in Word
  • Navigating Word Documents Efficiently
  • Selecting Efficiently
  • Working as a Power User
Templates
  • New Word Documents
  • The Blank Document Template
  • Custom Templates
  • Managing Templates
Word 2003 Level 2
Content
  • Creating Content
  • Inserting Symbols & Characters
  • Spelling & Grammar
  • AutoFormat & Auto Correct
  • Automating Content Creation
  • Using Word Reference Materials
  • Working with Fields
Formatting Word Documents
  • The Format Menu
  • Paragraph Formats
  • Bullets & Numbering
  • Borders & Shading
  • The Format Painter
  • Styles
  • How to Un-Format a Document
Aligning Text with Tables & Tabs
  • Tables
  • Tabs
Managing Documents
  • Save and Save As
Word 2003 Level 3
Sections
  • Pagination
  • Page Setup
  • Headers & Footers
  • Creating Multiple Sections
  • Headers & Footers in Multiple Sections
  • Newspaper Columns
Making Long Documents Accessible
  • Juggling Projects
  • Tables of Contents
  • Document Tables & indices
  • Endnotes-Footnotes & Cross References
  • Auto Summarize
  • Master Documents
Macros
  • Creating Macros with the Macro Recorder
  • Playing Macros
  • Macro Security
  • Editing & Managing Macros
Word 2003 Level 4
Reviewing Documents
  • Highlighting
  • Collaborative Reviews
  • Compare & Merge
  • Comparing Document Versions
  • Sealing & Protecting Documents
Forms
  • Creating Forms
  • Advanced Forms
  • Protecting Sections of Complex Forms
  • Fill-in-Fields
Working with Web Documents
  • Saving & Opening Web Documents
  • Publishing to the Web
  • Working with Hyperlinks
  • Applying Themes
  • Structuring Documents with XML
Word 2003 Level 5
Photos ClipArt & WordArt
  • Inserting & Positioning Pictures
  • Photo Alteration
  • Compressing Pictures
  • ClipArt
  • WordArt
Drawing
  • Basic Objects
  • Creating Freeform Diagrams
  • Organization Charts & Diagrams
  • Charts
Final Format Tips
  • Creating Text Boxes
  • Page Borders
  • Page Background & Watermark
Envelopes, Labels & Mail Merge
  • Envelopes & Labels