Level 1 Course Outline
Introduction to Microsoft Excel 2003
What is Excel?
Excel File Types
Excel Environment
Toolbars
Office Assistant
Review Questions
Workbooks and Worksheets
Creating and Opening Workbooks
Working with Workbooks
Working with Worksheets
Working with Cells
Navigating within a Worksheet
Navigating the Workbook
Review Questions
Spreadsheet Data
Entering Data
Using Time Saving Features
Checking the Spelling
Review Questions
Formatting and Customising Data
Selecting Items in Excel
Formatting Text
Formatting Numbers
Manipulating Data
Formatting Columns and Rows
Formatting with Colours and Patterns
Adding and Editing Borders
Using AutoFormat
Review Questions
Editing Spreadsheets
Cutting, Copying, and Pasting
Inserting and Deleting
Using Find and Replace
Using Undo and Redo
Review Questions
Formulas and Functions
Entering Formulas
Entering Functions
Using Named Cells and Ranges in Formulas
Review Questions
Printing
Using Page Setup
Margins
Headers and Footers
Printing a Spreadsheet
Review Questions
Level 2 Course Outline:
Viewing Worksheets
Customising View Options
Displaying and Customising Toolbars
Hiding Workbooks and Worksheets
Freezing Panes
Grouping and Ungrouping Worksheets
Review Questions
More Formatting Techniques
Using Styles
Conditional Formatting
Using the Format Painter
Using Guidelines
Hiding and Displaying Cells
Review Questions
More Formulas and Functions
Using the Series Command
Using the Insert Function Wizard
Using the Excel Function Categories
Correcting Formulas
Using the Formula Error Checker
Using the Formula Auditing Toolbar
Using the Watch Window
Review Questions
Database and List Management
Using Databases
Creating and Editing a Database
Sorting a Database
Using AutoFilters
Advanced Filters
Working with Filtered Data
Using Data Forms
Review Questions
Charts
Chart Wizard
Chart Toolbar
Working with Charts
Formatting the Chart
Review Questions
Drawing and Picture Objects
Drawing Toolbar
Working with AutoShapes
Creating Text Boxes
Adding Pictures
Layering Objects
Grouping and Ungrouping Objects
Excel 2003 and Other Applications
Converting Files from Other Applications
Copying Data from another Application
Embedding and Linking Objects
Hyperlinks
Managing Links
Level 3 Course Outline
Importing Data
Importing Data from External Sources
Importing Text Files
Using Microsoft Query
Querying Data from the Web
Refreshing Data
Review Questions
Templates and Styles
Working with Templates
Working with Styles
Review Questions
Analysing Data
What-If Analysis
Goal Seek
Data Tables
Scenario Manager
Solver
Using Pivot Tables
Review Questions
Macros and Custom Controls
Working with Macros
Running Macros
Adding Custom Controls
Review Questions
Security and Proofing
Security Features
Protecting Excel Files
Worksheet Protection
Working with Digital Signatures
Checking Spelling
Using Data Validation
Using Text To Speech
Documentation
Review Questions
Customising Excel 2003
Configuring Excel 2003 Options
Customising the Excel Environment
Working with Workspaces
Review Questions
Collaboration and Consolidation
Sharing Workbooks
Sending Workbooks
Consolidation
Review Questions
Previous Software Versions: MS Office XP, 2002, 2000
