Lesson 1: Introduction to MS Excel 2003
Opening MS Excel 2003
Navigating MS Excel 2003
Customizing the MS Excel 2003 Toolbars
Cells, Rows, and Columns
Formulas
Lesson 2: Worksheets and Workbooks
The Definition of Worksheets and Workbooks
Opening Worksheets and Workbooks
Labeling and Naming Worksheets
Adding and Deleting Worksheets
Hiding/ Unhiding Worksheets
Hiding Columns and Rows
Saving Workbooks
Headers and Footers
About Printing Worksheets and Workbooks
Page Setup
Set Page Margins
Select Print Area
Print a Range of Pages
Print Preview
Lesson 3: Entering Information into MS Excel 2003
About Entering Information into Excel
Entering Labels and Values
Multiple Entries
Copying Cells, Rows, and Columns
Pasting Cells, Rows, and Columns
Inserting and Deleting Rows and Columns
Filling Cells with a Series of Data
Editing Cell Data
Find and Replace, Go To Cell Data
Locking Rows and Columns By Splitting Panes
Locking Rows and Columns by Freezing Panes
Spell Check
Smart Tags
Lesson 4: Formatting a Worksheet
Change Font Size and Type
Add Borders and Colors to Cells
Changing Column Width
Changing Row Height
Merge Cells
Apply Number Formats and Create Custom Number Formats
Align Cell Contents
AutoFormats
Conditional Formatting
Lesson Five: Adding Elements to a Workbook
Adding Images
Modifying Images
Changing the Borders of a Picture or an Image
Compressing a Picture
Adding WordArt
Inserting AutoShapes
Adding Clip Art
Creating a Hyperlink
Lesson 6: Charts and Diagrams
Modifying and Moving a Chart
Organizational Charts or Diagrams
Lesson Seven: Formulas and Calculations
Definition and explanation of formulas and calculations
Mathematical operators
Creating a formula
References
Absolute, Relative and Mixed Cell References
Lesson 8: Managing Data
Using a Data Form
Entering Data Using a Data Form
Data Validation
Lesson 9: Lists
Creating a List
Inserting Rows and Columns into a List
Adding Up Values
Sorting Lists
Using Filters to Sort Lists
Using List Border to Expand a List
Inserting Columns and Rows Into a List
Totaling and Tallying Data
Lesson 10: Security and Protection in MS Excel 2003
Protecting a Workbook
Protecting Worksheets
Allow Users to Edit Ranges
Restrict Users and MS Excel 2003 Security
Lesson 11: Sharing Worksheets and Workbooks
Online Collaboration
Set Up a Shared Version of a Workbook
Merging Versions of the Same Workbook
Adding, Editing, and Deleting Comments
Creating and Sharing Templates
Creating a Template