Microsoft Excel Intermediate User

Training Course

Get more efficient using Microsoft Excel - 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 work effectively with spreadsheets and use tools to quickly organise, present and visualise data. You'll learn how to use intermediate formulas and functions - eg SUMIF, IF, VLOOKUP etc. We end the course showing you the power of PivotTables to quickly summarise data!

4 Hours of 1-to-1 training

You’ll receive 4 hours of 1-to-1 training from an EC-PC Tutor. During the training sessions we’ll cover core topics from the course, or we can customise the sessions to cover 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.

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

In addition to the instructor-led training you’ll also get 12 months access to the online self-paced version of the course, containing additional topics! You’ll be able to watch short video lessons, download practice files and get tutor help if required!

Certification

Once you have completed the online course we’ll send you a practical assessment. Pass the assessment and you’ll receive the following e-Certificate: EC-PC Microsoft Excel Intermediate User.

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

Get more efficient using Microsoft Excel - 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

Microsoft Word & Excel Beginners Plus

Microsoft Word Intermediate User

Microsoft Word & Excel Beginners

Microsoft Excel 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!"