Microsoft Excel certification exam (Part 1)
HTML-код
- Опубликовано: 12 июн 2024
- This updated, Excel 2019 (MO 200) practice exam will share with you some of the most widely used Excel features. Ones that will help you pass your exam, earn more money, and impress a few colleagues.
PRACTICE FILES and ENTIRE EXCEL COURSE!:
www.udemy.com/course/mo-200-m...
Need help with Excel Formulas/Functions??? Check out this cheatsheet:
• 7 Excel Formulas that ... 
Авто/Мото
The biggest problem I have with Excel is remembering the correct functions for which equations, and how to type them in correctly. I completely blank with anything that has to do with math, and then the panic sets it. I am an English student and can write essays in my sleep, but math/functions/equations? no thanks. Thanks for this video Prof, your calmness makes me believe that I actually am learning and not to overthink the questions. (:
That’s a great point! You totally just made me realize a trick you can use if your mind goes blank because of test anxiety and functions like mine does….I’ll show this in the next one, but you can type in a description of the function in Excel and look up what function to use. It’s not cheating just smart!
Me too
Just passed my Excel 2019/365 exam about 1 hour ago with a score of 925/1000. Your video helped me greatly. God bless and thanks for sharing your knowledge and guidance.
I've started studying for the Excel exams. I've had Office 365 (including Excel 365) for over a year, but the online training is apparently done on Excel 2019. The ribbon layout and other details are quite different. How should I deal with this disconnect?
How to apply for the exam ? where to apply ? Do you have link/website ?
My school assigned this exam to me. After watching some of your videos, I scored a 981/1000 and won second place in the Oklahoma Microsoft Office Specialist Championship. Although I don't think there was much competition, I was excited nonetheless. Thank you.
I definitely find remembering the correct functions to use in the correct settings the most difficult, but watching these videos is great, because you make it seem so straightforward and accessible! It definitely gives me more confidence and peace of mind having these step by step videos!
I just finished taking my certification exam and passed with a 981/1000! I had taken the exam about a week before, failed, and ran out of time. Just from watching your videos, I was able to not only pass but make almost a perfect score! With time to spare! Thank you, Mike! Definitely look into these videos if you need help!
How many projects are there?
I PASSED WITH A PERFECT SCORE 1000 THANKS TO YOUR VIDEOS!!! As a college student, the part one, part two, and the 7 formulas video were more helpful than my professors entire course! Thank you so much!!
You are brilliant man. Just passed the exam and get 91. Whatever we study in our class is nothing compare to exam. I fail first time and then watch your two video and get pass toady. I have to say I learn more about excel by watching your two video then doing the class last two months. Thank you.
These were amazing!!! I was so nervous going into my excel certification test but you explained everything so well and all of the problems were so similar. I would’ve been nowhere without your videos, thank you so much!!!😁
Thank you Professor Mike!! Just passed my MOS Excel Exam today with a score of 900/1000 after failing the first time with a score of 626/1000. Thanks for sharing your knowledge and skills the MOS was exactly like the material you covered in Videos 1 & 2.
I totally blank out when it comes to the functions. I would have to watch this over and over. Thank you ! you are a calm teacher, much appreciated.
Almost the end of 2023 and I passed the Microsoft Excel Associate (Office 2019) exam 900/1000 following this video and your part two. Thank you! Now on to the Expert!
Thank you so much Mike! I passed my Excel certification with 925 yesterday thanks to your videos that I used to prepare myself. I watch the entire série of the excel exam: Part 1 and 2. I would also recommend the 7 functions in excel video. Again, thank you, your videos are useful and helpful ☺️
A huge thanks to you Mike. Now I've got a 925 score on my Microsoft Office Specialist Excel exam. Your guide is very effective and most of the questions in the exam are covered in your videos. Thank you so much!
Thank you Mike. I passed all my Certiport Exams with your videos. I really appreciated.
The most challenging task for me was task 4 in the Check Your Worksheet chapter. It's actually not the task that's challenging but more of how the instruction is worded; "swap the data over the axis" doesn't sound anywhere near "switch row/column" and so I had a hard time trying to figure out what the task was asking me to do. But this video helped to clarify how tasks would possibly be worded on the exam, which I appreciate because the task might be written in a way that is difficult to understand but is actually just asking for a simple action.
Passed my Excel 2019 Certiport exam with a 868/1000 and I thank you for your videos! Everything you went over was what was needed to pass. I had difficulty with the server, my instructor had to reboot the program a few times but even with all that going on I was able to get a good score! Thank you thank you thank you!!
Hey Mike! I just want to thank you for your channel. I was able to pass my Word and Excel certification exam that’s required for my job. Thank you and god bless!
Mike! You're a homie. I just passed with a perfect score of 1000/1000! Your videos helped me remember how to do everything! Thank you so much!
The most challenging part for me was remembering the functions and formulas in Excel since I don't usually use them. But with the help of this video, I have something to look through or review incase I have difficulties in utilizing the Excel. I'm one of the fortunate students of Professor Mike who's been taught on how to use MS and discover things that I haven't known before. Thanks Professor :)
The most challenging part for me, is the proper functions. There are so many formulas and functions to remember, but with all your videos it really gives me a lot of tips on how to use Excel function and all other task . Thanks!
Our MOS Exam is just around the corner. I really have a hard time with formulas, and these video tutorials really helped me to further understand Excel functions. Thank you Prof Mike!
Hi Prof Mike,
This was a great way to refresh myself with all the equations and possible tasks that we may get on the Exel Exam. I think the most difficult task for me would be having to remember which formula goes with what. I believe that memorizing the formula is the hardest part because you must pay attention to the task details and what they are asking for. For example, in the task with the average bestseller, reading the task carefully was important so that the correct formula is used. What I had done as I was watching the video was taking notes of all the formulas and tasks that I need help with so that those are the tasks I focus on prior to the Excel exam. Thanks for such an amazing and detailed explanation video. It was very helpful.
The most difficult part for me in excel is using ' IF ' formula . I always confused about the exact formula in excel. Sometimes I always forget to put (=) sign between them. Then I start practicing about excel and the way you explained everything is awesome. Like in task 3 question 4, modify the formula to display the letter in upper case is so interesting, I always loved this one , whenever I make datasheets or etc. Through your videos its been so easy to use excel and the person who don't know anything about excel I would suggest to follow your instructions only. By using formulas , its been so easy to calculate several type of data.
Hi Professor!
Learning the fundamentals of MS Excel was quite challenging indeed. I always struggle with the conditional formatting, memorizing all the formulae, and making charts because they can all be tricky and susceptible to errors. I can't thank you enough Professor for every tutorial video you uploaded and making our learning fun and easier!
Just got 981/1000 on my exam. Exam was just like the skills taught in your videos. Thanks for the help!
After studying for less than 2 days only by watching 2 of your videos and taking some notes I decided to take the exam to see where I was at, and to my surprise I passed with a score of 725/1000. Thank you so much for making this video and helping me pass my Excel cert exam.
I just passed my MOS Excel exam with an 850 score. That's pretty good for me because Excel is my weakest program in the MS Office Suite. Your videos helped me tremendously in my studies prior to taking the exam. Thank you for putting these together!
One of my biggest problems with Excel has to be remembering all the functions. There are so many, and I get confused with what one to use. When doing the MOS exam, I already get so anxious and I overthink everything. This was a wonderful video to remind me of what to use and why. I like how you phrase the questions in the language that could potentially be used in the exam. From past experience, they do word things differently and I find this very helpful.
Passed by MS Excel 2019 Beginner Exam today on the first try! Thanks so much for your videos, they helped me prepare for success!
THANK YOU SO MUCH!! I PASSED THE TEST THE SECOND TIME BY WATCHING YOUR VIDEO. I LOVE YOU!!!!!
The toughest task was project 3 that is the mad world publishing project. In this project, the IF function is very difficult to remember and use in the correct way but the videos presented by you are very helpful to use the functions and clear each and every function for me. It really gives more confidence and strength to have these step-by-step videos. All projects videos presented by you are very easy and helpful. Practice tasks every day on excel worksheets give us more opportunity to learn new things. Thanks for this video professor and I am very glad to have a professor like you.
Im taking my test tomorrow and my excel teacher told us that we should all watch this video to prepare us for the exam! She even linked them on her page
Thank you so much Mike. I prepared for the exam using your videos only and got 943/1000 in the very first attempt. Please keep sharing such amazing and using videos. Thank you.
I agree with Danielle-Tori, remembering the formulas is the most difficult, but I know there is a search function that helps you decide what formula to use, which is super helpful in a pinch!
I found difficult to use formulas and remembering them, but throughout this course I learned really well and your videos really helped me for preparing my MOS excel certification exams. Your tips are very helpful and time saving. Through your videos excel became easy to use, thank you for posting videos.
Thank you so much for this video! It was spot-on with what was on the Excel Associate certification exam. Definitely helped me seal the deal on passing.
I really like this guy! Great voice, explanation, pace, and vibe
Thank you! Passed my exam today with a 975/1000 with the help from your videos!!!
The problems i struggle with Excel is the functions and the different use for them. I'm personally not great a math, but im super happy how easy excel makes it easier to give accurate calculations. Understanding standing the different functions can be difficult , but when practiced is super cool and easy. The video was super formative and great examples. Also paying attention to the keywords really help in order to put in the proper functions which really helps. This video is way better than Gmetrix . Thanks!
This was an incredible method for reviving myself with all of the situations and potential undertakings that we might get on the Excel Exam. I figure the most troublesome part for me would be the need to recall which formula goes with what. I accept that retaining the formulas is the hardest part since you should focus on the part that what has been asked in the question.
IF is most difficult function for me as its needs practice. In spite of the fact that I have begun to work and practice the formulas everyday, yet at the same time there are a few of them that I want to deal with. With the help of these kind of videos, I am sure that I will be able to master all the difficult formulas as well.
hi mike! I watched your video without practicing any exams and I got full marks! 1000/1000 thank you:)
I think the most difficult task for me is to remember the formulas. As every time I start using Excel, I get confused with the formulas especially CONCAT and IF functions. But Thanks to you Mike. Your videos help me a lot in doing the Excel tasks. I am getting accurate day by day in formulas.
Just passed the test with a 962/1000. These videos really helped. Thank you
Because of you I passed with a 925/1000, you are amazing
This video is very informative and interesting. As I never used applications like Excel so often in the past, I feel it very difficult to remember and apply the correct formulas. But now, I'm becoming confident in using the functions and formulas in the correct way by practising them regulary. Thanks a lot professor for a great video.
I think the most difficult part for me is to remember the formulas in excel. During assignments sometimes, I forget the exact formula but when I watched your videos its easy for me to do tasks. Your way of teaching helps me a lot. Your tips of formulas makes test easy for me. Sometime, I am confused between the formulas but your instructions made it easy. In some tasks I forget = sign while started writing formula in the formula bar but now keep doing practicing helps me to remember all formulas. Thanks to you for videos tis made easy everything.
This video is really helpful, especially since I'm going to take my certification this week.
The struggle is remembering some formulas but overall, the tutorial is very informative.
Thank you Mike, your Excel practice video is really useful. Today I was able to complete my Excel exam with a very satisfactory score. Once again thank you so muchhh!!!!
The hardest part for me is to remember the full name of functions and how to write them. For example, about the task where we have to count the number of columns with no information. I remembered that it's something blank, but it's hard to remember the exact name. But I fully understand the meaning of most of functions and I'm really happy with it. Thank you, professor!
Hello Mike, I passed excel exam from your videos.
Thank you very much for your time and support very useful knowledge to everyone.
The videos overall are so Helpful! I like how you make mistakes and are able to correct them - just as like we would. I alwasy struggle with trying to figure out what the heck excel is actually asking me to do, there are so many formuals and options out there that you have to really read to eliminate alot of the jargon - to figure out clearly what your task is. My only advice is sometimes your excel maybe formatted to something ours isn't. like the fx function, your automatically goes to the "if true" option, mine I have to set up and I struggle with figuring out what it is to get there. The other thing, is when we use a formula and you go to start typing it in, and it comes up, what do we press to use that function instead of writting it all out still. ANYWAY AWESOME semester and thank you! I am WAY less afarid of excel then when I began!
This was a great video confirming what I have learned in an Excel class in college and preparing for my MOS Associate Exam in Excel. Professor's kind of made me doubt myself a bit, but thank you for confirming and giving a whole lot of insight into what to expect on the Associate Exam. Getting ready to take the expert in two weeks too and like several have mentioned, functions can be tricky and confusing.
I passed my exam!!! This vid really made a difference and gave me those points I needed to achieve this certificate. Thanks a lot!
Amazing work!! Doesn’t it feel great to be certified?? I’m glad this video could help. That’s the best feeling as an educator so thank you so much for sharing your success with us! Do you think you will take the Excel expert exam?
Just purchased your course. I’m so excited, I’m planning to take the test in January 🎉
The Countblank function was a tough one! Thank you for reviewing it in this video!
All of it's tough to me man. Just started learning Excel, spent 5 hours on 46 minutes of a video tutorial the other day, loved your video as well provided a nice sneak peak at what I still have left to learn. Thanks for the content
I found this video informative and interesting. The only thing which makes me feel anxious is remembering formulas and putting them at right place. I always struggle while doing this thing as I am not good at memorizing things. But, the tips and tricks given my you are really great and helpful. Thanks!
Thank you Mike! Your videos are very helpful. I passed my exam.
Hello Mike,
Thank you for sharing the video. It provided valuable insights and proved to be quite beneficial. I recently passed the exam and would highly recommend it to others.
The most difficult part for me is using the 'IF' function. I find there are a lot of steps to remember as well as knowing when to use it. Thank you for posting these videos. I find them extremely helpful as I prepare for my Excel certification.
Thank you!! I brought the course and watched the two last videos and did the practice attachments/walk thoughts and I passed with an 850!! I took the test two days before and 486. (certiport)
I just took and exam and passed only because of you 🙏🙏🙏🙏your video helped me a lot, it I wouldn't watch this video I would definitely fail... Thanks again 😊
This video helped me get a 925/1000! Thank you for the incredibly accurate video! This video did the most for me when preparing to take the exam!
The most difficult thing for me in excel is to remember shortcuts and formulas. It always become difficult for me to remember formulas while doing assignments or tasks. I have to watch videos again and again to solve the tasks. And through your video it has become so easy to use the excel and I will suggest to those who want to know about excel, they can watch this video as it is really helpful.
Hello Mike!
I would like to thank you. Because of you I passed all my MOS Exams with a great score. Today I passed my Excel Exam with a great score of 850 points.
Outlook: 737 Points
Word: 850 Points
PowerPoint: 940 Points
Excel: 850 Points
I passed my excel exam!!! Thanks a lot for your videos.
Did my MOS Excel yesterday and got 950/1000 because of this video and Part 2 video!🎉
I definitely think the hardest thing about Excel is staying up to date with the formulas! I would have never known that you can just add UPPER and it would make everything uppercase. I feel a little nervous going into the exam not being clear on the functions but now that I've heard there is a cheat sheet ;p it'll definitely come in handy! haha.
The biggest struggle I have is remembering formulas especially when there is more than one step. In this video, the second task is what I felt was most difficult. I overthink it when it comes to using formulas and seeing the instructions to use the range instead of just selecting the cell had me confused at first. Like always, once I try it out or watch your demonstration it becomes clearer!
One of the biggest problem for me is to remember all the formulas. Actually, I love biology and mathematics for me is hardest thing to do. For becoming master in excel, I need to be good in mathematical functions. However, your videos are very beneficial for me to in understanding the concepts and formulas of excel. For understanding and memorizing all the formulas I need to practice daily and I am doing practice regularly to use excel easily and functionally. According to me, who want to know about excel, he or she can watch your videos. Your tips and tricks are really blessings for me because they can assist me in MOS exam.
I think the most challenging part for me is remembering all the functions and formulas as well as conditional formatting. Nevertheless, with the help of this video, I know I can pass my certification exam. It is really more conducive and fun to learn with Prof Mike's videos because they are presented step-by-step and are very detailed. Skills in excel will help me in meeting the different accounting needs of my future career. MS Excel will surely help me get my stuff done with ease and in a more organized manner.
A couple of things that are challenging with Excel is remembering the correct functions for which equations, or what formula to use based on the question can sometimes be confusing. Normally when it comes to exams with numbers, equations, and formulas I tend to blank out or get so nervous I can remember anything, especially if I'm being timed. I can follow the screen tip in the videos when entering the formulas, but tables can always post a challenge for me, as one mistake and it's like you have fallen off a cliff. For myself writing down or printing out how to do a task helps me to better remember or practice for it to actually stick in my head. Hopeful in the MOS exam I will be able to remember everything from the videos to help me pass or even get a good grade. Very educating in this video how you educate the steps with each detail.
These videos are very helpful!!! I do think my biggest challenge will be remembering what each formula is and when to use them. I have been trying to write them down as I go, but it can get confusing. Math is definitely not my strong suit to being with but as I said watching these videos really breaks it down for us. - Lisa Patton
I wish I would have watched this before my exam. I had the CONCAT function with the e-mails and I was like..???. I am taking it again tomorrow and glad I found this!!!
Just passed my exam like 5 mins ago making a 943/1000 im beyond grateful for this video and this video still helps years later ✨🥲
I will be taking the test this week and I am hoping to pass. Will update you. Thank you for this video it helped me a lot. The best thing you taught was the dinosaur image that you added. The hardest task is on the last one with the bookstores task but I will study this video again. Thank you.
Thank you for this wonderful video brother. I just passed the exam. You are brilliant man. Its very easy to understand because you explained it very well. Kudos brother, cheers!
This video and part 2 got me nearly a perfect score easily you’re the goat
Thanks Mike .. today i have cleared Ms 200 exam with 925 score, thanks for alll your videos which have helped me clear the exam....
Hello Mike!
I believe the hardest task is task number 2. I'm really struggling with remembering the advanced functions or the ones I don't use often like sum and average. Other than those I really struggle to remember the functions. I'm grateful for how well you explain everything and that you break down the complicated wording the MOS exam and Gmetrix like to use. I find figuring out exactly what the question is asking me is difficult and inserting a new chart and formatting the data. All the above tasks have difficult moments but for me, task number 2 with the formulas would be the most difficult.
Thanks,
Ashley Peddle
I look forward to using your teachings in my future exam.
Thanks for sharing this, I'm getting ready to do my exam and this helped a lot. The one thing that I was stumped on was the "Removing hidden properties and personal information". I hadn't come across that before and I'm learning on Excel for Mac so all the back office stuff is out of place for me. I still couldn't find where to do that. I'll be practicing on a windows prior to the exam though and will be sure to look it up.
Thanks Mike. 925 on my test yesterday.
The most difficult part for me was the entering formulas. If function is confusing, especially what information to insert in fields to get the correct formula at the end. Also I found challenging for me putting the brackets inside the formula. In your video there were tasks where you used formula without brackets and with brackets. Thank you for your detailed explanations!
Hi! 2024 here! This video is still accurate! I passed with an 831. Thank you for posting!
The most difficult task for me was choosing or remembering which function to use based on the task or question asked. I find it takes me longer to recognize what is actually needed, however your videos and tips are extremely helpful.
i just passed my exam this helped so much thank you !!!
Thank you so much.I am confident that I will pass my excel exam coming up on Monday now!
The most tricky part for me is about inserting formula. Sometimes I forget the correct command if it is sum, average, etc. Much more on the more advance part which includes the If, upper, etc. I do have hard time in inserting the correct cell if prompted to do so. One more thing, I am most of the time confused on inserting formula within existing formula. Sometimes I forget to put the open and close brackets and that always mess up the results. But honestly, your videos are really helpful in preparing us for the MOS exam. I do hope to pass it Prof.
You save my life sir I pass the exam today 831/1000 🎉if I can’t pass this exam today I can’t be graduated tmr thank you so much for your exam video part 1 and 2
When it comes to creating tables, spreadsheets, and accurate data analysis, working with Excel is a prerequisite. However, the most interesting and difficult part is remembering the functions, as I am always confused, but after watching this video, I understand how to do the function formula correctly. There are also other parts that are difficult for me, such as conditional formulas and function arguments, as I am sometimes confused about when and how to use Sumif, Averageif, Countif, and Sumif formulas, but after watching this video, I understand fully.
Thank you for uploading this video and I will do more practice in order to acquire good marks in the exam.
Hey!!! I took my Excel Associates exam and got a 831/1000!!! I kid you not!!! The Sports task was the exact same one as on my exam. What was hard for me was the IF function on the exam because I forgot to put the " " around the words like: "Books Sold" > 10,000.
I was so nervous and also the proctor kinda shook me up before the test so I feel like it might've made me more nervous. Causing me to forget.
Thank you so much! I got 978/1000 watching your videos ☺️
Thanks for the videos they really helped me I passed both the word and excell exams
Thanks, Mike for your help!
I got 831 on my excel exam!
I got the exact score too!!! I passed today.
The hardest thing for me was to apply functions and i must mention that i am slow learner. I learnt everything quickly because of your videos. A s i am more comfortable with learning through videos as compared to reading material.
I watched these videos but still failed my excel exam today, I'm very slow, I skipped a few questions and didn't have time to do project 6, so I bought your excel exam practice guide so I really hope it helps!! I'll be starting tomorrow 🙏
I love that your videos are super informative. I think the hardest part for me would be the IF functions (IF, SUMIF, AVERAGEIF, COUNTIF). Also when having to enter something that is greater than or equal to. Having to remember to input all the correction information into the function is something that I will have to pay a lot of attention to in order to make sure that my answers are correct. Also, while watching your video, when you did the countblank function, I had an OMG moment. How do I remember the difference between COUNT, COUNTA, AND COUNTBLANK functions to ensure that I use to correct one? Excel is a very useful tool but it takes plenty focus to absorb everything.
For me the toughest part was to remove hidden properties and personal information from the workbook..
But the way of your teaching is awesome 👍
The biggest difficulty I have with excel is the functions and dont know what some of them are used for and how to exactly use some of them correctly. Also trying to follow the instructions can be a little difficult at times i have to re-read them or read them very carefully. By watching your video it makes things a little easier to follow and understand. - Catherine Cornish