Microsoft Excel Proficient User

Training Course

This advanced online course builds on your existing Microsoft Excel skills and knowledge. Learn how to use the tools, formulas and techniques that are used in the workplace by proficient users.

On this course we'll start by showing you how to use grouping and auditing tools, and how to work with tables and setup advanced filters. The course will show you how to insert and understand nested functions. You'll also setup advanced conditional formatting and learn ways to identify blanks cells, find duplicate data and work with PivotTables. We end the course by showing you how to get started creating and using Macros!

Learn by watching short video lessons
The course is made up of short bite-sized video lessons.

Download practice files
You’ll be able to download the files used in the video lessons and try out what you’ve been shown. You’ll also be able to download additional exercises.

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.

Requirements
You’ll need good existing skills using Microsoft Excel, eg be familiar with the majority of topics covered on our Microsoft Excel Intermediate User course. You’ll need a Windows PC, with a reliable broadband connection, installed with the latest version of Microsoft Excel.

* Video lessons are currently being produced – 5 lessons each week *

Funding Opportunities

If you live in Scotland you could be eligible to apply for funding to pay for part of 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.

Apply Online

Microsoft Excel Proficient User

Training Course

This advanced online course builds on your existing Microsoft Excel skills and knowledge. Learn how to use the tools, formulas and techniques that are used in the workplace by proficient users.

Learn by watching short video lessons The course is made up of short bite-sized video lessons.

Download practice files You’ll be able to download the files used in the video lessons and try out what you’ve been shown. You’ll also be able to download additional exercises.

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.

Requirements You’ll need good existing skills using Microsoft Excel, eg be familiar with the majority of topics covered on our Microsoft Excel Intermediate User course. You’ll need a Windows PC, with a reliable broadband connection, installed with the latest version of Microsoft Excel.

*** Video lessons are currently being produced – 5 lessons each week ***

Funding Opportunities

If you live in Scotland you could be eligible to apply for funding to pay for part of 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.

Apply Online

Related products

Windows, Files and Folders Basic User

Microsoft Excel Proficient User

Microsoft Outlook Basic User

Windows, Files and Folders Intermediate User

Learn by watching short video lessons
The course is made up of short bite-sized video lessons.

Download practice files
You’ll be able to download the files used in the video lessons and try out what you’ve been shown. You’ll also be able to download additional exercises.

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.

Requirements
You’ll need good existing skills using Microsoft Excel, eg be familiar with the majority of topics covered on our Microsoft Excel Intermediate User course. You’ll need a Windows PC, with a reliable broadband connection, installed with the latest version of Microsoft Excel.

* Video lessons are currently being produced – 5 lessons each week *