Excel 2003 Bundle

Course Outline

Duration: 1 Day

Description: A combination of our Excel Basic and Intermediate classes covering the most popular and important topics of our day.

Course Contents:

Unit 1: Excel basics

Topic A: Spreadsheet terminology

Topic B: Opening and navigating workbooks

Unit 2: Entering and editing data

Topic A: Creating workbooks

Topic B: Entering and editing labels and values

Topic C: Entering and editing formulas

Unit 3: Modifying a worksheet

Topic A: Moving and copying formulas

Topic B: Using absolute references

Topic C: Inserting and deleting ranges

Unit 4: Using functions

Topic A: Entering functions

Topic B: Using AutoSum

Unit 5: Formatting worksheets

Topic A: Formatting rows and columns

Topic B: Number formatting

Topic C: Other formatting features

Unit 6: Printing

Topic A: Page Setup options

Unit 7: Creating charts

Topic A: Chart basics

Topic B: Modifying charts

Unit 8: Working with large worksheets

Topic A: Viewing options
Topic C: Printing large worksheets

Unit 9: Using multiple worksheets and workbooks
Topic A: Linking worksheets by using 3-D formulas
Topic B: Linking workbooks
Topic C: Managing workbooks

Unit 10: Advanced formatting
Topic A: Using special number formats
Topic B: Working with dates

Unit 11: List management
Topic A: Examining lists
Topic B: Sorting and filtering lists

Unit 12: Documenting and auditing
Topic A: Protection