Introduction to Excel

The course is designed for users new to Excel. It will provide trainees with the confidence, knowledge and practical experience to use Excel, to create and manipulate spreadsheets and produce printed reports.

Delegates should have sufficient Windows experience beforehand.

Equipment: No equipment is necessary for you to bring to the course. Pens and note paper will be available.

Lunch provided: Lunch and refreshments will be provided throughout the course.

Course Content
The Excel Screen

Ribbons, Quick Access Toolbar, Formula Bar, and Status Bar

Workbooks and Sheet Tabs

Data Entry

Types of Data

Data Entry Techniques

In Cell Editing

Selecting

Cut/Copy/Paste

Drag & Drop

Using AutoFill to fill Adjacent Cells and Extend Series, Custom Lists

Formulae and Functions

Simple formulas & Functions

Relative and Absolute References

Named Ranges

AutoSum

AutoFill

Paste Function

Average, Max, Min & Count Functions

Multiple Panes

Freeze and Unfreeze

Formatting a Worksheet

Using Borders and Shading to improve presentation

Font & Number Formatting, Alignment

Printing

Print Preview & Setup

Headers & Footers

Print Row/Column headings

File Management

Saving, Closing and opening files

New Workbooks

Good Working Practice

Creating a Chart

Creating Charts

An explanation of different versions

Course costs £109 per person. For more details please contact us at [email protected] or on 01603 788950.