Learningit.today

Home » All Courses » Microsoft Excel 2019

Microsoft Excel 2019

: 8 Hours

: Self Paced, AI Tutor, Instructor

: Beginner

: Available Immediately

R3168,00R4488,00

Guaranteed Safe Checkout

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.

Here’s what you will get

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 |

Hand on lab

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

Video Lessons

58+ Videos | 05:41+ Hours

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
Training Method

Self Paced, AI Tutor, Instructor-led

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.

You may also like…

  • Automating Administration With PowerShell

    MS Tech

    : 40 Hours
    : Instructor
    : Intermediate
    :Available Immediately

    Learn More
  • Microsoft Office 365 Word Advanced

    Word

    : 8 Hours
    : Instructor
    : Advanced
    : Available Immediately

    Learn More
Learningit.today