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

Objective 2-3 ‘Apply Advanced Conditional Formatting’ Part 3 Formatting based on numeric value, editing conditional formatting rules & arranging conditional formatting precedence.

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 conditional formatting tasks:
- Conditionally format a row based on single value @ 1:04;
- Editing conditional formatting rule @ 6:35;
- Changing order of effect for conditional formatting rules @ 7:52 ; and,
- Upgrading usability of worksheet @ 9:18.

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

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

[dragonabyss]

Just passed the exam with 800+. Thank you so much for making this possible for me and I hope more ppl could benefit from your videos!

[ania_k]

Thank you, this was very helpful!! I wish there were videos covering section 3 and 4 too

[chossi]

Thanks Craig, I wouldn't have passed the exam without your videos. Thank you so much!

[erikaraeking]

This was a great video series, I learned a lot of things, not just relevant to the exam, and you presented the information very well! I was dissapointed it didn't continue on through the rest of the material on the test, but since it's been a couple years seems like you probably won't be continuing. Either way, thanks so much for sharing!

[spencergowey]

Thank you so much for this video series man, just passed the exam with flying colors, keep it up!

[pancholitachiu]

I’ve never used those highlight styles at the top nor seen them. Great explanation to not use an integer in the formula as a best practice.

[ajaysharma-gwvy]

I have an exam Today for mo 201 and found these videos... this has saved me a lot of time to revise all the concepts in one place from these 12 videos. ..lest see hwo he exam goes. Great work . my major takeaway today was nested search function to find spaces at different places and using with len ..just too cool!!

[arvinndssinha]

WOW!!! Salute to the depth of knowledge you have, Sir. Thank you for doing a great job. I am sure, with the help of your tutorials the path to MOS-201 certification becomes easy. Thanks again, Master...

[dylanbuchman]

these videos are really helping me with an Excel course (not a good one); thank you

[rosedalton]

These are great, I wish I'd found them sooner.. Where are the questions relating to the practice files please?

[pancholitachiu]

Thank you for your valuable videos. In task 1 cond. formatting with a formula, why did you add a space after the cell right before the >?

[TheDisciplinedPoser]

Hello Craig,

First, I'd like to thank you for the content. These will help me a lot to prepare for the exam in next month. I see that there isn't anymore practice tasks after the domain 2.3 for 2019, but I do see all of them for 2016. Would it okay to study the 2016 versions?

[sawaimalhi]

can your share MO-201 Excel 2019 Expert Exam book in pdf???

[rafaelmakh]

cant undestand is it final part of it? where the rest?