Microsoft Excel certification exam part 2

This video will help you learn industry-standard Excel skills so that you can earn your Microsoft-official Excel certificate.

[@MikesOffice]

Let me know which task was the most challenging/difficult Excel task in this video! Thanks!

[@Datballerqualin]

This guy chill af. Scheduled to take this exam next week and I already feel confident based off of this vid

[@vanshuthakur5326]

The most difficult part in excel is that I forget the formulas while doing tasks.I was always indenting and aligning the column incorrectly, but thanks to the tutorials you provided, I practised more and more until I was able to do it correctly. I practice a lot with the help of your videos and it works. Now I am perfect in doing tasks and assignments. The F4 key in my laptop is not working but as per your videos, I used shortcut for that and it helps me. I watched this video and its really very interesting and helpful.I learned so many new things. Thank you professor for your videos and step by step instructions.

[@sheilamariecompleto9378]

Thank you so much for making learning so much easier with your videos. It's difficult for me to remember certain MS Excel formulas that I haven't used previously, such as the IF, CONCAT, COUNT, and UPPER formulas. With the help of this video, I was able to master it quickly and easily, particularly the use of F4. I watched it several times to prepare for my MOS Exam, and it was fantastic and entertaining!

[@izzyabushawar5527]

The most challenging excel task for me was creating the "custom ;)" column chart, I found it pretty easy after you did it but I never knew how to do that. I really enjoyed how you presented your video, it was serious but had the funny elements that every video should have. I wish I payed more attention in your class because I love your persona.

[@thelilyshadow]

My professor actually suggested we watch your videos before we take the MOS Exam. I will be taking it today in roughly an hour and your videos are helping me solidify a few things that I didn't quite understand, so, Thank you! I plan to edit this with my score that I get edit: I got a 960 out of 1000. Thank you!

[@yubrajghimire7]

Wonderful 🎉

[@kopikaamaheswaran499]

Hi Professor Mike, Thanks again for such an amazing detailed video to prep for the Final Exel Mos Exam. The most challenging task that I found was to remember when there is a question about alignment and having to delete cells, you must remember not to just simply grab or cut and paste the cells where it is asked. You MUST select the cell that you want to be removed then right-click, delete, then click shift cells up. This way everything will get moved and placed accordingly without any errors.

[@nickwhaley1070]

You do a great job teaching! Keep it up! The trickiest part for me was the task, the absolute cell reference, and the striking F4.

[@Ohromaa]

Life saver I just passed my excel with a 875/1000 after watching just two of your videos

[@juliem5513]

Hi Mike! watching your videos and doing the practice test helped me passed on my 2nd try with a 850/1000

[@stephaniee3202]

Hi Professor, When it comes to excel the thing I find more difficult is still figuring out what functions are required. With the way the wording is put down it gets confusing but once those are cleared up the rest comes easily. Also having the F4 tip makes multiplying much easier!

[@catm9378]

Thank you for making these videos they are very helpful, especially around exam time. What I found most difficult is once again the formulas. I am still struggling to remember which formula to use, after watching your videos I have more clarification and I will continue to refer back to my notes if needed.

[@onkarjadhav6672]

thanks man your videos were a great help i scored 962/1000 in the test

[@robynk704]

Thank you so much for your informative and detailed videos. I never would have thought that watching videos on Excel would be so good! The aspect that I found most challenging is having to remember the absolute cell reference and F4. That tip was very helpful, so thanks for that. It is going down on the notepad :-D

[@Snoopdog333333]

the F4 function was the most difficult to understand. Great stuff btw-thanks!

[@stopplzs]

just got a 925 my second try after getting 517 my first time. exam questions were almost identical to what you went over in both videos

[@hunni04]

watched these the day before my test and passed tysm

[@carlosmartinezreborned6403]

I just purchased your course on Udemy and really looking forward to going through it this week.

[@MikesOffice]

That’s great! I hope it helps!

[@McKennaHohenadel]

Thanks so much for this video Mike. The hardest part of excel for me is CONCAT. #loveurhat

[@McKennaHohenadel]

MIKE! I just took my excel certification... I AM CERTIFIED. There was in fact a CONCAT question and it required combining an email and a first name. All thanks to you I got it right. #certified #962

[@faizulpalash8643]

