Study Guide

Objective

This is a comprehensive course that covers both the basic and advanced features and functions of Excel. Students will learn, practice, apply, and test their skills in real-world business scenarios, preparing them for certifications and professional careers.

Content

1. Course Overview
2. Common Office Features
3. Excel Basics
4. Formulas and Functions
5. Simple Data Analysis
6. MO-200 (Excel Associate) Practice Exams
7. Advanced Workbook Options and Settings
8. Advanced Data Formatting
9. Advanced Formulas and Macros
10. Advanced Charts and Tables
11. MO-201 (Excel Expert) Practice Exams

Location and time

100% online (Self-Study) course which can be done in own pace. Course environment is LabSim -portal.

Materials

Online.

Teaching methods

This course will have the same learning features and methodology found in TestOut Office Pro such as instructional videos, text lessons, demo videos, progressive labs, custom assessments, and practice tests. This all-in-one course is delivered on TestOut’s user-friendly and time-saving online learning platform, LabSim®. It’s easy-to-use and flexible for face-to-face, hybrid, and online learning environments. No additional textbooks, resources, or downloads are required.

Employer connections

N/A

Exam schedules

Online.

International connections

N/A

Completion alternatives

N/A

Student workload

Depends on the student's baseline.

Content scheduling

Up to student her-/himself.

Further information

Course is for Open UAS Students.

Evaluation scale

Hyväksytty/Hylätty

Assessment criteria, approved/failed

Pass/Fail.

You have two choices for completion. You can do couple of exercises from each module of you can do the test. Test can be found form the study environment.

Assessment methods and criteria

You have two choices for completion. You can do couple of exercises from each module of you can do the test. Test can be found form the study environment.

Further information

Course is for Open UAS Students.