Excel 2003
15 Modules - 152 topics

1. Automating your work
Working with templates, scenarios and macros

Total number of topics in the module : 10

   1. Custom views
   2. Editing and running a macro
   3. Goal seek
   4. Managing scenarios
   5. Managing templates
   6. Merging scenarios
   7. Problems with unknown quantities and constraints
   8. Recording and running a macro
   9. Styles
  10. Templates

2. Calculations
Entering simple formulas or more complex ones (absolute references, subtotals . . .), array formulas, consolidation, formula auditing etc.

Total number of topics in the module : 10

   1. Absolute reference in a formula
   2. Array formulas
   3. Calculating while copying
   4. Data consolidation
   5. Entering a formula
   6. Evaluating formulas
   7. Formula auditing
   8. Locating invalid data
   9. Subtotal rows
  10. Watch Window

3. Charts and drawing objects
Creating and formatting graphic objects: charts, text boxes, drawings, diagrams, pictures etc.

Total number of topics in the module : 22

   1. A chart's plot area
   2. Attached and unattached text
   3. Chart gridlines
   4. Creating a chart
   5. Data table
   6. Drawing
   7. Formatting a picture
   8. Formatting objects
   9. Formatting text in a chart
  10. Formatting the axes
  11. Inserting and formatting a diagram
  12. Inserting titles into a chart
  13. Managing a chart
  14. Managing series
  15. Managing the legend
  16. Order in which objects overlap
  17. Presenting series
  18. Printing a chart
  19. Representing series differently
  20. Scale of the chart
  21. Selecting a chart object
  22. Type and format of a chart

4. Copying and moving
Inserting and deleting cells, copying and moving cell contents, using paste special

Total number of topics in the module : 6

   1. Copying into adjacent cells
   2. Copying into non-adjacent cells
   3. Copying results of a calculation
   4. Inserting and deleting cells
   5. Moving cell contents
   6. Paste Special

5. Data management
Using a workbook with assistance tools for entering, organising, representing, importing and exporting data.

Total number of topics in the module : 11

   1. Converting data
   2. Custom data series
   3. Editing a pivot table
   4. Exporting data
   5. Importing data
   6. Naming a range of cells
   7. Organising data in an outline
   8. Pivot charts
   9. Producing a pivot table
  10. Sorting a table
  11. Two-input data tables

6. Entering and editing data
Entering, editing and deleting data. Spell checking, find and replace etc.

Total number of topics in the module : 7

   1. Checking the spelling
   2. Current date and date formats
   3. Deleting the content of a cell
   4. Editing the content of a cell
   5. Entering data
   6. Finding and replacing
   7. Typing several lines in one cell

7. Filters
Activating filters, creating complex criteria ranges, calculating statistics on records in a data list

Total number of topics in the module : 9

   1. Activating AutoFilter
   2. Criteria ranges
   3. Displaying all the records
   4. Extracting records using a criteria range
   5. Filtering by several fields
   6. Filtering by the value of a field
   7. Filtering by values in one field
   8. Removing a filter
   9. Statistics from records

8.Integrated functions
Statistical, financial, logical, text and date functions

Total number of topics in the module : 10

   1. AutoSum button
   2. Date calculations
   3. Financial functions
   4. Formulas including conditions
   5. Functions and cell ranges
   6. Lookup tables
   7. Multiple conditions
   8. Nested conditions and conditional functions
   9. Simple statistical functions
  10. Text functions

9. List
Adding, editing and deleting records in a list.

Total number of topics in the module : 4

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

10. Table presentation
Formatting tables and cells: borders, characters, alignment, date formats and so on.

Total number of topics in the module : 16

   1. Applying cell borders
   2. Applying colour to cells
   3. AutoFormat
   4. Column width and row height
   5. Copying a cell's formatting
   6. Custom formats
   7. Displaying numerical values
   8. Displaying zero values
   9. Font and size of characters
  10. Font style
  11. Formatting cells which meet a condition
  12. Hiding items in a sheet
  13. Horizontal alignment of cell contents
  14. Merging cells
  15. Orientation of cell contents
  16. Vertical alignment in a cell

11. Various tools
Using various tools designed to help with data management.

Total number of topics in the module : 5

   1. Digital signatures
   2. Managing comments
   3. Projecting values
   4. Research task pane
   5. Validation criteria

12. Web and XML
Using XML features (these features are not available with Microsoft Office Standard Edition).

Total number of topics in the module : 6

   1. Adding an XML schema to a workbook
   2. Exporting data from a workbook to an XML file
   3. Hyperlinks
   4. Importing XML data into a workbook
   5. Publishing a web page
   6. Web page preview

13. Workbook management
Managing workbooks: opening, closing, saving, printing, protecting, sharing.

Total number of topics in the module : 20

   1. Closing a workbook
   2. Creating a new workbook
   3. Creating a workbook from a template
   4. Header and footer
   5. Hiding/displaying workbooks
   6. Moving around a workbook
   7. Opening a workbook
   8. Page break
   9. Page orientation and scaling
  10. Page setup for printing
  11. Print area
  12. Print preview
  13. Printing a column/row on each page
  14. Protecting workbooks
  15. Saving a new workbook
  16. Saving a workbook
  17. Sharing workbooks
  18. Using a shared workbook
  19. Workbook management
  20. Workbook properties

14. Working environment
Standard and customised working environments

Total number of topics in the module : 5

   1. Customising menus
   2. Customising toolbars
   3. Data management
   4. Environment basics
   5. What is a spreadsheet?

15. Worksheets, rows and columns
Managing worksheets (moving, copying, protecting, hiding, backgrounds), Managing rows and columns (deleting, inserting etc.)

Total number of topics in the module : 11

   1. Default options
   2. Deleting rows and columns
   3. Freezing columns and rows
   4. Hiding and displaying a worksheet
   5. Inserting rows and columns
   6. Inserting/Deleting a sheet
   7. Magnification of the workbook
   8. Moving or copying a sheet
   9. Protecting cells and worksheets
  10. Sheet background and tab colour
  11. Worksheet name