For me, I find multiplying a value is a little bit tricky and complicated. Although, after 2/3 times practicing, it seems like it recovers automatically. It looks like I have to practice more and more to recover that tricky one. A little time with so much works!! Huh 😕. Thank you, professor, for your excellent video.

[@mehakpreetkaur9889]

First of all Thank you so much Professor for this knowledgeable video as it is really helpful. Furthermore, I think using IF function is little bit confusing for me and remembering absolute cell reference is more challenging and use of F4. But after watching your this video for 2 to 3 times, it becomes easier for me to remember it and is going to help me in my upcoming exam. Really it is very helpful. Thankyou !

[@melgin4560]

Hi Mike, I've been following you around because your videos for MOS are very helpful. Thank you so much.

[@feleciaoakley6090]

After watching this video F4 is a little hard to remember what exactly it is for. IF function can be challenging in task 3 sometimes it is hard to get the formula correct. Alignment also poses a bit of confusion for me sometimes I have to do it twice to ensure it is the right thing to do. But the toughest task was 4&5 this is very challenging for me as creating charts for me is like math and I completely despise math but somehow you make excellent fun!!

[@andreacresswell1399]

I think the most challenging part for me was the absolute cell reference and the use of F4. I had to watch it a couple times to understand, but makes sense now! These are really helpful tips!

[@kristancampos8700]

The most challenging was deleting the cells to move the data up. I had that on my exam. I think I did it correctly:) But it was challenging!!

[@hirakhan78619]

Thank You so Much for such a wonderful video

[@MikesOffice]

Anytime Hira! Do you have an exam coming up?

[@hirakhan78619]

@@MikesOffice I have Passed my exam with 925 Marks

[@hirakhan78619]

Awesome Video

[@ligmaballs2019]

i liked and commented because u da man

[@dariusjohnson7389]

Which videos to pass the Specialist certification exam? I want to focus on one exam then broaden my knowledge.

[@aznivkaramanian9718]

For me, I still have the same problem as I said in last video. The most challenging task was to enter formulas; "I had to work hard in formula tasks to pass the exam." Thank you professor, for sharing this video with us :D

[@christinerenjit1872]

Hey! Would you say your Microsoft Excel certification exam parts 1 & 2 are sufficient wholistic prep for the Associate's exam? Are there any other resources I should take a look at? Also, another question, how much extra time would it take to prepare for the Expert exam?

[@zuradean849]

Thank you so much for sharing ❤

[@INFCraft196]

hey mike i have to make a clock in/out sistem in excel and show the picture once the person has clock in or out but im strugle whit showing the picture can you make a video to help me many thanks

[@joudzah1308]

Please send link of the test

[@zahrazafar4537]

I have a Microsoft word test tmr at highschool. .....TT

[@abhilashthombare-v1b]

where can i get this data?

[@randomyoutubevideos3503]

What about macros?

[@MikesOffice]

That’s on the Excel expert not the core. I think I stuck a macro question on that one

[@TroutNabber020]

“Bieb balls” 😂😂😂

[@markjohnston5516]

Any videos I should watch I have my test at 4

[@MikesOffice]

This is the big one: Microsoft Excel (2019) Certification Exam but I’ve got a few on my channel. Good luck!!

[@MikesOffice]

kzbin.info/www/bejne/foTbgnVjgNemh7c

[@haiyawo1840]

Dear Mike, I just did the MO-200 Excel test one hour ago and got 925 out of 1000. I was watching your videos this morning and before as well. You have added a lot of points to my score with your excellent teaching, thank you so much!

[@MikesOffice]

Congratulations, Haiya! That’s such a great score. Thank you for this nice comment. I’m just happy this video could help you study! The Excel test is a tough one but you passed it easily!

[@황용걸-i6u]

You are the best professor! for the first exam, I got 400 and after I watched this I got a 900 score on test 2. If u guys keep failing watch this it is really helpful!! Thank you, professor Mike

[@gebernalj]

Hello Mike. Today I took the Excel test and got an excellent score 1000/1000. I watched your videos about the Excel and they have been very helpful. Thank you you are a great teacher 🎉

[@joudzah1308]

How to test? Plz help

[@lisazalewski5761]

what did you do to study? did you just watch these videos? please let me know! i have my exam this monday, thank you!

[@gebernalj]

@@lisazalewski5761 I watched these videos and practiced on the computer different tasks that he show on videos. Good luck 🍀

[@gebernalj]

