Course Details

  • Course Code: USFEC17MXI
  • Location: Online
  • Duration: 10+ hours
  • Cost:
  • Qualification: All modern browsers and devices

Further Details

  • Course Access: Lifetime
  • Exams Included: Yes
  • Compatibility: All major devices and browsers

Approved Course:

A005786



MS Excel Intermediate Certification Course

Please Note: This course uses the Windows version of Microsoft Office 2016 for module content and all related tests. 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.



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

Example Certificate


Certificate No CERTIDNO
This certificate is to verify that
Your Name

has successfully completed the
MICROSOFT EXCEL INTERMEDIATE CERTIFICATION
on the
24th November 2020

A005786
Daniel Morgan
Head Tutor
New Skills Academy

This certificate can be verified online at:
https://newskillsacademy.com

How online learning can benefit you..

 

START THE MICROSOFT EXCEL INTERMEDIATE CERTIFICATION NOW



https://uk.trustpilot.com/review/newskillsacademy.co.uk

FAQ's

  • Who can take the course?

    Anyone who has an interest in gaining a greater understanding of this subject is encouraged to take the course. There are no entry requirements to take the course.

  • What is the structure of the course?

    The course is broken down in to individual modules. Each module takes between 30 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.

  • Where / when can I study the course?

    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!

  • Is there a test at the end of the course?

    Once you have completed all of the modules there is a 30 (multiple choice) question test. The questions will be on a range of topics found within the modules. The test, like the course, is online and can be taken a time and location of your choosing.

  • What happens if I fail the test?

    If you don’t pass the test first time you will get a second opportunity to take the test again after further study.

  • When will I receive my certificate?

    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 there will be an admin charge of $16

  • How can I pay?

    We use Paypal for all payments on the site. You can either use your Visa, MasterCard ,American Express, Solo cards or PayPal account to pay for the online course. All payments are handled securely by Paypal.

  • Is my payment secure?

    As previously mentioned your payment is totally secure. We use the latest ssl encryption for all transactions.

  • How long after payment can I begin the course?

    You can begin the course immediately after your payment has been received.
    You should receive an email with your log in details as soon as your payment has been accepted. If you don’t get this email please check your junk folder, failing that please contact us for further assistance.

  • How long is my certificate valid for?

    There is no expiry or renewal fees

Go at your own pace. There are no time limits for this course.
This course is compatible with all modern devices and browsers.
On completion of the course you will be awarded a certificate.
We are here to help if you have any problems.

What our students say ...