Microsoft Excel Proficient User Online

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 some 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

Microsoft Excel Proficient User Online

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 some 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! ***

Related products

Microsoft Excel Proficient User

Microsoft Word Basic User

Microsoft Excel Intermediate User

Microsoft Word & Excel Beginners