MO-200.AI3
Microsoft Excel 2019
Tackle complex data challenges, automate tasks, and create sophisticated Excel solutions. Prepare for the MO-200 exam.
- Practice in 50 Hands-On Labs — nothing to install
- 25 Interactive Lessons and 80 topics mapped to the official exam objectives
- 82 Practice Test Questions
Beginner Self-paced · 1 year access 4.5/5 (111 Reviews)
50 Hands-On LiveLabs
Practice real IT tasks in guided environments.
- Real environments
- Auto-graded
- No installation
25Interactive Lessons
80Topics
50LiveLab
82Practice Test Questions
46Videos
209Flashcards
209Glossary of terms
01 / Skills you'll get
What you will be able to do
Try Free →
No credit card required
The Microsoft Excel 2019 for beginners course is 100% aligned with the MO-200 exam objectives to help you prepare and pass the exam on your first attempt. Learn at your own pace and time from experienced instructors with a flexible learning module. The comprehensive course content focuses on the core fundamentals like navigating the Excel interface, workbooks, worksheets, and basic data entry techniques. You’ll also explore advanced data analysis tools like PivotTables, Power Pivot, and What-If Analysis to extract meaningful information. By the end of this Microsoft Excel course, you’ll be able to efficiently work with Excel, analyze data, create insightful reports, and make informed decisions.
- Create, navigate, organize, and manage workbooks and worksheets
- Data entry & formatting using text formatting options (font, size, color, alignment)
- Creating and applying cell styles
- Utilize formulas and functions like arithmetic operators, built-in functions, and logical functions
- Utilize lookup and reference functions (VLOOKUP, HLOOKUP, INDEX, MATCH)
- Understand and use cell references (relative, absolute, mixed)
- Data manipulation and analysis by sorting, filtering, and using ‘Fill Handle’
- Create tables and use structured references
- Create PivotTables and PivotCharts for data summarization and analysis
- Charting and visualization by various chart types (column, bar, line, pie, etc.)
- Using Sparklines for compact data visualization
- Record, run, edit, and modify macros
- Create user forms for input and output
- Import and export data from various sources
- Utilizing the Power Pivot data model for complex data analysis
- Perform What-If Analysis (scenarios, goal seek, data tables)
- Utilize Analysis ToolPak for statistical and engineering functions
Target Career Roles
- Accountants
- Cost Estimator
- Data Journalist
- Retail Manager
- Project Manager
02 / Lessons & labs
See exactly what you will learn and practice
Lessons
25 Interactive Lessons · 80 topics01 Introduction +
02 Fundamentals 3 topics · 1 LiveLab +
- Module A: Getting around
- Module B: Workbook basics
- Summary
1 LiveLab in this lesson — see the labs panel →
03 Creating worksheets 6 topics · 4 LiveLab +
- Module A: Entering data
- Module B: Formulas
- Module C: Functions
- Module D: Moving and copying data
- Module E: Reference types
- Summary
4 LiveLab in this lesson — see the labs panel →
04 Formatting 6 topics · 4 LiveLab +
- Module A: Text formatting
- Module B: Number formatting
- Module C: Alignment
- Module D: Borders and highlighting
- Module E: Styles and themes
- Summary
4 LiveLab in this lesson — see the labs panel →
05 Manipulating data 4 topics · 1 LiveLab +
- Module A: Data entry shortcuts
- Module B: Paste options
- Module C: Inserting, deleting, and hiding
- Summary
1 LiveLab in this lesson — see the labs panel →
06 Charts 3 topics · 5 LiveLab +
- Module A: Creating charts
- Module B: Chart types and elements
- Summary
5 LiveLab in this lesson — see the labs panel →
07 Output 4 topics · 5 LiveLab +
- Module A: Managing worksheet windows
- Module B: Printing worksheets
- Module C: Sharing workbooks
- Summary
5 LiveLab in this lesson — see the labs panel →
08 Settings and templates 3 topics · 2 LiveLab +
- Module A: Workbook options and properties
- Module B: Templates
- Summary
2 LiveLab in this lesson — see the labs panel →
09 Introduction +
10 Managing workbooks 3 topics · 1 LiveLab +
- Module A: Managing worksheets
- Module B: Customizing Excel
- Summary
1 LiveLab in this lesson — see the labs panel →
11 Named ranges 2 topics · 2 LiveLab +
- Module A: Using names in formulas
- Summary
2 LiveLab in this lesson — see the labs panel →
12 Tables 6 topics · 5 LiveLab +
- Module A: Sorting
- Module B: Filtering tables
- Module C: Structured references
- Module D: Validation
- Module E: Transposing data
- Summary
5 LiveLab in this lesson — see the labs panel →
13 Summarizing data 3 topics +
- Module A: Consolidation
- Module B: Subtotals
- Summary
14 PivotTables 4 topics · 1 LiveLab +
- Module A: Creating and formatting PivotTables
- Module B: Manipulating PivotTables
- Module C: PivotCharts
- Summary
1 LiveLab in this lesson — see the labs panel →
15 Presentation features 4 topics · 2 LiveLab +
- Module A: Conditional formats
- Module B: Custom Formats
- Module C: Graphics
- Summary
2 LiveLab in this lesson — see the labs panel →
16 Advanced charts 4 topics · 1 LiveLab +
- Module A: Special chart types
- Module B: Sparklines
- Module C: Quick Analysis
- Summary
1 LiveLab in this lesson — see the labs panel →
17 Collaboration 3 topics · 2 LiveLab +
- Module A: Permissions
- Module B: Shared workbooks
- Summary
2 LiveLab in this lesson — see the labs panel →
18 Introduction +
19 Logical and Lookup Functions 3 topics · 5 LiveLab +
- Module A: Decision-making functions
- Module B: Lookup and reference functions
- Summary
5 LiveLab in this lesson — see the labs panel →
20 Advanced Formulas 4 topics · 2 LiveLab +
- Module A: Auditing and error-trapping
- Module B: Formula options
- Module C: Arrays
- Summary
2 LiveLab in this lesson — see the labs panel →
21 Special functions 4 topics · 4 LiveLab +
- Module A: Date and time functions
- Module B: Text functions
- Module C: Other functions
- Summary
4 LiveLab in this lesson — see the labs panel →
22 Importing and Exporting 3 topics · 2 LiveLab +
- Module A: The Power Pivot Data Model
- Module B: Exporting data
- Summary
2 LiveLab in this lesson — see the labs panel →
23 Analysis 3 topics +
- Module A: What-if analysis
- Module B: The Analysis Toolpak
- Summary
24 Macros and Forms 4 topics · 1 LiveLab +
- Module A: Recording macros
- Module B: Running macros
- Module C: Forms
- Summary
1 LiveLab in this lesson — see the labs panel →
25 Appendix: Exam Objective MO-201 1 topics +
- Exam Objective
Hands-On Labs Our edge
50 LiveLabs- 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
- Deleting and Editing the Cell Content
- 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
- 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
- Exporting to a Text File
- Creating a Blank Form
Labs run in your browser — nothing to install.
03 / Exam details
Microsoft Excel 2019 Details
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.
Questions
40-60
(per exam)
Duration
90 minutes
(per exam)
Passing Score
The passing score varies from exam to exam and is provided on the score report.
(scaled score)
Exam Fee
USD 100
(per exam)
Delivered by
Certiport
(in-person or online)
Question Format
The exam consists of performance based questions and is...
single/multiple choice, performance-based
Practice Tests
82 Practice Questions
(mapped to official exam objectives)
Certification
MO-200.AI3
Microsoft credential
Ready to take the exam?
Add your official MO-200.AI3 exam voucher to your order.
Official Voucher · Fast delivery · Retake bundle available
Exam voucher is sold separately and not included with standard course.
04 / FAQs
Questions before you start
Who should do this Excel course?+
All those working with data and numbers, wanting to pass the MS MO-200 certification exam should take up this course. Professionals from various departments like finance & accounting, sales & marketing, human resources, operations, data analysis & scientists should be trained on their Excel skills.
What advanced topics will I be learning in this course?+
This Microsoft Excel course covers several advanced topics like pivot tables & pivot charts, power pivot, what-if analysis, analysis ToolPak, macro recording & editing, VBA programming, form control, array formulas, logical functions, lookup & reference functions, data validation, power query, and power BI integration.
Is this course relevant if I already know Excel 2016?+
This course is very relevant even if you already know Excel as you’ll be learning many new features and their usage. Additionally you”ll gain insights into best practices, efficient workflows, and latest excel trends.
Do I need prior experience to take this Excel course?+
No, this is a beginner-friendly course that gradually builds on your excel skills.
Does this course also prepare for Microsoft certifications?+
Yes, this course prepares you for the MO-200 Microsoft certification exam.
What are the career benefits of learning Microsoft Excel 2019?+
Besides adding a new skill set and value to your resume, completing this course will open doors to a variety of exciting roles like data analyst, financial analyst, project manager, etc. with higher income potential.
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?+
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
- 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.
What is the validity of the certification?+
For life
Where can I find more information about this exam?+
Master Excel To Power Up Your Data
Learn advanced Excel techniques to analyze, visualize, and automate data.
- 1 year of full access
- 50 LiveLab included
- Certificate of completion
No credit card required