Excel Expert

For those who have a basic grounding in Microsoft Excel, this course will provide you with the knowledge and skills to use MS Excel at an advanced level.

To get the most out of this course, you will need to have completed our entry-level Microsoft Excel course or have the equivalent experience of this extremely popular software.

Like all our Excel courses, you will be given a workbook to use as you progress through the course, which will be yours to take away as a handy reference guide.

You can also be confident that you’ll possess the top skills being sought by employers.

You’ll also have the powerful Pitman Training name on your CV, as a quality mark of achievement. To continue your training, we'd urge you to look at our other Microsoft Office courses, or our Microsoft Office Plus Diploma.

Microsoft Excel training moves to another level with this course which takes you on to an advanced level.

On successful completion of this course, you will be in a position to take the City & Guilds Spreadsheet Processing Techniques Intermediate exam, as well as the Microsoft Office Specialist test (MOS) and ECDL Advanced (Spreadsheets) exam.

If you frequently use Excel, and want to learn even more features of this comprehensive software, our Microsoft Excel Expert course is the one for you.

To get the most out of this course, you will need to have completed our Excel course or have the equivalent experience of this popular software.

This course is split into eight lessons. You’ll become confident in a range of Excel’s more sophisticated features including using AutoFill, creating and working with tables, using/hiding worksheets, custom formats; defining, using and managing named ranges; using conditional formatting and filtering data; recording and running macros; summarising data, database functions and pivot tables; using data across worksheets, switching between workbooks and workbook templates; worksheet, file and cell properties and using Excel’s statistical functions.

Our Microsoft Excel Expert course is part of our distance learning range – which can be accessed online via our distance learning portal.