Microsoft Excel (2019) Certification Exam

If you clicked on this video you're probably wondering how am I ever going to pass the Excel 2019 or MO 200 exam when there's just no information out there about this exam?
CHECK OUT THE NEW UPDATED VERSION HERE:
• Microsoft Excel certif...
PATREON: / mikesoffice
UDEMY COURSE: www.udemy.com/course/mo-200-m...
Well I'm going to share with you this practice exam with 6 projects that will show you tasks that are similar to ones you might run into on your Excel exam so that you can be well prepared. We're going to look at chart elements, new Excel functions, and tons of other skills you need to learn for your exam.
TIME STAMPS:
PROJECT 1
1:07 Navigate to a range and delete range
1:42 Format numbers to no decimal places
2:25 Remove table row
3:11 Average Function
3:45 Concat (join) Function
5:19 Remove table functionality
5:50 Freeze rows
PROJECT 2
6:59 Copy a formula
7:25 Remove conditional formatting
7:52 Format a table so every other row is shaded (Banded rows)
8:34 Sort multiple columns
10:20 Max Function
10:56 Remove duplicates
PROJECT 3
11:52 Print Titles (repeat titles on multiple pages)
12:56 Filter data
13:45 IF Function
16:13 Multiple two values
17:00 Create a chart in Excel
18:27 Add an alt description
19:19 Insert Sparklines
PROJECT 4
20:08 Left align text
20:24 Left Function
21:21 Conditional Formatting (Three Traffic Lights)
22:17 Apply a table style
22:53 Change chart color (Monochromatic Palette)
23:18 Add a data table to a chart
PROJECT 5
23:54 Import data from a text file
25:16 Move a chart to its own chart sheet
26:08 Add chart element: Add axis titles to a chart
26:57 Remove elements in a chart-Chart legend
PROJECT 6
27:54 Copy and paste formatting
28:48 Table name
30:01 Use named ranges in a formula
31:18 CountBlank Function

[@jeffskeys6634]

Passed with a 975 thanks to you Mike. Did your udemy and watch your video. I recommend anyone to get Mike’s udemy because it’s almost 100% to the actual exam and will teach you every model they are looking for. Also Mike is a great teacher and explains the process to you well.

[@MikesOffice]

That makes me so happy that you performed so well on this exam and that this video and course could help! Great work, Jeff!! I’ll be posting some new stuff soon on what to do once you have that certificate and how you can use it to earn a promotion or dream job. Was this exam for work or school?? Great work and thank you so much for this nice endorsement!

[@jeffskeys6634]

This exam was for school. Could not get a grand unless I passed. Sitting on a A- as of now. Already have a degree in Psychology. Looking to get my CPA, just need the credit hours in accounting. I’m a staff accountant at the moment. You’re welcome with the endorsement, anyone reading this comment I really do mean to get Mike’s udemy it help me and I never used excel until last year.

[@Richardfan01]

@@MikesOffice I'm also taking this exam for school at no cost. It's not a requirement but it's something the Ted Rogers School of Management is offering free for all business students at Ryerson/X University. Definitely will look nice on my resume as an undergrad co-op student. Thank you for all your hard work Mike!

[@MikesOffice]

Oh that’s awesome! Makes sense. It’s industry standard Excel stuff. Check out the new one I just uploaded if it helps you and your colleagues!

[@jeffskeys6634]

@@MikesOffice Will do. Keep teaching Mike!

[@analyze.and.optimize]

Absolutely insane results. I failed my first Certiport exam a few weeks ago. I took a GMetrix exam this morning and failed it. Then I watched your video two times through today and just scored a 957 on my exam. I am a senior and if I failed this test, which I probably would have if I hadn't stumbled across your video, I would not have been able to graduate on time. You saved my life. Thank you so much, Mike.

[@sawaimalhi8439]

really?

[@kyleherndon1164]

Just finished taking and passing my MOS Exam. Didn’t study and watched this video once and had all that I needed to succeed. Mike is an awesome teacher of Microsoft office. Thank you!!!!!!!!!!

[@sweetteas2467]

