Excel 2003
Proficient user (level 2)
7 Modules - 53 topics

1. Automating your work
Acquiring proficiency in automating common tasks.

Total number of topics in the module : 4

   1. Custom views
   2. Managing templates
   3. Styles
   4. Templates

2. Data lists
Intermediate data list skills.

Total number of topics in the module : 6

   1. Activating AutoFilter
   2. Displaying all the records
   3. Filtering by several fields
   4. Filtering by the value of a field
   5. Filtering by values in one field
   6. Removing a filter

3. Drawing objects
Intermediate skills with drawing objects.

Total number of topics in the module : 12

   1. Attached and unattached text
   2. Data table
   3. Drawing
   4. Formatting a picture
   5. Formatting objects
   6. Formatting the axes
   7. Inserting and formatting a diagram
   8. Managing series
   9. Order in which objects overlap
  10. Representing series differently
  11. Scale of the chart
  12. Type and format of a chart

4. Formatting
Intermediate formatting skills.

Total number of topics in the module : 4

   1. Applying colour to cells
   2. Copying a cell's formatting
   3. Merging cells
   4. Orientation of cell contents

5. Functions and calculation
Intermediate calculation skills

Total number of topics in the module : 6

   1. Evaluating formulas
   2. Formula auditing
   3. Formulas including conditions
   4. Functions and cell ranges
   5. Locating invalid data
   6. Simple statistical functions

6. Managing data
Intermediate skills with data.

Total number of topics in the module : 9

   1. Checking the spelling
   2. Copying results of a calculation
   3. Current date and date formats
   4. Finding and replacing
   5. Naming a range of cells
   6. Publishing a web page
   7. Sorting a table
   8. Typing several lines in one cell
   9. Web page preview

7. Workbooks
Intermediate skills with workbooks.

Total number of topics in the module : 12

   1. Creating a workbook from a template
   2. Freezing columns and rows
   3. Header and footer
   4. Inserting/Deleting a sheet
   5. Moving or copying a sheet
   6. Page break
   7. Page orientation and scaling
   8. Page setup for printing
   9. Print area
  10. Printing a column/row on each page
  11. Sheet background and tab colour
  12. Worksheet name

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