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.
The guideline learning time for this course is 18-20 hours.
Our Microsoft Excel Expert course is part of our distance learning range – which can be accessed online via our distance learning portal.
This means that you have the flexibility to study our Excel Expert course:
- In centre, with our friendly course advisors available for support and guidance as and when you need it.
- At home or from work – with support via email or telephone during working hours.
- On a blended mix – in-centre for the modules you need help with, at home or from work for those you are gliding through.
Once you’ve decided to go ahead, all you’ll need to do is contact your nearest Pitman Training centre that offers and supports our distance learning platform, and they will arrange for you to have an induction to show you around the system and talk you through how our online training works. After this, you can learn in your own time and at your own speed, but with the knowledge you have support at hand if required.
To find your nearest centre that offers and supports our online Microsoft Excel training, click here.