Excel Intermediate

Length of Programme: 3 hours

About the Workshop:

The Excel Intermediate Course covers a range of topics including:

* The IF function

* Nested IF

* The Lookup Function

* Validating Lookups

* IF?s With Lookups

* Data Functions

* The Auditing Toolbar

* Checking Errors

* Precedent and Dependent Tracing

* List Management

* Subtotals and Outlines

* Data Statistical Functions

* Goal Seek

* Scenarios

* Pivot Tables and Pivot Charts

Learning Objectives:

By the end of this course you will be able to:

* Query values within a spreadsheet

* Analyse data using advanced formulae

* Manage large amounts of data

* Create and manage pivot tables and charts

When you book on to this session you will be sent a short questionnaire designed to identify your particular development needs and goals. The course provider will use this information to focus the course content to your needs and to the needs of other participants on the course.

Participants:

This course is suitable for you if you:

* Require data to appear on a worksheet according to certain conditions

* Need to visually trace the logical flow of formulae across worksheet

* Need to map circular references

* Need to maintain a single list of up to a few thousand items in rows

Please use this link: https://lpdc.admin.keele.ac.uk/index.php/hr_courses to view all scheduled workshops.