Microsoft Excel 2019
(MO-200.AI3) / ISBN : 978-1-64459-225-0
About This Course
Start your prep for the MO-200 exam with the Microsoft Excel 2019 course and lab. The lab is cloud-based, device-enabled, and can easily be integrated with an LMS. 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. The study guide provides hands-on learning on the basic and advanced concepts covered in the Microsoft Excel certification exam.
Skills You’ll 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.
Get the support you need. Enroll in our Instructor-Led Course.
Interactive Lessons
25+ Interactive Lessons | 288+ Quizzes | 209+ Flashcards | 209+ Glossary of terms
Gamified TestPrep
28+ Pre Assessment Questions | 28+ Post Assessment Questions |
Hands-On Labs
50+ LiveLab | 106+ Video tutorials | 01:47+ Hours
Video Lessons
58+ Videos | 05:41+ Hours
Introduction
Fundamentals
- Module A: Getting around
- Module B: Workbook basics
- Summary
Creating worksheets
- Module A: Entering data
- Module B: Formulas
- Module C: Functions
- Module D: Moving and copying data
- Module E: Reference types
- Summary
Formatting
- Module A: Text formatting
- Module B: Number formatting
- Module C: Alignment
- Module D: Borders and highlighting
- Module E: Styles and themes
- Summary
Manipulating data
- Module A: Data entry shortcuts
- Module B: Paste options
- Module C: Inserting, deleting, and hiding
- Summary
Charts
- Module A: Creating charts
- Module B: Chart types and elements
- Summary
Output
- Module A: Managing worksheet windows
- Module B: Printing worksheets
- Module C: Sharing workbooks
- Summary
Settings and templates
- Module A: Workbook options and properties
- Module B: Templates
- Summary
Introduction
Managing workbooks
- Module A: Managing worksheets
- Module B: Customizing Excel
- Summary
Named ranges
- Module A: Using names in formulas
- Summary
Tables
- Module A: Sorting
- Module B: Filtering tables
- Module C: Structured references
- Module D: Validation
- Module E: Transposing data
- Summary
Summarizing data
- Module A: Consolidation
- Module B: Subtotals
- Summary
PivotTables
- Module A: Creating and formatting PivotTables
- Module B: Manipulating PivotTables
- Module C: PivotCharts
- Summary
Presentation features
- Module A: Conditional formats
- Module B: Custom Formats
- Module C: Graphics
- Summary
Advanced charts
- Module A: Special chart types
- Module B: Sparklines
- Module C: Quick Analysis
- Summary
Collaboration
- Module A: Permissions
- Module B: Shared workbooks
- Summary
Introduction
Logical and Lookup Functions
- Module A: Decision-making functions
- Module B: Lookup and reference functions
- Summary
Advanced Formulas
- Module A: Auditing and error-trapping
- Module B: Formula options
- Module C: Arrays
- Summary
Special functions
- Module A: Date and time functions
- Module B: Text functions
- Module C: Other functions
- Summary
Importing and Exporting
- Module A: The Power Pivot Data Model
- Module B: Exporting data
- Summary
Analysis
- Module A: What-if analysis
- Module B: The Analysis Toolpak
- Summary
Macros and Forms
- Module A: Recording macros
- Module B: Running macros
- Module C: Forms
- Summary
Appendix: Exam Objective MO-201
- Exam Objective
Fundamentals
- Saving a Workbook
Creating worksheets
- Creating a New Workbook
- Performing Calculations with Formulas
- Entering a Function
- Using Relative, Absolute, and Mixed References
Formatting
- Changing the Date Format
- Formatting Numbers
- Merging a Heading
- Applying a Theme
Manipulating data
- Deleting and Editing the Cell Content
Charts
- 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
Output
- Splitting a Large Worksheet
- Setting Page Margin
- Setting and Saving the Print Area
- Adding a Header
- Saving a Workbook as a PDF File
Settings and templates
- Checking Compatibility
- Creating a Workbook from a Template
Managing workbooks
- Inserting Hyperlink to an Image
Named ranges
- Creating Names for Cell Ranges
- Editing Names
Tables
- Sorting Data
- Sorting by Multiple Columns
- Filtering Data
- Formatting Data as a Table
- Creating Formulas Using Structured References
PivotTables
- Creating a PivotTable Automatically
Presentation features
- Inserting WordArt
- Inserting SmartArt
Advanced charts
- Customizing Sparklines
Collaboration
- Adding Comments
- Merging Shared Workbooks
Logical and Lookup Functions
- Using the IF Function
- Using the SUMIF Function
- Using the SUMIFS Function
- Using VLOOKUP
- Using the MATCH Function
Advanced Formulas
- Using an Array Formula
- Using an Array Function
Special functions
- Performing Calculations Using Date Functions
- Performing Simple Time Calculations
- Using the Concatenate Function
- Calculating the Minimum and Maximum Sales Value
Importing and Exporting
- Importing Data from a File
- Exporting to a Text File
Macros and Forms
- Creating a Blank Form
Any questions?Check out the FAQs
Still have unanswered questions and need to get in touch?
Contact Us NowThere are no technical prerequisites for the certification exam.
USD 100
The exam consists of performance based questions and is conducted in a live or simulated environment.
The exam contains 40-60 questions.
90 minutes
The passing score varies from exam to exam and is provided on the score report.
Microsoft Office Specialist (MOS) exam retake policy
- 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.
- 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.
- A two-day waiting period will be imposed between each subsequent exam retake.
- There is no annual limit on the number of attempts on the same exam.
- If a candidate achieves a passing score on an Office exam, the candidate may take it again.
For life