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 |
