MO-201 - Microsoft Office Specialist: Microsoft Excel Expert (Office 2019) - Course Overview

MO-201 is a certification exam offered by Microsoft, this certification assesses an individual’s knowledge and skills of Microsoft Excel (Excel 2019) 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 this course, 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 to visually represent their data and make it easier to analyze and visualize the data.

Upcoming Batches

Enroll Online
Start Date End Date

To be Decided

Key Features of MO-201 - Microsoft Office Specialist: Microsoft Excel Expert

  • 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 Study-Guides.

Who Should Attend:

  • 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-201 exam and obtain official certification by Microsoft.

Prerequisites of MO-201 - Microsoft Office Specialist: Microsoft Excel Expert

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

Why choose CloudThat as your training partner?

  • 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 gain Excel skills and will be more efficient and productive by choosing correct features and functions in Excel.

Learning objective of 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.

Course Outline Download Course Outline

Import data into workbooks.

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
  • Manage comments

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

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 (), and NOT () functions

Look up data by using functions

  • Look up data by using the 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

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 Pivot Chart 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-201 Training aspirants receive a Course Completion certificate from us.

Click to Zoom

Course Fee

Select Course date

Can't See the Date? Contact Us to Enroll and Get More Information

Add to Wishlist

Course ID: 15533

Course Price at

$499 + 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