Excel 2007
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