MO-201 Excel Expert Exam Review 2-2 Practice Tasks (3/3)

Objective 2-2 ‘Format & Validate Data’ Part 2 Auto Outline, Subtotal & Remove Duplicates.

Pass the new 2019 Excel Expert Exam with this review of the practice tasks & Excel tips covering the Microsoft Exam # MO-201 Microsoft Excel Expert (v2019) Study Guide.

This video walks through the following tasks:
- Auto Outline (@ 0:20);
- Manual Grouping (@ 2:32);
- Bonus: Reverse Grouping Direction (@ 4:46);
- Remove Duplicates (@ 8:33).

Order the textbook and/or download the practice files here:

MO-201 77-728 mos microsoft office excel 2016 2019 expert M0-201

[valerie.mccaffrey]

whoever you work for is very lucky. Your videos are of absurdly high quality. Taking MO 201 this week, thank you!

[agelosable]

I am going to pass the MOS exam thanks to you Craig. Your help is dope!

[nikoespino]

The grouping "up" or "down" feature could have saved me a lot of time in the past. I was modifying my documents to fit however excel decided to group before. Thanks for that bit!

[daphnebohl]

This series of videos is excellent! I have watched the whole series twice in preparation for my MO-201 exam and everything is explained very clearly. Thank you for posting.

[mayankgoel]

videos are good but excessive use of shortcut keys because of that understanding become difficult