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, and we'll show you how to use the Quick Analyse tool.

Tutor-led Course
Self-paced Course

Tutor-led Course

Tutor-led training, delivered 1-to-1 and to small groups!

Customised learning

Training can be customised to cover specific topics. Learn all topics from the course outline, or learn just what you need to know – you decide!

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.

Duration

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

Location

We can provide 1-to-1 training at our Aberdeen Training Centre. Business group training courses can be delivered onsite in the Aberdeen area and in cities throughout Scotland.

Remote learning

1-to-1 training can be delivered using Microsoft Teams.

Self-paced course

You'll get 12 months’ access to the self-paced online version of the course – you’ll be able to work through the course lessons at your leisure. Email support is available from your EC-PC Tutor when required.

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 have the option to obtain the EC-PC Microsoft Excel Intermediate User Certificate. To obtain the certificate you’ll need to complete the self-paced online course and pass a practical assessment.

Self-paced Course

Learn online at your own speed, with support from an EC-PC Tutor!

Learn by watching short video lessons

The course is made up of short bite-sized video lessons, watch each video then try out what you've been shown.

Get tutor support

Your EC-PC Tutor will support you during the course, answering any questions by email. Telephone and remote support is also available when appropriate.

Obtain certification

You'll have the option to complete an assessment – pass the assessment and you’ll receive 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. You'll need a Windows PC, with a reliable broadband connection, installed with the latest version of Microsoft Excel.

Get this course as part of an EC-PC.COM subscription!

Funding Opportunities

If you live in Scotland you could be eligible to apply for funding to pay for the 5 Hour Customised 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 Course – Apply for Funding

Aberdeen Course – Apply for Funding

What did others think of this course…

"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.

Tutor-led training, delivered 1-to-1 and to small groups!

Customised learning

Training can be customised to cover specific topics. Learn all topics from the course outline, or learn just what you need to know – you decide!

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.

Duration

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

Location

We can provide 1-to-1 training at our Aberdeen Training Centre. Business group training courses can be delivered onsite in the Aberdeen area and in cities throughout Scotland.

Remote learning

1-to-1 training can be delivered using Microsoft Teams.

Self-paced course

You'll get 12 months’ access to the self-paced online version of the course – you’ll be able to work through the course lessons at your leisure. Email support is available from your EC-PC Tutor when required.

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 have the option to obtain the EC-PC Microsoft Excel Intermediate User Certificate. To obtain the certificate you’ll need to complete the self-paced online course and pass a practical assessment.

Learn online at your own speed, with support from an EC-PC Tutor!

Learn by watching short video lessons

The course is made up of short bite-sized video lessons, watch each video then try out what you've been shown.

Get tutor support

Your EC-PC Tutor will support you during the course, answering any questions by email. Telephone and remote support is also available when appropriate.

Obtain certification

You'll have the option to complete an assessment – pass the assessment and you’ll receive 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. You'll need a Windows PC, with a reliable broadband connection, installed with the latest version of Microsoft Excel.

Get this course as part of an EC-PC.COM subscription!

Funding Opportunities

If you live in Scotland you could be eligible to apply for funding to pay for the 5 Hour Customised 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 Course – Apply for Funding

Aberdeen Course – Apply for Funding

Related products

Microsoft Excel Proficient User

Microsoft Word Basic User

Microsoft Word Intermediate User

Microsoft Excel Spreadsheets For Managers

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