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

1. Grasped 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

Excel 2007
Advanced user (level 3)
6 modules - 46 topics

1. Get clever (tips and tricks)
Choose the tips that fit what you do; not everyone will need all of these.

Total number of topics in the module: 11

   1. Custom formats
   2. Validation criteria
   3. Converting data
   4. Creating a data series
   5. Custom views
   6. Formula auditing
   7. Evaluating formulas
   8. The Watch Window
   9. Criteria ranges
  10. Filtering and extracting rows using a criteria range
  11. Statistics with a criteria range

2. Pivot your data
They constitute one of the main advantages of a spreadsheet like Excel, so make full use of pivot tables.

Total number of topics in the module: 5

   1. Pivot tables
   2. Modifying a pivot table
   3. Selecting, copying, moving or deleting a pivot table
   4. Defining the layout and the presentation of a pivot
   5. Pivot charts

3. Find the right formula
How to calculate with text, dates, times, arrays, conditions and also how to use tools like Solver.

Total number of topics in the module: 14

   1. Lookup tables
   2. Text functions
   3. Time calculations
   4. Date calculations
   5. Condition with AND, OR, NOT
   6. Nested conditions and conditional functions
   7. Array formulas
   8. Calculating with copied values
   9. Consolidation
  10. Financial functions
  11. Double entry data table
  12. Goal seek
  13. The Solver
  14. Managing scenarios

4. Customise, bring up to date
Adapt Excel to suit your preferences.

Total number of topics in the module: 6

   1. Creating and customising a theme
   2. Creating and working with templates
   3. Modifying and deleting templates
   4. Importing data
   5. Updating and managing imported data
   6. Workbook properties

5. Share and collaborate effectively
Excel proposes different solutions for a safe exchange of data: sharing, merging, various degrees of protection, signing the data etc.

Total number of topics in the module: 6

   1. Protecting workbooks
   2. Protecting specific cells
   3. Sharing a workbook
   4. Tracking changes in a workbook
   5. Merging workbooks
   6. Digital signatures

6. Find out more
Find out about macros See how Excel can work in collaboration with SharePoint.

Total number of topics in the module: 4

   1. Macros
   2. Discovering the SharePoint site
   3. Working with workbooks on a SharePoint site
   4. Managing versions of a workbook with SharePoint