Microsoft Excel 2019

(MO-200.AI1) / ISBN: 9781644591826
This course includes
Lessons
TestPrep
LiveLab
Share
$279.99
Try This Course
Are you an instructor?
Request a free evaluation copy

Microsoft Excel 2019

Gain the skills required to pass the Microsoft Excel MO-200 exam with the Microsoft Excel 2019 course and lab. Lab simulates real-world, hardware, software, and command-line interface environments and can be mapped to any text-book, course, or training. The Microsoft Excel certification course and labs thoroughly cover the MO-200 exam objectives and provide the ability to create and edit a workbook with multiple sheets and use a graphic element to represent data visually.
Here's what you will get

The Microsoft Excel 2019 certification validates a candidate's skills in managing worksheets and workbooks; data cells and ranges; and tables, table data and charts; and performing operations using formulas and functions. The MO-200 exam provides the ability to create and edit a workbook with multiple sheets and use a graphic element to represent data visually.

Lessons
  • 24+ Lessons
  • 234+ Quizzes
  • 210+ Flashcards
  • 210+ Glossary of terms
TestPrep
  • 28+ Pre Assessment Questions
  • 28+ Post Assessment Questions
Lab
  • 50+ Performance lab
  • 108+ Video tutorials
  • 01:51+ Hours
Video Lessons
  • 1+ Videos
Here's what you will learn
Download Course Outline
  • Module A: Getting around
  • Module B: Workbook basics
  • Summary
  • Module A: Entering data
  • Module B: Formulas
  • Module C: Functions
  • Module D: Moving and copying data
  • Module E: Reference types
  • Summary
  • Module A: Text formatting
  • Module B: Number formatting
  • Module C: Alignment
  • Module D: Borders and highlighting
  • Module E: Styles and themes
  • Summary
  • Module A: Data entry shortcuts
  • Module B: Paste options
  • Module C: Inserting, deleting, and hiding
  • Summary
  • Module A: Creating charts
  • Module B: Chart types and elements
  • Summary
  • Module A: Managing worksheet windows
  • Module B: Printing worksheets
  • Module C: Sharing workbooks
  • Summary
  • Module A: Workbook options and properties
  • Module B: Templates
  • Summary
  • Module A: Managing worksheets
  • Module B: Customizing Excel
  • Summary
  • Module A: Using names in formulas
  • Summary
  • Module A: Sorting
  • Module B: Filtering tables
  • Module C: Structured references
  • Module D: Validation
  • Module E: Transposing data
  • Summary
  • Module A: Consolidation
  • Module B: Subtotals
  • Summary
  • Module A: Creating and formatting PivotTables
  • Module B: Manipulating PivotTables
  • Module C: PivotCharts
  • Summary
  • Module A: Conditional formats
  • Module B: Custom Formats
  • Module C: Graphics
  • Summary
  • Module A: Special chart types
  • Module B: Sparklines
  • Module C: Quick Analysis
  • Summary
  • Module A: Permissions
  • Module B: Shared workbooks
  • Summary
  • Module A: Decision-making functions
  • Module B: Lookup and reference functions
  • Summary
  • Module A: Auditing and error-trapping
  • Module B: Formula options
  • Module C: Arrays
  • Summary
  • Module A: Date and time functions
  • Module B: Text functions
  • Module C: Other functions
  • Summary
  • Module A: The Power Pivot Data Model
  • Module B: Exporting data
  • Summary
  • Module A: What-if analysis
  • Module B: The Analysis Toolpak
  • Summary
  • Module A: Recording macros
  • Module B: Running macros
  • Module C: Forms
  • Summary

Hands on Activities (Performance Labs)

  • Saving a Workbook
  • Creating a New Workbook
  • Performing Calculations with Formulas
  • Entering a Function
  • Using Relative, Absolute, and Mixed References
  • Changing the Date Format
  • Formatting Numbers
  • Merging a Heading
  • Applying a Theme
  • Inserting and Deleting Cell Ranges
  • Creating a Simple Chart
  • Changing the Chart Color
  • Changing the Chart Style
  • Editing a Legend in the Chart
  • Creating a Column Chart and Switching its Rows and Columns 
  • Splitting a Large Worksheet
  • Setting Page Margin
  • Setting and Saving the Print Area
  • Adding a Header
  • Saving a Workbook as a PDF File
  • Checking Compatibility
  • Creating a Workbook from a Template
  • Inserting Hyperlink to an Image
  • Creating Names for Cell Ranges
  • Editing Names
  • Sorting Data
  • Sorting by Multiple Columns
  • Filtering Data 
  • Formatting Data as a Table
  • Creating Formulas Using Structured References
  • Creating a PivotTable Automatically
  • Inserting WordArt
  • Inserting SmartArt
  • Inserting a Trendline on a Chart
  • Customizing Sparklines
  • Adding Comments
  • Merging Shared Workbooks
  • Using the IF Function
  • Using the SUMIF Function 
  • Using the SUMIFS Function
  • Using VLOOKUP
  • Using the MATCH Function
  • Using an Array Formula 
  • Using an Array Function
  • Performing Calculations Using Date Functions
  • Performing Simple Time Calculations
  • Using the Concatenate Function
  • Calculating the Minimum and Maximum Sales Value
  • Importing Data from a File
  • Creating Relationships Between Tables
  • Exporting to a Text File
  • Creating a Blank Form
Exam FAQs
What are the prerequisites for this exam? There are no technical prerequisites for the certification exam.
What is the exam registration fee? USD 100
Where do I take the exam? Certiport
What is the format of the exam? The exam consists of performance based questions and is conducted in a live or simulated environment. 
How many questions are asked in the exam? The exam contains 40-60 questions.
What is the duration of the exam? 90 minutes
What is the passing score? The passing score varies from exam to exam and is provided on the score report.
What is the exam's retake policy?

Microsoft Office Specialist (MOS) exam retake policy

  1. If a candidate does not achieve a passing score on an exam the first time, the candidate must wait 24 hours before retaking the exam.
  2. If a candidate does not achieve a passing score the second time, the candidate must wait 2 days (48 hours) before retaking the exam a third time.
  3. A two-day waiting period will be imposed between each subsequent exam retake.
  4. There is no annual limit on the number of attempts on the same exam.
  5. If a candidate achieves a passing score on an Office exam, the candidate may take it again.
What is the validity of the certification? For life
Where can I find more information about this exam? To know more about the , click here.
What are the career opportunities after passing this exam?
  • Accountants
  • Cost Estimator
  • Data Journalist
  • Retail Manager
  • Project Manager
  • Business Analyst
  • Financial Analyst
  • Information Clerk
  • Administrative Assistant
×