2 Days

MO-211: Microsoft Excel Expert - Course Overview

MO-211 is a certification exam offered by Microsoft. This certification assesses an individual’s knowledge and skills of Excel (Microsoft 365 apps) for data management, data analysis, and visualization. The course will help in the ability of candidates to perform tasks such as managing worksheets and workbooks, managing data cells and ranges, working with tables, performing operations by using formulas and functions, and creating charts.  

After completing MO-211: Microsoft Excel Expert certification training, students will be able to:

  • Manage workbook options and settings
  • Manage and format data
  • Create advanced formulas and macros
  • Will be able to use formulas and functions to perform calculations on data.
  • Creation of charts and graphs, tables to visually represent their data and make it easier to analyze and visualize the data.

Upcoming Batches

Enroll Online
Start Date End Date

2025-04-28

1970-01-01

2025-05-05

1970-01-01

2025-05-12

1970-01-01

2025-05-19

1970-01-01

2025-05-26

1970-01-01

Key Features of MO 211 Course from CloudThat

  • This course welcomes individuals curious to expand their knowledge of Excel, data analysis and visualization, regardless of their background or prior experience.

  • The training program is structured for data analysts aiming to develop proficiency in using Excel efficiently to improve productivity.

  • This course will help in gaining knowledge of using Excel effectively and choosing the right feature and function for problems to provide the correct solution along with the Study-Guides.

Who can participate in the MO 211: Microsoft Excel Expert (Microsoft 365 Apps) Certification Training?

  • This course is suitable for anyone who wants to learn advanced Excel.
  • This essential course is for all business professional, students, teacher, freelancer, Marketer, entrepreneur across the industry.
  • This Excel course will help you take your Excel skills to the next level, and you will learn advanced features of Excel.
  • Excel users who want to pass the MO-211 exam and obtain official certification by Microsoft.

Prerequisites of MO-211: Microsoft Excel Expert Course

  • No pre-requisites are required for this course, but general IT knowledge or experience can be helpful.

Why choose CloudThat as your training partner for MO-211: Microsoft Excel Expert?

  • CloudThat has successfully trained a vast number of professionals, approximately 6.5 lakh individuals, and provided training services to more than 100 corporate clients across the globe.
  • We have well trained, experienced, and certified Subject matter experts and instructors to conduct these trainings.
  • The course guides students through specific tasks and real-world challenges to help them understand the relevance, power, and usefulness of Microsoft Excel.
  • By becoming proficient in Excel, participants will develop Excel skills and will be more efficient and productive by choosing correct features and functions in Excel.

Learning objective of MO-211: Microsoft Excel Expert Course

  • After acquiring skill of Excel, Person will be well versed with use of Excel for Data Analysis, Chart creation and formatting of charts, Prepare Reports, visualize data etc.
  • Create, open, edit, and save workbooks; understand the interface; and navigate to workbook elements. Manage workbooks and worksheets, change the screen display, and customize the Quick Access Toolbar.
  • Format cells and numbers, align and wrap content, add and remove cell styles, and merge cells.
  • Format data as a table, work with table styles, create named tables, define range names, and filter and sort data.
  • Create and display formulas, use references and common functions in formulas, and understand calculation operators and precedence.
  • Get data from other sources, fix text formatting by using text functions, and insert hyperlinks to related information.
  • Apply conditional formatting to data; create, edit, and format charts; create sparklines; and use the Quick Analysis feature to quickly analyze data.
  • Create advanced formulas and record macros

MO:211 Course Outline Download Course Outline

Manage workbooks

  • Copy macros between workbooks
  • Reference data in other workbooks
  • Enable macros in a workbook
  • Manage workbook versions

Prepare workbooks for collaboration

  • Restrict editing
  • Protect worksheets and cell ranges
  • Protect workbook structure
  • Configure formula calculation options

Use and configure language options

  • Configure editing and display languages
  • Use language-specific features

Fill cells based on existing data

  • Fill cells by using Flash Fill
  • Fill cells by using advanced Fill Series options
  • Generate numeric data by using RANDARRAY ()

Format and validate data

  • Create custom number formats
  • Configure data validation
  • Group and ungroup data
  • Calculate data by inserting subtotals and totals
  • Remove duplicate records

Apply advanced conditional formatting and filtering

  • Create custom conditional formatting rules
  • Create conditional formatting rules that use formulas
  • Manage conditional formatting rules

Perform logical operations in formulas

  • Perform logical operations by using nested functions including the IF (), IFS (), SWITCH (), SUMIF (), AVERAGEIF (), COUNTIF (), SUMIFS (), AVERAGEIFS (), COUNTIFS (), MAXIFS (), MINIFS (), AND (), OR (), NOT (), and LET () functions

Look up data by using functions

  • Look up data by using the XLOOKUP (), VLOOKUP (), HLOOKUP (), MATCH (), and INDEX () functions

Use advanced date and time functions

  • Reference date and time by using the NOW () and TODAY () functions
  • Calculate dates by using the WEEKDAY () and WORKDAY () functions

Perform data analysis

  • Summarize data from multiple ranges by using the Consolidate feature Perform what-if analysis by using Goal Seek and Scenario Manager
  • Forecast data by using the AND(), IF(), and NPER() functions
  • Calculate financial data by using the PMT() function
  • Filter data by using FILTER()
  • Sort data by using SORTBY()

Troubleshoot formulas

  • Trace precedence and dependence
  • Monitor cells and formulas by using the Watch Window
  • Validate formulas by using error checking rules
  • Evaluate formulas

Create and modify simple macros

  • Record simple macros
  • Name simple macros
  • Edit simple macros

Create and modify advanced charts

  • Create and modify dual axis charts
  • Create and modify charts including Box & Whisker, Combo, Funnel, Histogram, Map, Sunburst, and Waterfall charts

Create and modify PivotTables

  • Create PivotTables
  • Modify field selections and options
  • Create slicers
  • Group PivotTable data
  • Add calculated fields
  • Format data

Create and modify Pivot Charts

  • Create Pivot Charts
  • Manipulate options in existing Pivot Charts
  • Apply styles to Pivot Charts
  • Drill down into PivotChart detail

Certification

    • After clearing this certification participants can manage worksheets and workbooks, manage data cells and ranges, manage tables and table data, perform operations by using formulas and functions, manage advanced charts and tables, troubleshoot formulas, Create and modify Pivot table and Pivot charts.
    • Successful completion of the Microsoft Expert Excel certification course will help you in demonstrating your advanced Excel capability skills and job readiness for roles requiring Excel expertise.
    • Microsoft Excel certification is a globally recognized credential and very well accepted World-wide. 
    • On successful completion of MO-211 Training aspirants receive a Course Completion certificate from us.

Click to Zoom

Course Fee

Select Course date

Add to Wishlist

Course ID: 15934

Course Price at

$399 + 0% TAX
Enroll Now

Frequently Asked Questions

All you need is a good internet connection (for online Excel training) and basic computer operating skills, and you are good to go!

Becoming a certified Excel expert can help you get hired and can help you advance in your career.

Manage workbook options and settings Manage and format data Create advanced formulas and macros Manage advanced charts and tables

Yes. This course will cover basic steps like how to create and modify, delete macros.

Yes. This course will cover commonly used features for Data analysis, Date and Time functions, Lookup Functions, If and Conditional IFS functions, Pivot table and Pivot charts etc. After going through this Excel course, you will understand: Introduction to Excel Referencing in Formulas Formatting Sorting and Filtering Charts Ensuring Security Pivot Tables Functions VBA Macros Dashboard

Enquire Now