Microsoft Excel Intermediate Certification
Why you should study with us
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
ID: YDFT67YHJ
of achievement
This certificate is presented to
Your Name
For completing the
Microsoft Excel Intermediate Certification
on 21st November 2025
Selena Hurford
Selena Hurford
Course Tutor
Daniel Morgan
Daniel Morgan
Head of Academy
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.
It is easy to follow and understand, and gives you a full overview of the HR management.
You can download the training material if you prefer to take note directly on the paper version.
Filomena Cionti
This course is so easy. I was a little nervous before I started it but even after the first module I was at ease.
The video's are clear and the course is easy to understand.
Everything I need to learn is here, from the basics like handling to bathing to full grooming. you can save the work on to your pc or laptop as you go along so you can go back over it later on. at the end of each module you even get time to practise what you have learnt.
I'm so glad I found this company and will highly recommend.
Kirsty Wilson
WOW, I really learned so much more than I thought I would, this is an amazing course with useful insights and guidance. It was really well laid out, user friendly and a joy to participate in, even if you don’t want to start a business.
Any animal lover or owner would benefit from taking this course, as it covers so many aspects, from simple ways to handle a variety of different types of pets, grooming feeding and first aid as well.
It’s absolutely brilliant, I feel that I am now ready and prepared to start on my new journey. Thank you!
Loraine Simpson
To be honest I was sceptical at first. There are many online courses to choose from but what intrigued me the most about this course is the number of modules (22 of them). This appeared to be more detailed than others. The reason I took this course is because I started a new role as a support tutor for a large training company. I already had some experience in working with learners who had special needs and learning difficulties but wanted more in-depth knowledge and tips to support my delivery. I also wanted to know more on the legal of side of SEN too. The course was offered at a large discount that did give me concerns! But I took the plunge and have been pleasantly surprised on how well it's been written and presented in manageable bite-size chunks. I was planning to study about a couple of hours a night but once I started I found it difficult to stop. It took me about 3 days to complete. The information is comprehensive but manageable. You can tell the person/persons who wrote this have a passion for supported learning and give practical strategies to support SEN and care about their sector and want to share their passion. Highly recommended study material. :-)
John Glover
I found this course very easy reading and thoroughly understandable. It was very well put together and you could always go back into the exact page that you left. It was very easy to leave notes and could always go back into them for a refresher.
This course was very well thought threw and easy to move through each section. The self-assessment at the end of each section was very helpful and refreshes key elements that you needed. To be able to print this off was good as it provided a guide for yourself.
I would recommend to my friends.
Sandra Thomas
Great course!!I have learnt everything I need to become a nail technician!with many photos and videos and with many instructions leaves you with no questions at all!!I definitely suggest this course!!
Kiriaki Mitrou
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
ID: YDFT67YHJ
of achievement
This certificate is presented to
Your Name
For completing the
Microsoft Excel Intermediate Certification
on 21st November 2025
Selena Hurford
Selena Hurford
Course Tutor
Daniel Morgan
Daniel Morgan
Head of Academy
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.
It is easy to follow and understand, and gives you a full overview of the HR management.
You can download the training material if you prefer to take note directly on the paper version.
Filomena Cionti
This course is so easy. I was a little nervous before I started it but even after the first module I was at ease.
The video's are clear and the course is easy to understand.
Everything I need to learn is here, from the basics like handling to bathing to full grooming. you can save the work on to your pc or laptop as you go along so you can go back over it later on. at the end of each module you even get time to practise what you have learnt.
I'm so glad I found this company and will highly recommend.
Kirsty Wilson
WOW, I really learned so much more than I thought I would, this is an amazing course with useful insights and guidance. It was really well laid out, user friendly and a joy to participate in, even if you don’t want to start a business.
Any animal lover or owner would benefit from taking this course, as it covers so many aspects, from simple ways to handle a variety of different types of pets, grooming feeding and first aid as well.
It’s absolutely brilliant, I feel that I am now ready and prepared to start on my new journey. Thank you!
Loraine Simpson
To be honest I was sceptical at first. There are many online courses to choose from but what intrigued me the most about this course is the number of modules (22 of them). This appeared to be more detailed than others. The reason I took this course is because I started a new role as a support tutor for a large training company. I already had some experience in working with learners who had special needs and learning difficulties but wanted more in-depth knowledge and tips to support my delivery. I also wanted to know more on the legal of side of SEN too. The course was offered at a large discount that did give me concerns! But I took the plunge and have been pleasantly surprised on how well it's been written and presented in manageable bite-size chunks. I was planning to study about a couple of hours a night but once I started I found it difficult to stop. It took me about 3 days to complete. The information is comprehensive but manageable. You can tell the person/persons who wrote this have a passion for supported learning and give practical strategies to support SEN and care about their sector and want to share their passion. Highly recommended study material. :-)
John Glover
I found this course very easy reading and thoroughly understandable. It was very well put together and you could always go back into the exact page that you left. It was very easy to leave notes and could always go back into them for a refresher.
This course was very well thought threw and easy to move through each section. The self-assessment at the end of each section was very helpful and refreshes key elements that you needed. To be able to print this off was good as it provided a guide for yourself.
I would recommend to my friends.
Sandra Thomas
Great course!!I have learnt everything I need to become a nail technician!with many photos and videos and with many instructions leaves you with no questions at all!!I definitely suggest this course!!
Kiriaki Mitrou
Why you should study with us
Learn with confidence...
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...
Wow what an incredible insight for the start of anyone's journey in property. This course gives you so much information and there are tests and questions on each of the modules. The course is very easy to follow and well laid out. You can actually make notes on the pages of each module using the notes tab! I am very excited to say that I passed and I only spent one week on this course. I will print all the PDF information and keep it in a file with my certificate. I feel very confident for my future plans now I have completed this course.
Nichola Anderson
This is a great course for any level of knowledge. Very easy to navigate, great practical tasks and explanations are very clear. You can revise any module with no problem. The test wasn’t too hard if you completed every module. It may be handy to make some notes before you start. Overall I'm very happy with my choice. Thank you New skills for my New skills :)
Julia Bobkova
Lovely course for people who want to know the basics and of sign language. It's has helped me to get more of an understanding and will greatly benefit me in my workplace. So easy to pick up and the videos were easy to understand. Would definitely recommend to anyone.
Chloe Hambly
Fantastic course! Well-presented and challenging with frequent assessments. I feel a serious sense of accomplishment having not studied for over 30 years! Videos that accompany each module are carefully thought out and informative. Am so impressed with this course, have now signed up for 3 other courses and recommending New Skills Academy to everyone!
Marva Hudson
The course was clearly set out with helpful end of week tests which built my knowledge. Being dyslexic I found the course was set out in an easy to understand way. I was able to pass the test on my first attempt. The downloaded pdf are a useful resource that you can keep forever. Looking forward to the next course
Ross Dunsten
Yet another well laid out course. This is my 3rd course so far with New Skills Academy.
More than likely will be back for another one soon. This course was enjoyable to do, and I learnt a lot and passed first try. My certificate will be up on the wall soon.
Rob Coops
I took up this course initially to help me with my own dog, but found that as I worked through the material I actually started thinking that this could be something that I could use to make a second income. From start to finish I found the course engaging and interesting. I am now doing another dog related course and am experiencing the same level of enjoyment. I would recommend New Skills Academy without hesitation.
Keith Smith
Very interesting and helpful course. I ve learned a lot of interesting things about make up and the tutorials were very helpful and easy to understand. I really reccomend this course for everyone who is passionate about make up and wish to develop their skills and make a career from their hobby.
Nicoleta Lucaci
