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.

Submit form to obtain discount

Test Prep

28+ Pre Assessment Questions | 28+ Post Assessment Questions |

Features

50+ LiveLab | 106+ Video tutorials | 01:47+ Hours

58+ Videos | 05:41+ Hours

Why choose TOPTALENT?

Get assistance every step of the way from our Texas-based team, ensuring your training experience is hassle-free and aligned with your goals.
Access an expansive range of over 3,000 training courses with a strong focus on Information Technology, Business Applications, and Leadership Development.
Have confidence in an exceptional 95% approval rating from our students, reflecting outstanding satisfaction with our course content, program support, and overall customer service.
Benefit from being taught by Professionally Certified Instructors with expertise in their fields and a strong commitment to making sure you learn and succeed.

Outline

Lessons 1:
Introduction

Lessons 2:
Fundamentals

Module A: Getting around
Module B: Workbook basics
Summary

Lessons 3:
Creating worksheets

Module A: Entering data
Module B: Formulas
Module C: Functions
Module D: Moving and copying data
Module E: Reference types
Summary

Lessons 4:
Formatting

Module A: Text formatting
Module B: Number formatting
Module C: Alignment
Module D: Borders and highlighting
Module E: Styles and themes
Summary

Lessons 5:
Manipulating data

Module A: Data entry shortcuts
Module B: Paste options
Module C: Inserting, deleting, and hiding
Summary

Lessons 6:
Charts

Module A: Creating charts
Module B: Chart types and elements
Summary

Lessons 7:
Output

Module A: Managing worksheet windows
Module B: Printing worksheets
Module C: Sharing workbooks
Summary

Lessons 8:
Settings and templates

Module A: Workbook options and properties
Module B: Templates
Summary

Lessons 9:
Introduction

Lessons 10:
Managing workbooks

Module A: Managing worksheets
Module B: Customizing Excel
Summary

Lessons 11:
Named ranges

Module A: Using names in formulas
Summary

Lessons 12:
Tables

Module A: Sorting
Module B: Filtering tables
Module C: Structured references
Module D: Validation
Module E: Transposing data
Summary

Lessons 13:
Summarizing data

Module A: Consolidation
Module B: Subtotals
Summary

Lessons 14:
PivotTables

Module A: Creating and formatting PivotTables
Module B: Manipulating PivotTables
Module C: PivotCharts
Summary

Lessons 15:
Presentation features

Module A: Conditional formats
Module B: Custom Formats
Module C: Graphics
Summary

Lessons 16:
Advanced charts

Module A: Special chart types
Module B: Sparklines
Module C: Quick Analysis
Summary

Lessons 17:
Collaboration

Module A: Permissions
Module B: Shared workbooks
Summary

Lessons 18:
Introduction

Lessons 19:
Logical and Lookup Functions

Module A: Decision-making functions
Module B: Lookup and reference functions
Summary

Lessons 20:
Advanced Formulas

Module A: Auditing and error-trapping
Module B: Formula options
Module C: Arrays
Summary

Lessons 21:
Special functions

Module A: Date and time functions
Module B: Text functions
Module C: Other functions
Summary

Lessons 22:
Importing and Exporting

Module A: The Power Pivot Data Model
Module B: Exporting data
Summary

Lessons 23:
Analysis

Module A: What-if analysis
Module B: The Analysis Toolpak
Summary

Lessons 24:
Macros and Forms

Module A: Recording macros
Module B: Running macros
Module C: Forms
Summary

Appendix: Exam Objective MO-201

Exam Objective

Microsoft Excel 2019

Test Prep

Features

Why choose TOPTALENT?

Outline

Lessons 1: Introduction

Lessons 2: Fundamentals

Lessons 3: Creating worksheets

Lessons 4: Formatting

Lessons 5: Manipulating data

Lessons 6: Charts

Lessons 7: Output

Lessons 8: Settings and templates

Lessons 9: Introduction

Lessons 10: Managing workbooks

Lessons 11: Named ranges

Lessons 12: Tables

Lessons 13: Summarizing data

Lessons 14: PivotTables

Lessons 15: Presentation features

Lessons 16: Advanced charts

Lessons 17: Collaboration

Lessons 18: Introduction

Lessons 19: Logical and Lookup Functions

Lessons 20: Advanced Formulas

Lessons 21: Special functions

Lessons 22: Importing and Exporting

Lessons 23: Analysis

Lessons 24: Macros and Forms