@@joudzah1308 it is easy if you study Excel lessons, watch videos, and practice. The test is like watching on the video. Good luck 🍀

[@shukurenaialvarez1637]

May you help me with one question pls? What did you do in frezze panels?

[@rashwinderkaur4044]

The second part was as informative and interesting as the first one. The most difficult task that I found was to remember the formulas as I usually forget which formula to use. Once I get to know the formula that is supposed to be applied for solving a particular question, then it gets way easier for me to complete the task. However, the videos that you post are really helpful and make things much easier because earlier, apart from remembering the formulas, I had problem with applying them as well but now things have changed! Thanks to you Professor :)

[@theniftytot5102]

No way I didn’t know you work at Centennial College! That’s my school! I’m having my MOS exam today. Your MOS Word Exam Prep was the only thing that helped me pass the test with a 92%! Thank you so much. Edit: 95% on my MOS Excel.🎉

[@karamveerkaur5361]

First of all, Thank you so much for such a amazing and detailed video to prepare for the final excel MOs exam. According to me, I think the challenging task for me was the cell reference and F4 is a little hard to remember what exactly it is for. IF function can be challenging in task 3 sometimes it is hard to get the formula correct. I watched it many times again and again. Then, finally I am successfully done with it. But somehow you make excellent fun in this video even in all videos.

[@SRR0247]

Hi Mike! New to your enlightening channel and was wondering if there's a way to get the practice workbooks and/or worksheets you use in order to practice alongside w/you (your video tutorials)?? As a 'do-er', i learn best by doing while watching so it would be tremendously helpful to be able to use the practice workbooks you use on the videos.

[@abhasaxena4694]

Thank you bro Due to yours video I got 887/1000 in the test in my first attempt.. Thank a lots bro...

[@SpencerBartel]

Watched your videos the day before the exam 3 times and got 943/1000 first try!

[@InêsDias-f3w]

His music is garbage to me too but your videos are GOLD! ;) Thank you so much for your help, just got my certificate! I struggle with charts in general. Wish you the best!

[@cositayjack]

This was very well made, I will for sure check out your video on Excel functions.

[@Sderot.bringthemhome]

Hi, thank you for your video! i love it! i have a question about like add date to the pie chart, if you have something that can help with that i would love thank you

[@MiisssBrandi]

Thank you so much for your expertise in Excel. I'm almost positive that if it wasn't for your incredible knowledge and skill in Excel, most of us would be doomed. I found these video exercises more easy and simple compared to the last. For me, the most challenging part for me here would be remembering how to properly insert the formulas to ensure that I get the correct answers. The second challenge for me would be remembering to use the Absolute cell reference. I've made notes to ensure that this is something I don't leave out!

[@sukhmanpreetkaur1478]

For me, in the first project: Tim biebs, I found difficult to multiplies the value as it shows error, even I tried to correct it by using F4, still shows me a error. Then I watched again carefully and after trying for two times I got it correct.

[@walaaha8811]

I need more explanation for mixed, absolute cell references. thank you.

[@sanjeetkaur3450]

Well, I do not think I have any more difficulties in excel except for cases when the questions are twisted far more than what I can understand. Your videos and demos were really good and solved almost all of my queries. Usually, the questions are easy to interpret but at times they are so twisted that I cannot understand what I am supposed to do for the question. But once I know what exactly the task is, there is no more problem. I am positive about my MOS excel exam now, just Certiport works fine for it. Well, I have a bad history with Certiport! Hope it goes well.

[@JiaqiAn-di7vb]

Thanks Mike, this video is definitely help me understanding excel.

[@rahmamaulia5286]

thank you sir, i passed my exam with 943 score, this video helpful

[@samanthamansfield3523]

The most challenging task is the IF function for me. I still get confused on what data to put into the formula.

[@hamedknsowa4593]

Where formulas text , time and date , vlookup, hvlookup, pmt , they are comes in the exam

[@nimrathk]

I just passed my Microsoft Excel Certification exam after binge-watching your videos. Thank you for the help!

[@aileendanielapriddy7422]

In my opinion in Bite and Chin Chocolate number 3 is the most challenging to me

[@reemaljabri5452]

Why you didn’t use sum formula instad of pressing f4 in tax

[@saaji55]

Thank you, I like how you unintentionally made simple mistakes for which I suppose would-be doing, then how you correct the error.

[@MikesOffice]

