Skip to product information
1 of 1

Microsoft Excel Level 2

Microsoft Excel Level 2

👍 96% Positive reviews 📱 Access on mobile, tabs and desktop 👩‍🎓 280 students 🕛 Lifetime access 📝 Accreditation of completion
No reviews
Regular price £150.00
Regular price £300.00 Sale price £150.00
Sale Sold out
Tax included.

Microsoft Excel Certification Level 2

If it's not too much trouble, Note: This course utilizes the Windows form of Microsoft Office 2016. Some other adaptations will have a few contrasts in the capacities.


The Microsoft (MS) Excel Accreditation Level 2 instructional class will take what the staff part found in the Degree 1 program just as increment on it, teaching them further developed ideas than those that were introduced in the previous instructional class.

What's Covered in the Training course?

The item in the Degree 2 course is created for those that team up with Excel in the workplace just as dream to upgrade their capacities. Regardless of whether the worker is associated with monetary speculations, banking or counseling, the web substance will surely serve for anyone that tracks just as examinations a lot of information.

Representatives that are new to the workforce will need to ensure that they are outfitted with in any event middle of the road (Level 2) Excel capacities.

Prior to starting this Degree 2 instructional class, the staff part should have a decent handle of the Level 1 Excel capacities. Those with experience in Excel may truly feel that they can miss the Level 1 course, yet it is prescribed to in any event evaluate the course material, before starting the Level 2 material.

The instructional class shows colleagues how to utilize highlights, comprising of AVERAGEA, AVERAGEIF, AVERAGEIFS just as ABS. They will moreover find information acknowledgment subtleties, focusing on the sort of data approval, like date, list and furthermore time, notwithstanding considerably more data on specific highlights, comprising of CHAR, CODE, MEAN, MODE and ROUND and furthermore precisely how to utilize these capacities, to fulfill the association's requirements.

Different subtleties in the Level 2 program remembers exactly how to change text for Excel, e.g., modifying text to all top occurrence or diminished circumstance. Staff part will absolutely likewise find exactly how to change the set of experiences just as add a customized photograph, how to use AutoFill just as how to embed unique characters.

After completing the instructional class, workers will find out about the greater part of the capacities that Excel has just as precisely how to utilize the product program at a transitional level, which does the trick to have the option to utilize Excel in a ton of business settings.

What are the Conveniences of the Program?

Dominate information examination devices have applications all through the association;

Like the Degree 1 program, the Degree 2 instructional class makes up short modules, accessible on a gadget that can connection to the web;

Lifetime admittance to the program items empowers understudies to change any of the item any time later on;

On-line learning support is taken care of your staff individuals.

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

Customer Reviews

Based on 12 reviews Write a review
View full details

Buy with confidence

If for some reason you are not satisfied with our product, we will return your money within 14 days after your purchase, no questions asked.


Can I order more than one course?

Yes. You can order as many courses as you like. You can purchase 1, 2 or even 10 courses. It’s entirely up to you.

Can I order the course for someone else?

Yes. You can order the course for a family member, friend, work colleague, staff members and more. When placing your order, just send us an email to inform us that the course is for someone else and we will create an account for them.

Are there any additional costs?

No. The course price you see listed is the only cost you have to pay to study the course. There are no hidden fees or anything like that.

When you finish the course, you will be awarded with a PDF certificate of achievement which you can print out yourself.

Is this price genuine?

Yes. We’re running a special promotion this month and have reduced the price of the course to make it easier for more people to start our courses. So the price you see is the discounted price we have on offer. You can order the course today and get started with your learning straight away.

What if I don’t pass first time?

We have our exam pass guarantee in place. You will be allowed to retake the final assessment as many times as you require until you pass the course. There is no additional charge to retake the test.

What do I get at the end of the course?

Once you’ve finished the course you will be awarded with your certificate. We’ll dispatch this within 1-3 working days of you completing your course.

How do I enroll?

Just click the ‘Buy Now’ button, which will add the course in your shopping cart, from here proceed with the checkout and enter your payment details. You can pay securely using Debit/Credit card, PayPal or even Google Pay.

Once we have confirmed your enrollment, we will send you access to your course straight away so you can enjoy our learning.

Can I study if I live outside the UK?

Yes. With Online Courses Learning you will receive access to your online training course, meaning that you can study from anywhere in the world, as long as you have an internet connection. We have students taking our courses worldwide.

When does this course start?

We provide online training courses that are completely flexible. With our online training courses you can enroll and start your course today. You have complete control over your own learning.

Do I need to come to a training venue?

You do not need to attend any training venue or classes.

When will I receive my course?

You will receive instant access to your online training course once you have successfully completed the checkout and we confirm your enrollment. We send your login details for the course, along with a receipt for your payment to the email address used at checkout. Please make sure you therefore use the correct email address at checkout.

Will I have a tutor?

Yes. If you need any help or support when studying the course just email the tutor support team and they will help answer any questions you may have.

Do I receive a certificate?

Once you have finished the course you will receive a certificate to showcase your new skills and qualifications. This certificate will be sent to you via email in PDF format once you have completed the course. Hard copies of certificates are available for an additional £9.99.

Do I need any previous experience or qualifications before I join a course?

Most of the courses available require little or no previous knowledge prior to enrolling.

How long do I have access to my course?

You will have lifetime access l.

Is the course recognized?

Yes. Our courses are accredited through the CPD Certification Service. CPD is recognized nationally across the United Kingdom and internationally around the world, thus the CPD Award should be recognized by academic institutions, public organizations and private companies. Your certificate will contain the universally recognized CPD Certification Service logo.

Can I cancel or refund my course?

Yes. We offer 14 days peace of mind guarantee. As long as you haven’t logged into the course, you can get a full no questions asked refund within the first 14 days after ordering.

I have another question about the course, how can I contact you?

Please email us at

CPD Accredited

The CPD Certification Service provides support, advice and recognised independent CPD accreditation to support the Continuing Professional Development obligations and policies of professional bodies and academic institutes.


CDP certification details

Upon completion of the course you will be awarded with the CPD Certification.

This course is CPD accredited with the CPD Certification Service. Your certificate will display the universally recognized CPD Certification Service logo as proof of your knowledge and competencies gained from taking this course.

The Certificate of Achievement will provide proof that you have studied the course and will contain your grade classification level. You can use the certificate from us as part of your portfolio of evidence and/or use it to attend job or academic interviews.

The CPD certification is also a vital measure of your professional commitment, as taking this course clearly demonstrates your potential to employers and the value that you can bring to an organization. It shows that you are serious about your chosen career sector and it can be that crucial step in helping you to gain a new job or promotion.

What is CPD?

The CPD Certification Service was established in 1996 as the leading independent organization operating across all sectors to complement CPD polices of professional and academic institutions. Recognized nationally by employers, professional organizations and academic intuitions the CPD Certification Service is a valuable certificate to achieve.

CPD stands for Continuing Professional Development. CPD is a commitment to lifelong learning, a skill that is invaluable to all people in society. Employers from both the public and private sectors, as well as academic intuitions across the UK and internationally recognize Continuing Professional Development (CPD).

CPD is a great way for individuals to gain new skills, improve their job prospects, gain greater job satisfaction and also help to secure a promotion.

Benefits of CPD
Regardless of where you are in your career, undertaking a CPD course can help you;

Enhance your employment opportunities
Improve career satisfaction
Track prior learning
Show you are up-to-date with the requirements of your job
Contribute to your CV
Lead to further education
Demonstrate your commitment and value within your organization
Prepare you for promotion
When you finish with the course your certificate will contain the recognised CPD mark.