MO-200 Excel Associate (Office 2019) Courses

Microsoft Excel Associate - Essential Formulas

Learn the Style and Standard of Microsoft Excel Associate Certification Exams

The purpose of this FREE course is to provide you with a sense of the style and standard of the Microsoft Certification Exams at Associate level.

Understand the approach that MOS University takes to the preparation of candidates for Microsoft Office Specialist exams.

We have successfully prepared thousands of exam candidates through a combination of Excel technique tuition, sample exam project tasks and how to successfully cope with exam pressure.

What's Included in the FREE Course

  • How to register for a MOS exam

  • Essential Formulas for Excel Associate Certification

  • SUM(), MAX(), MIN(), AVERAGE()


  • IF() Functions

  • Unique()

  • Try It Yourself (TIY) Exercises

  • Sample Project Tasks for the Associate Exam

  • Special Discount Course Offers

Click the button below to enrol for FREE!

MOS University Courses

MOS University provides two courses designed to prepare you for success in any Microsoft Office Specialist exam.

Complete Techniques courses ensure your competency in all of the techniques and skills measured by Microsoft.

Practice Exams and Video Solutions courses ensure that you are familiar with the standard and style of the Project Tasks in whichever Microsoft product you want to be certified in.

Be 100% Confident of Your Success at the 1st Attempt

Microsoft Excel Associate - Essential Formulas

MO-200 Microsoft Excel Associate

(Office 2019)

Complete Techniques

MO-200 Microsoft Excel 2019

Complete Techniques

MO-200 Microsoft Excel 2019

Practice Exams

Two Course Bundle: Complete Techniques and Practice Tests

MO-200 Course Details

MO-200 Microsoft Excel 2019

Complete Techniques for the MO-200 Associate Certificate Exam

Why Study with MOS University

  • Catering to students at all levels, these courses cover every possible aspect of the Microsoft Excel 2016 Core syllabus.

  • Exam preparation online sessions exploring student questions.

  • Learn at your own pace and be assured of our support throughout.

  • These courses cover all of the essential Microsoft Excel 2019 Core techniques AND provide you with the opportunity to practice using practice quetions set to the style and standard of the actual test.

  • Comprehensive exercise pack with complete video solutions.

  • This course is guaranteed to teach you all the techniques required for the MO-200 exam AND prepare you for the requirements of the exam so that you can pass the exam on your first attempt.

  • 'Try It Yourself' exercises with virtually all lectures will ensure your understanding as the course progresses.

Microsoft Excel Associate - Essential Formulas

Course Content


How the Exam is Conducted

Calculate and Transform Data

Perform Calculations using the AVERAGE(), MAX(), MIN() and SUM() Functions
Count Cells using the COUNT(), COUNTA() and COUNTBLANK() functions
Perform Conditional Operations by using the IF() Function
The Unique () Function

Try It Yourself (TIY) Exercises

Try It Yourself (TIY) Exercises
TIY for Lectures for Calculate and Transform Data

TIY for Lectures for the Unique() Function

Sample Exam Questions

Using the Macro Enabled Excel Sample Questions File

Exam 1 Macro Enabled Excel File

Conclusion & Special Discounts

Create Charts

Modify Charts

Format Charts

Sample Course Videos

Unique () Function

Create Tables in Excel 2019

77-727 Certification Bundle

Here are all the courses that are included in your bundle

Comprehensive Tuition for the 77-727 Excel 2016 Core Certification Exam

2 courses designed to prepare you for success in the MOS Excel Core Certification exam!

Be 100% Confident Of Your Success.

© 2024 BowTieLearning Ltd. All Rights Reserved

Contact Us: [email protected]