ICT932 Excel 2007 Getting Started
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:
- Enter data in a worksheet
- Save a worksheet
- Print a worksheet
- Use cell references
- Apply number formatting
- Apply conditional formatting
- Apply text formatting
- Use simple formulae
- Work with multiple worksheets
- Add borders to cells
- Sort data
- Replicate formulae
Level: Beginner
Audience: All education staff
Pre Skills:
- Basic mouse and keyboard skills
- Basic skills in Windows XP
Hardware: Personal computer (PC)
Software: Microsoft Excel 2007
