Microsoft Excel Intermediate User

Training Course

This course will show you how to use Microsoft Excel effectively at intermediate level. Learn the shortcuts, the tools and the formulas that are used in the workplace by experienced Excel users.

On this course you'll learn how to become more productive using Microsoft Excel. The course will increase your knowledge of using formulas and inserting functions - eg TODAY, SUM, SUMIF, VLOOKUP, IF etc. We'll also show you how to create drop-down lists, sort data, filter data and setup conditional formatting. We end the course showing you the power of PivotTables to quickly summarise your data.

Course Information

Duration
1 day (5 to 6 hours approx).

Requirements
Learners should have some experience using Microsoft Excel, eg be familiar with the majority of topics covered on our Microsoft Excel Beginners Plus course.

Course Notes
Learners will receive user-friendly course notes for future reference.

Version
The course is delivered using Microsoft Excel Office 365. We can provide training using other versions of Microsoft Excel on request.

Certification
Learners who complete the course will receive the following e-Certificate: EC-PC Microsoft Excel Intermediate User. The certificate may be used as evidence of CPD depending on the requirements of the learner’s profession.

Delivery Locations
The course can be delivered at locations throughout the UK including: Aberdeen, Dundee, Edinburgh, Glasgow, Inverness, Perth, Stirling, Birmingham, London, Manchester, Reading, Slough.