Microsoft Excel certification exam (Part 1)

[@danielle-torisingh114]

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. (:

[@MikesOffice]

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!

[@chellyyamoah]

Me too

[@samezaber2618]

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.

[@M0T0CR055]

Took the exam today 01.07.2024. and passed it (940/1000). One minor mistake because a question was not that clear. (To me) Want to say that your videos still up to date regarding the content and your tips! Anyone who’s looking forward to passing the exam, should have a look at your videos 😉

[@sarahkorte3876]

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!!

[@michaelloman5931]

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.

[@carlosivan34]

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.

[@houstonvanhoy2198]

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?

[@bunnysaiyed]

How to apply for the exam ? where to apply ? Do you have link/website ?

[@akhik5902]

HI @carlosivan34 , could you pls guide me for the exam

[@andreacresswell1399]

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!

[@scoobydoredherring5719]

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

[@robynk704]

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.

[@Bitbatgaming]

Hey I just passed my Excel certification thanks to you with a score of 800 and I wanted to thank you! I was doing this stupid experienced software thing for my school and it didn’t teach me much but once I watched your videos it was like everything made sense!

[@sheilawilliams5072]

Thanks, Mike for your help! I got 831 on my excel exam!

[@concert_connoisseur22]

I got the exact score too!!! I passed today.

[@mehakpreetkaur9889]

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.

[@yashyadav3734]

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 😊

[@GingerReinhardt-jn1hd]

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.

[@shailacopland2668]

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.

[@tatyanaros9450]

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!

[@concert_connoisseur22]

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.

[@DJJordance]

Passed on the first try thanks to this video alone, thanks Mike 😁

[@eri8308]

THANK YOU SO MUCH!! I PASSED THE TEST THE SECOND TIME BY WATCHING YOUR VIDEO. I LOVE YOU!!!!!

[@olivinful]

I struggle most with the CONCAT formula. I find most functions are straightforward because the name of the function coordinates with what it does. But, I have never heard the word concat in my life, and I am constantly forgetting what it does! I also tend to forget how to use two functions simultaneously, like you did when making something uppercase and also using the left 3 function. but practice makes perfect! Thank you for the comp[rehensive video!

[@kristelleanned]

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!

[@AmandaGallagher-ir9ko]

Hi! 2024 here! This video is still accurate! I passed with an 831. Thank you for posting!

[@chahatkaur9216]

This was a staggering strategy for restoring myself with the circumstances in general and potential endeavors that we may get on the Excel Exam. I figure the most irksome part for me would be the need to review which equation goes with what. I acknowledge that holding the equations is the hardest part since you should zero in on the part that what has been asked in the inquiry. In the event that is most troublesome capacity for me as its requirements practice. Disregarding the way that I have started to work and practice the recipes regular, and simultaneously there are a couple of them that I need to manage. With the assistance of these sort of recordings, I am certain that I will actually want to dominate every one of the troublesome recipes too

[@rashwinderkaur4044]

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.

[@restyarae2711]

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!!!!

[@catm9378]

I would say the problem I often face when using excel is remembering the formulas used to calculate. I often forget to use brackets and I will try to submit the formula and it will not work because of this. I have now written down all of the formulas and this helps me as a reference when doing my work.

[@aljunvillarias344]

Aside from the functions, I think I will have a hard time with the language or words being used by Microsoft. Some times I have a different understanding of the instructions that makes my mistakes. I like how Prof Mike, in his videos, try to explain what would each project mean and what are the output of it.

[@sanjeetkaur3450]

Only problem I face when using excel is putting correct formulas and values. Of ten when I enter the formulas and values in the cell it displays error message. I have to make several tries to get it right. But once it is correct it is all perfect. The IF and Alphabet formatting functions like CONCAT, UPPER etc. were particularly new to me but I am slowly learning to use them. So excel is once again fun for me.

[@MrMarcusjames]

Thanks Mike. 925 on my test yesterday.

[@gurpreetsingh-fy5zd]

Task 5 in the last project which says "On the Bookstores worksheet, perform a multi-level sort. Sort the table by "Bookstores" (A to Z) then by "Total Q1 Revenue" (Largest to Smallest)

[@jepthaespanola-animas3896]

Biggest struggle for me is remembering the formulas, especially when you use the fx function already. LOL. This is a great video for review. Definitely gonna watch it again until I remember all of them :) Thanks a lot, Professor!!!

[@the_fleerian]

I remmeber a test asking me about creating ranges! It would be helpful to know how to create one and name it too

[@danicaamorsanchez721]

For me, the challenging task in Excel is remembering the functions and their uses, especially the ones that I don't use frequently. Overall, this review video has familiarized me with the different ways I can use Excel functions in my work.

[@aznivkaramanian9718]

For me, the most challenging task is to put the formulas. I have a big struggle in this part because I am confusing which formula should I use and working hard to be ready in the formula part for Exam. Thank you professor, for sharing this video with us :D

[@MikesOffice]

Anytime! Thanks for commenting. Which function did you think was the most challenging one in this video??

[@aznivkaramanian9718]

Project 2 task 2. Insert a column sparkline to compare the goals was the most challenging one.

[@MikesOffice]

@@aznivkaramanian9718 ah that’s interesting! Yeah the mini charts called spark lines aren’t used too often.

[@laurennsullivann]

i just passed my exam this helped so much thank you !!!

[@KevinPlaysPro]

Thank you sm! my exam is tomorrow, fingers crossed

[@irispeniero3509]

Excel can handle a large variety of tasks and functions. The most challenging part of Microsoft Excel is writing formulas, making charts, and conditional formatting to organize multiple data and carry out calculations. It is easy to learn how to sum a column or sort or filter a table but when you input the wrong data using the wrong tool it will give you a different result. But with Prof. Mike's tutorial videos, it helps me to understand better how Excel works and makes life easier.

[@jenni4312]

Yes toughest is definitely formulas

[@cozytori]

The biggest problem I have is with the If function and it's purely about how it is presented. It freaks me out when establishing the initial statement that it says false beside it, it makes me think I did it wrong when I did not.

[@kimpreece4589]

Love this video - can I download the files somewhere and follow along?

[@lulut3914]

In the countblank formula, player 2 should have had 1 blank month but the formula put in a "0" why is that?

[@sigmatrex6247]

That was helpful my teacher hardly teaches

[@ziyadabdullah931]

If I don’t pass the test the first time can I retake it? If yes how many times

[@noahhoogendoorn1137]

Are you open to posting an excel file to go along with the video that you post?

[@weliaagbon1210]

Hi Mike. Good Day! Your videos helps and enlighten every questions in my head. But, wanna ask about the MOS Excel 77-727 Crashed Course vids? Pls. . .

[@_zara_in]

Thank you so much I just passed

[@meinazhang809]

The biggest challenge me in this video is the "if" formula. I was confused with when to insert the text. other thing is with the swich row in chart. litter confused with it because i do understand the when to switch the row. other than that maybe my excel vison is not updated, I do not have the CONCAT option.

[@juans.3547]

Anyone know how to train on this hands on I tried to pass it today And failed miserably please help I have another retake in 2 weeks

[@themaster5815]

Hello, Mike I wanted to ask on where should I start for an excel certification and which version of excel should I strived to get?

[@aminatasene5726]

Do you offer any coupons for your course on udemy?

[@KidsLearnHTML]

Question: Could that sort been done using the small square arrows at the top of each column as well? (In cells A3 and E3) 🤔

[@omkarkekane2611]

Anyone know where i can find the documents he used?

[@ArcusLibri]

Instead of using CONCAT, couldn't use just use &? Does it matter how you get to the answer?

[@MikesOffice]

In the real world, yes. But not if they are looking for the Concat function-which they are

[@Liznina1128]

Where and what is the process in taking the exam? Is this free?

[@Emilymk97]

The dinosaurs are back! I love that.

[@MikesOffice]

Lol, well in that case, have to keep sneaking them in.

[@missyjane7167]

Hi Professor! I find formulas difficult and tricky part in learning excel. I love how you teach you make excel easy to learn but for the formula part XD I can not remember all of it. I have this idea that maybe I should take notes for all the functions and formulas so I can guide myself whenever I need it or practice always. Before I find calculator as my convenient way of calculating but learning excel functions, it is very nice, clean and more cool to look at so I should learn this by heart. EARLAH JANE ABABON

[@يوسفالصافي-و6ص]

thank you very Mutch, very helpful.

[@ligmaballs2019]

Great video mike

[@caitlynhoolihan2077]

This video is awesome thank you!

[@SuperGari2]

Hi! Is the exam taken online?

[@MikesOffice]

Yupp!

[@SuperGari2]

Hmm, how did you get online test? I only see take test in center.

[@taharana5859]

Punjab college se kon hai❤

[@heidyarizala7370]

Great vid!!!

[@shermainehernandez915]

Bravo!!!!

[@aprilcalvin4698]

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!

[@TheWanderingMind4]

How many projects are there?

[@eunicepooten2118]

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.

[@ravneetbhangu5366]

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.

[@Claire-hr7mh]

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!!!😁

[@preetikumari2022]

For me the toughest part was to remove hidden properties and personal information from the workbook.. But the way of your teaching is awesome 👍

[@kopikaamaheswaran499]

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.

[@sherrydevilla4558]

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.

[@gauravsahi7824]

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.

[@alyssa_.k]

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!

[@theangler1051]

Just got 981/1000 on my exam. Exam was just like the skills taught in your videos. Thanks for the help!

[@Thedrickx]

Am I crazy or did you do part 3 of "know your functions" wrong? It reads "Configure the total row to display the total number of goals/points each month." Should this not have been sums of each column along the "Total" row from B14 - G14?

[@omkarkekane2611]

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)

