Description

After opening a new spreadsheet the format of the data and cells will be set to a default, which can be very plain and uninteresting. Using the formatting features within Excel you can 'jazz up' your worksheets putting emphasis on particular areas using colour and borders. This opportunity will build upon the skills covered in 'Excel 2003 - Getting started with spreadsheets', developing the essential skills needed to create more professional looking spreadsheets.

Content:

1. Be able to change the format of cells
2. Be able to change the row height and column width
3. Be able to change the font, colour, shading and background of your data
4. Be able to copy formatting from one cell range to another
5. Be able to change the border style of a cell/range of cells
6. Be able to wrap text within a cell and change its orientation
7. Be able to centre text over a range of cells
8. Be able to apply conditional formatting
9. Be able to use AutoFormat
10. Be able to change some of the print settings before printing

Level: Beginner

Audience: All education staff

Pre Skills: Competence in the basic skills in a Windows environment

Hardware: Personal computer (PC)

Software: Microsoft Excel 2003