I PASSED WITH A 914. Thank you so much Mike. For those who think they won't have a similar outcome like me, my first attempt, I got a 600. After studying and watching Mike's videos I brought that up to a 914. Im probably just like you and I know you can do it. Believe it!

[@sawaimalhi8439]

realy from youtube or udemy curses??

[@bigkranium4090]

You watch Naruto?

[@sweetteas2467]

@@bigkranium4090 oh I didn’t even realize I made a Naruto reference. But I have seen the show it’s good.

[@naslee3037]

Hey I have a question, do you have to pay to take the certification exam?

[@dee2954]

What did u study other than the video???

[@331755]

Took my UNT Excel Certification Exam and scored a 875/1000 from just an hour of studying this video! Thanks a ton Mike.

[@FedericoKog]

Thank you so much man! Got a 935 on the Certification, don't stop on helping people, you are making a big change by also teaching better than our actual teachers.

[@MikesOffice]

haha thanks man! 935 is an amazing score on the Excel exam. Well done. I'm glad this video could help.

[@tizianamartinho3056]

After I failed my exam on first attempt, I decided to watch your video and practice..I took it again today and I passed with 950✅ thank you so much! I had like 21min left 🙌🏾

[@rabikadana4700]

how much did you practice, and what did you use to practice?

[@Flameknight-mb5hy]

Tell us now😡

[@Blackkeysfan86]

I was terrified to take that exam because I did so poorly on my gemetrix tests. Your videos helped me so much and I just passed with a 978! I’m beyond thankful! You did an excellent job!

[@suzanne3t]

I'm a Black Keys fan, too!

[@desireegonzalez9073]

This was a fantastic guide. I watched twice from start to finish as the majority of the content I have never been exposed to. Your video depicted the examples very well. I took my Word exam 07/28 passing with a mere 700 and I learned from that experience not to spend too much time on anything or you will run out of time. Yesterday I scored an 978 on this exam which I didn't think I was capable of. I am grateful that someone with your skill has invested in this content for the good of others. This experience gave me the ambition to take my 3rd exam (Outlook) tomorrow. Thank you!

[@edhammerk]

Thank you so much for these videos! I took the Associate exam 2 weeks ago and then watched this practice exam and passed my advance test on Wednesday! I tried Access 2019 yesterday but didn't so I am looking forward to reviewing those videos but also checking out your patreon site! Thank you for helping, I recommend everyone to watch all these tutorials and use his patreon account to help you prepare for the exams.

[@hongboliu9244]

After watching the video, I finished my Exam with 900 points, thank you Mike! You are amazing!

[@saraafonso1141]

Just passed this exam thanks to you!! Thank you for all the work you’re doing here!

[@paigekortz1013]

I watched all of your practice exams for Microsoft Word, PowerPoint, and Excel certifications and I passed them all (with great scores) on THE VERY FIRST TRY! Thank you so much for taking the time to make these videos! They are very useful and I would highly recommend anyone taking these certification exams to watch these before!

[@somatiek7325]

Mike, thank you for creating these videos of the Microsoft Office exams. I studied the Microsoft books as well as watched your videos over and over, I took the MOS PPT, word and excel exams and passed all three at first try, thanks to your very detailed and simplified explanations of each task and function of these applications. Your series of videos' are truly one of the best tutorials on KZbin, you captured each question that one will encounter and went over it thoroughly. You have accomplished your mission by creating accessible learning for those who want to enhance their skills and further their careers. A big Thank you!!

[@stephanyst-jacques8152]

Just did MOS WORD Exam, passed using jasperactive, gmetrix learning paths. Then discovered your videos, the task's were almost exactly the same. Hopefully it is so, for the Excel and Power point exam. Thank you so much for sharing Mike!

[@Itsthebrownkid]

People from Canada that I love: 1. Mike’s Office 2. The Weeknd I made an 828 on my excel certification test, I owe it all to you. Thank you for the tutorial!

[@MikesOffice]

This made me laugh! This means a lot to make that list, thank you! 828 is a great score! I'm glad this video could help. Would you ever take the Excel Expert exam?