It’s a gift, really. Haha I’m trying to limit the mistakes as I get more practice but maybe it’s not so bad? Teaches my people what mistakes NOT to make

[@atrt6740]

Can you send me that pdf which shows skills measured

[@tsitigray8006]

Thank you for your help. your video helped me a lot..

[@austingross8567]

Will creating data tables ever be asked of me on the exam?

[@ravneetbhangu5366]

I think everything is ok with excel as per your videos, but I am still finding difficulty to use several formulas . Because sometimes I honestly forget like which formula I have to choose on the time . Secondly The F4 button is not working on my phone, then I thought you said that you just simply named the cell. Well professor with your videos and the way you explained everything seemed to be so easy and relaxing. I hope I would score good in Mos exam. Thank you professor for always guiding us......

[@chahatkaur9216]

Well, I don't think I have any more problems with Excel, except in circumstances where the queries are bent far beyond my comprehension. Your videos and demonstrations were excellent and answered almost all of my questions. The questions are usually simple to decipher, but occasionally they are so twisted that I am unsure what I am expected to do in response to them. But there is no longer a difficulty once I know what the task is. I am now confident in my MOS excel exam; all I need is Certiport to pass it. Well, I've had an awful experience with Certiport! I'm hoping everything goes smoothly.

[@Faiz_Muzakky]

Thanks for your sharing. I am very happy with your explanation. Excel looks so much easier

[@robertengland6981]

Failed my first exam a month ago because I was confused on some of the wording. Been studying but still needed some better explanations found your video today and watched both about 2 hours before my exam. You explained everything so clearly and I went in confident and scored a 975/1000 and finished with 20 minutes to spare Thank you!

[@kellycrawford3223]

It would be awesome if you could provide practice files so we could follow along in an actual document.

[@MikesOffice]

I post them all on my Patreon page.

[@chahatkaur9216]

Well, I don't think I have any more problems with Excel, except in circumstances where the queries are bent far beyond my comprehension. Your videos and demonstrations were excellent and answered almost all of my questions. The questions are usually simple to decipher, but occasionally they are so twisted that I am unsure what I am expected to do in response to them. But there is no longer a difficulty once I know what the task is. I am now confident in my MOS excel exam; all I need is Certiport to pass it. Well, I've had an awful experience with Certiport! I'm hoping everything goes smoothly.

[@hjohnsondavis]

OUTSIDE-IN was the most difficult task of the review. I reminded the video several times and then laughed. Oh, they want the label on the OUTSIDE END. Thank you fir for the information.

[@lovemeAndILoveYou123]

Trying to remember all the steps for the IF function/formula and trying not to mess it up is challenging have to re watch a couple times just to understand and do it correctly. And again reading and understanding what to do for each question being asked to do and making sure im doing it properly. - Catherine Cornish

[@pirichan5430]

Hi, I just wanna say thank you so much. After watching your videos I got 923/1000 for my Microsoft Excel Exam 😊

[@shehlaali704]

According to me, the question that asks to enter a formula that multiplies the Unit Price to cell H2 is most difficult. In one of your videos where I need to name the cell and then multiply was easier as compared to this one because I am not sure when to press F4. I have got an idea though how to answer this question, but I will surely practice on Excel as I do not want to make a mistake in my Exam.

[@jenfield8444]

The Hardest function I find in this video is the -Concat. I find it hard to keep it straight, I really enjoy that the function puts it all together but I do find this one a bit tricky. I have a bad habit of putting a small space or inbetween a formula or a comma where it shouldn't be. I have to review my work so often this becomes time consuming.

[@lisamartel969]

I do agree with a lot of the others about the F4 absolute cell reference confused me at first, I had to re-watch that part of the video numerous times to be able to wrap my head around it haha. I think I get it now, but I do need to practice now to get it drilled in my mind :) -- Lisa Patton (Martel is my married name - sorry for the confusion)

[@tatyanaros9450]

The most challenging task for me in this video was absolute cell reference and using the shortcut F4. I'm working on Mac and not sure if this short cut works fine. Also I didn't get at what point exactly to use it, so I need to watch this video again!

[@richelledavis1596]

The most challenging task was the IF function, i learned through the course and by the informative videos to follow the key word in the instruction "IF" LOL. Performing the formula can be tricky, the easier way to have the dialogue box to perform the task easier. The most difficult task in Excel is adding tax .... i hate math .... but the great thing about Excel it does the work for you if the proper functions are put in place. The example files have made it easier to practice and to overcome that challenge. Thanks!! Most appreciated

