Excel 2007
Full training in 17 steps
17 modules - 135 topics

1. Discover Excel and work with a simple table
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: 12

   1. Zoom
   2. Column width/row height
   3. Inserting/deleting rows, columns and cells
   4. Moving cells
   5. Copying to non-adjacent cells
   6. Copying cell format quickly
   7. Merging cells
   8. Orientation of cell content
   9. Displaying several lines of data in one cell
  10. Cell styles
  11. Absolute reference in a formula
  12. Copying the results of a calculation

6. Customise your worksheets
An Excel workbook contains several sheets so that you can manage your data efficiently. Learn to name them, move them, insert new ones.

Total number of topics in the module: 3

   1. Sheet name, tab colour
   2. Inserting and deleting sheets, sheet background
   3. Moving, copying, hiding sheets

7. 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: 9

   1. Control date, date formats
   2. Simple conditions
   3. Custom formats
   4. Applying a conditional format
   5. Managing conditional formats
   6. Sorting a table
   7. Naming a range of cells
   8. Validation criteria
   9. Freezing a column/row on the screen

8. 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

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

Total number of topics in the module: 12

   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. Data series and chart axes
   9. Managing series
  10. Chart type options
  11. Managing chart templates
  12. Printing and page layout of a chart

10. Illustrate your tables
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

11. Move up a gear
Now that you are at ease with the basic commands, see how Excel can help you to work better, faster.

Total number of topics in the module: 10

   1. Converting data
   2. Creating a data series
   3. Using cell ranges in functions
   4. Subtotal rows
   5. Summarising data with an outline
   6. Custom views
   7. Attaching a comment to a cell
   8. Formula auditing
   9. Evaluating formulas
  10. The Watch Window

12. 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. If your needs are not too specific, these functionalities can even replace a database management system.

Total number of topics in the module: 9

   1. Creating and managing a table
   2. Formatting a table
   3. Automatic calculations in a table
   4. Automatic filtering
   5. Custom filters
   6. Blank cells and duplicates
   7. Criteria ranges
   8. Filtering and extracting rows using a criteria range
   9. Statistics with a criteria range

13. 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

14. 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

15. 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: 11

   1. Find and replace
   2. Checking spelling
   3. Hyperlink
   4. Creating and customising a theme
   5. Creating and working with templates
   6. Modifying and deleting templates
   7. Transfer, export: PDF, XPS, e-mail and Web page
   8. Converting Excel files
   9. Importing data
  10. Updating and managing imported data
  11. Workbook properties

16. 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: 7

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

17. 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