Description

Course

Designed for users with a working knowledge of Excel and enables you to produce complex worksheets and reports.

By the end of this session, delegates will be able to produce data tables and charts using pivot tables, lookup functions and enable the production of analysed data.

You are welcome to bring along an Excel spread sheet that you are working on.

Who would benefit from this course?

This course is designed for people who are currently using excel and want to learn more to improve accuracy and quality of finance reporting.

Topics covered

LookUp Tables

• Producing closest and exact match VLOOKUP’s
• Produce a HLookUp
• Understand when to use a LookUp

Pivot tables & charts

• Create pivot tables from a set of data
• Create pivot charts
• Change chart type and format
• Add/remove legends, data labels, title and additional data

Useful Functions

• Identifying and correcting errors
• Naming a range of cells
• Find and replace text or data
• Advanced formatting eg negative numbers colour change
• Removal of duplicates
• Subtotal

Workbook security

• Add a password to a workbook
• Protecting worksheets
• Protecting elements of a worksheet
• Applying workbook security

Validity and accuracy

• Error checking
• Checking validity of results

Data Validation

• Applying data validation rules to cells for continuity
• Adding drop-down lists to cells for user selection

Venue

Centre Delivery – or at business premises by request.
Delivery can be one-to-one or group.

Duration

Full day