Microsoft Excel Intermediate

This intermediate course is recommended for anybody who may use Excel at home or in the workplace for simple tasks such as tracking modest costs or computing sums or totals.

Overview

Microsoft Excel is one of the most extensively used programmes in the world for visualising and analysing data. This programme is utilised in nearly every business, not to mention in families all around the world. Excel is used by small company owners to monitor hours, money, and invoicing, and by major businesses for data analysis, data visualisation, and a variety of other functions.

This series of classes can help you whether you are fresh new to the world of Excel or you have training and experience of the programme and want to enhance your abilities. By the end of the beginning, intermediate, and advanced courses, you will be an Excel expert as well.

Why should I complete the Microsoft Excel Intermediate Course ?

This Microsoft office course is an all-in-one full MS office training course for beginners through experts. If you work in any sector such as engineering, auditing, data analysing, data entry, or if you are a student, teacher, or researcher, or if you work in a field where any of these three Microsoft Office products are utilised, you may select this course to obtain the skill as per your demand.

Modules

Learning more about intermediate Excel functions including ABS, SUMIF, HLOOKUP, VLOOKUP, COUNTIF, AVERAGEIF, AVERAGEIFS, and AVERAGEA
Data validation with date, list, time, and numbers
Functions such as RANK, MIN, MAX, CHAR, MODE, MEDIAN, CODE, CLEAN, and EXACT
How to remove duplicates in Excel
Creating random numbers
Changing text case
Adding passwords
Sending emails from Excel
Adding custom backgrounds
How to auto fill data
Adding special characters
Changing border colour and theme

Entry Requirements

Don't worry, no prior familiarity with Microsoft Excel is required to take this session. This training is intended for those who have never used Excel before. You simply need a basic grasp of computers and Windows to attend. You'll be alright if you know how to work with several windows, traverse the desktop, and save a file.

How to Apply

Each of our courses has different entry requirements and a different admission process. We encourage you to look at our course pages and the How to apply section for detailed information.

This course is currently only available online in instructor-led format. Classes will take place via GoTo Webinar and Microsoft Teams. For more information please contact us.

FEE

For information regarding fees please scroll down to the pricing section.

Please consider that we are currently not offering in-class lessons due to Covid restrictions.

TIMETABLE

For information regarding the timetable for this course, please scroll down to review the full dates and availability

DURATION

1-5 days

WHATS INCLUDED

Course Material
Case Study
Experienced Lecturer
Refreshments
Certificate

Package Deals

For package deals please enquire now and speak to a member of our team.

Learning more about intermediate Excel functions including ABS,
SUMIF, HLOOKUP, VLOOKUP, COUNTIF, AVERAGEIF, AVERAGEIFS,
and AVERAGEA
Data validation with date, list, time, and numbers
Functions such as RANK, MIN, MAX, CHAR, MODE, MEDIAN, CODE,
CLEAN, and EXACT
How to remove duplicates in Excel
Creating random numbers
Changing text case
Adding passwords
Sending emails from Excel
Adding custom backgrounds
How to auto fill data
Adding special characters
Changing border colour and theme