Scroll down to: Intermediate Level | Advanced
Level
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 |
