Name: Microsoft Excel Associate (MO-200)
Rating: 5

Current Status

Not Enrolled

Price

550

Get Started

Take this Course 10hr

Welcome to Microsoft Excel Associate (MO-200)

This Course is specifically designed to facilitate passing of your MO-200 exam. We are honored to be here with you on this journey.

This course delivers:

In-depth preparation for each exam objective
Detailed procedures to help build the skills measured by the exam
Hands-on video based tasks to practice what you’ve learned
Ready-made practice files

After completing this course, your will be proud of your progress in these areas:

Manage Worksheets and Workbooks
Manage Data Cells and Ranges
Manage Tables and Table Data
Perform Operations by Using Formulas and Functions
Manage Charts

Before you begin the course,
do this first !

Please download the course materials by clicking the button here.

After download, click here to commence the lesson.

Click below to download the Work File :

MO-200 Exam Tutorial 1

MO-200 Exam Tutorial 2

Course Content

Expand All

Exam Tutorial 1

Project 1 – Bike Rental 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

Task 1: Import CSV

Task 2 : Clear Cell Formating

Task 3 : Name a Table

Task 4 : Modify Page Setup

Task 5 : Inspect Workbooks for Issues

Project 2 – Trekking Supplies 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

Task 1: Merge and unmerge cells

Task 2: Insert and remove hyperlinks

Task 3: Apply built-in conditional formatting

Task 4: Add data series to charts

Task 5: Apply Chart styles

Project 3 – Tijah Cafe 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

Task 1 : Search for Data within a workbook

Task 2: Configure print settings

Task 3: Apply number formats

Task 4: Switch between rows and columns in source data

Task 5: Add and modify chart elements

Project 4 – IT Hardware 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

Task 1: Define a named range

Task 2: Reference named ranges and named tables in formulas & Perform Calculation using SUM Function

Task 3: Remove conditional formatting

Task 4: Modify cell alignment, orientation, and indentation

Task 5: Sort data by multiple columns

Project 5 – Bicycle Kembara 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

Task 1: Freeze Worksheet rows and columns

Task 2: Modify Basic Workbook properties

Task 3: Set a print area

Task 4: Perform Calculation using SUM Function

Task 5: Format text by using the CONCAT() functions

Project 6 – Food Inventory 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

Task 1: Insert and configure total rows

Task 2: Perform Calculation using MAX Function

Task 3: Create Charts

Task 4: Create Excel tables from cell ranges

Task 5 : Apply chart layouts

Project 7 – Staff Payroll 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

Task 1 : Insert mixed references

Task 2 : Fill cells by using Auto Fill

Task 3 : Add or remove table rows and column

Task 4 : Configure table styles options

Task 5 : Insert Sparklines

Exam Tutorial 2

Project 1 – Computer Apps 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

Task 1 : Reference Named Ranges

Task 2: Adjust row height and column width

Task 3: Apply cell styles

Task 4: Create Excel tables from cell ranges + Apply table styles

Task 5: Customize headers and footers

Project 2 – Organic Syamsul 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

Task 1: Import Data From .txt files

Task 2: Insert and remove hyperlinks

Task 3: Remove conditional formatting

Task 4: Create Excel tables from cell ranges

Task 5: Apply Chart styles

Project 3 – Kuih Raya 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

Task 1: Display and modify workbook content in different views + Change Window Views

Task 2: Format cells by using Format Painter

Task 3: Perform calculations by using the AVERAGE()

Task 4: Add data series to charts

Task 5: Filter records

Project 4 – Unit For Rent 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

Task 1: Customize the Quick Access Toolbar

Task 2: Modify Basic Workbook properties

Task 3: Set a print area

Task 4: Save workbooks in alternative file formats

Task 5: Wrap Text Within Cells

Project 5 – Moving Out Sales 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

Task 1: Add or Remove Table Rows and Columns

Task 2: Display and modify workbook content in different views

Task 3: Freeze Worksheet rows and columns

Task 4: Configure table styles options

Task 5: Format text by using LEFT() functions

Project 6 – FnB 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

Task 1: Insert Sparklines

Task 2: Create Chart sheets

Task 3: Apply cell formats from the Format Cells dialog box

Task 4: Switch between rows and columns in source data

Task 5: Display formulas

Project 7- Customer Service 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

Task 1: Insert Sparklines + Fill cells by using Auto Fill

Task 2: Insert and configure total rows

Task 3: Perform conditional opperations by using the IF() function

Task 4: Format text by using UPPER() functions

Task 5: Create Charts

Welcome to Microsoft Excel Associate (MO-200)

Before you begin the course, do this first !

Course Content

Before you begin the course,
do this first !