An organisation development specialistLinked In

Excel Introduction 2010

Duration 1 day


Designed for

Those who have little or no knowledge of using a computerised spreadsheet program.

Pre-requisites

Delegates should have used a mouse and have knowledge of Microsoft Windows

A pre-course questionnaire is available for delegates to confirm their existing knowledge before attending this programme.

Course Aims

By the end of this course delegates will be able to create, edit, print and improve the appearance of spreadsheets. Delegates will also have learned how to construct formulae and different calculation types that are available. The course finishes with instruction in graphically representing your data and the various graph types that are available.

Course Contents

- Starting Excel
- Screen Familiarisation
- Moving Around
- Entering & Editing Data
- Help
- Saving/Opening Files
- Using AutoFill
- Printing and Print Preview
- Changing Column Widths & Row Heights
- Enhancing Worksheets Presentation using Borders, Colours, Patterns and Font Enhancements
- Entering Formulas & Mathematical Priorities
- Basic Functions
- Function Wizard
- Naming Cells
- Absolute and Relative Addressing
- Creating 2D & 3D Charts using Chart Quick Key and Chart Wizard
- Creating Picture Charts

More