MO-211 · Topic 14 Power Query, Data Import and Transformation Mission Lab

1 · Import

2 · Transform

3 · Combine

4 · Load

Certification Checkpoint

Five independent tasks. Feedback appears only after submitting the project.

Project 14 · Municipal Data Integration10:00

0%

Mission Report

Microsoft Office Specialist Preparation Series

Mission Progress Record

This certifies that

has actively participated in

MO-211 · Topic 14

Power Query, Data Import and Transformation

Completed a practical Microsoft Excel workplace mission involving data import, type correction, cleaning, splitting, replacing, pivoting, unpivoting, merging, appending, parameters, custom columns, query dependencies, refresh control, and load destinations.

Skills Demonstrated

Power Query · Data Import · Data Types · Cleaning · Split and Merge · Pivot and Unpivot · Merge Queries · Append Queries · Parameters · Load and Refresh

Mission Score: —Practice Activities: —Checkpoint: —Completion Date:

Juan CarballoMicrosoft Office Specialist Master Instructor