[@Itsthebrownkid]

@@MikesOffice glad to hear it! I haven’t done much research on the expert exam but wouldn’t be opposed to trying

[@gwyneth6151]

THANK YOU IT HELPED ME A LOT. WASNT ABLE TO STUDY ANYTHING FOR THE EXAM EXCEPT FOR LISTENING TO THIS VIDEO TWICE. BIG THANK YOU!!!! EARNED A SUB.

[@MatsGamed]

DUDE BIG THANKS TO YOU I MISSED 20 HOURS OF EXCEL CLASSES WATCHED THIS ONE VIDEO 900/1000 GOOD MAN!!!!! I LOVE YOU

[@MikesOffice]

That's awesome!! I'm so glad this video could help!!

[@TheDisciplinedPoser]

Hello, Any other recommendations to prepare for the exam besides this video?

[@MatsGamed]

@@TheDisciplinedPoser This is enough trust me just watch this video like 2 times and really look what he’s doing then you are gonna be fine i knew nothing of excel and I with this video I made it easily

[@aaronphang6936]

@@MatsGamed Is this better than working on the Gmetrix projects to prepare for the final.

[@MatsGamed]

@@aaronphang6936 all I know is that I didn’t know anything about using this program and after this video I was able to make the test easily

[@yankeeplayer08]

Thank you so much I was able to score a 925 studying this video for the past 4 days! I feel I understand Excel so much more now thanks to you.

[@soccerstarz502]

Thank you so much for this video. At first I was worried because there was literally no information about the exam but then watching your videos, practicing by doing the projects on Patreon and doing the GMETRIX exams really helped me pass with a 978!

[@JenniferRubyHan]

Thank you so very much. Because of you, I passed the Excel 2019 exam with a 871.

[@kaniyahm6004]

Thank you so much man. I failed the first time I took the exam with a 580. I studied on all sorts of platforms and still failed. However. I only watched your video a few times and passed with a 985 on my second try. You're a total lifesaver🙏🏽

[@waifung5247]

Big thanks to you ! Got a pass with 935/1000 All I did for preparation were , only watched this video twice and jotted some notes .

[@sehrishaqeel6545]

Absolutely on point! I watched just your videos for Word 2019 and PowerPoint 2019 and scored 945 and 940 marks. These videos are really helpful to go for the exam with confidence. Thanks!

[@corrinebresky4116]

Took the exam yesterday and got a 957! Thank you so much for this video - so incredibly helpful!

[@sambrook5909]

Honestly your videos have been a lifeline! Im currently studying this in the UK but i have office 365 installed however the course material is for office 2016 so some takes have not turned out as they shoud or function not available. Hopefully doing my exam in the next few weeks. So your videos have been great, Thank you.

[@Spear524]

My exam was exactly like the video. This video helped sooooo much since theres NO free study guide out there. Thanks a bunch Mike!

[@maobarcarse1833]

I just passed my MOS exam today! 11-08-2021 a very reliable source ;) BIG HELP!!!! 100% Thank you, Mike!!!!!

[@jennaryan6221]

I got a 957 after watching your video right before my exam! I scored a 745 on my first one only two weeks ago. Thank you so much, your video was so helpful!

[@MikesOffice]

That's a great score, Jenna!! I'm glad this video could help! Did you complete your exams as part of a course for school??

[@jeffery8168]

Your videos are a lifesaver. All the questions were very similar, without you I would have failed!

[@gabeeblamo4627]

THIS IS THE MOST ACCURATE TUTORIAL EVER! I JUST PASSED MY MOS EXAM LAST WEEK AND THIS TUTORIAL IS STILL RELEVANT TODAY!! I WATCHED THIS VIDEO SEVERAL TIMES AND IT REALLY HELPED ME UNDERSTAND THE WHOLE EXCEL ENVIRONMENT!!! THANK YOU SOOOOOO SOOO MUCH MIKE! YOU SAVED ME TIME!!!!!!!!!!!!!!!! KUDOS TO YOU!

[@janechioma9152]

