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

• 3.0 Analyzing Data
• 3.1 Filter lists using AutoFilter
• 3.2 Sort lists
• 3.3 Insert and modify formulas
• 3.4 Create, modify, and position diagrams and charts based on worksheet data

• 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

• 3.3 Group and outline data
• 3.4 Use data validation
• 3.5 Create and modify list ranges
• 3.6 Using statistical, date and time, financial, and logical functions
• 3.7 Add, show, close, edit, merge and summarize scenarios
• 3.8 Perform data analysis using automated tools
• 3.9 Create PivotTable and PivotChart reports
• 3.10 Use Lookup and Reference functions
• 3.11 Use Database functions
• 3.12 Trace formula precedents, dependents and errors
• 3.13 Locate invalid data and formulas
• 3.14 Watch and evaluate formulas
• 3.15 Define, modify and use named ranges
• 3.16 Structure workbooks using XML

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