Course – CMC – (MO-210) Office Specialist: Microsoft Excel 365

Current Status

Not Enrolled

Price

Closed

Get Started

This course is currently closed
Duration
Benefits
Audience
Class Details

About this course

This course prepares learners to pass the MO-210: Microsoft Excel (Microsoft 365 Apps) exam and apply job-ready Excel skills on day one. This instructor-led course blends explanation, guided walkthroughs, and hands-on practice aligned to the official exam objectives (workbooks, data cells/ranges/tables, formulas/functions, charts/objects, collaboration). By the end, students are ready to take the Microsoft Excel 365 (MO-2010) exam with confidence.


Duration

Total: 40 class hours  |  Schedule: (10) four-hour sessions  |  Format: in-person / virtual / hybrid.


Benefits

Microsoft Office Specialist (MOS) certification for Excel demonstrates advanced, real-world spreadsheet skills employers demand.

  • Career advantage: Validates professional Excel competency for business, finance, operations, and data roles.
  • Global recognition: MOS is trusted by employers and institutions worldwide.
  • Productivity gains: Learn to solve complex problems faster using advanced Excel features.
  • Stackable credential: Counts toward MOS Associate and Expert certification tracks.


Who should take this course?

This course is designed for students, professionals, and career changers who want to prove advanced Excel mastery for the workplace.

  • Business analysts, accountants, financial professionals
  • Students and job seekers adding in-demand Excel credentials
  • Administrative and operations staff handling data reporting
  • Teams standardizing on Microsoft 365 and seeking efficiency gains


Class Details

Exam Objectives:

  • Manage workbooks (10–15%)
  • Manage data cells and ranges (20–25%)
  • Manage tables and table data (15–20%)
  • Perform operations using formulas and functions (20–25%)
  • Manage charts (20–25%)
  • Manage objects (10–15%)

Pre-requisites:

No formal prerequisites. Familiarity with Excel basics is recommended. Learners should be comfortable with spreadsheets, simple formulas, and navigating Microsoft 365 Apps.

Labs:

Hands-on labs and performance-based tasks using GMetrix MO-201 practice & courseware, plus instructor-designed projects to reinforce advanced Excel skills. Sample breakdown below.

  • Create and manage workbooks; navigate worksheets
  • Customize views, page setup, printing, and workbook options
  • Inspect workbooks for issues and apply protection
  • Insert, format, and manipulate data
  • Name and reference cell ranges
  • Use advanced paste, fill, and clear options
  • Create and format tables
  • Filter, sort, and calculate table data
  • Apply structured references and table styles
  • Apply conditional logic, text, date, and financial functions
  • Reference cells across worksheets/workbooks
  • Use error-checking and formula auditing tools
  • Create and format charts (column, line, pie, etc.)
  • Modify chart elements, layouts, and styles
  • Apply trendlines, sparklines, and advanced chart options
  • Insert and format shapes, SmartArt, images, and objects
  • Layer, align, group, and apply object effects
  • Use links, comments, and collaboration features

Additional Resources:

Official exam objectives (Certiport PDF): MOS Excel 365 – Exam Objectives
Practice & courseware: GMetrix MO-201

Course Content

Course Details 4 Topics
Sessions Recorded from Previous Classes (by Publish Date)
Microsoft Excel Class Published 9-29-2026 9 Topics
Don't forget to clock in/out for ALL learning activitiesClock in/out
+
Scroll to Top