Microsoft Excel - An Essential Guide (Level 1)

Aims

The aim of this session is for participants to understand the concept of a spreadsheet, worksheets, cells and cell referencing, what goes into cells (data, labels, calculations), charts, and formatting. You will also find out where and how you can learn more.

Objectives

By the end of the course participants will be able to:

• explain what spreadsheets are and what they can be used for
• use the Excel Help system
• create simple worksheets using data, labels and formulae
• understand cell formats
• use a named cell in a formula
• copy and paste formula (including using the cell handle)
• use simple functions - in particular, SUM and IF
• create and format charts; rotate a 3-D chart
• make use of the options available in Page Setup

Format

One 2-hour hands-on session, with additional demonstrations via overhead projection.