Microsoft Excel

Aims

Microsoft Excel is a spreadsheet programme which supports the creation of financial, statistical and other reports using formulae and functions. Microsoft Excel is enormously powerful and flexible and has a reputation as the most widely used spreadsheet application. Very few users venture beyond the basics and therefore do not exploit the benefits of this formidable application.

Structure

Microsoft Excel can be delivered to introductory, intermediate and advanced level. Each level is scheduled into a 1-day programme which is trainer led.

Content

This course will cover the following topics:

Introductory Level:

• Understand the principles of a Worksheet and Workbook

• Create, edit, save and retrieve spreadsheets

• Copy and move data

• Construct formulae and use functions

• Format text and numbers

Intermediate Level:

• Link formulae and use more functions

• Work with multiple worksheets and workbooks

• Consolidate data

• Create and customise charts

• Create hyperlinks

Advanced Level:

• Use the Group feature

• Protect workbooks, worksheets, cell ranges, add/remove a password

• Understand, apply, modify, create styles

• Use linking formulas

• Understand and use data consolidation

• Use advanced functions

• Understand, manage and create a scenario manager

Associated Courses

Expand your knowledge and skills and book on to the following related courses:

• Microsoft Excel Charts & Graphs

• Microsoft Access

Suitable for

As a working knowledge of the full range of ICT packages is becoming a core competence within any workforce, this programme would be suitable for anyone who works with or manipulates data at any level within an organisation.

Cost

£175 (ex VAT) / level – includes all course materials, refreshments and a 2 course lunch at our 1835 Restaurant.

Tailored

As well as being open to any individual, this course can be delivered:

• to meet individual company requirements

• to company housestyles and templates

• within company premises

• specifically to a group or team of staff

Course Dates & Booking

Print Factsheet

Make an Enquiry

News and Events
Find Out More ››

Current Promotions
Find Out More ››