Don't FAIL your next Excel Exam! Watch this instead...

It is easy to fail the Excel MOS exams. But I'm going to help you avoid that in this video with 10 Excel MOS exam questions you will absolutely run into.
Need more help?
Check out my whole course on the Excel MOS exam:
www.udemy.com/course/mo-200-m...
Time Stamps:
0:36 Import a text/csv file
2:49 Freeze Rows/Columns
3:45 Create and Edit Hyperlinks
4:40 Countblank Function
5:53 IF Function
9:07 Insert Sparklines
10:26 Swap Data in a chart
11:18 Navigate to a named range
11:58 Insert Headers/Footers
13:12 Set print area

[@trickzter5701]

0:45 Import file 2:55 Freeze rows and columns 3:50 Create/Edit Hyperlink 4:45 Use countblank 6:00 IF Function 9:05 Insert Sparklines 10:30 Swap Data Excel Charts 11:25 Find Name Range 12:05 Insert Header and Footer 13:15 Set Print Area

[@MikesOffice]

Thanks for creating these chapters!

[@user-ms6mn4nn6w]

I studied this and two other videos for literally less then a day and passed my exam. you deserve the world.

[@michaelzimmerman5186]

What other videos did you watch

[@edwardrobles9860]

For real which other videos did you watch?

[@kadijahdiallo565]

Which videos please ?

[@gawrinaidu86]

Hi Mike. I sat for the MOS Excel Associate 2019 exam today and scored 981/1000. This is my first attempt. Thank you very much for your great teaching and knowledge sharing through youtube and udemy. Both helped me tremendously. Im extremely grateful. Looking forward to more videos of yours😊🙏🏼

[@StopWhining491]

Congratulations!

[@Itsmuhdd]

I just finished the exam now and i got 1000/1000 ! Thanks to your tutorials it was very helpful for studying them, i was even reviewing them 30 mins prior exam. Thank you man!

[@ElzMCgamer]

Hey, you helped me out soo much!! Thank You!! I’m in an IT class, and we all watch your videos to help us with things like this, your soo helpful!! Thanks!!

[@RidiculousCombo]

I'd like to thank you for these helpful tips. Took my MOS Excel 2019 exam today and got 871/1000 points and therefore the official MOS Excel certificate!

[@BartM93x]

How long you had to learn Excel before taking the exam?

[@shameenamir3213]

I just came here to thank you because yesterday i got my MOS certificate. Thank youuu mike ✨

[@Bucketlistexplorer]

Hello Mike, I passed excel exam from your videos. Thank you very much for your time and support very useful knowledge to everyone.

[@user-nr6kr5yo3f]

you literally touched on every part of my exam that i missed or was confused on whatttttt you are Golden!

[@Komiroya]

Thank you Mike for your classes. I just scored 925 on my first try. I'll be going for my expert test in a week or so after I finish your expert course.

[@ayecherryaung2992]

Hey Mike, I just want to say Thank you as I passed my MOS excel expert today with the help of your videos on excel which are concise and easy to understand. Keep up with this great work, Mike!

[@BartM93x]

Hello. How long had you to learn and practise Excel before taking a exam?

[@edbee816]

Almost the end of 2023 and I passed the Microsoft Excel Associate (Office 2019) exam 900/1000 following this video and your part one. Thank you! Now on to the Expert!

[@anithabs9501]

How many questions and the duration of exam? Please

[@user-pk9ry6jj7z]

I'm Korean and I live in an English-speaking country, so taking the Excel test was very difficult for me from language to understanding. For me, who has a short attention span, your video was concise but accurate to the point, so I couldn't take my eyes off it for a second. The day before the Excel test, I was so confused that your video that I looked for saved me and I passed with a good score. Thank you so much

[@antoniusronald2161]

Hi Mike. I just do my MOS Excel Associate 2019 exam today and scored 288/1000. This is my first attempt. Thank you very much for your great teaching and knowledge sharing through youtube and udemy. I will never give up from this failure. I will continue learn n much learn And not giving up, Your video is great to made me know excel's!

