Microsoft Excel 2003 Training CD ROMs

Unlimited User License

Course Outline - Excel 2003 Training Bundle
Approx. 16 hours of training on 8 CD-ROMs or DVDs,

Level 1 - Beginner

Getting Started

• Starting Excel
• Workbooks and Worksheets
• Task Pane
• Menu Bar and Shortcut Menus
• Toolbars
• Navigation and Mouse Pointer

Entering Data

• Data Entry
• Auto-Fill Entry
• Erasing Data
• AutoComplete and Preselections
• Undo and Redo

Saving, Opening and Closing Files

• File Save and 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 and Averages
• Function Overview

Formatting

• Adjusting Column Widths and Row Heights
• Formatting Toolbar
• Numeric Formatting

Changing Worksheet Layout

• Inserting Columns, Rows and Cells
• Deleting Columns, Rows and Cells
• Moving Cells
• Copying Cells

Printing

• Using Print Preview and Page Setup
• Printing Controls
• Printing

Excel Help System

• Using Excel Online Help
• Using Excel Offline Help

Level 2 - Intermediate

Additional Formatting

• Cell Alignment and Orientation
• Borders
• Centering Text Across Columns
• Hiding and Unhiding Columns and Rows

Conditional Formatting

• Formatting Based on Values and 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 and 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 and Replace

• Matching Entire Cells and Case Factors
• Formulas and Wildcard Characters
• Find and Replace by Format

Adjusting Worksheet Views

• Freeze/Unfreeze Panes
• Horizontal and Vertical Split Screens

Customizing Toolbars

• Adding and Removing Buttons
• Economizing Buttons and Resetting Toolbars
• Creating New Tool Bars

Level 3 - Advanced

The "IF" Function

• "IF" Functions and Relational Operators
• Using Text in "IF" Functions
• Logical Operators ("AND" and "OR") with "IF" Functions
• Nested "IF" Functions
• Getting Table Data with "VLOOKUP" Function

Dates and Time

• Using Dates as Values
• Entering a Series of Dates
• Date/Time Techniques

Multi-Sheet Workbooks

• Renaming Sheets and Coloring Tabs
• Inserting and Deleting Sheets
• Moving, Copying and Grouping Sheets
• Formulas Across Multiple Sheets

Multiple Workbooks

• Opening and Displaying Multiple Workbooks
• Moving and Copying Sheets Across Workbooks
• Linking Formulas Across Workbooks
• Locating and Maintaining Links

Features and Settings

• Show/Hide Gridlines and Formulas
• Recently Used File List and New Workbook Settings
• Other Settings and Features

Overview of Charting

• Quick Chart Creation
• Chart Types
• Titles, Gridlines and Scaling
• Formatting Basics
• Printing and Copying Charts

Overview of Database Features

• Sorting Data
• Creating Subtotals
• Filtering
• Pivot Tables

Level 4 - Charts and Graphical Features

Creating a Chart

• Quick Chart Creation
• Chart Wizard
• Using the Chart Toolbar
• Copying, Moving and Re-shaping a Chart
• Changing a Chart's Location

Formatting a Chart

• Selecting Elements to Format
• Color Backgrounds and Fill Effects
• Controlling Text Size and Position
• Series Order and Column Options

Chart Content

• Titles and Data Labels
• Gridlines and Legends
• Scaling Column and Line Charts
• Add and Remove Data from a Chart
• Adding Trendlines

Specific Chart Types

• Line Charts
• Column Charts
• Pie Charts
• Combination Charts (Dual Axis)

Printing Charts

• Printing Chart from A separate Sheet
• Printing a Chart Located on a Worksheet

Annotating Charts and Worksheets

• Adding Text and Arrows
• Inserting, Displaying, Hiding and Editing Comments
• Printing Comments

Outlining and Custom Views

• Group and Outlining Capabilities
• Custom Views

Drawing Toolbar

• WordArt
• Shapes, Lines and Arrows
• Coloring Objects and Adding Text
• Clipart
• Applying 3-D and Shadow Effect

Level 5 - Database Features

Excel Databases

• List Attributes and Building Lists

Data Form

• Setting a Single Record with Formulas
• Adding Records to a Database
• Finding Records

Data Validation

• Establishing Data Entry Criteria
• Using Formulas and Lists to Restrict Data
• Using Data Validation on Existing Data
• Data Validation Exclusions

Data Sort

• Sorting from a Menu
• Sorting from the Toolbar
• Multiple-Key Sorting
• Sorting with Custom Lists
• Sorting Columns

Data Subtotals

• Single Level Subtotals
• Multiple Level Subtotals

Data Filter

• Criteria
• Multiple Column
• Creating Custom Filter
• Top Ten
• Copying Formatting and Sorting Data
• Using "SUBTOTAL" Function to Count Results
• Advanced Filter

Data Functions

• "SUMIF", "COUNTIF"
• Array Formulas
• Database Functions

Level 6 - MOS 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 and 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

Level 7 - MOS Special Topics

Functions

• Statistical Functions
• Date and 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

Level 8 - Tips & Tricks For Excel 2003

Tips, Tricks & Shortcuts

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