Course Details

  • Course Code: USMC21MEB
  • Location: Online
  • Duration: 35 hours
  • Cost:
  • Qualification: All modern browsers and devices

Further Details

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

Approved Course:




Course Modules/Lessons

Microsoft Excel for Beginners Certification

Module 1: Introduction to Excel

Module 2: Add

Module 3: Multiply

Module 4: Subtraction

Module 5: Dividing

Module 6: Sort

Module 7: Percentage

Module 8: Running Totals

Module 9: Print

Module 10: Paste Special

Module 11: Merge

Module 12: Filter

Module 14: AVERAGEIF

Module 15: SUMIF Formula

Module 16: IF Formula

Module 17: VLOOKUP

Module 18: HLOOKUP

Module 19: Countif Formula

Module 20: CountBlank

Module 29: Doughnut Charts

Module 28: Pie Charts

Module 27: Pivot Tables

Module 25: Date Formula

Module 26: Month Formula

Module 23: Concatenate

Module 21: Counta Formula

Module 31: Column Charts

Module 32: Bar Charts

Module 33: Number Formatting

Module 34: Create Borders

Module 35: Conditional Formatting

Module 36: Comments

Module 22: Count Formula

Module 24: Transpose

Module 30: Line Charts

Module 13: Average

Microsoft Excel Intermediate Certification

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

Microsoft Excel Advanced Certification

Module 1: Add a Password

Module 2 : AND Function

Module 3 : Auto Updating Drop-down Lists

Module 4 : CEILING Formula

Module 5 : Charts that Update Automatically

Module 6 : CHOOSE Formula

Module 7 : Compare 2 Lists with VLOOKUP Function

Module 8 : CORREL Function

Module 9 : Create an Advanced Calculator

Module 10 : Create a Combo Chart

Module 11 : Create a Custom Tab

Module 12 : Create a Pivot Chart

Module 13 : Create Visual In-cell Indicators

Module 14 : Create Visual In-cell Indicators with Icon Sets

Module 15: Customize the Status Bar

Module 16: DATEDIF Function

Module 17: DATEVALUE Function

Module 18: DAVERAGE Function

Module 19 : DCOUNT Function

Module 20 : DCOUNTA Function

Module 21 : Depreciation Formula

Module 22 : DGET Function

Module 23 : DMAX Function

Module 24 : DPRODUCT

Module 25: DSUM Function

Module 26: EDATE Function

Module 27: EOMONTH Function

Module 28: Find and Replace

Module 29: FIND Function

Module 30: INDEX Function

Module 31: INDEX MATCH Function

Module 32: INDIRECT Function

Module 33: Insert Serial Number Automatically

Module 34: IPMT Function

Module 35: ISBLANK Function

Module 36: ISERR Function

Module 37: ISLOGICAL Function

Module 38: ISNONTEXT Function

Module 39: ISNUMBER Function

Module 40: ISODD Function

Module 41: Isolate First Name

Module 42: ISTEXT Formula

Module 43: LEFT Function

Module 44: LEN Function

Module 45: MATCH Function

Module 46: Vlookup Multiple Results at Once

Module 47: OR Formula

Module 48: PMT Formula

Module 49: Replace Formula

Module 50: Select all Cells with Comments

Module 51: Sparkline Charts in Excel

Module 52: Straight Line Depreciation

Module 53: Strikethrough

Module 54: Sum of Years Depreciation

Module 55: Timeline in Pivot Table

Module 56: Vlookup with 2 Criteria

Module 57: Vlookup with DropDown List

Module 58: Vlookup with Max

Module 59: Vlookup with Min

Module 60: Watch Window In Excel

Excel Macros Certification

Module 01: Definitions and Background

Module 02: Running, Naming and Saving

Module 03: Important Tips

Module 04: Practical Macros

Example Certificate


Certificate No CERTIDNO
This certificate is to verify that
Your Name

has successfully completed the
MS EXCEL CERTIFICATION BUNDLE
on the
27th August 2025

Daniel Morgan
Head Tutor
New Skills Academy

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

How online learning can benefit you..

 

START THE MS EXCEL CERTIFICATION BUNDLE 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 ...