I normally don't comment on KZbin videos often but this video and your excel formulas video helped me pass my excel MOS exam on my first try yesterday. I watched both the night before and also a few hours before the exam and scored a 892. I was doing great on the GMetrix practice exams but the formulas would always get to me until I watched your excel formulas video, without it I probably wouldn't have passed.

[@ninivlogs1756]

Thank you for this video!! I just finished my test and I passed with an 815!!! I watched this video before the test and it was almost the exact same type of questions!!

[@freshy6203]

Your videos have helped me pass word, PowerPoint, and I just passed excel today. Thank you so much for helping out!

[@KJ-qs3xf]

With the help of this video, I passed Excel 2019!! Thank you!!

[@sasham5251]

Hey Mike. Thank you very much for doing this video! It is awesome! I was able to pass my Exam. Also, the video that you made for 2016 Excel Exam was helpful as well!

[@momofverycutebaby]

Thank you, Mike. I passed my Excel 2019 exam with the help of your tutorial videos. I scored 950 in just a single try.

[@chorizojoe8282]

Please tell me you monetize these videos! You deserve all gain from this. You’re helping people out there, much respect !

[@brayanmartinez5434]

Thank you so much! I just passed my test with a 785 score in my second attempt for Neeley at TCU.

[@stephanier9685]

i just finished the test and i was really close to passing but i still want to thank you for making this video like the test was literally identical with what you taught and i understood it much better after i watched it

[@rossydiaz4273]

I took the exam yesterday amd your video really helped me remember and I loved your practice thank you

[@hanaragones7582]

Just completed the test today. Thanks a lot for this video, Mike. Helps me a lot.

[@MikesOffice]

Great work on passing your exam!

[@ranimaharaj-sharma4332]

Thank you.. Knowing what to except was great.. Much appreciated and well demonstrated...

[@machardoang3922]

Thank you so much I was able to pass my exam . I’m definitely subscribing to your channel!

[@PSJustMe12]

Passed with a score of 1000 just from watching this video twice! Thank you!

[@bryceharvey5572]

Thanks for your help Mike this video helped me get a 943 on my Microsoft Certification test. I was really worried about how the exam would go and this video helped me surpass my fears and expectations. Thanks for all your help Mike

[@clampsgiveup9235]

I just passed my exam because of you. I watched ur video like 3 times and passed my exam. Thank you so much. It was like 99% identical questions

[@k80389]

You are a lifesaver. I got really sick in the middle of taking my classes and missed so much. I tried my best by taking my GMetrix. Practice tests but this gives much clearer instructions. Thank you!

[@MikesOffice]

Sorry about you being sick but I'm so glad this could help you to pass the test!! Congratulations on getting your certificate in Excel. How were you able to find this channel/video?

[@k80389]

@@MikesOffice I found you when I searched Excel gmetrix practice test

[@jessalilpunchy]

I took this exam Thursday and made a 1000!! I did 2 practice tests from GMetrix in addition to watching this video, and I'd say this video covered about 80% of the stuff that was on the actual exam. Thank you for creating this for us!!

[@sawaimalhi8439]

wao can you please share me gmetrix steup??

[@harleycraig782]

passed with a 900, forgot about that =left function and had to skip it, but a lot of what you mentioned in this video and more recent videos were spot on and on the test. thank you

[@kingslimeball1098]

Passed my retake with a 700 right on the line. Sheeesh! Thank you for your help!!

[@Devilz1224]

I just took the exam today and because of watching this video several times and redoing the practice exams, I was able to pass with a 962 score. Previously, I have never had any background or even understand the basics of Excel, but because of this video, it helped me to understand what I needed to do and as well as the shortcuts to save time for the exam. Thank you so much Mike!

[@thehandicat6959]

Thanks to your video I was able to get a 962 on my certification test! It was my first one too and I’m really excited! Thank you so much!

[@karaleeanne6333]

Thank you so much for this video, I watched it twice and got a 978!

[@nyajoee]

I passed with a 721 on my second attempt for my business department at UNT, thank you Mike!!

[@tizianamartinho3056]

