Excel 2003 EN
Beginner (level 1)
6 Modules - 44 topics

1. Data lists
Basic data list skills.

Total number of topics in the module : 4

   1. Adding records
   2. Creating a list
   3. Deleting records
   4. Find and editing records

2. Drawing objects
Basic skills with drawing objects.

Total number of topics in the module : 10

   1. A chart's plot area
   2. Chart gridlines
   3. Creating a chart
   4. Formatting text in a chart
   5. Inserting titles into a chart
   6. Managing a chart
   7. Managing the legend
   8. Presenting series
   9. Printing a chart
  10. Selecting a chart object

3. Formatting
Basic formatting skills.

Total number of topics in the module : 8

   1. Applying cell borders
   2. AutoFormat
   3. Column width and row height
   4. Displaying numerical values
   5. Font and size of characters
   6. Font style
   7. Horizontal alignment of cell contents
   8. Vertical alignment in a cell

4. Functions and calculation
Basic calculation skills.

Total number of topics in the module : 3

   1. Absolute reference in a formula
   2. AutoSum button
   3. Entering a formula

5. Managing data
Basic skills with data.

Total number of topics in the module : 9

   1. Copying into adjacent cells
   2. Copying into non-adjacent cells
   3. Deleting the content of a cell
   4. Editing the content of a cell
   5. Entering data
   6. Environment basics
   7. Inserting and deleting cells
   8. Moving cell contents
   9. What is a spreadsheet?

6. Workbooks
Basic skills with workbooks.

Total number of topics in the module : 10

   1. Closing a workbook
   2. Creating a new workbook
   3. Deleting rows and columns
   4. Inserting rows and columns
   5. Magnification of the workbook
   6. Moving around a workbook
   7. Opening a workbook
   8. Print preview
   9. Saving a new workbook
  10. Saving a workbook

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