Intermediate Microsoft Excel | The Digital College

back to courses

Intermediate Microsoft Excel

Digital Skills

Broaden your Excel skills through our online course, which covers pivot tables and charts, data validation, and conditional formatting.

Intermediate Microsoft Excel

Intermediate Microsoft Excel

£29.75

+VAT

Buy now

Not in work?

Not a Job Centre Job Seeker?

You could qualify for FREE

Government Funded training

Learn More
Buy now

  • Earn discounts
  • Receive reminders
  • Keep training records
  • Track progress
Intermediate Microsoft Excel

PayPal Buyer protection

Highfield Awarding Body

Mobile device friendly content

Subtitles: English

Duration: 1 hr 30 mins

Retakes: Unlimited


Overview

The Intermediate Microsoft Excel course provides insight into some of the more advanced functions of Excel for anyone looking to develop their Excel skills further. From pivot tables and charts, to functions and formulas, you’ll be equipped with the knowledge and skills you need to work with Excel on a more advanced level both at home and at work.


The course provides an exploration into some of Microsoft Excel’s more advanced functions in bite-sized units which contain narrated slides and demonstration videos to take you through the content in a simple manner.

Candidates will undertake an online multiple-choice assessment and will receive a certificate if successful (any certificates from an official awarding body are sent to you via email).

Course Syllabus

  • Course Introduction

    This unit provides an introduction to the Intermediate Microsoft Excel course, outlining the course structure and how the rest of the units cover the course content.


  • Pivot Tables & Charts

    We begin the course with a look at what pivot tables and pivot charts are. This unit also provides demonstrations for how to insert and edit pivot tables and charts in Excel, as well as the advantages of using pivot tables and charts.


  • Data Validation

    Now it is time to look at data validation. By the end of this unit, you will have a good understanding of what data validation is, the different types of data validation you can set, and how to set data validation.


  • Conditional Formatting

    We will look at what conditional formatting is, the various kinds of conditional formatting you can set for data, different rules you can apply through conditional formatting and how to apply conditional formatting to a set of data, as well as the positives of using this function.


  • Sparklines

    We are now halfway through this Intermediate Microsoft Excel course. We'll explore what sparklines are, the different kinds of sparklines you can create in Excel, and how to create sparklines in a spreadsheet, as well as the convenience of using sparklines.


  • Text to Columns

    In our penultimate unit, we'll examine the text to columns function, covering what it is, how you can apply it to a table of data, and why it's advantageous to use it.


  • Functions & Formulas

    We are now on the final unit of this Intermediate Microsoft Excel course. We'll learn the difference between a function and a formula, and explore the different functions you can use, including what each function does. This unit also covers writing your own formulas and the benefits of using functions and formulas.


Obtaining your certificate

You will need to pass a multiple-choice exam at the end of the course in order to gain your accreditation. Once passed, we will send your official certificate by email.

Intermediate Microsoft Excel

Broaden your Excel skills through our online course, which covers pivot tables and charts, data validation, and conditional formatting.

£29.75

+VAT

Buy now
Our cookie policy 🍪

The Digital College uses cookies and related methods to improve your experience of our website.

By accepting cookies and continuing to our site, you are agreeing to our use of cookies to customise your site experience, personalise the content we may show you, and tailor and measure the effectiveness of our marketing.

For more information, please see our Cookie Policy and Privacy Policy

Accept
Accept only necessary