Congrats! How was it? I will retake it tomorrow at UNT too

[@nyajoee]

@@tizianamartinho3056 it wasn’t bad only a few that i skipped but i did run out of time again

[@MikesOffice]

The time limit is challenging. Well done on passing the Excel exam, Joseph!

[@tizianamartinho3056]

Joseph Badejo congrats!🎊

[@Itsthebrownkid]

Lmaoo busi 3100 #gmg

[@susansandell5370]

Your videos are awesome. They were exactly like the exam. I passed with a 914! Thank you so much!

[@raniajan4912]

Mike, you are the best! I just passed my Excel Certification Thank you sooooo much for your help.🙏

[@ShakespearesAriel]

This practice exam was 100% on point. I just took the certification exam and it was nearly identical. Thanks Mike!

[@clampsgiveup9235]

was the project order the same just different questions or not?

[@clampsgiveup9235]

like I know the questions wont be the exact same, just idea but I dont even know what i'm asking looll

[@ShakespearesAriel]

@@clampsgiveup9235 Maybe by chance, but my exam was nearly identical to this one in task questions (aka sparkline columns vs other options, or unrimmed traffic light conditional formatting vs other options). I don't exactly remember the order, but if you can do this one, I'd say you'd be good for the real one. He gives lots of good tips in this video. I also watched this playlist and the other from the 2016 exam. kzbin.info/door/GJWvOQnqN17JVLqsk-GqZg

[@louisdrage2227]

Did you take the associate exam? ("Microsoft Office Specialist: Excel Associate (Excel and Excel 2019)")

[@ShakespearesAriel]

@@louisdrage2227 yes. It was almost exactly like this video

[@sharod8504]

Just took my test and PASSED!!!! This videos was Extremely helpful! As I took the exam I was able to automatically recognize what they were asking for and was able to answer them with confidence! Thank you again for putting this video together!

[@djg7684]

Today was the last day of school for me and I passed with an 800! Thanks to you and the studying I did

[@roxsheida4004]

I want to thank you for this video. I took the exam and failed it but I didn't have my ADA assigned (extended time). I didn't feel like GMETRIX prepared me at all. I failed with a 533. I watched this video 2x and learned more than GMETRIX taught in the entire program. I passed with an 828!!! Tyvm!!! #GoArmy

[@noahrivera329]

Insane results. Just passed with a perfect score! Thank you so much!!!

[@hughjanus3485]

Failed the exam my first time with a 560, watched this and your other videos and just got a 925! Thanks so much it was a huge help!!!

[@matthewdam7500]

Highly recommend this video. Questions are almost similar to this guide right here!!

[@thiloshneemoonsamy1778]

Thank you so much! Passed my exam today with 957.

[@patrickmorris8219]

After watching this video and doing your Udemy course I passed with an 887! Thank you so much! Highly recommend the course.

[@monserratrodriguez2755]

Thank you so much for the Spanish subtitles! :)

[@KrissyMcKnight]

Bro this video helped save my grade. Had failed this test previously, and then finally passed after watching this!

[@reneewoodfin7021]

thanks for the test prep. passed the exam with a 950! Now, I need to decide if I want to do exper Word/Excel or Outlook next.

[@camilevalot2600]

I watched this video an hour before my test, and it was so helpful. Had I not watched it, I would not have understood anything, let alone pass. Thank you!

[@MikesOffice]

Great work, Camile! That makes me happy that you not only passed but understood the material more after watching this! That's my real goal. Was this your first Microsoft exam?

[@Sumit993]

Just wanted to share, that I scored 945/1000 on MOS Certification Exam today, a big thank you to you. Your every video helped me a lot. Thanks a lot.....

[@pasindunimshan3708]

Thanks Mike, your video helped me get my Excel Specialist certification. I got 831 out of a 1000 points. Thanks a lot.

[@themillman7517]

That's kinda crazy, I watched this through before my test and my score went from like 600 to 957. Thanks for the thorough breakdown.

[@Kreatorsink]

Thank you very much for your videos. It helped me pass my exam.

[@brandongood5401]

