Course advisor's notes

This 1 day seminar is held at our five Pitman Training Centres in Scotland (see below for full details) and helps you to take Excel to the next level making an impact on your work and saving you hours of time. More information...

Email a friend

 

Seminar Content | Excel Optimise

Create charts and Graphics - allows data to be assessed and compared easily.
Advanced formula - fear and myths surrounding more complex formula are shattered.
Sorting and filtering data - sort your data quickly and easily and learn how to use filters to extract the data you require and then perform calculations on it.
Validation and protection - ok, so you give others access to your data, but how will you ensure they enter the right data in the correct format?
Subtotals - condense your data into manageable chunks and utilise features such as Add & Average.

Aims and Objectives

Learn how to optimise Excel.

Target Audience

Those who already have a good understanding of Excel and wish to enhance their current knoweldge of this.

Prerequisites

A knowledge of:
Data entry.
Formatting.
Formula.
Printing.

Seminar Code

PITMAN TRAINING EDINBURGH, GLASGOW, ABERDEEN, FORRES & DUMFRIES ONLY

::adCenter::