Excel 2003 EN
Advanced user (level 3)
8 Modules - 55 topics

1. Automating your work
Validating advanced skills in automating common tasks.

Total number of topics in the module : 6

   1. Editing and running a macro
   2. Goal seek
   3. Managing scenarios
   4. Merging scenarios
   5. Problems with unknown quantities and constraints
   6. Recording and running a macro

2. Data lists
Advanced data list skills.

Total number of topics in the module : 3

   1. Criteria ranges
   2. Extracting records using a criteria range
   3. Statistics from records

3. Formatting
Advanced formatting skills.

Total number of topics in the module : 4

   1. Custom formats
   2. Displaying zero values
   3. Formatting cells which meet a condition
   4. Hiding items in a sheet

4. Functions and calculation
Advanced calculation skills.

Total number of topics in the module : 12

   1. Array formulas
   2. Calculating while copying
   3. Data consolidation
   4. Date calculations
   5. Financial functions
   6. Lookup tables
   7. Multiple conditions
   8. Nested conditions and conditional functions
   9. Subtotal rows
  10. Text functions
  11. Two-input data tables
  12. Watch Window

5. Managing data
Advanced data list skills.

Total number of topics in the module : 13

   1. Validation criteria
   2. Converting data
   3. Custom data series
   4. Editing a pivot table
   5. Exporting data
   6. Hyperlinks
   7. Importing data
   8. Managing comments
   9. Organising data in an outline
  10. Paste Special
  11. Pivot charts
  12. Producing a pivot table
  13. Projecting values

6. Workbooks
Advanced skills with workbooks.

Total number of topics in the module : 10

   1. Data management
   2. Default options
   3. Hiding and displaying a worksheet
   4. Hiding/displaying workbooks
   5. Protecting cells and worksheets
   6. Protecting workbooks
   7. Sharing workbooks
   8. Using a shared workbook
   9. Workbook management
  10. Workbook properties

7. Working environment
Acquiring proficiency in configuring the working environment.

Total number of topics in the module : 4

   1. Customising menus
   2. Customising toolbars
   3. Digital signatures
   4. Research task pane

8. XML
Assessment.

Total number of topics in the module : 3

   1. Adding an XML schema to a workbook
   2. Exporting data from a workbook to an XML file
   3. Importing XML data into a workbook