Microsoft Excel Intermediate Certification

MS Excel Intermediate Certification Course

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

The MS Excel Intermediate Certification Course will take what you learned in the beginner course and expand upon it. Additionally, this course will teach you more advanced concepts than those that were presented in the beginner 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 color 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 analyze 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.

This course includes

24/7 Student Support

End of course certification

Lifetime access to your course

Compatible with modern devices

PLUS - Access to the exclusive New Skills Academy Study Group!
ID: YDFT67YHJ
certificate

of achievement

This certificate is presented to

Your Name

NSA

For completing the

Microsoft Excel Intermediate Certification

on 21st November 2025

Selena Hurford

Selena Hurford

Course Tutor

cpd

Daniel Morgan

Daniel Morgan

Head of Academy

Certificate Example

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.

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.

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!

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.

The pass mark for the test is 70%.

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.

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.

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.

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.

Once you have been awarded your certificate it is valid for life. The certificate does not expire or need renewing.

This course was super fun and so easy to follow.

I loved the convenience of learning everywhere, I could use my phone or tablet and do the course in the car, breaks while at work or in the privacy of my living room. The videos were wonderful and the worksheets helped so much as well... I'm more confident in myself now :)

Tara Ireland

Wow! Wow!! Wow!!! Is there anyone still thinking about doing the course? Dont think. Buy the course and just do it. Very Interesting course. I thought I wouldn't be able to finish this in 1 month, But I was wrong. I was totally Glued to my computer that I forgot my lunch. I am happy I bought this course and I passed the course, and I have printed my certificate. What else could you ask for? They even would allow you use their Business Logo on your website makes it so professional. You also get templates of almost everything you would need to start a new company from Business cards to flyers. All I can say is Thanks for the great course and great give away templates.

I will recommend this over and over again.....

Abidemi Bewaji

I love being able to study from home, the site is easy to use and I like being able to just log in and study for as long as I have free then pick it up again the next day or a week later. I lost my job suddenly with no notice and decided to take the opportunity to get back into something new I intended to do long ago but just never had the time or money to do so. The great prices for online learning and being able to learn from home whilst doing part time work have helped out so much when on a budget and being unable to be able attend full time college courses.

Kirsten Owen

An enjoyable and informative course, with clear, digestible amounts of information. The worksheets help with understanding and remembering everything, and the whole course is well presented and easy to follow.

Being an online course it allowed me to work at my own pace, and with simple instructions to navigate through the modules, back tracking and repeating ones if I felt I needed too. I was also able to download and print off documents of information for my own files, so if I need to refer back to them I can.

I’d rate it as 10/10, and am looking at the next Level already!

Natasha Davy

Amazing course, easy to understand and very straight forward. It gives you a chance to review previous modules, also you are able to take notes and save them in your course profile, where you can check them at any time.

Along with the course, you get rewards for completing your course modules. It opens the door to a chance of doing something you like or changing your career, also for people that just want to get new skills in different areas.

Do it at your own pace from your own home, I usually do it on my days off. Totally worth it, I recommend it.

Sara Correia

really enjoyed the course, nice short sections easy to take in the information.

I particularity liked the option to save the pfd and print the material, this allowed me to look back on the information, which was very helpful.

I would recommend this course to others as it gives an understanding to the events industry.

I look forward to using my diploma and put the skills i learnt into practice in a day to day career change. Thanks!

Cos Constantinides

Duration:
10 hours

Access:
Lifetime Access

Approved by:
CPD

Learning Type:


Text based modules  Images  Video learning 

Cost:
$110.00

MS Excel Intermediate Certification Course

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

The MS Excel Intermediate Certification Course will take what you learned in the beginner course and expand upon it. Additionally, this course will teach you more advanced concepts than those that were presented in the beginner 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 color 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 analyze 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.

This course includes

24/7 Student Support

End of course certification

Lifetime access to your course

Compatible with modern devices

PLUS - Access to the exclusive New Skills Academy Study Group!
ID: YDFT67YHJ
certificate

of achievement

This certificate is presented to

Your Name

NSA

For completing the

Microsoft Excel Intermediate Certification

on 21st November 2025

Selena Hurford

Selena Hurford

Course Tutor

cpd

Daniel Morgan

Daniel Morgan

Head of Academy

Certificate Example

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.

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.

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!

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.

The pass mark for the test is 70%.

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.

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.

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.

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.

Once you have been awarded your certificate it is valid for life. The certificate does not expire or need renewing.

This course was super fun and so easy to follow.

I loved the convenience of learning everywhere, I could use my phone or tablet and do the course in the car, breaks while at work or in the privacy of my living room. The videos were wonderful and the worksheets helped so much as well... I'm more confident in myself now :)

Tara Ireland

Wow! Wow!! Wow!!! Is there anyone still thinking about doing the course? Dont think. Buy the course and just do it. Very Interesting course. I thought I wouldn't be able to finish this in 1 month, But I was wrong. I was totally Glued to my computer that I forgot my lunch. I am happy I bought this course and I passed the course, and I have printed my certificate. What else could you ask for? They even would allow you use their Business Logo on your website makes it so professional. You also get templates of almost everything you would need to start a new company from Business cards to flyers. All I can say is Thanks for the great course and great give away templates.

I will recommend this over and over again.....

Abidemi Bewaji

I love being able to study from home, the site is easy to use and I like being able to just log in and study for as long as I have free then pick it up again the next day or a week later. I lost my job suddenly with no notice and decided to take the opportunity to get back into something new I intended to do long ago but just never had the time or money to do so. The great prices for online learning and being able to learn from home whilst doing part time work have helped out so much when on a budget and being unable to be able attend full time college courses.

Kirsten Owen

An enjoyable and informative course, with clear, digestible amounts of information. The worksheets help with understanding and remembering everything, and the whole course is well presented and easy to follow.

Being an online course it allowed me to work at my own pace, and with simple instructions to navigate through the modules, back tracking and repeating ones if I felt I needed too. I was also able to download and print off documents of information for my own files, so if I need to refer back to them I can.

I’d rate it as 10/10, and am looking at the next Level already!

Natasha Davy

Amazing course, easy to understand and very straight forward. It gives you a chance to review previous modules, also you are able to take notes and save them in your course profile, where you can check them at any time.

Along with the course, you get rewards for completing your course modules. It opens the door to a chance of doing something you like or changing your career, also for people that just want to get new skills in different areas.

Do it at your own pace from your own home, I usually do it on my days off. Totally worth it, I recommend it.

Sara Correia

really enjoyed the course, nice short sections easy to take in the information.

I particularity liked the option to save the pfd and print the material, this allowed me to look back on the information, which was very helpful.

I would recommend this course to others as it gives an understanding to the events industry.

I look forward to using my diploma and put the skills i learnt into practice in a day to day career change. Thanks!

Cos Constantinides

Why you should study with us

Learn with confidence...

Free Course RRP $100

Get a FREE Course

Tick this box to Sign up for our newsletter, and get access to the Interview Skills and CV Writing Certificate course for free! By signing up, you agree to our Privacy Notice & Cookie Policy and to receive marketing and related emails from academy+ brands. You can unsubscribe at any time.

What our students say about us...