Microsoft

Microsoft Excel 2019

Tackle complex data challenges, automate tasks, and create sophisticated Excel solutions. Prepare for the MO-200 exam.

(MO-200.AI3) / ISBN : 978-1-64459-225-0
Lessons
Lab
TestPrep
AI Tutor (Add-on)
Instructor-Led (Add-on)
111 Reviews
Get A Free Trial

About This Course

The Microsoft Excel 2019 for beginners course is 100% aligned with the MO-200 exam objectives to help you prepare and pass the exam on your first attempt. Learn at your own pace and time from experienced instructors with a flexible learning module. The comprehensive course content focuses on the core fundamentals like navigating the Excel interface, workbooks, worksheets, and basic data entry techniques. You’ll also explore advanced data analysis tools like PivotTables, Power Pivot, and What-If Analysis to extract meaningful information. By the end of this Microsoft Excel course, you’ll be able to efficiently work with Excel, analyze data, create insightful reports, and make informed decisions.

Skills You’ll Get

  • Create, navigate, organize, and manage workbooks and worksheets 
  • Data entry & formatting using text formatting options (font, size, color, alignment)
  • Creating and applying cell styles
  • Utilize formulas and functions like arithmetic operators, built-in functions, and logical functions
  • Utilize lookup and reference functions (VLOOKUP, HLOOKUP, INDEX, MATCH)
  • Understand and use cell references (relative, absolute, mixed)
  • Data manipulation and analysis by sorting, filtering, and using ‘Fill Handle’
  • Create tables and use structured references
  • Create PivotTables and PivotCharts for data summarization and analysis
  • Charting and visualization by various chart types (column, bar, line, pie, etc.)
  • Using Sparklines for compact data visualization
  • Record, run, edit, and modify macros
  • Create user forms for input and output
  • Import and export data from various sources
  • Utilizing the Power Pivot data model for complex data analysis
  • Perform What-If Analysis (scenarios, goal seek, data tables)
  • Utilize Analysis ToolPak for statistical and engineering functions

Get the support you need. Enroll in our Instructor-Led Course.

Download Course Outline

1

Introduction

2

Fundamentals

  • Module A: Getting around
  • Module B: Workbook basics
  • Summary
3

Creating worksheets

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

Formatting

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

Manipulating data

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

Charts

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

Output

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

Settings and templates

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

Introduction

10

Managing workbooks

  • Module A: Managing worksheets
  • Module B: Customizing Excel
  • Summary
11

Named ranges

  • Module A: Using names in formulas
  • Summary
12

Tables

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

Summarizing data

  • Module A: Consolidation
  • Module B: Subtotals
  • Summary
14

PivotTables

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

Presentation features

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

Advanced charts

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

Collaboration

  • Module A: Permissions
  • Module B: Shared workbooks
  • Summary
18

Introduction

19

Logical and Lookup Functions

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

Advanced Formulas

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

Special functions

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

Importing and Exporting

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

Analysis

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

Macros and Forms

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

Appendix: Exam Objective MO-201

  • Exam Objective

1

Fundamentals

  • Saving a Workbook
2

Creating worksheets

  • Creating a New Workbook
  • Performing Calculations with Formulas
  • Entering a Function
  • Using Relative, Absolute, and Mixed References
3

Formatting

  • Changing the Date Format
  • Formatting Numbers
  • Merging a Heading
  • Applying a Theme
4

Manipulating data

  • Deleting and Editing the Cell Content
5

Charts

  • 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
6

Output

  • Splitting a Large Worksheet
  • Setting Page Margin
  • Setting and Saving the Print Area
  • Adding a Header
  • Saving a Workbook as a PDF File
7

Settings and templates

  • Checking Compatibility
  • Creating a Workbook from a Template
8

Managing workbooks

  • Inserting Hyperlink to an Image
9

Named ranges

  • Creating Names for Cell Ranges
  • Editing Names
10

Tables

  • Sorting Data
  • Sorting by Multiple Columns
  • Filtering Data 
  • Formatting Data as a Table
  • Creating Formulas Using Structured References
11

PivotTables

  • Creating a PivotTable Automatically
12

Presentation features

  • Inserting WordArt
  • Inserting SmartArt
13

Advanced charts

  • Customizing Sparklines
14

Collaboration

  • Adding Comments
  • Merging Shared Workbooks
15

Logical and Lookup Functions

  • Using the IF Function
  • Using the SUMIF Function 
  • Using the SUMIFS Function
  • Using VLOOKUP
  • Using the MATCH Function
16

Advanced Formulas

  • Using an Array Formula
  • Using an Array Function
17

Special functions

  • Performing Calculations Using Date Functions
  • Performing Simple Time Calculations
  • Using the Concatenate Function
  • Calculating the Minimum and Maximum Sales Value
18

Importing and Exporting

  • Importing Data from a File
  • Exporting to a Text File
19

Macros and Forms

  • Creating a Blank Form

Any questions?
Check out the FAQs

Read out this Questions and Answers section if you still have any doubts.

Contact Us Now

All those working with data and numbers, wanting to pass the MS MO-200 certification exam should take up this course. Professionals from various departments like finance & accounting, sales & marketing, human resources, operations, data analysis & scientists should be trained on their Excel skills.

This Microsoft Excel course covers several advanced topics like pivot tables & pivot charts, power pivot, what-if analysis, analysis ToolPak, macro recording & editing, VBA programming, form control, array formulas, logical functions, lookup & reference functions, data validation, power query, and power BI integration.

This course is very relevant even if you already know Excel as you’ll be learning many new features and their usage. Additionally you”ll gain insights into best practices, efficient workflows, and latest excel trends.

No, this is a beginner-friendly course that gradually builds on your excel skills.

Yes, this course prepares you for the MO-200 Microsoft certification exam.

Besides adding a new skill set and value to your resume, completing this course will open doors to a variety of exciting roles like data analyst, financial analyst, project manager, etc. with higher income potential.

Related Courses

All Course