Excel Expert Tutorial (MO-201 Practice Exam)

Thank you man this helped a lot

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.

Hey Mime, me and my friend wanna thank u too much for helping us easily pass excel expert 2019. Keep doing what you do, u are changing everyone’s lives in Microsoft

Mike my man. I watched your videos for only a day straight, after not doing well on a Certification test. After watching you videos, I came into the testing room the next day with confidence and I passed. Thanks to your amazing videos and your way of teaching and explaining functions. Thanks

Thank you!!Your video help me to pass the exam.

Hi Mike, i am really appreciate your video. Most of the questions are came as per this video. Please put same for PL-300 exam.

Hi Mike! Thanks for all your help!

Sarah Shaw is in trouble!

how can i write a formula that only compares 2 cells in a given row that will have 4 values? For example, cell B1 has a value of 6 and C1 has a value of 2. the "Difference cell" will total C1-B1 = -4. then when i add a value of 3 into cell D1 of 3, the "difference cell" will total D1-C1 = 1. then when i add a value of 3 into cell E1, the "difference cell" will total E1-D1 = 0. Hope this makes sense lol

Hi Mike. Thanks for this video. It is very helpful.

Do you have an inventory excel system? Just an excel file. I work with inventory monitoring in a warehouse with no inventory system. So, i created one using excel only with various formulas just to automate the file (Vlookup, sumif, sumifs, sumproduct, if , iferror, & others) . These formulas slows down my file every time i make an update .

Is there a file associated with your video that I can practice with?

Hi Mike. Just curious. For the conditional formatting you said you have to clear the existing conditional formatting rule. I'm wondering why you didn't just edit the rule (manage rules / edit)? thanks

تعبت من الدراسه

Isn't that first section with the fill by 100 incorrect? Row 7 jumps by 200 not 100.

Hi Mike! Thank you so much for your videos. I just took the Expert Exam today and I passed with a score of 970. The questions were almost the same. There are different sets of the Expert Excel exam but I got the one that is almost identical to this. Thanks again and I hope you can make an Access MOS Tutorial.

Hey Mike! Thank you for going over the look up and averageifs functions! Thanks to your videos, I passed my Associate exam. I will be taking the Expert one in about three weeks for possible college credit. Also, do you have a video on mapping cells from the developer tab?

Thank you so much

Make an access one please Mike

Could you cover a little more pivochart fields pls

Could you cover more on pivot tables im a bit unclear

Nah mikes the boy, if u put reps into this video I promise you will pass!!!

Everything he went over in this video was literally on the exam I’m sad I didn’t watch the other one.

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!

Hello, I'm learning Excel and want to get a cert, if I watch and practice just this video will I be exam-ready or should I do a udamy course as well? can someone who's taken the exam help me out?

Thank you so much!

hey, just wanted to thank you for your videos. i was watching it to revise for my excel expert exam and i passed !!! god bless you bro

Could you go over MO-211?

Would you please provide me some sample of excel associate exam's questions and answer

Sir I have a doubt if the search option is available on the exam

Can you share this data on the description

İt is so interesting I found your video after passing mo-201 exam 🥹

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

Hello Mike, I would like to ask you about specific videos for Excel Expert 2016 (tips for the real test) for people that are practicing to get the Master certificate, for some reason we are finding the 2016 version more difficult than 2019 .. Any advice will be appreciated. thanks

Excellent tutorial! can you please share excel and word documents (sample data files), that you used in this tutorial ?

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.

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!!!

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

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

Realmente, Muchas Gracias

OMG THANK YOU I PASSED IT

how to become a MOS instructor? What are exams need to do?

how to become a MOS instructor? What are exams need to do?

I have my exam in a couple days and I've done a lot of gmetrix tests getting mostly 90s and have seen a lot of videos but I'm still really afraid bc I really need to pass this exam. Is the actual test close to this or gmetrix? or is it harder?

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

Im taking my Expert Excel exam tomorrow! I'll respond my results:

great, thanks

this was a great study guide. i finished the mo-201 test with 10 mins to spare

thanks, Mike,
Today I have passed MOS 201 excel expert exam at my attempt!

the real exam was a bit tricky. understanding the questions and do these in exam environment in a short time is the game plan.

best of luck to all.

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