[@ryleynail]

First try I made a 608. I found mikes videos and just passed today with 928!

[@anithabs9501]

Please reply the exam pattern, ie, no of question and duration

[@615w6]

Watched this and a couple other videos a few times the day of my exam and got an 850 i appreciate the help man

[@cartereckblad]

Your videos have directly helped me pass the second time I took the exam!!! Should have watched you before I took it the first time haha

[@shaliyahschannel2143]

Hi Mike thanks and I really appreciate your effort to upload your video for MOS preparation exam and I am proud to say that because of all your video I pass my MOS PowerPoint recently. Now next is my MOS Outlook and I already watch your video about MOS outlook but one thing I noticed is there is no part 1 on that I seen only part 2 Is there any chance that I get also the part 1 or if you have other video for MOS outlook it would be great if you can share too. Again thank you so much and God bless you and your family. Cheers

[@FATIMA-mx4sl]

Thanks for designing a great course! It was worth every penny. I passed the Excel certification exam with flying colors. The course was easy, simple and straight to almost exactly what I was tested on.

[@BartM93x]

Hello. How long had you to learn and practise Excel before taking a exam?

[@KidsLearnHTML]

Just took the MS 200 Exam last Thursday (Feb 2) in advance of my high school students taking it so as to have a better understanding of what the tasks entail and any hidden curveballs they might encounter. I got a 975! Thanks for your help in having this channel. I subbed a couple months ago and the content, especially this video, helped out a lot!

[@Jacob-mf5yq]

How many questions were there?

[@jessicabarajas4463]

Watching this video made everything a million times easier THANK YOU

[@MM-nn7vw]

I took my exam today and passed with a score of 962! Your videos were extremely helpful.

[@logananderson8507]

Bro this vid was so helpful! Keep up the great content!

[@renatoj.desideria.3309]

Thank you Mike, I passed my 3 Microsoft office test with your videos. ✔️

[@kayleenicholaspotts519]

Hey Ma, look! I made it! Great video Mike. Such valuable information and you are 100% the reason I aced my Excel Exam!

[@jeremyrondonuwu8836]

Hey Mike! Thank you so much for such a helpful video! I scored 975 out of 1000 in the exam that I took yesterday just by practicing through this video over and over for the past two weeks 😂🎉 Hope anyone else gets a high score in this exam too!

[@BartM93x]

How long did you need to learn Excel before taking a exam?

[@EvaRadio]

thanks Mike, I passed my word and excel exams on Friday first attempts. I didn't get a perfect score due to "subtle stylings" but I only studied for 2 days, now I'm going for PowerPoint. I am an IT professional so I can troubleshoot user issues but now feels good to be certified

[@BartM93x]

Hello. How long had you to learn and practise Excel before taking a exam?

[@nivekg992]

Thanks this video was very helpful. There is 1 thing that I missed, was something like: "Remove all personal information from the workbook" or something like that. Like I said I missed it and had no idea what it was talking about or how to do it.

[@tashafoster3249]

I just took my exam and scored a 906/1000 simply from watching this video and Part 1 a couple times! Thank you so much this was soooo helpful!!! You officially have a new Subscriber :)

[@minty380]

Thanks so much for this, this guide is a god, more than 8 of the questions on this were on my exam so thanks a lot and i passed with a 875 on my first try thanks so much

[@ellieshoulders3577]

Extremely helpful, thank you!

[@Xyxle410]

You helped me pass my Powerpoint and Word Exams 4 my MOS

[@elizabethMOSCertification]

Impressive! Thanks for the video.

[@robertabrego-mf1be]

This is so helpful! Thanks

[@hrkmmmfr0008]

Hi Mike Can you please make a video for MOS Access exam please and thank you for these great videos.

[@jidatakieddin6679]

Thanks a lot! ur videos are very helpful & I passed my exam with 800/1000. Your videos are very simple and straight to the point

[@BartM93x]

