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!

1-to-1 instructor-led training and self-paced learning

1-to-1 instructor-led training and self-paced learning

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

Training times are flexible - training can be delivered all in 1 day, or over shorter sessions (eg lasting 1 or 2 hours).

Remote learning and in-person training

Training can be delivered remotely using Microsoft Teams. We can also provide in-person training sessions at our Aberdeen Training Centre or onsite at client business premises subject to location.

Self-paced learning

You'll get 12 months access to the self-paced online course. You’ll be able to watch short bite-sized video lessons and download practice files.

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 (if you don’t have Microsoft 365 you can download a free trial for 1 month).

Notes

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

Certification

You’ll receive an eCertificate of Attendance confirming the number of instructor-led training hours. 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.

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.

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

Training times are flexible - training can be delivered all in 1 day, or over shorter sessions (eg lasting 1 or 2 hours).

Remote learning and in-person training

Training can be delivered remotely using Microsoft Teams. We can also provide in-person training sessions at our Aberdeen Training Centre or onsite at client business premises subject to location.

Self-paced learning

You'll get 12 months access to the self-paced online course. You’ll be able to watch short bite-sized video lessons and download practice files.

Requirements

Notes

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

Certification

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

Microsoft Outlook Intermediate User OLD

Microsoft Word Proficient User

Microsoft PowerPoint Basic User

Microsoft Outlook Basic 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!"