Microsoft Excel 2019 With Course, Videos, Test Prep & Mentoring

This course includes

Lessons

25+ Lessons | 288+ Quizzes | 209+ Flashcards | 209+ Glossary of terms

TestPrep

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

Hands-On Labs

49+ LiveLab | 00+ Minutes

Need guidance and support? Click here to check our Instructor Led Course.

Here's what you will learn

Download Course 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