[@KateMcLeod-i5g]

I have failed twice in the past, and am required to pass for my Junior year classes! I been watching your excel videos for two months, and have memorized your tips and tricks! I took it last week and scored a 965, one of the highest scores of the Summer! Thank you so much for your help, and easy access to prepping for the exam. You are such an encouragement to students!

[@bernielaguna6968]

I passed my exam!!! This vid really made a difference and gave me those points I needed to achieve this certificate. Thanks a lot!

[@MikesOffice]

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?

[@estherlubiba220]

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 ☺️

[@nobelpreetkaur4416]

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!

[@catherinejohnston6227]

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!

[@salmamagdy3958]

how can I book and take the Microsoft excel exam?

[@braytonsky7275]

I’m curious. For the Concat portion, would I be penalized for not using the built in function? For problems, like that, I prefer to do ={selected cell}&”@example.org” it does the same thing but would I be penalized for this? If anything this shows a deeper understanding of text functions. If I take the test, should I be worried about how I write the formula if the results are the same?

[@AnnetteGomez-v9n]

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.

[@harryskountzos9327]

Because of you I passed with a 925/1000, you are amazing

[@nyareed8209]

Awesome work dude! Watched your videos and got a 975/1000!!

[@Snoopdog333333]

excellent video. Thanks so much!! Embedded functions is the most confusing for a novice like myself.

