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 be more productive using Microsoft Excel. We'll show you how to use tools to organise and visualise data. You'll increase your knowledge of using formulas and inserting functions - eg TODAY, SUM, SUMIF, VLOOKUP, IF etc. We end the course showing you the power of PivotTables to quickly summarise your data!

4 Hours of 1-to-1 training

Our 1-to-1 training sessions can be customised to cover core topics from the course – learn what you need to know!

Flexible training times

Training can be delivered all in 1 day, or over a period of time (eg 1 hour a week for 4 weeks).

Learn online or face-to-face

Training can be delivered remotely using Microsoft Teams, or face-to-face at our Aberdeen Training Centre. We can also provide customised onsite training for 1 or more delegates – please contact us for a quote.

User-friendly notes

If you attend a face-to-face course you’ll receive a printed training manual. For remote courses we’ll send you a PDF manual.

Online self-paced learning

You’ll get 12 months access to work through the self-paced online course. You’ll be able to watch short bite-sized video lessons, download practice files and get tutor support if you need help.

Certification

If you complete the self-paced online course, you’ll then have the option to work through a practical assessment – pass the assessment and you’ll obtain the EC-PC Microsoft Excel Intermediate User Certificate.

Requirements

You’ll need some existing skills using Microsoft Excel, eg be familiar with the majority of topics covered on our Microsoft Excel Basic User course. To complete the course online you’ll need a Windows PC installed with Microsoft 365.

Cost

£200

Funding Opportunities

If you live in Scotland you could be eligible to apply for funding to pay for the course with an SDS Individual Training Account (ITA) from Skills Development Scotland.

You can apply for ITA funding if you are 16 or over and you are:

– unemployed and on benefits

– not working and have no income

– employed with an annual income less than £22,000

– self-employed with an annual income less than £22,000

You will not be eligible to apply for ITA funding if you are in education or involved in any other SDS funded programme.

FAQs

Q: I am currently on benefits, will I be able to apply for ITA funding?

A: Yes

Q: I have no income but my partner/husband/wife works, will I be able to apply for ITA funding?

A: Yes

Q: I am self-employed and earn less than £22,000 per annum, will I be able to apply for ITA funding?

A: Yes

Q: I am employed and earn less than £22,000 per annum, will I be able to apply for ITA funding?

A: Yes

Q: How do I apply for ITA funding?

A: Complete an online application on the My World of Work website.

Online 4 Hour Instructor-led Course – Apply for Funding

Aberdeen 4 Hour Instructor-led Course – Apply for Funding

What did others think of this course…

"I learned a lot from the course. Some useful tips and techniques to apply, especially where I am dealing with large spreadsheets with thousands of rows of data. I was able to use real-life examples of files I use in my role, that was helpful."

Gail Robertson

"Kelvin was very open and responsive to queries. His friendly manner made the course enjoyable. The comprehensive booklet (with visuals/screenshots) will be a God-send and will be our bible going forward! Thanks!

Suz Strachan

"Great delivery - relaxing environment and delivered at a good pace that suited all parties, course was tailored to exactly our specifications and everyone came away feel much more confident and excited about using knowledge learned."

Katie McNutt

"Great course, good content throughout, good delivery."

Ryan Scott

"I liked the flexibility of the course, remote meeting via Zoom or in person and adaptability of the course to fit my prior excel experience (daily for years) however with no formal training. This course really filled out my knowledge of Excel."

Graham Cullen

The course was excellent, I have learned a lot. Very well taught by Kelvin, he is very knowledgeable. Nice and easy to follow even when done via the Teams app!"

Naomi Travis

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.

Funding Opportunities

If you live in Scotland you could be eligible to apply for funding to pay for the course with an SDS Individual Training Account (ITA) from Skills Development Scotland.

You can apply for ITA funding if you are 16 or over and you are:

– unemployed and on benefits

– not working and have no income

– employed with an annual income less than £22,000

– self-employed with an annual income less than £22,000

You will not be eligible to apply for ITA funding if you are in education or involved in any other SDS funded programme.

FAQs

Q: I am currently on benefits, will I be able to apply for ITA funding?

A: Yes

Q: I have no income but my partner/husband/wife works, will I be able to apply for ITA funding?

A: Yes

Q: I am self-employed and earn less than £22,000 per annum, will I be able to apply for ITA funding?

A: Yes

Q: I am employed and earn less than £22,000 per annum, will I be able to apply for ITA funding?

A: Yes

Q: How do I apply for ITA funding?

A: Complete an online application on the My World of Work website.

Online 4 Hour Instructor-led Course – Apply for Funding

Aberdeen 4 Hour Instructor-led Course – Apply for Funding

Related products

EC-PC Office IT Basic User

Microsoft Excel Basic User

Microsoft Word Intermediate User

Microsoft PowerPoint Intermediate User

"I learned a lot from the course. Some useful tips and techniques to apply, especially where I am dealing with large spreadsheets with thousands of rows of data. I was able to use real-life examples of files I use in my role, that was helpful."

"Kelvin was very open and responsive to queries. His friendly manner made the course enjoyable. The comprehensive booklet (with visuals/screenshots) will be a God-send and will be our bible going forward! Thanks!

"Great delivery - relaxing environment and delivered at a good pace that suited all parties, course was tailored to exactly our specifications and everyone came away feel much more confident and excited about using knowledge learned."

"Great course, good content throughout, good delivery."

"I liked the flexibility of the course, remote meeting via Zoom or in person and adaptability of the course to fit my prior excel experience (daily for years) however with no formal training. This course really filled out my knowledge of Excel."

The course was excellent, I have learned a lot. Very well taught by Kelvin, he is very knowledgeable. Nice and easy to follow even when done via the Teams app!"