Course advisor's notes

This half day seminar is held at our five Pitman Training Centres in Scotland (see below for full details) and helps advanced users of Excel streamline tasks. More information...

Email a friend

 

Seminar Content | Excel Super User

Streamline your workflow - no matter what we do, there are always repetitive tasks, Macros will alleviate these dull tasks.
Collaborating with others - you have learnt how to stop people from altering your data, but let’s suppose others have access – how do you know where they have been and what they did?
Auditing Worksheets - identify which cells will alter if you change one or, what happens to formula if you delete a particular cell.
Analysing data - analysis, understanding and presentation of data is a key feature of Excel, Pivot Tables are the answer.
Importing and exporting data - export your data into Word, publish your worksheet to the web or import from the web

Aims and Objectives

To complete students knowledge of Excel in order to support others who use this powerful tool.

Target Audience

Advanced users of Excel.

Prerequisites

A knowledge in:
Data entry.
Formatting.
Formula.
Printing.
Create charts and Graphics.
Advanced formula.
Sorting and filtering data.
Validation and protection.
Subtotals.

Seminar Code

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

::adCenter::