Excel 2003 Training

Office Training Category > Excel 2003 Course >

Join thousands of corporate repeat customers in receiving the highest quality training products on the market.

 Email this page to a friend

*Keynotes provide 239 pages (printable) of Full Color Study Guides on disk.

Please call 1-888-797-4040 for price on multi-user license.

**Keynotes provide 388 pages (printable) of Full Color Study Guides on disk.

Video Tape Based Training:
VHS tape provides classroom like visual presentation of lectures. Learn new software skills through step-by-step, easy to understand training sessions. In-depth learning through actual case studies - as trainer steps you visually through real-life scenarios, and teaches you how-to effectively use the software.

Multimedia CD-ROM & DVD Based Training:
With CD & DVD based training, the lectures were video taped and then digitized and presented to you in Full Motion Video, Audio, & Graphics. DVDs will run on both a computer DVD Drive and a TV DVD Player.

System Requirements: x86/400 mhz (minimum), CD-ROM Drive (for CDs),
DVD Drive or TV DVD Player (for DVDs), 64 MB RAM, Sound Card. Available Hard Disk Space 200 MB. Windows 98, NT, ME, 2000, XP, Vista, or Apple Mac.

Course Summary - Excel 2003 Training:
Approx. 16 hrs. of training on 8 CDs, DVDs or Videos w/388 Pages of Full Color Study Guides

View detailed outline

Beginner

Getting Started
Entering Data
Saving, Opening and Closing Files
Entering Formulas
Basic Excel Functions
Formatting
Changing Worksheet Layout
Printing
Excel Help System

Intermediate

Additional Formatting
Conditional Formatting
Specialized Numeric Formatting
Cell References
Range Names
Formula Auditing Techniques
Cell Protection Techniques
Find and Replace
Adjusting Worksheet Views
Customizing Toolbars

Advanced

The "IF" Function
Dates and Time
Multi-Sheet Workbooks
Multiple Workbooks
Features and Settings
Overview of Charting
Overview of Database Features

MOS Additional Topics

Templates
Protection
Sharing Workbooks
Exporting Data From Excel
Importing Data to Excel
Excel and the Web
Customizing Excel Environment

MOS Special Topics

Functions
Formula Troubleshooting
Data Analysis Tools
Consolidating Data
Managing a List
File Properties
Workbook/Worksheet

Charts and Graphical Features

Creating a Chart
Formatting a Chart
Chart Content
Specific Chart Types
Printing Charts
Annotating Charts and Worksheets
Outlining and Custom Views
Drawing Toolbar

Database Features

Excel Databases
Data Form
Data Validation
Data Sort
Data Subtotals
Data Filter
Data Functions

Tips & Tricks For Excel 2003

Navigation Shortcuts
Selection Shortcuts
Data Entry Shortcuts
Operational Shortcuts
Formula and Functions Tips
Numeric Formatting
Data Expansion
Drag & Drop
Graphical Shortcuts

View detailed outline