Microsoft Excel 2019
(MO-200.AI3)
/ ISBN: 978-1-64459-225-0
This course includes
Lessons
TestPrep
LiveLab
Mentoring (Add-on)
Microsoft Excel 2019
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.
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
-
25+ Lessons
-
288+ Quizzes
-
210+ Flashcards
-
210+ Glossary of terms
TestPrep
-
28+ Pre Assessment Questions
-
28+ Post Assessment Questions
LiveLab
-
50+ LiveLab
-
106+ Video tutorials
-
01:47+ Hours
Video Lessons
-
58+ Videos
-
05:41+ Hours
- 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 (Live 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
- 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
| 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
|
| What is the validity of the certification? | For life |
| Where can I find more information about this exam? | Know more about the MO-200 |
| What are the career opportunities after passing this exam? |
|
×
