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