Looking for the Intermediate Microsoft Word course? Click here |
Intermediate Microsoft Excel
Broaden your Excel skills through our online course, which covers pivot tables and charts, data validation, and conditional formatting.
Intermediate Microsoft Excel
£29.75
+VAT
Not in work?
Not a Job Centre Job Seeker?
You could qualify for FREE
Government Funded training
- Earn discounts
- Receive reminders
- Keep training records
- Track progress
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.
Popular Courses
Overview
This course combines The Digital College courses "Level One Award in Health and Safety in a Construction Environment" and "Preparation for the CITB health, safety and environment test" to enable you to attain a CSCS "Green Card" as quickly as possible. Nothing extra to pay; all training and exam costs included! You just pay for the card.
Overview
This is the official qualification required by local councils for anyone in England and Wales applying for a Personal Licence to serve or sell alcoholic drinks. This delivers the complete training package of online study, practice questions, an invigilated assessment and an official certificate to those that pass this qualification. The certificate can then be supplied to your local council as part of your Personal Licence application.
Overview
This bundle contains everything you need to gain a Personal Licence to authorise the sale of alcoholic drinks in England and Wales. This delivers the complete training package of online study, practice questions, an invigilated assessment and an official certificate to those that pass this qualification. We will then obtain a DBS certificate and apply to your local council on your behalf - saving you a lot of time and effort.
Overview
This Level 1 Award Health and Safety course and test, awarded by Highfield Qualifications, is aimed at learners who currently work, or want to work, in construction. Successful completion will enable you to move on to take the CITB health, safety and environment test, and then apply for the new Construction Skills Certificate Scheme (CSCS) Green Card. This card allows access to construction sites in the UK as a non-skilled worker and is designed to improved overall site safety.
Overview
Our Level 2 Award An Introduction to First Aid for Mental Health qualification will increase your awareness of common mental health issues, such as anxiety, depression and stress, that can have an impact on our everyday lives. You'll also obtain knowledge on how a mental health first aider can provide immediate "on the spot" care to others, while looking after their own mental wellbeing. Upon successful completion of the invigilated assessments, you will receive an official certificate. This qualification incorporates the Level 1 Award An Introduction to Mental Health and Wellbeing qualification.
Overview
Our Level 2 Food Hygiene certificate course covers food hygiene, food hazards, food poisoning, how food becomes unsafe, personal hygiene, awareness of contamination, time and temperature factors, proper cleaning and sanitising, premises and equipment and food handling responsibilities. This is perfect for anyone preparing or handling food.