Description

Excel 2007 is part of the Microsoft Office suite of programs and is a very powerful spreadsheet program organised into worksheets.
A spreadsheet is an application that provides you with the tools necessary to create tables of data and perform calculations. Worksheets commonly use cells where you can enter text, numbers or formulae, the ability to control the format of that text (font, bold, italics and size), indenting, margins, the ability to check spelling. Many worksheets also handle graphics to varying degrees.

This guide will take you through the basics of creating and using an Excel 2007 spreadsheet.

Content:

1. Enter data in a worksheet
2. Save a worksheet
3. Print a worksheet
4. Use cell references
5. Apply number formatting
6. Apply conditional formatting
7. Apply text formatting
8. Use simple formulae
9. Work with multiple worksheets
10. Add borders to cells
11. Sort data
12. Replicate formulae

Level: Beginner

Audience: All education staff

Pre Skills:

1. Basic mouse and keyboard skills
2. Basic skills in Windows XP

Hardware: Personal computer (PC)

Software: Microsoft Excel 2007