Excel 2007
Beginner (level 1)
7 modules - 43 topics

1. Get started in Excel
Discover Excel and carry out simple tasks: opening a workbook saving it, entering and modifying data etc.

Total number of topics in the module: 9

   1. Spreadsheet application basics
   2. Overview of the environment
   3. Opening a workbook
   4. Moving around a workbook
   5. Entering data
   6. Modifying the contents of a cell
   7. Selecting and deleting cells
   8. Undoing and redoing an action
   9. Saving a workbook

2. Set out your first Excel calculations
A spreadsheet application is designed to calculate Learn how to enter simple formulas.

Total number of topics in the module: 4

   1. Entering a calculation formula
   2. Calculating a sum or another simple statistic
   3. Calculating a percentage
   4. Reproducing data in adjacent cells

3. Look good with easy formatting
Get the presentation of your tables right: apply colour, borders, currency symbols etc.

Total number of topics in the module: 7

   1. Simple numerical formats
   2. Applying a theme
   3. Formatting characters
   4. Character font and size
   5. Aligning cell content
   6. Cell colour
   7. Cell borders

4. Create a workbook and print your work
Some basic skills: how to print your work, or create a new workbook.

Total number of topics in the module: 3

   1. Page layout
   2. Print preview and printing
   3. Creating a new workbook

5. Increase your efficiency
You will find yourself getting more done in less time once you have mastered these simple,
common commands for changing the view, copying, managing column widths, making
references absolute, inserting rows, moving cells, entering automatic dates etc.

Total number of topics in the module: 8

   1. Zoom
   2. Column width/row height
   3. Inserting/deleting rows, columns and cells
   4. Moving cells
   5. Copying to non-adjacent cells
   6. Absolute reference in a formula
   7. Sheet name, tab colour
   8. Control date, date formats

6. Let charts explain your data
Present your data visually: learn about creating and customising charts.

Total number of topics in the module: 8

   1. Creating and positioning a chart
   2. Managing a chart
   3. Selecting items in a chart
   4. Adding and removing items
   5. Formatting chart items
   6. Modifying a chart's text items
   7. Legend and plot area
   8. Printing and page layout of a chart

7. Do more with your Excel table
By declaring your data as a table, you have access to easy sorting and filtering and other time-saving options.

Total number of topics in the module: 4

   1. Creating and managing a table
   2. Formatting a table
   3. Automatic calculations in a table
   4. Automatic filtering

Excel 2007
Proficient user (level 2)
6 modules - 46 topics

1. Grasp the basics? Take the next step
Simple, common commands that you should be at ease with before you move on to more complex tables.

Total number of topics in the module: 8

   1. Copying cell format quickly
   2. Merging cells
   3. Orientation of cell content
   4. Displaying several lines of data in one cell
   5. Cell styles
   6. Copying the results of a calculation
   7. Inserting and deleting sheets, sheet background
   8. Moving, copying, hiding sheets

2. Move on to more complex tables
You are ready for more complex calculations or a more sophisticated presentation of your
tables? Among other things, learn how to sort data, set conditions, work with automatic dates.

Total number of topics in the module: 6

   1. Simple conditions
   2. Applying a conditional format
   3. Managing conditional formats
   4. Sorting a table
   5. Naming a range of cells
   6. Freezing a column/row on the screen

3. Print an attractive document
Make sure that your table looks as good on paper as it does on the screen: find out all about printing in Excel.

Total number of topics in the module: 5

   1. Repeating row/column headings on printed pages
   2. Hiding elements of a sheet
   3. Print area
   4. Page breaks
   5. Headers and footers

4. Create striking charts
Formatting commands for producing high-impact charts.

Total number of topics in the module: 4

   1. Data series and chart axes
   2. Managing series
   3. Chart type options
   4. Managing chart templates

5. Illustrate your data
Use simple techniques with charts, drawing objects and pictures to brighten up your data.

Total number of topics in the module: 11

   1. Creating a drawing object
   2. Selecting and deleting objects
   3. Copying and moving objects
   4. Resizing a drawing object
   5. Modifying a text box
   6. Modifying a drawing
   7. Formatting drawing objects
   8. Inserting a picture
   9. Managing pictures
  10. Rotating and aligning objects
  11. Stacking objects

6. Find out what's new and exciting
Discover some new functionality, most of it easy to grasp, for presenting and processing data, managing workbooks etc.

Total number of topics in the module: 12

   1. Using cell ranges in functions
   2. Subtotal rows
   3. Summarising data with an outline
   4. Attaching a comment to a cell
   5. Custom filters
   6. Blank cells and duplicates
   7. Find and replace
   8. Checking spelling
   9. Hyperlink
  10. Transfer, export: PDF, XPS, e-mail and Web page
  11. Converting Excel files
  12. Finalising a workbook