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 2024
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.
The International Massage course is exceptional in value. The course is comprehensively laid out, each component labelled with an initial written notes, followed by details excellent videos which actually show exactly how to massage.
The course covers all types of massage such as Lomi lomi massage to hot stone massage.
I have benefited enormously from registering on this course. I would have absolutely no hesitation in recommending this course to anyone as I am aware of how much they would benefit.
I gave my friend a massage just for fun & she was amazed & told me she thinks I am the best masseuse ever. She should know as she has regular massages from professional. So what are you waiting for? Go ahead sign up for the course.
By the way no one is paying me to say this, I am saying what I believe to be true.
Abba Howson
This course is incredibly helpful and easy to understand to start off a career in event planning. The case studies give you an insight into the real world of this role and not just the "shiny exterior". I'm loving this course and cannot wait to use the knowledge that I have gained in the [hopefully not so distant] future!
Leanne Dormer
This course is really good. Easy to read and I found it really enjoyable and interesting as it was full of facts and information relating to the course.
It is nicely broken up into sections with short tests at the end and it doesn’t feel too overwhelming, feels very manageable.
I especially like that there is no time limit on completing this course, being a full time mum of two small children my life is pretty hectic so it’s great that whenever I get half an hour free I can sit and do as much or as little as I want.
Lauren Jones
Amazing course, great for people that never have time to go to college or evening classes. So easy to complete online and step by step instructions to help you. Will definitely be doing another course after this.
I’m starting my own business and this course will help me get started as it states all the things I need to know and to be aware of. I can’t wait until I have completed this as this will be a new chapter in my life. You have no time limit on this course which is great as I have a very busy life but this course gives you no pressure.
Would recommend this to anyone.
Megan Atkins
I found this course very useful. It covers the all categories of cleaning and goes in to great detail without being overwhelming. Its a clean and easy to use step by step interface that glides you through the modules. If you want to take more time and revise in your own time without access to the internet, the PDF viewer and print functions are a great feature. This course has helped me gain the new knowledge of this industry and will be the first step towards a great career. There is certainly more than meets the eye when it comes to cleaning and I have an even bigger appreciation for an industry which is vital to millions and widely under appreciated. Thank you British Cleaning Certificate for the excellent service!
Mike Satchell
I found the course straight forward and easy to follow.
It’s given me a great understanding of first aid procedures and has outlined some important aspects of looking after pets in general. It paid particular attention to the description of the CPR procedure. I will come in very useful.
The multi choice test at the end is easy to complete and I found the worksheets at the end of each module very helpful to outline the important aspects.
I look forward to completing many more courses on offer to help progress my new dog walking and pet care business.
Thank you.
Georgina Batty
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 2024
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.
The International Massage course is exceptional in value. The course is comprehensively laid out, each component labelled with an initial written notes, followed by details excellent videos which actually show exactly how to massage.
The course covers all types of massage such as Lomi lomi massage to hot stone massage.
I have benefited enormously from registering on this course. I would have absolutely no hesitation in recommending this course to anyone as I am aware of how much they would benefit.
I gave my friend a massage just for fun & she was amazed & told me she thinks I am the best masseuse ever. She should know as she has regular massages from professional. So what are you waiting for? Go ahead sign up for the course.
By the way no one is paying me to say this, I am saying what I believe to be true.
Abba Howson
This course is incredibly helpful and easy to understand to start off a career in event planning. The case studies give you an insight into the real world of this role and not just the "shiny exterior". I'm loving this course and cannot wait to use the knowledge that I have gained in the [hopefully not so distant] future!
Leanne Dormer
This course is really good. Easy to read and I found it really enjoyable and interesting as it was full of facts and information relating to the course.
It is nicely broken up into sections with short tests at the end and it doesn’t feel too overwhelming, feels very manageable.
I especially like that there is no time limit on completing this course, being a full time mum of two small children my life is pretty hectic so it’s great that whenever I get half an hour free I can sit and do as much or as little as I want.
Lauren Jones
Amazing course, great for people that never have time to go to college or evening classes. So easy to complete online and step by step instructions to help you. Will definitely be doing another course after this.
I’m starting my own business and this course will help me get started as it states all the things I need to know and to be aware of. I can’t wait until I have completed this as this will be a new chapter in my life. You have no time limit on this course which is great as I have a very busy life but this course gives you no pressure.
Would recommend this to anyone.
Megan Atkins
I found this course very useful. It covers the all categories of cleaning and goes in to great detail without being overwhelming. Its a clean and easy to use step by step interface that glides you through the modules. If you want to take more time and revise in your own time without access to the internet, the PDF viewer and print functions are a great feature. This course has helped me gain the new knowledge of this industry and will be the first step towards a great career. There is certainly more than meets the eye when it comes to cleaning and I have an even bigger appreciation for an industry which is vital to millions and widely under appreciated. Thank you British Cleaning Certificate for the excellent service!
Mike Satchell
I found the course straight forward and easy to follow.
It’s given me a great understanding of first aid procedures and has outlined some important aspects of looking after pets in general. It paid particular attention to the description of the CPR procedure. I will come in very useful.
The multi choice test at the end is easy to complete and I found the worksheets at the end of each module very helpful to outline the important aspects.
I look forward to completing many more courses on offer to help progress my new dog walking and pet care business.
Thank you.
Georgina Batty
Students also bought
MS Excel Certification Bundle
The Complete Microsoft Excel Certification
The Microsoft Office Certification
Microsoft Word Certification
Microsoft Teams Certification
Microsoft PowerPoint Certification
Microsoft Outlook Certification
Microsoft Excel Advanced Certification
Excel Macros Certification
Get all 27 beauty courses+ hundreds of others!
Unlimited learning membership
£99
A YEARAs featured in...
Get a FREE course
Sign up to our newsletter and get access to the Interview Skills and CV Writing Certificate course for free!
Simply enter your details below and we will email you access to your free course!
What our students say about us...
Learn with confidence...
