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. We'll also look at how to setup advanced conditional formatting, and you'll learn ways to identify blanks cells and find duplicate data. We end the course by showing you how to get proficient with PivotTables!

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.

Obtain certification
Once you complete the course assessment you’ll receive the following e-Certificate: EC-PC Microsoft Excel Proficient User.

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.

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

* Video lessons will be released in small bite-sized chunks – 5 lessons each week *

The course covers the following topics:

use grouping tools
use formula auditing tools
use Excel tables
use named cells and ranges
use an advanced filter
use data validation
use What-if analysis
use the IF Function
use the AND Function
use the OR Function
use functions to lookup data
use conditional formatting
use an array formula
use tools to identify blank cells
use tools to find duplicates
use PivotTables.

View Course Outline

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.

Obtain certification Once you complete the course assessment you’ll receive the following e-Certificate: EC-PC Microsoft Excel Proficient User.

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.

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

*** Video lessons will be released in small bite-sized chunks – 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

Microsoft Outlook Intermediate User OLD

Microsoft Excel Basic User

Microsoft Excel Intermediate User Demo lessons

Microsoft Word Basic 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.

Obtain certification
Once you complete the course assessment you’ll receive the following e-Certificate: EC-PC Microsoft Excel Proficient User.

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 will be released in small bite-sized chunks – 5 lessons each week *