Course Details

  • Course Code: UKFEC16MXI
  • Location: Online
  • Duration: 10 hours
  • Cost: £199.00
  • Qualification: All modern browsers and devices

Further Details

  • Course Access: 12 months
  • Exams Included: Yes
  • Compatibility: All major devices and browsers

Approved Course:

A005786



MS Excel Intermediate Course

Please Note: This course uses the Windows version of Microsoft Office 2016. Any other versions will have some differences in the functions.

The MS Excel Intermediate Course will take what you learnt in the beginners course and expand upon it. Additionally, this course will teach you more advanced concepts than those that were presented in the beginners course.

What you will learn

Some of the highlights of the intermediate Excel course include the following:

  • Learning more about intermediate Excel functions including ABS, 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
  • How to use Templates
  • Insert Charts
  • Adding custom backgrounds
  • How to use Tables
  • How to auto fill data
  • Adding special characters
  • Changing border colour and theme

Before jumping into the MS Excel Intermediate course, one should have a good basic overview of the beginner Excel functions. Those with experience in Excel might feel as if they can skip the beginner course, but it is best to at least go through the course and review it before starting the intermediate curriculum.

Like the beginner course, the intermediate course is set up into short modules, and you can watch the module videos on any device that can connect to the internet. The curriculum in the intermediate course is designed for those who work with Excel in the workplace, and it is primarily for those who want to improve their skills with this program. There is a lot of useful information found in this course, and these skills are necessary for anyone who is going into investments, banking, or consulting, and will also be useful for administrators or for those who track or analyse a lot of data. If you are someone who is new to the workforce, you, too, will find that employers are looking for candidates with at least intermediate Excel skills.

The course teaches students how to use functions, including AVERAGEA, AVERAGEIF, AVERAGEIFS and ABS. You will also learn data validation information and students work through several modules, each of which are focused on a type of data validation, such as date, list, and time. The course deals with more information on specific functions, which include CHAR, CODE, MEDIAN, MODE, and ROUND. Additional information is given on how to manipulate these functions to meet your needs as an Excel user.

Other information in the MS Excel Intermediate Course includes how to change the text in Excel, i.e. changing text to all upper case or lower case. You will also learn how to change the background and add a custom image, how to use AutoFill and how to insert special characters.

Upon completion of this course, you will know about most of the functions that Excel has, and how to use this software at an intermediate level. Additionally, you will have the skills necessary to use Excel in most business environments. You will also be fully prepared to begin the MS Excel Advanced Course.



Course Modules/Lessons

Module 1: SumProduct Formula

Module 2 : Data Validation With Date

Module 3 : Data Validation with Whole Numbers

Module 4 : Data Validation with List Feature

Module 5 : ABS Function

Module 6 : CHAR Function

Module 7 : CLEAN Function

Module 8 : CODE Function

Module 9 : EXACT Function

Module 10 : AVERAGEA Function

Module 11 : AVERAGEIF

Module 12 : AVERAGEIFS Function

Module 13 : CELL Function With 10 Variations

Module 14 : LARGE Function

Module 15: MAX Function

Module 16: MEDIAN Function

Module 17: MIN Function

Module 18: MODE Function

Module 19 : N Function

Module 20 : RANDBETWEEN Function (Insert Random Numbers)

Module 21 : RANK Function

Module 22 : Remove Duplicate Values

Module 23 : ROUND Function Up/Down

Module 24 : Add Custom Background Image

Module 25: Change Text To Lower Case

Module 26: Change Text To Upper Case

Module 27: Change Text To Proper Case

Module 28: Insert Special Character

Module 29: Use Autofill : A Time Saving Trick

Module 30: Treemap Chart

Module 31: Sunburst Chart

Module 32: Use Tables

Module 33: Use Templates

Module 34: Use Themes

I would highly recommend

Fantastic course with great instruction and demonstrations.

I can already feel the benefit of this course whilst at work through improved efficiency and the handy tips I have picked up.

I have been using Excel for years now and I really regret not seeking some tuition sooner as I have learnt so many simple but useful things that can really make a difference straight away.

Very pleased with this provider and looking forward to the advanced level and possibly further courses in the future.

I would highly recommend this to anyone wishing to enhance their current knowledge or as a refresher.

Jordan Price – Swindon



Example Certificate


Certificate No CERTIDNO
This certificate is to verify that
Your Name

has successfully completed the
MICROSOFT EXCEL INTERMEDIATE CERTIFICATE
on the
10th October 2024

A005786
Daniel Morgan
Head Tutor
Igrow Academy

This certificate can be verified online at:
https://igrowacademy.co.uk

START THE MICROSOFT EXCEL INTERMEDIATE CERTIFICATE NOW



FAQ's

  • Who can take the Microsoft Excel Intermediate Certificate course?

    Anyone who has an interest in learning more about this subject matter is encouraged to take the course. There are no entry requirements to take the course.

  • What is the structure of the course?

    The course is broken down into 34 individual modules. Each module takes between 20 and 90 minutes on average to study. Although you are free to spend as much or as little time as you feel necessary on each module, simply log in and out of the course at your convenience.

  • Where / when can I study the course?

    You can study the course any time you like. Simply log in and out of the web based course as often as you require. The course is compatible with all computers, tablet devices and smart phones so you can even study while on the move!

  • Is there a test at the end of the course?

    Once you have completed all 34 modules there is a multiple choice test. The questions will be on a range of topics found within the 34 modules. The test, like the course, is online and can be taken a time and location of your choosing.

  • What is the pass mark for the final test?

    The pass mark for the test is 70%.

  • What happens if I fail the test?

    If you don’t pass the test first time you will get further opportunities to take the test again after extra study. There are no limits to the number of times you can take the test. All test retakes are included within the price of the course.

  • When will I receive my certificate?

    Once you have completed your test you can log in to your account and download/print your certificate any time you need it. If you would prefer us to post you a certificate to a UK address, there will be an admin charge of £10 (certificates sent internationally may cost more).

  • How can I pay?

    You can either use your Visa, MasterCard, American Express, Solo cards or PayPal account to pay for the online course. Our site uses the latest SSL encryption to ensure your safety. All payments are handled securely by PayPal.

  • How long after payment can I begin the course?

    You can begin the course immediately after your payment has been received. You will create your login details during the checkout process. We will also send you an email confirming your login details.

  • How long does it take to complete the Microsoft Excel Intermediate Certificate course?

    We estimate that the course will take about 10 hours to complete in total, plus an additional 30 minutes for the end of course test.

  • How long is my certificate valid for?

    Once you have been awarded your certificate it is valid for life. The certificate does not expire or need renewing.
Go at your own pace. There are no time limits for this course.
This course is compatible with all modern devices and browsers.
On completion of the course you will be awarded a certificate.
We are here to help if you have any problems.