t. +44 (0)1582 463463
e. contact@tihtc.co.uk
t. 01582 463463
e. contact@tihtc.co.uk

Excel – advanced

A one-day workshop

This course focuses on pivot tables to comparing percentages, create field calculations, and build reports. It also looks at utilising powerful formulas to generate results from a range of criteria and retrieving data from an external file with lookup formulas.

Also included are what-if analyses tools to meet projected targets and looks at forecasting by generating varying scenarios.

This course finishes with a look at recording macros to quickly automate what would otherwise be repetitive manual tasks. Understanding how macros work and how to utilise them to add an extra dimension to spreadsheets.

learning objectives

Who should attend?

Attendees are required to be familiar with Excel intermediate level content, for example knowledge of writing formulas, and basic conditional formatting before attending this course.

Format

A very practical, interactive one-day session for a maximum group size of 12. Comprehensive materials provided.

Expert trainer

Alan became a professional IT trainer in 1995, when on completion of an NVQ accreditation in IT, the organisation providing the course, Apex North London, asked if he would like to join their team, which he happily did. Alan went on to become a City & Guilds Assessor with them.

Session outline

1. Nesting formulas

2. Data validation

3. Lookup functions

4. Advanced pivot tables

5. Advanced conditional formatting

6. Summing by criteria

7. What-if analysis

8. Recording macros

Multiple delivery formats and options
users

Face-to-face delivery

monitor-code

Virtual delivery

fingerprint

Tailored solutions