Part 1 Excel 200 - BUSINESSEDUCATIONNY

BUSINESSEDUCATIONNY

Part 1: Excel 200

There are 61 tasks to master in Excel 200, spread out within 5 domains (major topics). Below are the names of each domain and the number of tasks that the domain has. There are hyperlinks to each domain and the video training in the box below.

Domain Number And Name	Tasks
Domain 1: Manage Worksheets & Workbooks	18
Domain 2: Manage Data Cells & Ranges	17
Domain 3: Manage Tables & Table Data	8
Domain 4: Perform Operations By Using Formulas & Functions	8
Domain 5: Insert & Format Graphic Elements	8

Excel 200
Domain 1: Manage Worksheets & Workbooks

MO-200 Excel 2019 Associate Domain 1: Manage Worksheets & Workbooks	Exercise Labs Questions
Lesson 1: Introduction	0
Lesson 2: Import Data & Navigate Workbooks	4
Lesson 3: Format Worksheets & Workbooks	3
Lesson 4: Customize Options & Views	6
Lesson 5: Configure Content For Collaboration	4
Post Assessment	17

Excel 200
Domain 2: Manage Data Cells & Ranges

MO-200 Excel 2019 Associate Domain 2: Manage Data Cells & Ranges	Exercise Labs Questions
Lesson 1: Manipulate Data In Worksheets	4
Lesson 2: Format Cells & Ranges	8
Lesson 3: Define & Reference Named Ranges; Summarize Data	5
Post Assessment	17

Excel 200
Domain 3: Manage Tables & Table Data

MO-200 Excel 2019 Associate Domain 3: Manage Tables & Table Data	Exercise Labs Questions
Lesson 1: Create & Format Tables	3
Lesson 2: Modify, Filter & Sort Table Data	5
Post Assessment	8

Excel 200
Domain 4: Perform Operations By Using Formulas & Functions

MO-200 Excel 2019 Associate Domain 4: Perform Operations By Using Formulas & Functions	Exercise Lab Questions
Lesson 1: Insert References; Calculate & Transform Data	5
Lesson 2: Format & Modify Text	3
Post Assessment	8

Excel 200
Domain 5: Manage Charts

MO-200 Excel 2019 Associate Domain 5: Manage Charts	Exercise Lab Questions
Lesson 1: Create & Modify Charts	5
Lesson 2: Format Charts	3
Post Assessment	8

All Post Assessments From Domains 1-5 (EVERYTHING)

Practice Test 1

TEST Primer

Do Formulas Without Formula Builder

Popcorn And A Movie

COMPETITION