Excel 2003: Beginner Level
- 1.0 The Excel Screen
- 1.1 Overview � Loading Microsoft Excel 2003
- 1.2 Screen Elements � Menu and Button Bars
- 1.3 Screen Elements � Workbook and Spreadsheet Properties
- 2.0 Creating Data and Content
- 2.1 Enter and edit cell content
- 2.2 Navigate to specific cell content
- 2.3 Locate, select and insert supporting information
- 2.4 Insert, position and size graphics
- 2.5 Saving, closing and opening files
- 4.0 Formatting Data and Content
- 4.1 Apply and modify cell formats
- 4.2 Apply and modify cell styles
- 4.3 Modify row and column formats
- 4.4 Format worksheets using AutoFormat
Excel 2003: Intermediate Level
- 1.0 Collaborating
- 1.1 Insert, view and edit comments
- 2.0 Managing Worksheets
- 2.1 Create new workbooks from templates
- 2.2 Insert, delete and move cells
- 2.3 Create and modify hyperlinks
- 2.4 Organize worksheets
- 2.5 Preview data in other views
- 2.6 Customize window layout
- 2.7 Setup pages for printing
- 2.8 Print data
- 2.9 Organize workbooks using file folders
- 2.10 Save data in appropriate formats for different uses
- 3.0 Organizing and Analyzing Data
- 3.1 Use subtotals
- 3.2 Define and apply advanced filters
Excel 2003: Advanced Level
- 1.0 Formatting Data and Content
- 1.1 Create and modify custom data formats
- 1.2 Use conditional formatting
- 1.3 Format and resize graphics
- 1.4 Format charts and diagrams
- 2.0 Collaborating
- 2.1 Protect cells, worksheets, and workbooks
- 2.2 Apply workbook security settings
- 2.3 Share workbooks
- 2.4 Merge workbooks
- 3.0 Managing Data and Workbooks
- 3.1 Import data to Excel
- 3.2 Export data from Excel
- 3.3 Publish and edit Web Worksheets and workbooks
- 3.4 Create and edit templates
- 3.5 Consolidate data
- 3.6 Define and modify workbook properties
- 4.0 Customizing Excel
- 4.1 Customize toolbars and menus