Hello. How long had you to learn and practise Excel before taking a exam?

[@MansagarSinghShorts]

Thank you so much sir this video is very helpful

[@faroukalhoni6070]

You are a LEGEND I passed my MOS Exam today from the first attempt.

[@MikesOffice]

That’s great to hear! Well done!! The Excel test can be tough!

[@ahmedmofreh7236]

Thanks man

[@AlexisMontgomery-mn3qs]

I just took mine using this video and got an 887/1000 he is amazing!!

[@bluvs_tae]

Was it hard ?

[@zuradean849]

Thanks for sharing 😊

[@kareyrademacher1593]

Juniper Hills High School in Nampa, Idaho watches you everyday. We are a juvenile correctional facility, so every day we try to RISE UP! Please shout us out!

[@Zuko214]

Hey Mike, thanks to your course I got a perfect score on this exam! Thanks Mike!

[@MikesOffice]

Well done, Josh!! I’m glad the course could help you get a perfect score! What was it about the course that helped you?? Great work on a perfect score!

[@Zuko214]

@@MikesOffice I just went over both practice exams in your course and they helped me on every question on the exam! Great course Mike!

[@BartM93x]

Hello. How long had you to learn and practise Excel before taking a exam?

[@Ammu_Yazhini]

It was very helpful

[@Azfoltzo]

Doing the exam in 20min, wish me luck lads

[@wahaabraja6049]

JUST PASSED WITH A 900 THANK YOU

[@Faiz_Muzakky]

Thank you

[@Sanosan5249]

I failed my excel exam a month ago and will be taking a retake soon. I believe my mistake was I did a Take at home exam on a 15 inch monitor so there was a smaller screen in the screen as well as the chat box and proctor camera image and empty space on the bottom. Felt like I was doing a exam in a 4x5 window and had to adjust the screen so many times so I can answer and read the questions. I end up running out of time. Update: I passed, recommend using a bigger monitor than 15" easier to navigate.

[@torigarcia9302]

what helped you prepare for the exam? and did you pay for the exam pn the Microsoft website?

[@terrychan6889]

when will you have an update on Excel MOS-201 Exam Preparation course?

[@Sderot.bringthemhome]

Thank you! I am wondering if I need to save up in excel exam ? If I don’t save is it conider as mistakes?

[@navyntune8158]

I still remember the day I got to MOS country level, we have Word Expert, PowerPoint Expert and... Normal... Expert. This- this monstrosity is so hard to master that it didn't even need to be expert level to be on par with the others. It was hotrifying.

[@prisaataei3086]

Hi, I have basic knowledge of Microsoft Office in general but want to take the exams and get my certificate, where do you recommend practicing to learn them more to take the exams? Thank you

[@nayanghimire5663]

hey mike. I asked you for a video before my MOS exams but please don't ignore this one. The video topic that i wanna see is: 👉 what are the most used commands that we must add in the quick access toolbar in order to complete the mos exams faster than usual?

[@MikesOffice]

Already made that video right here: kzbin.info/www/bejne/oWLUfZ-Yh7SWja8

[@nayanghimire5663]

@@MikesOffice hello mike. Since u responded, can u please create 2 more videos: 1. About whether the viewers must choose 2016 or 2019? (2016 has less competition so it will comparitively be easier to get into the national and international rounds and 2019 is more likely to last for upcoming days of office world). 2. I had a question yesterday in my word exam but I can't remember the exact word. Well, the question was (use the word feature to replace all instances of the word "****" into "****" ). Is this question referring to the autocorrect options or the replace in the home tab?? 3. Please create a single or a series of video for the options tab itself so that we can understand every unknown segment of the options tab in office suite applications.

[@ChampagneDream]

Had my excel exam today. I wrote it and scored a 925/1000. I wrote it on a MacBook and unfortunately certiport blocks out greater than sign on the keyboard for Mac, so I got the if function question wrong. The other question I got wrong was alt text because certiport blocks out macs from right clicking on graphs :(. Regardless still an amazing mark and just want to say thanks for these amazing videos :)