[@Radhe_krip]

Brother, can we practice this practically ? From where will we get this question paper ?? Please tell bro

[@glenamariebautista5254]

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!

[@RoshniDiary]

how question come in exam? the way you show? and question pattern is like the way you show? how much time they give to complete the exam? how many questions are there?

Can i really be able copy and paste word from the task board?

[@hussar4447]

All I know is functions, don't know sht about any other components😅, panicking now, exam next month

[@hamdanmasykurul764]

the running t-rex got me off guard

[@SURYA-hl1hy]

hey I'm not able to register for the MO-211 Exam. can you please help me out.

[@ritalagana565]

Hello. By any chance do you have a tutorial for 2016 Access? Thank you.

[@imashafernando2507]

I competed Associate 2019.But i can not find the online job?

[@JanWent]

Where can I find the files for Microsoft Excel Part 1 and Part 2 tutorials?

[@mechibellealcantara6425]

I'm having a hard time when it comes to formulas, and locating some buttons.

[@blobeboae5874]

Got a 350!!! Time to paint the ceiling red!!

[@vanvin3031]

Hi Mike. Is this identical to MO-210?

[@Imjadybaby]

I'm taking my exam tomorrow, I did so bad on it today I scored 200/1000, but this video covered a lot of the questions I struggled with really bad! so wish me luck!! thanks for the video :)