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.
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).
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.
Absolutely loved this course!! I am very happy with my experience in completing this online course with New Skills Academy.
It was an easy process and their website is very easy to get around. No stress over time limits. I worked through the course at my own pace, and from the comforts of my own home.
Very informative and loved the worksheet after each module which gave me a chance to really think about the work needed for the final test and gave me a chance to really understand each module.
I will definitely be putting what I have learned from the course into practice within our office.
Natalie Rogerson
This was the first online course I’ve funded myself and I was apprehensive as you don’t really know what you’re going to get!
However, I’m happy to report that this course has given me a really good grounding in Child Psychology and has whet my appetite to pursue some of the content in more detail under my own steam.
When I had questions, the Support Team’s responses were lightning fast and reassuring and for the fee paid and the experience I’ve had this has been great value for money and a firm foundation on which to build in the future.
Thank you New Skills Academy!
Tom Shires
Very enjoyable and informative course which covered all aspects of dog grooming, managing the business side and history of dog grooming. What I liked most was being able to do the course at my own pace, revisiting modules as required to gain a complete understanding of what I was learning.
I found the video tutorials very helpful and was able to give my own dog a professional cut after watching them.
On the one occasion I forgot my password online help were very prompt in helping me . I would highly recommend this course. Good value for money.
Thank-you New Skills Academy!
Jacqueline Myers - B
Jacqueline Myers
I would like to say that I have completely enjoyed the course online and I am very pleased with the resources and information that was given. My father is very proud of me completing the course in a short amount of time and I can only give credit to New Skills Academy for giving me the opportunity to complete a qualification that will benefit me in the future. I say this because my preferred job role is a human resources manager or even assistant to start off with. Many thanks for this amazing experience and the importance of this qualification as a whole.
Kaoutar Lenabdeljilil
Just writing to congratulate your team for putting this course together. I have been Training with SEN for a year as a trainee and fallen in love with this profession and the development of children in early years. I have had some professional in house training but i really enjoyed this course thank so much i needed a way to prove the some of my gained knowledge for my self as a single mum working so hard i am in tears this morning with joy thank so much i have lot of work to with our children with revisited knowledge and insight knowledge what bank of information to come back to when i need refreshing
Thank you This course was amazing I couldn't stop reading Like a hungry child
Tracey Boyce
At age 44, I took a notion to start a new career, so I booked a Travel & Tourism online course with New Skills Academy.
I was actually pretty nervous when I looked at the modules as it’s been years since I studied!
I was pleasantly surprised at how well the course flowed and how uncomplicated it was. The presentation of the course was easy to read and understand.
When I got to the final test, I was nervous, but had no need to be. It was a general test of knowledge and I passed with 70%. I feel proud!
Angela Wilson
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.
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).
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.
Absolutely loved this course!! I am very happy with my experience in completing this online course with New Skills Academy.
It was an easy process and their website is very easy to get around. No stress over time limits. I worked through the course at my own pace, and from the comforts of my own home.
Very informative and loved the worksheet after each module which gave me a chance to really think about the work needed for the final test and gave me a chance to really understand each module.
I will definitely be putting what I have learned from the course into practice within our office.
Natalie Rogerson
This was the first online course I’ve funded myself and I was apprehensive as you don’t really know what you’re going to get!
However, I’m happy to report that this course has given me a really good grounding in Child Psychology and has whet my appetite to pursue some of the content in more detail under my own steam.
When I had questions, the Support Team’s responses were lightning fast and reassuring and for the fee paid and the experience I’ve had this has been great value for money and a firm foundation on which to build in the future.
Thank you New Skills Academy!
Tom Shires
Very enjoyable and informative course which covered all aspects of dog grooming, managing the business side and history of dog grooming. What I liked most was being able to do the course at my own pace, revisiting modules as required to gain a complete understanding of what I was learning.
I found the video tutorials very helpful and was able to give my own dog a professional cut after watching them.
On the one occasion I forgot my password online help were very prompt in helping me . I would highly recommend this course. Good value for money.
Thank-you New Skills Academy!
Jacqueline Myers - B
Jacqueline Myers
I would like to say that I have completely enjoyed the course online and I am very pleased with the resources and information that was given. My father is very proud of me completing the course in a short amount of time and I can only give credit to New Skills Academy for giving me the opportunity to complete a qualification that will benefit me in the future. I say this because my preferred job role is a human resources manager or even assistant to start off with. Many thanks for this amazing experience and the importance of this qualification as a whole.
Kaoutar Lenabdeljilil
Just writing to congratulate your team for putting this course together. I have been Training with SEN for a year as a trainee and fallen in love with this profession and the development of children in early years. I have had some professional in house training but i really enjoyed this course thank so much i needed a way to prove the some of my gained knowledge for my self as a single mum working so hard i am in tears this morning with joy thank so much i have lot of work to with our children with revisited knowledge and insight knowledge what bank of information to come back to when i need refreshing
Thank you This course was amazing I couldn't stop reading Like a hungry child
Tracey Boyce
At age 44, I took a notion to start a new career, so I booked a Travel & Tourism online course with New Skills Academy.
I was actually pretty nervous when I looked at the modules as it’s been years since I studied!
I was pleasantly surprised at how well the course flowed and how uncomplicated it was. The presentation of the course was easy to read and understand.
When I got to the final test, I was nervous, but had no need to be. It was a general test of knowledge and I passed with 70%. I feel proud!
Angela Wilson
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...
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
I found this course incredibly useful, as it provided me with practical knowledge which I can implement in my role as a Support Worker. The videos were clear and concise, and the downloadable worksheets reinforced what I had learned as I was able to put pen to paper. Overall, a fantastic course for a great price! I am looking forward to taking on my next one.
Teleisha Harley
Omg im so excited, over joyed and all the good stuff that comes to mind! Wonderful experience doing lessons with New Skills Academy. I look foward to doing more courses with them. I hope this will encourage others to come on board and refresh your minds or to learn something new, it's a win win situation. I want to thank New Skills Academy so much for making this as simple as possible for me.
Shari Anderson
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
Excellent course, well explained and easy to understand. The course can be done at my own pace and is available on various devices. The layout of the course was excellent and the notes options is very good. The content is perfect and well structured, making it easy to understand and follow. I will definitely be taking more courses in the future.
Luis Costa
It was an eye opening course that was flexible and easy to access. I was able to complete it from the comfort of my own home whilst also having the tasks to complete which enabled me to check my knowledge. I know feel much more confident in my field of work and really enjoyed doing it.
Ellie Clarke
This course is a great way to brush up on my rusty excel skills, I recommend this course to anyone looking for something to do during lockdown, it's easy to use and talks you through each stage step by step. It has given me the confidence I need to further my career.
Georgia Darke
I am a doctor. This course is well organized, covering all areas of CBT. The videos and practical tips are very helpful. All the modules are arranged with good explanations and examples. Also each module consists of quick test and assignment which enables you to gain knowledge. Finally I would like to thank the New Skills Academy team.
Dr. M. Arshad
