Microsoft Excel (2019) Certification Exam
HTML-код
- Опубликовано: 20 июл 2024
- 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 
Авто/Мото
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.
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!
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.
@@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!
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!
@@MikesOffice Will do. Keep teaching Mike!
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.
really?
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!!!!!!!!!!
Took my UNT Excel Certification Exam and scored a 875/1000 from just an hour of studying this video! Thanks a ton Mike.
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!
realy from youtube or udemy curses??
You watch Naruto?
@@bigkranium4090 oh I didn’t even realize I made a Naruto reference. But I have seen the show it’s good.
Hey I have a question, do you have to pay to take the certification exam?
What did u study other than the video???
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 🙌🏾
how much did you practice, and what did you use to practice?
Tell us now😡
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🙏🏽
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 .
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!
I'm a Black Keys fan, too!
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!
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.
After watching the video, I finished my Exam with 900 points, thank you Mike! You are amazing!
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!
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?
@@MikesOffice glad to hear it! I haven’t done much research on the expert exam but wouldn’t be opposed to trying
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.
haha thanks man! 935 is an amazing score on the Excel exam. Well done. I'm glad this video could help.
Hi there,
Could you please tell me. How to book test please.
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!
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??
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
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!
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
DUDE BIG THANKS TO YOU I MISSED 20 HOURS OF EXCEL CLASSES WATCHED THIS ONE VIDEO 900/1000 GOOD MAN!!!!! I LOVE YOU
That's awesome!! I'm so glad this video could help!!
Hello, Any other recommendations to prepare for the exam besides this video?
@@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
@@MatsGamed Is this better than working on the Gmetrix projects to prepare for the final.
@@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
MOS-200 Excel Certified , alot of the examples posted here were exactly like the test !! Thanks for the video , my score was 957/1000 CID#: H832-7121
Passed with 1000 on my first attempt thank you so much Mike. You are very good trainer.
I have watched your all video so many time .
Took the exam yesterday and got a 957! Thank you so much for this video - so incredibly helpful!
This practice exam was 100% on point. I just took the certification exam and it was nearly identical. Thanks Mike!
was the project order the same just different questions or not?
like I know the questions wont be the exact same, just idea but I dont even know what i'm asking looll
@@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. ruclips.net/channel/UCGJWvOQnqN17JVLqsk-GqZg
Did you take the associate exam? ("Microsoft Office Specialist: Excel Associate (Excel and Excel 2019)")
@@louisdrage2227 yes. It was almost exactly like this video
Passed with a score of 1000 just from watching this video twice! Thank you!
Thank you so very much. Because of you, I passed the Excel 2019 exam with a 871.
Please tell me you monetize these videos! You deserve all gain from this. You’re helping people out there, much respect !
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!
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.
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!!
wao can you please share me gmetrix steup??
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.
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.
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?
Today was the last day of school for me and I passed with an 800! Thanks to you and the studying I did
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!!
I passed with a 721 on my second attempt for my business department at UNT, thank you Mike!!
Congrats! How was it? I will retake it tomorrow at UNT too
@@tizianamartinho3056 it wasn’t bad only a few that i skipped but i did run out of time again
The time limit is challenging. Well done on passing the Excel exam, Joseph!
Joseph Badejo congrats!🎊
Lmaoo busi 3100 #gmg
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!
With the help of this video, I passed Excel 2019!! Thank you!!
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 RUclips, 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!!
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.
Just passed this exam thanks to you!! Thank you for all the work you’re doing here!
I didn't study for the exam, just watched this video twice and got a 914. Thank you!
the comments aren't cap I just got a 950/1000 and had been failing every exam before... you are the goat!
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!
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?
@@MikesOffice I found you when I searched Excel gmetrix practice test
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!
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!
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!
Thank you so much for this video, I watched it twice and got a 978!
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.
A big thanks you for the video it simple and better than what we have in class thanks 😊. I passed my certificate ✊🏾
I love hearing that! Congratulations on passing your exam!! Was this your first MO exam?
I do on my Patreon page! www.patreon.com/mikesoffice
I just passed my MOS exam today! 11-08-2021 a very reliable source ;) BIG HELP!!!! 100% Thank you, Mike!!!!!
Thank you, Mike. I passed my Excel 2019 exam with the help of your tutorial videos. I scored 950 in just a single try.
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!
Thanks mike, purchased your course on udemy and scored 957/1000.
realy please tell more about them plz
I normally don't comment on RUclips 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.
My exam was exactly like the video. This video helped sooooo much since theres NO free study guide out there. Thanks a bunch Mike!
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.....
Thank u Mike... I scored 935 marks... Ur video and the assignments tricks helped me to score well ....and was last moment saviour 👍
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
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!!!
Your videos are a lifesaver. All the questions were very similar, without you I would have failed!
Bro this video helped save my grade. Had failed this test previously, and then finally passed after watching this!
Yesterday I got my certificate with 978 points, thank you very much! 🎉😁
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!
Your videos have helped me pass word, PowerPoint, and I just passed excel today. Thank you so much for helping out!
I passed with a 935!!! Thank you so much Mike! Your videos helped me so much 🙏🙏🙏
Yes! Well done! 935 is a great score.
wao good can you help me how i do that course
Thank you.. Knowing what to except was great.. Much appreciated and well demonstrated...
Thank you so much! I just passed my test with a 785 score in my second attempt for Neeley at TCU.
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.
just passed with flying colors, if you're taking the exam these videos are so helpful
Thanks Mike, your video helped me get my Excel Specialist certification. I got 831 out of a 1000 points. Thanks a lot.
Passed my retake with a 700 right on the line. Sheeesh! Thank you for your help!!
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
May God bless you so much. I started your videos and decided to get the patron exam last week. Literally on Saturday and it was worth it. I got a 828. I passed.
Thanks for signing up for Patreon and supporting this channel! I'm glad it helped you pass your Excel exam!!
Thank you so much I was able to pass my exam . I’m definitely subscribing to your channel!
After watching this video and doing your Udemy course I passed with an 887! Thank you so much! Highly recommend the course.
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!
Mike, you are the best! I just passed my Excel Certification
Thank you sooooo much for your help.🙏
Bro I JUST did the test and literally got 100%! That's got to be my first one since like 14 loool
Nicely done, Nicholas! 100% is so impressive!
is the question literally like this?
@@feyy7520 no they’re different. Just similar
I am beyond terrified to take this exam tomorrow, I failed the first time and I've been studying for days with this video to help me.
I just took my mo200 exam, and I passed it with 850 from the first time. Thank you for your helpful videos
i have my test next Thursday, i’m hoping i’ll pass! This video seems pretty convincing! i used the word certification video and passed with the help of that video! i’ll update and hopefully say that i passed next week!
i just finished my test and got a 828! I will say that a lot of the tasks on the test weren’t in the video, so i would still use other resources as well to study, but this definitely helped a lot!
I will take my exam tomorrow.
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!
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!
I got a 957 out of 1000!!😁
I just wanted to confirm this video's legitimacy in providing mostly the questions that indeed reflected in the exam. I recently took the Excel Specialist exam and I failed at my first attempt after watching this video, but I do admit that I didn't actually invested my time in studying this, more like just scrolling here and there. However, in my second attempt, I analyzed this video thoroughly in order to serve as a guidance since the questions were somehow familiar to the previous set of questions I had-- I gave it a shot and it worked. I passed with an 857 (from what I remember) which is way much higher than what I have had before. For those who want to pass this test because it's a requirement for a school or when you don't have a choice, this is definitely worth to watch.
P.S. I kept some pdfs that I used to study for my test, comment here and I'll send the pdf copy for it. Good luck!
I’m down for those PDFs!! officesmikes 7@gmail.com. Great work, Angela! I wish more students would admit what you just did. There’s a difference between passively watching and actively watching and paying close attention. Congratulations on becoming certified!
@@MikesOffice Already sent! Continue to use this platform for accessible learning for everyone. I hope this can help for those who could not access specific modules for this certification. Thank you!
Your videos are awesome. They were exactly like the exam. I passed with a 914! Thank you so much!
I took the exam yesterday amd your video really helped me remember and I loved your practice thank you
This was great I used the udemy course and got a 825 on my first attempt, way better than the UNT course material/practice exam. My advise is to continue to take the udemy practice exam as many times as possible and when its time to take the real exam you will find that the time limit won't be an issue at all, you will fly through it.
Just completed the test today. Thanks a lot for this video, Mike. Helps me a lot.
Great work on passing your exam!
Thank you Mike for all of your excel content. I took my MO-200 today and scored 978! I missed one question! Taking the Expert Exam in two weeks.
Taking the expert exam in two weeks
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
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.
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!
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?
Thank you so much Mike ,I mainly saw your videos and scored 807 in the MOS exam :)
Scored a 978/1000 yesterday by studying Mike's videos on MO-200. His learning materials are awesome!
That's such a great score!!! Well done! And thanks for endorsing this channel. I'm glad they could help you become certified in Excel!
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!!!
Amazing work, Grace! Congratulations on getting certified in Excel and getting 100% in your Excel class! Glad this video could help!
Thank you so much for the Spanish subtitles! :)
Highly recommend this video. Questions are almost similar to this guide right here!!
Insane results. Just passed with a perfect score! Thank you so much!!!
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!
I passed with 925!! these videos helped me greatly, thank youuuuu
Passed with a 906! I did Mike’s Udemy course and studied the practice exams. He’s an excellent teacher and his course is amazing! Highly recommend! Thank you Mike.
Thank you, Alex!!! I’m glad you did so well on your exam and the course on Udemy could help!! So what’s next? Was this for school or work?
@@MikesOffice You’re very welcome Mike! This was for work. I have an accounting job and utilize excel everyday. So this certification helped me improve my excel skills and I can add this to my resume. Strongly considering the excel expert certification next 👍🏻
Thank you so much for this!! I got a 405 the first time and after watching your video 3 times my score went up to 875. Your video is so similar to the exam.