MO-200.AI2-CVM
Microsoft Excel 2019 With Course, Videos, Test Prep & Mentoring
- Practice in 49 Hands-On Labs — nothing to install
- 25 Interactive Lessons and 79 topics mapped to the official exam objectives
- 81 Practice Test Questions
Self-paced · 1 year access
49 Hands-On LiveLabs
Practice real IT tasks in guided environments.
- Real environments
- Auto-graded
- No installation
25Interactive Lessons
79Topics
49LiveLab
81Practice Test Questions
209Flashcards
209Glossary of terms
01 / Lessons & labs
See exactly what you will learn and practice
Lessons
25 Interactive Lessons · 79 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 · 4 LiveLab +
- Module A: Sorting
- Module B: Filtering tables
- Module C: Structured references
- Module D: Validation
- Module E: Transposing data
- Summary
4 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 +
Hands-On Labs Our edge
49 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
- 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.
Prepare for Microsoft Excel 2019 With Course, Videos, Test Prep & Mentoring
One-time payment. Full access for 1 year. Start with a free trial if you want to look around first.
- 1 year of full access
- 49 LiveLab included
- Certificate of completion
No credit card required