Excel Expert Tutorial (MO-201 Practice Exam)

In this Excel Expert Tutorial, you will learn important, Excel expert skills such as; how to create simple macros in Excel, how to use advanced functions, and also advanced options for both conditional formatting and charts! This tutorial is base on Excel expert skills listed on the official Microsoft Office Excel Expert exam (MO-201). Let me know in the comments if you want me to cover any more Excel expert skills in the next Excel expert tutorial!

[MikesOffice]

What Excel Expert skills were new to you and which ones would you like me to cover in the next one? Let me know! 👍

[brendenaebersold]

This dude is a legend. I watched this like 4-5 times before my exam and this was basically a carbon copy of my exam. I highly recommend this to anyone looking to take it. Thank you Mike!!!

[AndySchneid]

Took my first excel test and got a 368. Watched your videos the days coming up to my next attempt and got a 775. Thank you.

[fqnxyrh]

Thanks Mike. Your videos helped me a lot to score 940 in the Excel Expert test yesterday.

[laurenerickson]

OMG MIKE WAKE UP! I’m in Australia and you’re probably asleep, but I just took my Excel Expert exam and thanks to your video and Udemy course I scored a 1000! I still can’t believe it. Wasn’t expecting that score at all, but was able to make a couple educated decisions in the right direction, which paid off. THANK YOU MIKE!!!

[onetruehitman]

Thank you so much! With your videos and Gmetrix I passed PowerPoint 2019, Word 2019, Excel 2019, Word Expert 2019, and Excel Expert 2019 and got the MOS Associate and MOS Expert certifications!

[alieamansaray]

Thank you so much for your help! When I first took the exam I score 300 something and did not pass. After watching your video I scored a 800 and passed!!!

[huozhenwei]

Thanks a lot Mike. All your exam tutorial series are really helpful, I used them to review my knowledge before I took my exams. The projects and tasks in the real exam are almost the same as you presented. I passed all 5 exams and got the MOS 2019 Expert Certificate yesterday. I have recommended your channel to all my workmates and friends. Keep it up the good work!

[CasperDaGhostB]

I’m in my freshman year and sometimes have a hard time keeping up and half the time when my teacher give assignments, I just do it and not learn anything. I have my exam in 2 days and I’m halfway through the video and already learned so much! Thank you!

[ninoalfonsomahinay]

I JUST PASSED THE EXAM THANKS TO THIS VIDEO! THANK YOU SO MUCH❤

[HeywoodFloyd]

Thanks Mike, lots of good examples and walking through makes a huge difference.

[ktybee]

Super duper great video that helped me pass with a 918. Highly recommended!

[dthvizion]

Thanks a lot man. I failed after just studying using the test prep off Cengage and GMetrix but passed with flying colors thanks to you. You actually explained what to do and why.

[chillin]

Hey bro had surprise exam that I didn’t know about listened to your videos on the drive to exam and passed. You’re the goat

[betclips]

Thank you so much for this video you awesome human! Just aced my exam thanks to you!

[tanvikansara]

Hi Mike! I watched your videos just a day or two before my excel expert exam and I scored 918 in the first attempt! Thank you so much!! The videos were soo helpful, even the 2016 ones. Thank you for making learning accessible for all through this platform!

[lauramarinello]

Mike. I have been avoiding this exam for years as everyone says how hard it is (and they're not wrong). I watched your video last night and took the exam this morning and SMASHED IT with an 809. The questions were hard, I skipped a few, and tried to logic my way through others (nested formulas are evil) but I bloody smashed it and couldn't have done it without you. Thank you for taking your time to share your knowledge. You are an everyday hero! :)

[jaquelineramos]

Fantastic tutorial! It helped me a lot to be prepared for my MOS-Excel Expert that is about to happen in a couple of days. Thank you so much!

[Evil]

This video helped me to go from not knowing half the answers on the review to passing the exam with an 861! Great video and would highly recommend to anyone struggling. The questions on the exam are very similar but make sure to learn consolidation.

[kateleeth]

Questions on the exam were literally the same exact ones you showed, thank you!