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