[@Swizzletwice]

Excellent presentation. Well-organized, well-taught, and great personality. Thank you.

[@jessicastaniforth3707]

I would have to agree with what many others have said-that absolute cell reference/F4 would likely be my trickiest part of this video.

[@munirapatel8857]

Thank you so much for the video! I think the most challenging part in this video was displaying something lower than 10%, the input of inventory column that is displayed as "low".

[@Bucketlistexplorer]

Hello Mike, I passed excel exam from your videos. Thank you very much for your time and support very useful knowledge to everyone.

[@HeyscottieHey]

I Stan this channel, 943 isn't a perfect score but I'm very happy with it. Mike is goated in my books.

[@TylerMiller-ov9gg]

Predicate the help, had no clue about the intricacies of excel until today. Took my exam after watching a couple videos, skipped about 3 problems and passed with a 825! Thanks Mike!

[@catherinejohnston6227]

The second task would be the one I get stuck on. One thing that always gets me, is when using a formula and refencing a cell it copies down but does not work. One of the things I found very useful and had forgotten until watching this was to use F4 to hold the cell reference when it continues down. I will have to write this down for the exam.

[@zohaibtariq3973]

Thank you so much Mike for your part 1 and part 2 of the Microsoft Excel certification exam videos! I just finished taking my exam and got an 887/1000.

[@amandamitchell9988]

The curveball in the second project - changing the alignment by deleting cells - is probably something that would have been difficult for me without your explanation! I am awful about not fully reading a question and discerning what it is actually asking. I definitely would have manually moved it up. Also, the question about removing a row and now changing content outside the table - did not understand that it meant not to click the whole line! Very glad I watched this!

[@shailacopland2668]

Definitely for me was the F4 function. I had to go back after the video just to rewatch it to ensure I get the correct answer the exam! Toooo many functions soooo little time 😂😂

[@sagalabdi1441]

Really Nice Video, very informative like all your other videos. I appreciate your dedication. I would like to practice the IF function which is like the hardest task for me as well but your demonstration has totally helped me. Thanks!

[@TopDoppe]

This video was very informative and all of the questions were briefly explained so there was not any part that was too difficult for me to understand yet there was the third part in this video 4th and 5th question where I had to see the video twice to understand it. Rest everything was very fine and both the videos were very thoroughly explained and helped me with my excel understanding.

[@RiyaSharma-ru2se]

Hey professor I found second task in first project difficult but got it after watching several times. To be honest at first it was hard to understand what's going on in that question and after watching the video thrice I was able to learn how to use that function in excel. Thanks

[@jddon100]

How do you get the practice sheets?

[@rachelbiskupski4562]

I think the most difficult task was using the IF function formula for the Inventory Warning Column. It is hard to remember if you need to add the % sign or some other detail to get the correct answer. Also the Bite and Chiu task that asked to move the alignment. You have to really pay attention to the wording of the questions. I am going to watch lot of your videos in order to get a better grasp of things.

[@petiennebales9860]

The first project, the second task, with the taxes... eeek... I am so confused... I have some practicing to do!

[@manjotkaur9866]

Thank you so much for sharing this video as it's going to help a lot in the MOS exam. The most difficult part is cell reference and the use of F4.

[@navtejsinghjawanda8110]

In my opinion, the two most tricky parts of this video were project 2- task 1 and project 3- part 3. These tasks were not necessarily difficult but they were tricky. If we did not pay attention to the question then we can easily make mistakes in these questions like the professor talks about in the video. Furthermore, in general, I find it very difficult to find different functions and options in the ribbon. I think it is something that can be improved over time with practice.

[@ritikasharma8184]

For me, the challenging task was the second task from project one. It was little bit hard for me to understand that how to put the formula and I need to work hard on the formulas. Thank you very much for this video and your videos are always very helpful.

[@shaolinli]

To me, creating a chart with 3 columns of data is the hardest to remember because intuitively i dont want to include the column name so i never know if i should highlight it or not

[@arianafeltrin4106]

The hardest task from this video for me will most likely be absolute cell reference. What would have been the hardest would be deleting a row or column in a table because as you mentioned if you use Word frequently for tables it might mess you up. Thankfully I now know that there is a different method in Excel and that type of question shouldn't be a problem anymore. Thank you for the videos, they are very helpful!