[@ennykraft]

Which exam is that? Is there a more advanced one?

[@tutukumari7098]

Hi Mike , I am unable to register for exam , Could you please guide?

[@davidmazigh1791]

Thank you so much professor Mike I passed my exams after watching your videos thank you for the great job that are you doing, but last week I failed the Excel Expert please tell me how to reach you to help me for the next exam, I've already the questions 🙏

[@mollymcbride2474]

how do u get to the first part

[@vertigoz]

Is there any truth about shortcuts not being captured by the system evaluating you? I keep hearing it at formation

[@shaylamordue7796]

I MADE THE CUT!!! hahahah I want to take the Expert exam now

[@MikesOffice]

Of course! Gotta give a shoutout to the 1000 point, Excel star. You better take the Excel Expert! I’ll have training for that one up soon.

[@imashafernando2507]

Hi Mike............I Completed MOS Word 2019.Can I get the certificate from USA Through post.I need to verify my school comes from USA. My shows "Order Official Certificate"Is it works.I'm from Sri Lanka.I waiting Positive answer.

[@gari9163]

Is MO-200 Microsoft Excel 2019 Associate Certification intermediate level while MO-201 Microsoft Excel 2019 Expert Certification is advanced? I was looking thru Udemy, and can't decide which one should i learn. Thanks!

[@MikesOffice]

That's exactly it! MO-200 is beginner and intermediate. MO-201 or Excel Expert is advanced/expert stuff. I'll have the Expert one up soon.

[@nabilakartikasari8110]

@@MikesOffice Hope u upload the Expert soon, cause i'll have certification

[@MikesOffice]

@@nabilakartikasari8110 working on that one right now. I do have one video on that up here while you wait for that one!

[@kendallquillin1334]

any way you can do all the questions from the exam. Lots of stuff on the exam you did not go over

[@MikesOffice]

I have a whole course on it. Link is below this video.

[@DrPixel07]

So I'm in Highschool and I'm in a Microsoft office class that teaches word and excel, and the teacher says we are having our final exam this week and idk what video to watch so I can pass it and get certified can anybody reccomend any tips or a video i should watch

[@MikesOffice]

Definitely not this one 🥸

[@rosemarry3693]

I'm taking my test today. Im so nervous😢. Will let you know what score I got. Need prayers

[@MikesOffice]

Good luck!!

[@rosemarry3693]

@@MikesOffice thank you so much. Just because of your videos, I made 700/1000. And passed my exam. This Exam was required for my Accounting Degree from Louisiana State University. I'm so happy. I can't believe it when I check my grade. But 50 minute time was too short. I missed some questions just because of time. But I'm so happy

[@KidsLearnHTML]

@@rosemarry3693 Congratulations!

[@rosemarry3693]

@@KidsLearnHTML thanks

[@julieballs3994]

gonna take it today,i'm not confident at all😭

[@MikesOffice]

It’s tough, but you got this!

[@lavelclaytorsProjectswPurpose]

Does this apply to Excel 365?

[@MikesOffice]

Same thing.

[@eugenecaidoy1220]

I fail in WORD, POWERPOINT I hope in EXCEL I passed

[@yoshibeast12]

I just failed my 2nd take. I feel pretty bummed out

[@MikesOffice]

You shouldn’t. Timed exams can throw people off.

[@MikesOffice]

I was thinking of doing small, live group classes to help people pass these. Would you be down for that?

[@yoshibeast12]

@@MikesOffice Is that on your Patreon? I've been practicing on my own but feedback would be appreciated.

[@tutsecret499]

Speaking of failing. Don't you hate when you know the subject but you messed up during the interview and you respond differently. And you know the work step by step, but on the interview for some reason maybe did not think, did not pay attention well properly and rushed the answer. And when you leave the interview the response comes clear. And I get so angry at myself.

[@dasonjacob2181]

I am a failure

[@wolfpackgaming2492]

Why do you say that?