Passed with a 906, thanks for the video it helped a ton!

[@meghathakur7472]

Thank u Mike... I scored 935 marks... Ur video and the assignments tricks helped me to score well ....and was last moment saviour 👍

[@paco1669]

Thanks so much for this! I had a little bit of experience with excel but this helped a lot. I got 100%! Thank you so much!

[@kengchicheng9211]

I love u Mike!! You are one of a kind😘

[@peppno3702]

This video literally amazing, i passad my exam with 917 poin. Thank you so much

[@TheIcoolable]

Thanks a lot. This video helped me pass my exam I prob wouldn’t have passed without this video.

[@Stylishheart101]

I just passed my exam! Thank you so much for the course!

[@graceanamaria8919]

Thank you so much!! I watched your video twice through and got a 721!! Meaning in my excel class I got a 100%! Couldn’t have done it without your video!!!

[@MikesOffice]

Amazing work, Grace! Congratulations on getting certified in Excel and getting 100% in your Excel class! Glad this video could help!

[@joselynnnassimbwa1269]

Thanks for your help, I excelled at my certification exam yesterday

[@othihonghanh503]

Big thanks to you ! Got a pass with 1000/1000 All I did for preparation were, only watched this video twice and jotted some notes .

[@fatibenkhaled7343]

Thank you.took the exam yesterday and I passed. Thank you for all the videos .

[@shaleendutta3950]

Thank you so much Mike ,I mainly saw your videos and scored 807 in the MOS exam :)

[@abdullahalibrahim2008]

I just took my mo200 exam, and I passed it with 850 from the first time. Thank you for your helpful videos

[@chaloux9419]

You're a real one Mike. I failed the excel test twice but after this video i passed with a 934

[@mariahazel6707]

I always failed on my Gmetrix practice test until I watched your video twice before I took my exam and I passed with the score of 785! Yey! Very grateful for this video especially, Sir Mike! Thank you! This is my first attempt and I am very grateful that I already passed and received the certification right away.

[@MikesOffice]

That's amazing that you could use this video as a learning resource for getting certified, Maria! Well done!! Was this your first MOS exam?

[@Directorgeneral2032]

Perfect tutorial, thank you.

[@AL-vd8by]

Thx I got a high score so I got into the mos national championship. Personally this video helped more than jasperactive or gmetrix. I forgot everything so I have to study excel again, and this video restored my memories again.

[@Q8Patriot]

Thanks for the walkthrough, appreciate it

[@MikesOffice]

Anytime, Ahmad! Do you have an exam coming up?

[@themizzle1212]

just took the exam passed with a 90, this video got me like 12 questions right on my exam thank you so much

[@nicolsontv5852]

So cool, Thank you so much for all you do sir!

[@kamerynfini6621]

watched this video twice, just scored 825. exact answers. thank u so much!!

[@faithupshaw-mitchell2755]

I'd like to thank you for this video, it helped soo much! I am currently a freshman in college and have had trouble passing the Excel 2019 Cert. Exam for my Advanced Business class. I failed twice in a row; It wasn't until I came across your video, became a patreon member, and followed your practice exam along with my teacher's additional practice exams that I passed about 2 hours ago with a 957! Thank you Mike!

[@MikesOffice]

That's such a great score, Faith!! Well done. I'm so glad this video and the training resources helped! Thanks for becoming a Patreon member, it really helps me keep this going. How much was this test worth on your overall grade? You almost got a perfect score!

[@afaithphoto8074]

I got a 957 out of 1000!!😁

[@khiengmar102]

Hi Mike, I failed my first Certiport exam with score 405 in last month. I also took and practiced with in GMetrix but I can’t pass. Now I watched your video a few weeks and practice, I get a higher score 925. That awesome. Thanks for sharing your video.

[@KatieBoney]

just passed with flying colors, if you're taking the exam these videos are so helpful

[@adjadiakhate2923]

I've cleared the MO-200. Thank you for this great video!

[@parvavlogs3722]

is the offical exam conducted by online or exam center?

[@thomasackerman8150]

Yo much love my man just passed all thx to u