
SECTION 1:	Getting Started With Excel
Lesson 1.1	Introduction What Is Excel? New Features In Excel 2003 Opening Excel Exiting Excel Practice Exercise
Lesson 1.2	Help With Excel Finding Help The Office Assistant The Help Task Pane Practice Exercise
Lesson 1.3	Beginning Excel The Standard Toolbar The Formatting Toolbar Working With Excel Menus Exploring Task Panes Excel Short-Cut Keys Practice Exercise
Lesson 1.4	The Basics Of File Management New Workbooks How To Open Existing Workbooks How To Save Workbooks How To Close Workbooks Excel File Types Practice Exercise
Lesson 1.5	Explore Your Workbook Switching Worksheets The Active Cell Selecting Cells Exploring A Worksheet The Zoom Feature Practice Exercise
Section 1:	Review Questions

SECTION 2:	Excel Basics
Lesson 2.1	Working With Excel Columns, Rows, Cells, And Ranges Creating Worksheet Labels Entering And Deleting Data Printing Your Worksheet Practice Exercise
Lesson 2.2	Basic Excel Features What Is Autofill? What Is Autosum? What Is Autocomplete? Working With Basic Formulas Practice Exercise
Lesson 2.3	Editing Tools Using Autocorrect Using Spell Check Using Find And Replace Documenting A Worksheet With Comments Practice Exercise
Lesson 2.4	Moving Your Data Dragging And Dropping Cells How To Cut, Copy, And Paste Cells How To Cut, Copy, And Paste Multiple Cells And Items How To Use Paste Special How To Insert And Delete Cells, Rows, And Columns Using Undo, Redo, And Repeat Practice Exercise
Lesson 2.5	Using Smart Tags And Option Buttons What Are Smart Tags? The Error Option Button The Autofill Option Button The Paste Option Button Practice Exercise
Section 2	Review Questions

SECTION 3:	Working With Excel
Lesson 3.1	Modifying Cells And Data Changing The Size Of Rows Or Columns Working With The Formatting Toolbar Adjusting Cell Alignment Rotating Text Creating Custom Number And Date Formats Practice Exercise
Lesson 3.2	Cell Formatting Conditional Formatting What Is The Format Painter What Is Autoformat Cell Merging And Autofit Find And Replace Formatting Practice Exercise
Lesson 3.3	Enhancing A Worksheet’s Appearance Adding Patterns And Colours Adding Borders Adding Fill Effects Working With Styles Practice Exercise
Lesson 3.4	Modifying Excel’s Toolbars Hiding Toolbars Showing Toolbars Moving Toolbars Customizing Toolbars Practice Exercise
Lesson 3.5	Working With Charts Creating A Chart Formatting A Chart Manipulating A Chart Enhancing A Chart With Drawing Tools Enhancing Your Chart With Titles And Tables Practice Exercise
Lesson 3.6	Working With Charts And Data Changing The Type Of Chart Changing The Source Data Creating 3-D Charts Working With The Chart Axes And Data Series Making Custom Charts Practice Exercise

Section 2	Review Questions

SECTION 4:	Workbook Management
Lesson 4.1	Organizing Your Workbook Inserting And Removing Worksheets Renaming, Moving, And Colour-Coding Worksheets How To Split And Freeze A Window Using Multiple Workbooks And Windows Using A Watch Window Creating A Custom View Practice Exercise
Lesson 4.2	Formatting Your Workbook Using Headers And Footers Inserting Page Numbers Changing Margins And Orientation Hiding Rows, Columns And Worksheets Practice Exercise
Lesson 4.3	Printing A Workbook Microsoft Office Document Imaging Choosing A Print Area Setting Up Page Breaks Choosing Paper Size And Changing Print Scale Adding Print Titles And Gridlines Practice Exercise
Lesson 4.4	More Workbook Features Linking Workbooks Consolidating Workbooks Combining Worksheets Protecting Worksheets Using Templates Practice Exercise
Section 4	Review Questions