@A Kamran that is awesome! You did extremely well on the exam! Congrats to you! Thank you for taking the time to comment and let me know. I'm thankful to hear that you found my videos helpful as you prepared. Congrats again!
Just took the exam yesterday and got a 978. Thank you so much for the help! The most underrated advice you gave was “take a deep breath you are going to be okay”. I was super nervous at first until I was finally able to relax and focus the exam haha.
@supertantan This is great score! Congrats to you. I'm thankful to hear that something I said was helpful to you. Again congrats on your score. You did awesome!
I just took my MO-200 exam today and I passed it with a score of 892. I can't thank you enough for all of your videos, plus your advice on what to do on exam day. Thank you!!!
@Trevor Powell you did awesome! Congrats on passing the exam! Thank you for taking the time to comment. I'm thankful to hear that you found my videos helpful!
Your videos really helped me to understand the material and thanks to you and several others on UA-cam I passed my excel associate exam and I’m now officially certified!
Brendan, your videos are an absolute jackpot for all of us, who seek to obtain these certificates! I took my MO-200 exam today, scored 1000 points and even had 17 minutes of time left. I prepared solely by watching your videos taking notes and reviewing the material. By watching these videos all of you will be well equipped for the exam. Thank you very much Brendan, keep up the great work, it is well appreciated! Word is the next step for me now.
@@sawaimalhi8439 I suggest you to really watch Brendan´s videos related to MO-200 exam, take notes and follow his explanations in your own excel document (you can simulate a lot by yourself, create your own data and play with it) this way you can get a good feeling for the locations of the required action within your ribbon tabs. To put this into perspective, I have used excel during two six month internships, my bachelor´s and for some private calculations, so I am not a pro user yet. Another suggestion I have is that you look for a channel called Mike´s Office, he has a mock exam and guides you through it. This is very close to the real exam.
@Sawai Halhi what Soap mentions is great advice. Practice is going to be key. Make sure that you are familiar with the functions that you could be asked to perform on the exam. Here is a video that I did on functions ua-cam.com/video/Etp4j2LjvZM/v-deo.html.
I just got home from taking my MO-200 exam and I passed because of your videos. The online college course and textbook I paid for did not prepare me for this exam, your video series did. Pretty much everything you covered in the series was on my exam. Thank you so much!
I pray that I will pass that MOS Excel certification exam. My examination is on June 16 this friday. I will be back to this video to thank you becausw I passed and got that MOS Certified Excel Associate Specialist ❤
Just watched this video before a sat for my final, the certification exam. Helped me get the little tips and tricks. Also helped me breathe through it. Passed with ease. Thanks.
If you watch and take notes on all of Brendan's videos on the MO-200 exam, you will pass the test. I spent a week watching all of his videos two times and scored a 978/1000 yesterday!
@Jang Park Watching all of my videos sounds a little torcherous. LOL I'm thankful to hear that you found my videos helpful! You really did awesome on the exam. Congrats on earning your certification!
@Phoenix Martial Arts This is awesome! Congrats on earning your certification! I'd like to make a few videos on the Excel Expert MO-201 exam at some point. This year has been crazy, and I haven't been able to produce content, like I would have liked to. Maybe sometime in the future. Congrats again!
@Sam Oh You did awesome on the exam! Congrats!... I want to warn you about the Expert Exam. It is going to be much more difficult. You cannot be over prepared for that exam. The wording of the task questions can be confusing and you might need to read the task more than once to understand what they are asking you to do. Also review the exam objectives, specifically the functions for the exam. You can find all of that information here: docs.microsoft.com/en-us/learn/certifications/exams/mo-200. You should feel comfortable using all of the functions on that list. I wish you the best!
@@Brendan_Sinclair I took the expert exam today and I was able to pass with the score 727. I took a bunch of practice exams including the ones in Gmetrix, and I was able to get perfect scores or close to perfect. But like you said, it was much more difficult, and there were 1 or 2 questions I couldn't answer due to the wording of the question. Thank you again for all of your tutorials and advices. Stay safe and cheers!
I just took the MO-200 exam today so heres my thoughts/tips The formatting is really bizarre, the excel interface screen can be quite small when trying to read labels/information on graphs. You will constantly be battling between scrolling up and down between the excel interface screen and the question prompts right below. Make sure you are reading all the questions in their entirety. Flag the ones you dont understand or are in question and just move on. For some reason today when I took it and continued through the 6 projects I was given, I thought I had extra time (17 minutes) to review my answers, only to find out at the last 5 minutes of the exam an entire section was skipped. Somehow during the exam as I was going through the projects it skipped project 3 so there was a bunch of unanswered questions? I had to scrambled to get those done. Most of the questions were just managing workbook options and settings, adjusting language/macros in the options section, modifying a few charts or formulas, record a macro, and then a few formulas you had to create. I ended up passing, but felt a lot of my time was spent fumbling around adjusting the screen between excel and the question section below it or trying to fix the pivot table information so I could see what was in the filters column, etc. Overall not a super difficult exam, I would just make sure you have some practice with formulas, working in pivot tables, some conditional formatting (just a basic knowledge), for some of the more difficult/trickier questions that may come about.
@Antonio ODonnell This is awesome news! Congrats to you on earning this certification! Thank you for taking the time to comment and let me know. It means a lot to em.
Man your videos are super so easily explained. what baffles me is how the hell have you only 8.25k subcribers, man your top well done keep it up pal. please do videos on the rest of the 2019 exams please
@The Kidd Productions I'm thankful to hear this. I would encourage you to look at your score reports and focus on the domains that you scored the lowest in. I wish you the best.
Hello Brendan. First, I'd like to thank you for taking the time make this kind of content on your channel; it's valuable and essential to passing the exam. And are you planning to make videos for MO-201?
@Sam Oh I'm thankful to hear that you are finding my content valuable. I would like to create a few MO-201 videos, but I still have a lot of MO-100, MO-200, and MO-300 content to create. It is going to be a while before I begin to make MO-201 content sadly.
I have Excel 365 (Microsoft Office Apps for enterprise) installed on my PC. Can I use that to study/practice for the MO-200: Microsoft Excel (Office 2019) exam?
Hi Brendan! You are doing a wonderful job with your videos and explaining everything that we should study. Do you recommend that we go over any official practice tests for the mo-200 exam?
@Trevor Powell Thank you for your kind words! If you are looking for additional materials I would recommend this book MOS Study Guide for Microsoft Excel Exam MO-200: amzn.to/3aXgYYd. The GMetrix software is a great simulation software that you can purchase www.gmetrix.com/Products/Filter?Certification=Microsoft+Office+Specialist+(MOS)&Version=Microsoft+Office+365%2f2019&Type=Tests. If you are looking for something free, I created a practice exam for the Excel 2016 exam ua-cam.com/video/D3vmHuUdx4o/v-deo.html. Many of the exam objectives are the same between 2016 and 2019. The main differences are the functions that you could be asked to perform.
Hi Brendan I really love your videos! I am already Microsoft Office Specialist Master on 2013 and 2016. Now I'm on the exam for 2019/365. My question is, will you make some videos for mo-101 and mo-201? I would appreciate it very much! Many greetings from switzerland!
@Nicole Roloff I'm thankful to hear that you are find the videos helpful. As much as I would like to create a few videos for the MO-101 and MO-201 exams, I do not see that happening in the near future. Unfortunately, this school year has been much more demanding than I had anticipated, and it has hindered what I have been able to create for UA-cam.
Thank you so much for the advice! In a few hours I'm going to have my exam. I just want to know is if ok if I have windows 11 instead of windows 10, there would be a problem?
Not to sound ignorant, but could someone explain the difference between MS 200 and MS 201 Certifications? I feel like I should know the answer but it's escaping me. How would the exams differ, if they do at all?
@Thiago Vicente, Yes, the exams are fairly similar. There are some difference, mainly the functions that you could be asked to perform on the exam. Here is a playlist that I created for the Excel 77-727 exam ua-cam.com/play/PLEqweL5D54PBNNCaCWKmOQC9Z5f-7Wzdd.html.
Brendan I took the 2019 Excel Expert exam. One thing that threw me off was the ribbon was different on the exam than what I have on my 2019 Home Excel version. The ribbon had icons and not names and I had to hover over each one to see what it was. Everything had been moved around. I was not prepared for this and wasted a lot time. Do you know why the ribbon is different on the exam? Are they using a different 2019 version? Also, when I finished the exam there was a message that there was a error with submisson and to contact the proctor. The proctor didn't have a clue what was wrong. I checked my Certiport account and it says failed but there are no scores. I am thinking my exam never got submitted.
@fmih I'm sorry that you had this experience. That exam is hard enough without having the issues that you experienced. I think that maybe the reason that your ribbon was different is because of window size of Excel. The ribbon adapts to the size of your program. If the icons can't all fit, they get truncated to make them all visible on the ribbon. Every testing center is different, so you they might been using the 2019 version or they might have been using the 365 version. There are a few differences between the two. The 365 version has a few additions to the ribbon, but I'm not sure if that would have been the reason for your issues. Did the proctor call Certiport to get the issue solved? I would call Certiport and talk to them about the issues that you had. Maybe they can do something for you.
Hi Brendan, I'd like to pass MO-200 exam to get MOS certification, so I've checked out you tips and advice. I bought Joan Lambert's MOS study guide and took the Gmetrix/LearnKey course. i have never taken any pre-assessement so I wonder if you offer individual lessons so as to prepare me directly for the exam. Thank you, Nicola
@ brendan What is the duration of exam ? What is the minimum time to complete exam ? How much time will be needed to perform one project ? What is the total marks and minimum passing marks ? Do we have to submit our Exam within time ? Or our exam will automatically submit when time finishes ?
I have a couple questions regarding the MOS Certifications. Where exactly to I sign up/purchase taking the exam? Which MOS exams do I start with? I'm a finance college student, primarily interested in taking the Excel exam but may look to take more. I have some experience using most of the different Microsoft applications.
@coronac805 The process for you is going to be a little different from the process that I would go through for my students taking the exam. Here is a link to Certiport regarding exams: certiport.pearsonvue.com/Certifications/Microsoft/MOS/Certify/Office-365-and-Office-2019. In my opinion, I would begin with the Excel 2019 MO-200 exam. After that, I would look into the Excel Expert 2019 MO-201 exam. The Excel Expert exam is a difficult exam. If you are still looking to earn more certifications, I would look at earn the MOS Expert certification. The link I provided explains how to obtain the MOS Expert certification.
Hi, Brendan! Thanks for the video. You said that it is important for the MOS 200 to pay attention to the Objects and SmartArts settings, but I did not find this requirement in the measured skills document on the Microsoft page. Isn't that only for the 2016 test? Thank you!
@@Brendan_Sinclair Thank you very much for the reply. My English is so bad, so maybe my question may seem aggressive. Please don't think that. Thanks again, now I'm calmer, hehe.
@Leonardo Turra I didn't take your question as being aggressive. I was trying to joke around with my comment back. That doesn't always come out in text. Let me know if you have any other questions.
Hi Brendan I am using bought practice exams to prepare for my O365 certification exams and at the moment I am going through the Excel questions but it keeps marking 2 particular questions wrong although I think they are right. Q1 is format a set of cells so that they show the US $ left aligned and the decimal points all aligned. I am doing this by using the number options, currency and accounting as I believe that this is the only one that meets the requirements. Q2 is to select text from one cell and use a hyphen (with a space either side) to separate it from text in another cell so that they appear together in one cell for example High - Low. I am using the TEXTJOIN function and the result looks exactly as it should in the result cell but it keeps marking me wrong. Am I doing this incorrectly? Any advice would be greatly appreciated. Thank you for your videos they are great.
@Susan Cockburn who made the practice exams? On your second question, I think that you need use the CONCAT function. Here is a video on the CONCAT function ua-cam.com/video/14tHoIJz_UA/v-deo.html and another on the TEXTJOIN function ua-cam.com/video/c29nlp6oMl0/v-deo.html.
I ordered the book MOS Study Guide for Microsoft Excel Exam MO-200 and downloaded the exercise folder from the book. Unfortunately, I couldn't open all files. My excel is the most updates one. Anyone can help!? very appreciate it !!!
@Gregory Green GMetrix is a great resource. I use it in my classroom to evaluate my student's skills. I've had a lot of success in my classroom and I will share one of my biggest secrets to my student's success... I ask my students to get a 900 or better on all of the Practice Exams before I will allow them to take the certification test. Making my students earn that score makes them work through their weaknesses. I also stress the importance of knowing the functions. Make sure that you know them before sitting for the exam. Here is a video that I made on the functions that you could be asked to perform on the exam ua-cam.com/video/Etp4j2LjvZM/v-deo.html.
Hi. I took my excel exam today and there was one question I still cannot figure out. How to use the left function with showing all text in uppercase. can you help me with that?
@Wajiha Khan I've only made one video on Access. The video can be found here ua-cam.com/video/bk6DAqmJ_VY/v-deo.html. Honestly, there hasn't been much interest in Access videos.
@Jonathan Straiton I do not currently have any course recommendations for this exam at this time. I would recommend these books: MOS Study Guide for Microsoft Excel Exam MO-200: amzn.to/2KZo5VO Microsoft Excel 2019 Step by Step: amzn.to/2M2Fa0D Excel 2019 Bible: amzn.to/2M9IJSV In the past, I have used Lynda.com to prepare for the Word and Excel Expert exams.
This is what I done below, as nothing 1. Locate your local Certiport Authorised Centres (www.certiport.com/locator) 2. Select any the providers and go to the website 3. Then search for, Home Study packages 4. During Covid-19 some providers are offering these packages, but you may need to call or email and request this. I'm based in UK and www.mousetraining.london is offering a HomeStudy Kit £146 Included in kit: A. MS Official book B. Exam Coupon C. Exam style questions. The owner named Michael really knowledgable (not just a salesman). **THE BEST BIT** is some providers are doing HOME TESTING!! so need to go to centre.
HI Brendan-Your doing a great job. Will you be doing any videos on Excel Expert? Can you take the Excel Expert exam without taking the Excel core exam? I did pass the 2016 Excel core exam and now I want to try the 2019 Excel expert exam. Or should I just take the 2016 Excel expert exam?
@fmih Excel Expert is on my projects list, but I am currently working on something else. Yes, you can take the Excel Expert exam without taking the core Excel exam. Are you planning on taking any other MOS 2016 exams? I ask because both the 2016 and the 2019 exams contain a path for special titles. The 2016 is the Microsoft Office Specialist Master and the 2019 is the Microsoft Office Specialist Expert. In order to obtain those titles, you have to earn specific certifications to qualify. If you don't plan on working on either of those tracks, then I would probably take the 2019 Excel Expert exam if I were in your shoes. Let me give you a word of caution. The Excel Expert exam is a very difficult exam. I cannot encourage you to prepare enough. This link covers the domains of the exam query.prod.cms.rt.microsoft.com/cms/api/am/binary/RE44NP0. I would recommend this book as well MOS Study Guide for Microsoft Excel Expert Exam MO-201: amzn.to/3aX8uAs.
@@Brendan_Sinclair no, I don't plan on taking any more 2016 exams. I did pass Powerpoint 2016. I want to focus on just passing the 2019 exams, even though there doesn't really seem to be that much difference between 2016 and 2019 material. If I can pass the Gmetrix Excel Expert, I should be able to pass right? I didn't find it that difficult. Have you taken the 2019 Excel Expert? Thanks for your advice.
@fmih Yes, I have taken and passed the Excel Expert Exam for both 2016 and 2019. Feeling comfortable with the GMetrix content is a great first step. I wouldn’t say that this means you will pass. The expert exams are much more difficult than the core exams. Obviously the content being tested on is difficult, but the wording of the task questions add to the complexity. You have to act on instinct to complete the task. I can’t stress enough knowing all of the functions that you could be tested in.
@@Brendan_Sinclair Do you remember what you saw on the 2019 Excel expert exam that was new? Was it similar to the 2016 Excel expert exam? I found the tasks on the exam to be very similar to the ones on Gmetrix. I had never used and didn't even know what PowerPoint was and managed to pass with a 920 by using Gmetrix and watching your videos.
@fmih I can't share specifics for what I saw on the exam. There is some similarity between the 2016 and 2019 Excel Expert exams. The functions that you could be asked to perform on the exam were updated in 2019. In my mind, I had thought I knew the functions that they would ask me but I was wrong in my assumption. In my opinion, I thought the 2019 exam seemed to be harder than the 2016 exam. A big reason for this is because of the wording of the task questions. Some advice that I give my students when they take the expert exams is you are going to feel overwhelmed at some point in the exam. Take a step back for a second and take a deep breath if you need to. Don't underestimate the difficulty of the 2019 Excel Expert Exam. I don't believe that you can over-prepare for this exam.
@mert ceyhun Can making videos for the MO-201 exam is something that I would like to do in the future, but I am still working on videos for the MO-100, MO-200, and MO-300 exams. Is there anything in particular you are looking for?
One last question. The test is given using Excel 2019 but I have 365. I have look at so many videos stating that they are the same some say they are different. What are your thoughts?
@Toqir Mulak I've begun working on making a project for this exam, but it is not ready to be released. The process is going to be delayed for a few weeks as school starts back up and the majority of my attention is getting ready for the new school year. I did a project for the Excel 2016 exam here ua-cam.com/video/D3vmHuUdx4o/v-deo.html. Many of the concepts found in the project can be found on the 2019 exam. The main exception will be the functions that you are asked to perform. Here is a link that breaks down the exam docs.microsoft.com/en-us/learn/certifications/exams/mo-200.
@imwestendbanker I would say that the main difference between the two exams are the functions that you are asked to perform. Here is a video that I made that covers the functions that you could be asked to do on the Excel 2019 MO-200 Exam: ua-cam.com/video/Etp4j2LjvZM/v-deo.html and one that I did for the Excel 2016 exam 77-727: ua-cam.com/video/GmqzinAs31M/v-deo.html. I have a playlist for each exam listed below with lots of material for both exams. Excel 2019 MO-200: ua-cam.com/play/PLEqweL5D54PAyQ6UF8I4PRZ9B5Bk2PynP.html Excel 2016 77-727: ua-cam.com/play/PLEqweL5D54PBNNCaCWKmOQC9Z5f-7Wzdd.html
@Roy Mosby you are not able to take the exam on the Mac. Here is a link from Certiport on which exams can be taken on PC/Mac certiport.pearsonvue.com/Support/Technical-requirements.aspx.
Hey Brendan. Great video. Do you think it's possible to cram/study this exam in about 10 days and still pass? I'm a novice with Excel, but I'm also really good with tech and used to be an IT. I'm asking because I can get out of a college course if I have an MO-200 certification... but I have a June 15th deadline. What do you think? Cram/study for the exam OR just take the college course? Thanks!
@Andrew Tennant, I would say no for most people, but it is possible. I have helped teachers do it during a two-week crash course quite a few times. Your IT background might be helpful to you. You should look into the GMetrix software for prep. Here is a link www.gmetrix.com/Products/Filter?Certification=Microsoft+Office+Specialist+(MOS)&Version=Microsoft+Office+365%2f2019&Product=MO-200%3a+Excel+Associate+365%2f2019. If you decide to get that software, I would encourage you to get at least a 900 on all of their practice tests before you sit for the exam. I would also recommend that you view some of my 2016 Excel materials ua-cam.com/play/PLEqweL5D54PBNNCaCWKmOQC9Z5f-7Wzdd.html. For the most part, the 2016 and the 2019 tests cover the same content. The main difference is the functions that are used on the exams. Here is a video that I created on the Functions you might be asked to perform on the Excel 2019 exam ua-cam.com/video/Etp4j2LjvZM/v-deo.html. I also created a free project for the Excel 2016 exam that you could use for practice ua-cam.com/video/D3vmHuUdx4o/v-deo.html. Most of it will be relevant for the Excel 2019 exam. A book that I would recommend is MOS Study Guide for Microsoft Excel Exam MO-200: amzn.to/3aXgYYd. I'm not sure if I answered your question or not. If you have any more questions let me know.
@userme The links are in the description, but you can also access them here: Excel 2019 Exam Page (Certiport): certiport.pearsonvue.com/Cert... Excel 2019 Exam Page (Microsoft): docs.microsoft.com/en-us/lear...
@Robert Vargas This playlist isn't complete, but yes, I believe that you can use it to aid in test preparation. The videos in this playlist were created specifically to cover concepts that you could see on the exam. Here is a link to the Microsoft Excel 2019 Exam Page which lists all of the concepts that you could see on the exam certiport.filecamp.com/uniq/nY6SgqYbd6rDtIU1.pdf.
Brendan Sinclair thank you I have the list from them too. It’s so hard to find a online course one that is good and second that I can understand the English
Thanks for your videos. I have taken the MOS Excel 2019 exam today and passed with 98% marks (978/1000). Your videos helped.
@A Kamran that is awesome! You did extremely well on the exam! Congrats to you! Thank you for taking the time to comment and let me know. I'm thankful to hear that you found my videos helpful as you prepared. Congrats again!
Could you please recommend a or few PREPARATION COURSE/S OFFERED ONLINE besides Brendan's tutorials?
help me
i’m taking it in 28 minutes and i haven’t studied at all
@@matthewschwab9316 How did it go? xD
Just took the exam yesterday and got a 978. Thank you so much for the help! The most underrated advice you gave was “take a deep breath you are going to be okay”. I was super nervous at first until I was finally able to relax and focus the exam haha.
@supertantan This is great score! Congrats to you. I'm thankful to hear that something I said was helpful to you. Again congrats on your score. You did awesome!
I just took my MO-200 exam today and I passed it with a score of 892. I can't thank you enough for all of your videos, plus your advice on what to do on exam day. Thank you!!!
@Trevor Powell you did awesome! Congrats on passing the exam! Thank you for taking the time to comment. I'm thankful to hear that you found my videos helpful!
Your videos really helped me to understand the material and thanks to you and several others on UA-cam I passed my excel associate exam and I’m now officially certified!
Brendan, your videos are an absolute jackpot for all of us, who seek to obtain these certificates! I took my MO-200 exam today, scored 1000 points and even had 17 minutes of time left. I prepared solely by watching your videos taking notes and reviewing the material. By watching these videos all of you will be well equipped for the exam. Thank you very much Brendan, keep up the great work, it is well appreciated! Word is the next step for me now.
plese guide me how to prepre for that exam
@@sawaimalhi8439 I suggest you to really watch Brendan´s videos related to MO-200 exam, take notes and follow his explanations in your own excel document (you can simulate a lot by yourself, create your own data and play with it) this way you can get a good feeling for the locations of the required action within your ribbon tabs.
To put this into perspective, I have used excel during two six month internships, my bachelor´s and for some private calculations, so I am not a pro user yet.
Another suggestion I have is that you look for a channel called Mike´s Office, he has a mock exam and guides you through it. This is very close to the real exam.
@Sawai Halhi what Soap mentions is great advice. Practice is going to be key. Make sure that you are familiar with the functions that you could be asked to perform on the exam. Here is a video that I did on functions ua-cam.com/video/Etp4j2LjvZM/v-deo.html.
Without you idk if I pass but watching these I got a 962/1000 thank you
I just got home from taking my MO-200 exam and I passed because of your videos. The online college course and textbook I paid for did not prepare me for this exam, your video series did. Pretty much everything you covered in the series was on my exam. Thank you so much!
Thank you so much! I watched all your excel 2019/365 videos and passed the exam today with 871/1000! :)
@Karolina Sudzinska Congrats! This is no small feat. You did awesome and I appreciate that you took the time to comment.
@@Brendan_Sinclair Thank you! I appreciate people like you helping others for free 😊 keep up the Great work you do
I pray that I will pass that MOS Excel certification exam. My examination is on June 16 this friday. I will be back to this video to thank you becausw I passed and got that MOS Certified Excel Associate Specialist ❤
Just watched this video before a sat for my final, the certification exam. Helped me get the little tips and tricks. Also helped me breathe through it. Passed with ease. Thanks.
That is awesome to hear! I'm glad to hear that my video was helpful!
I passed all three certificates because i watched you and mike’s videos. Thank you so much.
If you watch and take notes on all of Brendan's videos on the MO-200 exam, you will pass the test. I spent a week watching all of his videos two times and scored a 978/1000 yesterday!
@Jang Park Watching all of my videos sounds a little torcherous. LOL I'm thankful to hear that you found my videos helpful! You really did awesome on the exam. Congrats on earning your certification!
realy so plz guide me also where i started from
I passed the first time thanks in large part to these videos. Hugely appreciated, thank you Brendan! Hope that you do a series on the next Excel up.
@Phoenix Martial Arts This is awesome! Congrats on earning your certification! I'd like to make a few videos on the Excel Expert MO-201 exam at some point. This year has been crazy, and I haven't been able to produce content, like I would have liked to. Maybe sometime in the future. Congrats again!
Hey just wanted to say thank you! I passed MOS Excel 2019 today with a 957, your videos helped me soo much!
@Doc68 this is awesome news. Congrats on earning your certification! You did very well on the exam. Thank you for taking the time to comment.
Thank you Brendan for all of your excel content. I took my exam today and scored 978! I missed one question! Taking the Expert Exam in two weeks.
@Sam Oh You did awesome on the exam! Congrats!... I want to warn you about the Expert Exam. It is going to be much more difficult. You cannot be over prepared for that exam. The wording of the task questions can be confusing and you might need to read the task more than once to understand what they are asking you to do. Also review the exam objectives, specifically the functions for the exam. You can find all of that information here: docs.microsoft.com/en-us/learn/certifications/exams/mo-200. You should feel comfortable using all of the functions on that list. I wish you the best!
@@Brendan_Sinclair I took the expert exam today and I was able to pass with the score 727. I took a bunch of practice exams including the ones in Gmetrix, and I was able to get perfect scores or close to perfect. But like you said, it was much more difficult, and there were 1 or 2 questions I couldn't answer due to the wording of the question. Thank you again for all of your tutorials and advices. Stay safe and cheers!
Love the big boy figurine in the background!!! My favorite place to go as a child. :)
I just took the MO-200 exam today so heres my thoughts/tips
The formatting is really bizarre, the excel interface screen can be quite small when trying to read labels/information on graphs. You will constantly be battling between scrolling up and down between the excel interface screen and the question prompts right below. Make sure you are reading all the questions in their entirety. Flag the ones you dont understand or are in question and just move on. For some reason today when I took it and continued through the 6 projects I was given, I thought I had extra time (17 minutes) to review my answers, only to find out at the last 5 minutes of the exam an entire section was skipped. Somehow during the exam as I was going through the projects it skipped project 3 so there was a bunch of unanswered questions? I had to scrambled to get those done. Most of the questions were just managing workbook options and settings, adjusting language/macros in the options section, modifying a few charts or formulas, record a macro, and then a few formulas you had to create. I ended up passing, but felt a lot of my time was spent fumbling around adjusting the screen between excel and the question section below it or trying to fix the pivot table information so I could see what was in the filters column, etc. Overall not a super difficult exam, I would just make sure you have some practice with formulas, working in pivot tables, some conditional formatting (just a basic knowledge), for some of the more difficult/trickier questions that may come about.
Hi Brendan,
Today I was able to pass the exam. All your tutorials, tips and advice were a huge help! Thank you!
@Antonio ODonnell This is awesome news! Congrats to you on earning this certification! Thank you for taking the time to comment and let me know. It means a lot to em.
Could you please recommend a or few PREPARATION COURSE/S OFFERED ONLINE besides Brendan's tutorials?
@@TheDisciplinedPoser LinkedIn learning has a good course for this certification. I did plus Brendan's tutorials.
Thanks for your videos. I watched them. Today was my exam. I scored 957/1000.
@Mariela Busheva you did very well on this exam. Congrats to you!
Thanks
UA-cam won't allow me to like the channel! I did subscribe!
Thank you! Your videos helped me pass the exam today!
Thank you so much, Brendan. Your videos were of great help. Passed MOS-200 Excel exam today God Bless.
Thank you for sharing. Great content.
Thank you Brendan for your videos. Scored 981 using your videos. Was very helpful for preparation. Thanks again.
Man your videos are super so easily explained. what baffles me is how the hell have you only 8.25k subcribers, man your top well done keep it up pal. please do videos on the rest of the 2019 exams please
This helped me alot i have failed the test three times and im hoping it will help me this time.
@The Kidd Productions I'm thankful to hear this. I would encourage you to look at your score reports and focus on the domains that you scored the lowest in. I wish you the best.
Thank you for your videos! Your tips really helped me to prepare for the MO-200 exam. I passed with a 950!
@John Jarvis that is a really great score. You really knew your stuff. Great job! Thank you for taking the time to comment.
First off great videos they are very helpful. Secondly, where did you get this music it's awesome!
Hello Brendan. First, I'd like to thank you for taking the time make this kind of content on your channel; it's valuable and essential to passing the exam. And are you planning to make videos for MO-201?
@Sam Oh I'm thankful to hear that you are finding my content valuable. I would like to create a few MO-201 videos, but I still have a lot of MO-100, MO-200, and MO-300 content to create. It is going to be a while before I begin to make MO-201 content sadly.
Love this video,. Im planning to take mos exam where to find mos excel reviwer.
Can't wait for the video tutorials!
Just passed 978/1000. Great videos. Keep up the good work.
@Sally Zhu you did awesome on the exam! Congrats!
@@Brendan_Sinclair Thank you very much.
I would like to know which software MOS is using to test and to mark practical assessments?
Hi Brendan!Awesome Tutorial with Excellent Tips Thank You.
I have Excel 365 (Microsoft Office Apps for enterprise) installed on my PC. Can I use that to study/practice for the MO-200: Microsoft Excel (Office 2019) exam?
Thanks a lot :) Your videos are so helpful to me
Thanks brendan. I passed with score 914.
@Haryati Saphihis that is great. You did awesome on the exam!
OMG, I found your video 1 day before my exam and gmetrix has been a failure😭 Hopefully I will pass.
Did you pass?
Hi Brendan! You are doing a wonderful job with your videos and explaining everything that we should study. Do you recommend that we go over any official practice tests for the mo-200 exam?
@Trevor Powell Thank you for your kind words! If you are looking for additional materials I would recommend this book MOS Study Guide for Microsoft Excel Exam MO-200: amzn.to/3aXgYYd. The GMetrix software is a great simulation software that you can purchase www.gmetrix.com/Products/Filter?Certification=Microsoft+Office+Specialist+(MOS)&Version=Microsoft+Office+365%2f2019&Type=Tests. If you are looking for something free, I created a practice exam for the Excel 2016 exam ua-cam.com/video/D3vmHuUdx4o/v-deo.html. Many of the exam objectives are the same between 2016 and 2019. The main differences are the functions that you could be asked to perform.
That outro music goes hard!
Is this playlist sufficient to pass the microsoft certification exam?
Is there any truth about shortcuts not being captured by the system evaluating you? I keep hearing it at formation
Hi Brendan
I really love your videos! I am already Microsoft Office Specialist Master on 2013 and 2016. Now I'm on the exam for 2019/365. My question is, will you make some videos for mo-101 and mo-201? I would appreciate it very much!
Many greetings from switzerland!
@Nicole Roloff I'm thankful to hear that you are find the videos helpful. As much as I would like to create a few videos for the MO-101 and MO-201 exams, I do not see that happening in the near future. Unfortunately, this school year has been much more demanding than I had anticipated, and it has hindered what I have been able to create for UA-cam.
Thank you so much for the advice! In a few hours I'm going to have my exam. I just want to know is if ok if I have windows 11 instead of windows 10, there would be a problem?
How did you do? Did this video help?
@@1dgrandson Yes, I did it very well, thank you very much😄
@@jialincv389 That’s wassup!
I've seen conflicting sources stating the MO-200 exam length as 50 or 90 minutes. Can anyone please confirm current exam length. Thanks.
Hey , i am from nepal and i want to attend MOS exam for the first time , which version of excel should i do excel 2016 or 2019 please advice.
Not to sound ignorant, but could someone explain the difference between MS 200 and MS 201 Certifications? I feel like I should know the answer but it's escaping me. How would the exams differ, if they do at all?
Hi Brendan! First of all, thanks! Please let me know if this exam is similar to 77-727. Regards.
@Thiago Vicente, Yes, the exams are fairly similar. There are some difference, mainly the functions that you could be asked to perform on the exam. Here is a playlist that I created for the Excel 77-727 exam ua-cam.com/play/PLEqweL5D54PBNNCaCWKmOQC9Z5f-7Wzdd.html.
Brendan
I took the 2019 Excel Expert exam. One thing that threw me off was the ribbon was different on the exam than what I have on my 2019 Home Excel version. The ribbon had icons and not names and I had to hover over each one to see what it was. Everything had been moved around. I was not prepared for this and wasted a lot time. Do you know why the ribbon is different on the exam? Are they using a different 2019 version? Also, when I finished the exam there was a message that there was a error with submisson and to contact the proctor. The proctor didn't have a clue what was wrong. I checked my Certiport account and it says failed but there are no scores.
I am thinking my exam never got submitted.
@fmih I'm sorry that you had this experience. That exam is hard enough without having the issues that you experienced. I think that maybe the reason that your ribbon was different is because of window size of Excel. The ribbon adapts to the size of your program. If the icons can't all fit, they get truncated to make them all visible on the ribbon. Every testing center is different, so you they might been using the 2019 version or they might have been using the 365 version. There are a few differences between the two. The 365 version has a few additions to the ribbon, but I'm not sure if that would have been the reason for your issues. Did the proctor call Certiport to get the issue solved? I would call Certiport and talk to them about the issues that you had. Maybe they can do something for you.
Hi Brendan, I'd like to pass MO-200 exam to get MOS certification, so I've checked out you tips and advice. I bought Joan Lambert's MOS study guide and took the Gmetrix/LearnKey course. i have never taken any pre-assessement so I wonder if you offer individual lessons so as to prepare me directly for the exam. Thank you, Nicola
@Nicola Vistoli I just responded to the email that you sent me.
@ brendan
What is the duration of exam ? What is the minimum time to complete exam ? How much time will be needed to perform one project ? What is the total marks and minimum passing marks ? Do we have to submit our Exam within time ? Or our exam will automatically submit when time finishes ?
I have a couple questions regarding the MOS Certifications.
Where exactly to I sign up/purchase taking the exam?
Which MOS exams do I start with?
I'm a finance college student, primarily interested in taking the Excel exam but may look to take more. I have some experience using most of the different Microsoft applications.
@coronac805 The process for you is going to be a little different from the process that I would go through for my students taking the exam. Here is a link to Certiport regarding exams: certiport.pearsonvue.com/Certifications/Microsoft/MOS/Certify/Office-365-and-Office-2019. In my opinion, I would begin with the Excel 2019 MO-200 exam. After that, I would look into the Excel Expert 2019 MO-201 exam. The Excel Expert exam is a difficult exam. If you are still looking to earn more certifications, I would look at earn the MOS Expert certification. The link I provided explains how to obtain the MOS Expert certification.
@@Brendan_Sinclair Thank you for the help. You're videos are really helpful too. Happy holidays
Hi, Brendan!
Thanks for the video. You said that it is important for the MOS 200 to pay attention to the Objects and SmartArts settings, but I did not find this requirement in the measured skills document on the Microsoft page. Isn't that only for the 2016 test?
Thank you!
@Leonardo Turra You would be correct on this. I did mix up the two exams. Can I ask for forgiveness? Thank you for pointing this out.
@@Brendan_Sinclair Thank you very much for the reply. My English is so bad, so maybe my question may seem aggressive. Please don't think that. Thanks again, now I'm calmer, hehe.
@Leonardo Turra I didn't take your question as being aggressive. I was trying to joke around with my comment back. That doesn't always come out in text. Let me know if you have any other questions.
Hi Brendan
I am using bought practice exams to prepare for my O365 certification exams and at the moment I am going through the Excel questions but it keeps marking 2 particular questions wrong although I think they are right.
Q1 is format a set of cells so that they show the US $ left aligned and the decimal points all aligned. I am doing this by using the number options, currency and accounting as I believe that this is the only one that meets the requirements.
Q2 is to select text from one cell and use a hyphen (with a space either side) to separate it from text in another cell so that they appear together in one cell for example High - Low. I am using the TEXTJOIN function and the result looks exactly as it should in the result cell but it keeps marking me wrong. Am I doing this incorrectly?
Any advice would be greatly appreciated.
Thank you for your videos they are great.
@Susan Cockburn who made the practice exams? On your second question, I think that you need use the CONCAT function. Here is a video on the CONCAT function ua-cam.com/video/14tHoIJz_UA/v-deo.html and another on the TEXTJOIN function ua-cam.com/video/c29nlp6oMl0/v-deo.html.
@@Brendan_Sinclair Hi Brendan, thank you for getting back to me. The questions have been set by GMetrix. I will try the CONCAT function.
I take my excel certification test tomorrow as a student in high school!! Feeling nervous ahh
@Sia Bhakta How'd you do?
@@Brendan_Sinclair I finished in 20 minutes and I got a 920!! Thank you so much for all your help sir, everyone in my school recommended your video!
I ordered the book MOS Study Guide for Microsoft Excel Exam MO-200 and downloaded the exercise folder from the book. Unfortunately, I couldn't open all files. My excel is the most updates one. Anyone can help!? very appreciate it !!!
Hey Brendon, do you recommend practice test like those from Gmetrix?
@Gregory Green GMetrix is a great resource. I use it in my classroom to evaluate my student's skills. I've had a lot of success in my classroom and I will share one of my biggest secrets to my student's success... I ask my students to get a 900 or better on all of the Practice Exams before I will allow them to take the certification test. Making my students earn that score makes them work through their weaknesses. I also stress the importance of knowing the functions. Make sure that you know them before sitting for the exam. Here is a video that I made on the functions that you could be asked to perform on the exam ua-cam.com/video/Etp4j2LjvZM/v-deo.html.
Brendan Sinclair thank you, you rock!
Hi. I took my excel exam today and there was one question I still cannot figure out. How to use the left function with showing all text in uppercase. can you help me with that?
It sounds like maybe you were asked to nest a function. For example it would look something like this =PROPER(LEFT(A1:2)).
@@Brendan_Sinclair I think that would be UPPER not PROPER
You would be correct. Even I make mistakes 😂
HI
SIR did you make video about acces 2016
@Wajiha Khan I've only made one video on Access. The video can be found here ua-cam.com/video/bk6DAqmJ_VY/v-deo.html. Honestly, there hasn't been much interest in Access videos.
@@Brendan_Sinclair ok thanks sir
Do you have any recommendations for a specific course to take in prep for the MO-200?
@Jonathan Straiton I do not currently have any course recommendations for this exam at this time.
I would recommend these books:
MOS Study Guide for Microsoft Excel Exam MO-200: amzn.to/2KZo5VO
Microsoft Excel 2019 Step by Step: amzn.to/2M2Fa0D
Excel 2019 Bible: amzn.to/2M9IJSV
In the past, I have used Lynda.com to prepare for the Word and Excel Expert exams.
This is what I done below, as nothing
1. Locate your local Certiport Authorised Centres (www.certiport.com/locator)
2. Select any the providers and go to the website
3. Then search for, Home Study packages
4. During Covid-19 some providers are offering these packages, but you may need to call or email and request this.
I'm based in UK and www.mousetraining.london is offering a HomeStudy Kit £146
Included in kit: A. MS Official book B. Exam Coupon C. Exam style questions. The owner named Michael really knowledgable (not just a salesman).
**THE BEST BIT** is some providers are doing HOME TESTING!! so need to go to centre.
HI Brendan-Your doing a great job. Will you be doing any videos on Excel Expert? Can you take the Excel Expert exam without taking the Excel core exam? I did pass the 2016 Excel core exam and now I want to try the 2019 Excel expert exam. Or should I just take the 2016 Excel expert exam?
@fmih Excel Expert is on my projects list, but I am currently working on something else. Yes, you can take the Excel Expert exam without taking the core Excel exam. Are you planning on taking any other MOS 2016 exams? I ask because both the 2016 and the 2019 exams contain a path for special titles. The 2016 is the Microsoft Office Specialist Master and the 2019 is the Microsoft Office Specialist Expert. In order to obtain those titles, you have to earn specific certifications to qualify. If you don't plan on working on either of those tracks, then I would probably take the 2019 Excel Expert exam if I were in your shoes. Let me give you a word of caution. The Excel Expert exam is a very difficult exam. I cannot encourage you to prepare enough. This link covers the domains of the exam query.prod.cms.rt.microsoft.com/cms/api/am/binary/RE44NP0. I would recommend this book as well MOS Study Guide for Microsoft Excel Expert Exam MO-201: amzn.to/3aX8uAs.
@@Brendan_Sinclair no, I don't plan on taking any more 2016 exams. I did pass Powerpoint 2016. I want to focus on just passing the 2019 exams, even though there doesn't really seem to be that much difference between 2016 and 2019 material. If I can pass the Gmetrix Excel Expert, I should be able to pass right? I didn't find it that difficult. Have you taken the 2019 Excel Expert? Thanks for your advice.
@fmih Yes, I have taken and passed the Excel Expert Exam for both 2016 and 2019. Feeling comfortable with the GMetrix content is a great first step. I wouldn’t say that this means you will pass. The expert exams are much more difficult than the core exams. Obviously the content being tested on is difficult, but the wording of the task questions add to the complexity. You have to act on instinct to complete the task. I can’t stress enough knowing all of the functions that you could be tested in.
@@Brendan_Sinclair Do you remember what you saw on the 2019 Excel expert exam that was new? Was it similar to the 2016 Excel expert exam? I found the tasks on the exam to be very similar to the ones on Gmetrix. I had never used and didn't even know what PowerPoint was and managed to pass with a 920 by using Gmetrix and watching your videos.
@fmih I can't share specifics for what I saw on the exam. There is some similarity between the 2016 and 2019 Excel Expert exams. The functions that you could be asked to perform on the exam were updated in 2019. In my mind, I had thought I knew the functions that they would ask me but I was wrong in my assumption. In my opinion, I thought the 2019 exam seemed to be harder than the 2016 exam. A big reason for this is because of the wording of the task questions. Some advice that I give my students when they take the expert exams is you are going to feel overwhelmed at some point in the exam. Take a step back for a second and take a deep breath if you need to. Don't underestimate the difficulty of the 2019 Excel Expert Exam. I don't believe that you can over-prepare for this exam.
Hi. Will you plan to add some videos for Exam MO 201?
@mert ceyhun Can making videos for the MO-201 exam is something that I would like to do in the future, but I am still working on videos for the MO-100, MO-200, and MO-300 exams. Is there anything in particular you are looking for?
Brendan Sinclair thank you Brendan so I gotta wait then !
yo HELP i’m TAKING this in 25 mins what should i do
One last question. The test is given using Excel 2019 but I have 365. I have look at so many videos stating that they are the same some say they are different. What are your thoughts?
@Robert Vargas they are the essentially the same. For the purposes of the exam you can think of them as the same.
Hi Brendan where can I get practice questions for the latest exam ?
@Toqir Mulak I've begun working on making a project for this exam, but it is not ready to be released. The process is going to be delayed for a few weeks as school starts back up and the majority of my attention is getting ready for the new school year. I did a project for the Excel 2016 exam here ua-cam.com/video/D3vmHuUdx4o/v-deo.html. Many of the concepts found in the project can be found on the 2019 exam. The main exception will be the functions that you are asked to perform. Here is a link that breaks down the exam docs.microsoft.com/en-us/learn/certifications/exams/mo-200.
@@Brendan_Sinclair thank you
Hello! Is the passing score for Exam MO-200 still 700?
Hey Brandan, are there any main differences compared to the 77-727 syllabus?
@imwestendbanker I would say that the main difference between the two exams are the functions that you are asked to perform. Here is a video that I made that covers the functions that you could be asked to do on the Excel 2019 MO-200 Exam: ua-cam.com/video/Etp4j2LjvZM/v-deo.html and one that I did for the Excel 2016 exam 77-727: ua-cam.com/video/GmqzinAs31M/v-deo.html. I have a playlist for each exam listed below with lots of material for both exams.
Excel 2019 MO-200: ua-cam.com/play/PLEqweL5D54PAyQ6UF8I4PRZ9B5Bk2PynP.html
Excel 2016 77-727: ua-cam.com/play/PLEqweL5D54PBNNCaCWKmOQC9Z5f-7Wzdd.html
Could anyone verify if you can take this exam using the Mac version of excel?
@Roy Mosby you are not able to take the exam on the Mac. Here is a link from Certiport on which exams can be taken on PC/Mac certiport.pearsonvue.com/Support/Technical-requirements.aspx.
Thanks a lot!
Hey Brendan. Great video.
Do you think it's possible to cram/study this exam in about 10 days and still pass? I'm a novice with Excel, but I'm also really good with tech and used to be an IT.
I'm asking because I can get out of a college course if I have an MO-200 certification... but I have a June 15th deadline.
What do you think? Cram/study for the exam OR just take the college course?
Thanks!
@Andrew Tennant, I would say no for most people, but it is possible. I have helped teachers do it during a two-week crash course quite a few times. Your IT background might be helpful to you. You should look into the GMetrix software for prep. Here is a link www.gmetrix.com/Products/Filter?Certification=Microsoft+Office+Specialist+(MOS)&Version=Microsoft+Office+365%2f2019&Product=MO-200%3a+Excel+Associate+365%2f2019. If you decide to get that software, I would encourage you to get at least a 900 on all of their practice tests before you sit for the exam. I would also recommend that you view some of my 2016 Excel materials ua-cam.com/play/PLEqweL5D54PBNNCaCWKmOQC9Z5f-7Wzdd.html. For the most part, the 2016 and the 2019 tests cover the same content. The main difference is the functions that are used on the exams. Here is a video that I created on the Functions you might be asked to perform on the Excel 2019 exam ua-cam.com/video/Etp4j2LjvZM/v-deo.html. I also created a free project for the Excel 2016 exam that you could use for practice ua-cam.com/video/D3vmHuUdx4o/v-deo.html. Most of it will be relevant for the Excel 2019 exam. A book that I would recommend is MOS Study Guide for Microsoft Excel Exam MO-200: amzn.to/3aXgYYd. I'm not sure if I answered your question or not. If you have any more questions let me know.
@@Brendan_Sinclair Thank you so much for your kind and thorough answer. This is definitely helpful. I'll take those practice tests and see how I do!
0:44 "take a peek at Excel 2019 exam"
@userme The links are in the description, but you can also access them here:
Excel 2019 Exam Page (Certiport): certiport.pearsonvue.com/Cert...
Excel 2019 Exam Page (Microsoft): docs.microsoft.com/en-us/lear...
@@Brendan_Sinclair thank you very much.
Will this exam be multiple choices or click and drops?
@Nathan Tran neither. You will have full access to the program and be asked to carry out tasks within the program.
@@Brendan_Sinclair Thank you so much Brendan! I truly appreciated for your information.
super
Can I use this playlist "Excel 2019 Exam MO-200" to pass the MO-200 excel test?
@Robert Vargas This playlist isn't complete, but yes, I believe that you can use it to aid in test preparation. The videos in this playlist were created specifically to cover concepts that you could see on the exam. Here is a link to the Microsoft Excel 2019 Exam Page which lists all of the concepts that you could see on the exam certiport.filecamp.com/uniq/nY6SgqYbd6rDtIU1.pdf.
Brendan Sinclair thank you I have the list from them too. It’s so hard to find a online course one that is good and second that I can understand the English