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