OMG MIKE WAKE UP! I’m in Australia and you’re probably asleep, but I just took my Excel Expert exam and thanks to your video and Udemy course I scored a 1000! I still can’t believe it. Wasn’t expecting that score at all, but was able to make a couple educated decisions in the right direction, which paid off. THANK YOU MIKE!!!
That’s so amazing, Lauren!! Well done. Wow, I honestly don’t even know if I could get 1000 on the Excel expert exam. There’s just so many ways to make a mistake. But you did it!! Congratulations! Now the next step...how can you let employers know you are an Excel wizard? I’m glad the Udemy course could help! You are proof that it can work! Thank you for letting me know
This dude is a legend. I watched this like 4-5 times before my exam and this was basically a carbon copy of my exam. I highly recommend this to anyone looking to take it. Thank you Mike!!!
I’m taking this test in two days, I’ve been using LinkedIn learning to study but then I found this video with the most positive comments so I’m about to just watch this over and over again the next 2 days and hope that works out 😅
Thanks a lot Mike. All your exam tutorial series are really helpful, I used them to review my knowledge before I took my exams. The projects and tasks in the real exam are almost the same as you presented. I passed all 5 exams and got the MOS 2019 Expert Certificate yesterday. I have recommended your channel to all my workmates and friends. Keep it up the good work!
Thank you so much! With your videos and Gmetrix I passed PowerPoint 2019, Word 2019, Excel 2019, Word Expert 2019, and Excel Expert 2019 and got the MOS Associate and MOS Expert certifications!
Mike. I have been avoiding this exam for years as everyone says how hard it is (and they're not wrong). I watched your video last night and took the exam this morning and SMASHED IT with an 809. The questions were hard, I skipped a few, and tried to logic my way through others (nested formulas are evil) but I bloody smashed it and couldn't have done it without you. Thank you for taking your time to share your knowledge. You are an everyday hero! :)
Laura!! Way to go! This exam is absolutely intimidating so it's amazing you had some great success with it. I'm glad this video could help. Haha, and thank you so much-- I would love to be everyone's Microsoft exam hero! Thanks for letting us know that it went well! What's next for you? Word Expert? Microsoft Master?
@@MikesOffice this was my final exam so I'm a 2019 Master or whatever the super level is. I've done Word and Word Expert, PowerPoint, Outlook and now Excel and Excel Expert - all in high 800-900 range. Couldn't have done it without you! I looked for a one off donation link but could only find the patron option. Can you help me help you? :)
Thanks a lot man. I failed after just studying using the test prep off Cengage and GMetrix but passed with flying colors thanks to you. You actually explained what to do and why.
I’m in my freshman year and sometimes have a hard time keeping up and half the time when my teacher give assignments, I just do it and not learn anything. I have my exam in 2 days and I’m halfway through the video and already learned so much! Thank you!
Hi Mike! I watched your videos just a day or two before my excel expert exam and I scored 918 in the first attempt! Thank you so much!! The videos were soo helpful, even the 2016 ones. Thank you for making learning accessible for all through this platform!
Hi Tanvia! Congratulations on doing so well on the Excel Expert exam. You don’t know how much that means that people like yourself appreciate that education can be accessible through RUclips! I always worry that someone will come by here and think because the videos I post are free that they aren’t valuable as a paid resource might be. students like yourself are proof that they can help! Well done and thanks for letting me know!!
Thank you so much for your help! When I first took the exam I score 300 something and did not pass. After watching your video I scored a 800 and passed!!!
Do you think just watching this video is enough to pass? I have my test later today but do not have money for paid resources so I am trying my best with youtube videos and stumbled across this one. Congratulations on passing your test!
This video helped me to go from not knowing half the answers on the review to passing the exam with an 861! Great video and would highly recommend to anyone struggling. The questions on the exam are very similar but make sure to learn consolidation.
OMG THANK YOU SO MUCH MIKE I have been stressing about this exam for weeks but today I passed with a 970 thanks to you! Seriously your channel is the bezt
Mike my man. I watched your videos for only a day straight, after not doing well on a Certification test. After watching you videos, I came into the testing room the next day with confidence and I passed. Thanks to your amazing videos and your way of teaching and explaining functions. Thanks
thanks, Mike, Today I have passed MOS 201 excel expert exam at my attempt! the real exam was a bit tricky. understanding the questions and do these in exam environment in a short time is the game plan. best of luck to all.
Hey Mime, me and my friend wanna thank u too much for helping us easily pass excel expert 2019. Keep doing what you do, u are changing everyone’s lives in Microsoft
I was about to watch this before taking my excel expert exam. I got caught up on some Gmetrix practice exam and totally forgot about the video. The Exam was EXACTLY like this video, testing the same knowledge on what he covers. Smh I knew I should have watched the video 🤦🏽♀️ I still passed though.
Hey Mike! Thank you for going over the look up and averageifs functions! Thanks to your videos, I passed my Associate exam. I will be taking the Expert one in about three weeks for possible college credit. Also, do you have a video on mapping cells from the developer tab?
Hi Mike! Thank you so much for your videos. I just took the Expert Exam today and I passed with a score of 970. The questions were almost the same. There are different sets of the Expert Excel exam but I got the one that is almost identical to this. Thanks again and I hope you can make an Access MOS Tutorial.
Hello, Thanks for the video. I have a question : is the Excel Expert 2019 program the same as that of 2016? I trained on the 2016 to pass the 2019 (complicated story) Thank you for your comeback, Respectfully,
Hi... Some of your videos helped a lot... I took a mock test for PowerPoint today and there was a question I wanted to ask you about... The question asked us to insert a video and then make playback settings to return to the title slide after the video ends.. I'd be really grateful if you shared how to do the 2nd bit of the question... Thanks!!😀
Hi Diya, it sounds like that's just another way of saying change the features so that it loops at the end of the presentation. I'll test it out but it sounds like that is what is being asked.
Hi Mike. Just curious. For the conditional formatting you said you have to clear the existing conditional formatting rule. I'm wondering why you didn't just edit the rule (manage rules / edit)? thanks
I'm wondering that, too. The task said to make it bold Italic and remove the red fill, but there was also red font. The task didn't say to remove the red font. The way Mike did it, it also removed the red font. Confusing.
Hello Mike, I would like to ask you about specific videos for Excel Expert 2016 (tips for the real test) for people that are practicing to get the Master certificate, for some reason we are finding the 2016 version more difficult than 2019 .. Any advice will be appreciated. thanks
Right at the end of this video, you mentioned being able to do tasks very quickly. What kind of time limits are we looking at with the Excel Exam? Is each objective timed or the whole exam timed in one block?
Hi Mike, do you have any video on nested functions? That is really something that I always struggle with when I need to mix different formulas. Could you please help me with those envolving if,index,match,and,or and so.... Thanks a lot!
Hi Mike. Thanks for this video. It is very helpful. Do you have an inventory excel system? Just an excel file. I work with inventory monitoring in a warehouse with no inventory system. So, i created one using excel only with various formulas just to automate the file (Vlookup, sumif, sumifs, sumproduct, if , iferror, & others) . These formulas slows down my file every time i make an update .
Hey Mike, would be maybe nice if you would go thru all topics of the exam with possible questions because I have personally sometimes problem to understand what they want from me even if the solution is easy. I watched all your videos :) Thanks for your work
I do take a deeper dive into the Excel Expert exam here if you are interested: www.udemy.com/course/mo-201-mos-expert-excel-2019-exam/?couponCode=47DB488876890411800E
@@barboragruberova8603 it absolutely will be there by default if you have that type of question on the exam, because you would have to add it into the formula as you said or change the formatting and they want you to just worry about inputting the weekday function.
Hey Mike! I was wondering if, on the Expert exam, the test will act exactly like normal Excel by telling me what the order of the values in the cells is. Like, when I type in "concat", the cell automatically has a line under it that says "(text 1,...)" and when I type in "if" the cell below says "(logical test, [value_if_true], [value_if_false])". Thanks!
Hello, I'm learning Excel and want to get a cert, if I watch and practice just this video will I be exam-ready or should I do a udamy course as well? can someone who's taken the exam help me out?
Hi Mike.. Can you please make a video on Index function when you get the time. Also, I think it would be better if you include MO-201 ind the video title.
Mike: Thank you for your videos, very informative. Are there questions about Macros, Cube functions and Data tables in the Excel Expert exam? How about Rand, randbetween?
Good questions! For the 2019 version there is no cube functions and very simple macros. No vba. No rand or rand between. Mostly vlookup/hlookup, averageifs, I hope that helps a little. I’ll come out with more Excel expert stuff soon.
I have my exam in a couple days and I've done a lot of gmetrix tests getting mostly 90s and have seen a lot of videos but I'm still really afraid bc I really need to pass this exam. Is the actual test close to this or gmetrix? or is it harder?
@@kayeiaramariedeocampo7980 to tell the truth I think with gmetrix and this video or his course in udemy it’s more than enough. I passed and it had a couple questions like gmetrix and some like the ones shown in this video. The only part I had a little rough time was with the macros and advanced formulas, it was the only part I got less than 70%. If you have passed gmetrix a couple times with ease you’re ready. Hope this helps, best of luck
how can i write a formula that only compares 2 cells in a given row that will have 4 values? For example, cell B1 has a value of 6 and C1 has a value of 2. the "Difference cell" will total C1-B1 = -4. then when i add a value of 3 into cell D1 of 3, the "difference cell" will total D1-C1 = 1. then when i add a value of 3 into cell E1, the "difference cell" will total E1-D1 = 0. Hope this makes sense lol
On the subtotal questions you used the subtotal function 2 times. Why did you not used both subtotals at the same time. In that case both subtotals would appear in one line and not in two. Would both solutions be right in the exam?
I've done it both ways but sometimes it's good to show a new step twice. You have a good point, you can also choose both right away. Both would get you full marks.
Hello Mr Mike's I paid for patreon on 30.10.2021 for one month. Now after to days at 01.11.2021 another 3 dollars? First i was a big fan of your guides, now i am unsure, do i have to pay again in 3 days or what is going on? Thanks for your answer. At least amazing guide btw, thanks.
So you paid 6 dollars for exam guides that would normally cost 100 dollars through Gmetrix and you’re mad? I don’t get it. Sorry that’s just how patreon works. I didn’t set it up like that.
Hey Mike..I passed MOS 2016 Word Excel and Powepoint using your Udemy classes. I am hoping to do the same for 2019 versions. I have already bought the MO 200 course.Could you please tell me when we can expect MOS 2019 Powerpoint and Word on Udemy?
I passed! Of course it wasnt verbatim, but it was truly helpful. Some skills like SUMIFS between ranges and calculating Active Fields got me a little stuck.
@@kayeiaramariedeocampo7980 Of course! It's a way of adding formulas to a Pivot Table for desired columns. Sadly, I didn't learn about it until after the exam. In the video "How to use a Pivot Table Calculate Field?" by Computer Tutoring explains it very well at 2:02 minutes Also be aware of File settings such as "Protecting the Workbook Structure" and Macros. It's a large portion. Things that were also included in Mike's videos were Fill Series, HLOOKUP, Grouping, Error Checking, Slicers, Subtotals, =WEEKDAY, and Combo Area chart. Do research on =SUMIFS!! Best of luck to you. (Sorry my previous comment got deleted because I linked the video!)
Should be back tomorrow just like the other 55 videos they made a false claim on. Sorry I should have had a back up but I had no idea someone would attack this channel like that.
I just created a course on Word about how to get 1000 points. Its free in the next 3 days if you use this link: www.udemy.com/course/microsoft-word-2019-mo-100-study-guide-to-1000-points/?couponCode=C8B43509EB65F7D877F2
I was actually going to cover that in a video. Usually you can do it through a school but I think you can go to Certiport’s website and buy an exam voucher.
What Excel Expert skills were new to you and which ones would you like me to cover in the next one? Let me know! 👍
This is Excel Expert 2019 ?
🤩 thanks
@@VIKUI_CO Yes it is! Do you have an exam coming up??
@@MikesOffice I have
Dinamic chart from the pivot analysis!
Goal seek
Took my first excel test and got a 368. Watched your videos the days coming up to my next attempt and got a 775. Thank you.
was it the expert one? i wanna appear too for the expert one
OMG MIKE WAKE UP! I’m in Australia and you’re probably asleep, but I just took my Excel Expert exam and thanks to your video and Udemy course I scored a 1000! I still can’t believe it. Wasn’t expecting that score at all, but was able to make a couple educated decisions in the right direction, which paid off. THANK YOU MIKE!!!
That’s so amazing, Lauren!! Well done. Wow, I honestly don’t even know if I could get 1000 on the Excel expert exam. There’s just so many ways to make a mistake. But you did it!! Congratulations! Now the next step...how can you let employers know you are an Excel wizard? I’m glad the Udemy course could help! You are proof that it can work! Thank you for letting me know
I am taking my exam next week in Australia also.
1000 is amazing!
Good luck with your exam Sally!!!
Did you passed na Excel Associate Cert before?how long did you need to learn since you have passed Associate Cert?
This dude is a legend. I watched this like 4-5 times before my exam and this was basically a carbon copy of my exam. I highly recommend this to anyone looking to take it. Thank you Mike!!!
I’m so glad you said this mines tomorrow
@@notgracie6153 did this video end up helping? Debating on whether to just use this video to study
@@rohitgandhy4428 Taking mine in a hour, ill lyk 🤣
I’m taking this test in two days, I’ve been using LinkedIn learning to study but then I found this video with the most positive comments so I’m about to just watch this over and over again the next 2 days and hope that works out 😅
@@thecrypticglint4250 Did this video end up helping? im taking my test today ahh
Thanks a lot Mike. All your exam tutorial series are really helpful, I used them to review my knowledge before I took my exams. The projects and tasks in the real exam are almost the same as you presented. I passed all 5 exams and got the MOS 2019 Expert Certificate yesterday. I have recommended your channel to all my workmates and friends. Keep it up the good work!
Super duper great video that helped me pass with a 918. Highly recommended!
Tomorrow is my day! xD
@@khodosgames1644 same here
@@iOnly_Snooze how was it? I just passed today with 945 :)
Same here
Did you passed na Excel Associate Cert before?how long did you need to learn since you have passed Associate Cert?
Thank you so much! With your videos and Gmetrix I passed PowerPoint 2019, Word 2019, Excel 2019, Word Expert 2019, and Excel Expert 2019 and got the MOS Associate and MOS Expert certifications!
Mike. I have been avoiding this exam for years as everyone says how hard it is (and they're not wrong). I watched your video last night and took the exam this morning and SMASHED IT with an 809. The questions were hard, I skipped a few, and tried to logic my way through others (nested formulas are evil) but I bloody smashed it and couldn't have done it without you. Thank you for taking your time to share your knowledge. You are an everyday hero! :)
Laura!! Way to go! This exam is absolutely intimidating so it's amazing you had some great success with it. I'm glad this video could help. Haha, and thank you so much-- I would love to be everyone's Microsoft exam hero! Thanks for letting us know that it went well! What's next for you? Word Expert? Microsoft Master?
@@MikesOffice this was my final exam so I'm a 2019 Master or whatever the super level is. I've done Word and Word Expert, PowerPoint, Outlook and now Excel and Excel Expert - all in high 800-900 range. Couldn't have done it without you! I looked for a one off donation link but could only find the patron option. Can you help me help you? :)
Did you passed na Excel Associate Cert before?how long did you need to learn since you have passed Associate Cert?
Thanks a lot man. I failed after just studying using the test prep off Cengage and GMetrix but passed with flying colors thanks to you. You actually explained what to do and why.
Did you passed na Excel Associate Cert before?how long did you need to learn since you have passed Associate Cert?
I’m in my freshman year and sometimes have a hard time keeping up and half the time when my teacher give assignments, I just do it and not learn anything. I have my exam in 2 days and I’m halfway through the video and already learned so much! Thank you!
Hey bro had surprise exam that I didn’t know about listened to your videos on the drive to exam and passed. You’re the goat
Hi Mike! I watched your videos just a day or two before my excel expert exam and I scored 918 in the first attempt! Thank you so much!! The videos were soo helpful, even the 2016 ones. Thank you for making learning accessible for all through this platform!
Hi Tanvia! Congratulations on doing so well on the Excel Expert exam. You don’t know how much that means that people like yourself appreciate that education can be accessible through RUclips! I always worry that someone will come by here and think because the videos I post are free that they aren’t valuable as a paid resource might be. students like yourself are proof that they can help! Well done and thanks for letting me know!!
Hi Tanvi, could you please share the resources that you've used for your prep? Thanks
Did you passed na Excel Associate Cert before?how long did you need to learn since you have passed Associate Cert?
I JUST PASSED THE EXAM THANKS TO THIS VIDEO! THANK YOU SO MUCH❤
Hello! Did you watch only this video? I am not finding other helpful videos for expert exam!!
Thank you so much for your help! When I first took the exam I score 300 something and did not pass. After watching your video I scored a 800 and passed!!!
Thanks Mike. Your videos helped me a lot to score 940 in the Excel Expert test yesterday.
Do you think just watching this video is enough to pass? I have my test later today but do not have money for paid resources so I am trying my best with youtube videos and stumbled across this one. Congratulations on passing your test!
@@mayangmokomDid you pass?
This video helped me to go from not knowing half the answers on the review to passing the exam with an 861! Great video and would highly recommend to anyone struggling. The questions on the exam are very similar but make sure to learn consolidation.
Did you passed na Excel Associate Cert before?how long did you need to learn since you have passed Associate Cert?
hey, just wanted to thank you for your videos. i was watching it to revise for my excel expert exam and i passed !!! god bless you bro
this was a great study guide. i finished the mo-201 test with 10 mins to spare
OMG THANK YOU SO MUCH MIKE I have been stressing about this exam for weeks but today I passed with a 970 thanks to you! Seriously your channel is the bezt
did you just watch this video to pass?
Mike my man. I watched your videos for only a day straight, after not doing well on a Certification test. After watching you videos, I came into the testing room the next day with confidence and I passed. Thanks to your amazing videos and your way of teaching and explaining functions. Thanks
Did you passed na Excel Associate Cert before?how long did you need to learn since you have passed Associate Cert?
thanks, Mike,
Today I have passed MOS 201 excel expert exam at my attempt!
the real exam was a bit tricky. understanding the questions and do these in exam environment in a short time is the game plan.
best of luck to all.
Congrats 🎉! Mine is in 2 days, what videos did you watch? Can you please shareee? Thanks
Questions on the exam were literally the same exact ones you showed, thank you!
Thanks you Mike ❤
I get 1000 in my excel expert exam
Can you please share the tips ? if not a perfect score.. atleast 999...:)
Thank you so much for this video you awesome human! Just aced my exam thanks to you!
Hey Mime, me and my friend wanna thank u too much for helping us easily pass excel expert 2019. Keep doing what you do, u are changing everyone’s lives in Microsoft
Meant to say Mike not Mime
And me!!!😁🤣😂
@@krishna5581 yes u too
Me too!
great video
I took the exam today and got 807.
helped me a lot
You are the best, really thank you very much. Today I passed my certification thanks to your videos!!!
Wow, this was filmed perfectly. Nicely done sir
Cut right to the point. Too many RUclips excel videos will be 7mins+ for something that is two seconds. This so great, every second utilized
I was about to watch this before taking my excel expert exam. I got caught up on some Gmetrix practice exam and totally forgot about the video. The Exam was EXACTLY like this video, testing the same knowledge on what he covers. Smh I knew I should have watched the video 🤦🏽♀️ I still passed though.
I am glad that you passed! I've gotta do a better job convincing people these videos can help!
Got a 925 on my MOS Excel! Thanks so much!
Thank you!!Your video help me to pass the exam.
Hey Mike! Thank you for going over the look up and averageifs functions! Thanks to your videos, I passed my Associate exam. I will be taking the Expert one in about three weeks for possible college credit. Also, do you have a video on mapping cells from the developer tab?
Hi Mike! Thank you so much for your videos. I just took the Expert Exam today and I passed with a score of 970. The questions were almost the same. There are different sets of the Expert Excel exam but I got the one that is almost identical to this. Thanks again and I hope you can make an Access MOS Tutorial.
Hi bạn bạn có bộ excam Excel and word Expert 2019 thì cho mình xin với nha!
Thanks Mike, lots of good examples and walking through makes a huge difference.
Fantastic tutorial! It helped me a lot to be prepared for my MOS-Excel Expert that is about to happen in a couple of days. Thank you so much!
Good luck, Jaqueline!!
Hello, Thanks for the video. I have a question : is the Excel Expert 2019 program the same as that of 2016? I trained on the 2016 to pass the 2019 (complicated story)
Thank you for your comeback,
Respectfully,
Hi Mike! Thanks for all your help!
Hi... Some of your videos helped a lot... I took a mock test for PowerPoint today and there was a question I wanted to ask you about... The question asked us to insert a video and then make playback settings to return to the title slide after the video ends.. I'd be really grateful if you shared how to do the 2nd bit of the question... Thanks!!😀
Hi Diya, it sounds like that's just another way of saying change the features so that it loops at the end of the presentation. I'll test it out but it sounds like that is what is being asked.
@@MikesOffice Oh wow thank you so much... Also is 828 a good score? I wanna take part in the mos championships😅
Hi Diya could you please share the resources you've used for preparation for excel Mo 201 exam? Thanks
Mike Please, Please, finish the MOS Access Projects I really would love to practice with them.
Sir I have a doubt if the search option is available on the exam
Excellent tutorial! can you please share excel and word documents (sample data files), that you used in this tutorial ?
Have anyone watched this video lately for the expert exam? I have it in a week and I was wondering if this video still helps. Thanks
It helped a lot I got an 880
@@luciansavaggethanks! Did you see only this video or other videos too?! I am not finding other expert excel from Mike.
Excellent. Thanks Mike. It’s really useful. I want to be Microsoft certified Excel expert. Need your kind advice please.
Hi Mike. Just curious. For the conditional formatting you said you have to clear the existing conditional formatting rule. I'm wondering why you didn't just edit the rule (manage rules / edit)? thanks
Good question. I was wondering the same thing.
I'm wondering that, too. The task said to make it bold Italic and remove the red fill, but there was also red font. The task didn't say to remove the red font. The way Mike did it, it also removed the red font. Confusing.
My first attempt was basically an exact copy of this, for my next attempt will they be the same questions?
Hi Mike, i am really appreciate your video. Most of the questions are came as per this video. Please put same for PL-300 exam.
Thumbs Up Enjoyed The Tutorial...Thank You Mike
I'm glad you liked it Darryl! Were there any surprises in this one?
No surprises Mike mind you it's been a long time since I did this exam lol
Nah mikes the boy, if u put reps into this video I promise you will pass!!!
Thanks a lot! This video is very helpful.
OMG THANK YOU I PASSED IT
Yes!!! Well done!
Hello Mike, I would like to ask you about specific videos for Excel Expert 2016 (tips for the real test) for people that are practicing to get the Master certificate, for some reason we are finding the 2016 version more difficult than 2019 .. Any advice will be appreciated. thanks
Hi Mike.
Can you please make a video on Create custom Documents Elements in word expert 2019 when you get the time.
Thank you man this helped a lot
Right at the end of this video, you mentioned being able to do tasks very quickly. What kind of time limits are we looking at with the Excel Exam? Is each objective timed or the whole exam timed in one block?
The exam is timed. 50 minutes for 25 exercises
@@cubeermaui Ah thank you! So I discovered! I took it and passed, largely thanks to these videos!
Hi Mike, do you have any video on nested functions? That is really something that I always struggle with when I need to mix different formulas. Could you please help me with those envolving if,index,match,and,or and so.... Thanks a lot!
Everything he went over in this video was literally on the exam I’m sad I didn’t watch the other one.
Hi Mike. Thanks for this video. It is very helpful.
Do you have an inventory excel system? Just an excel file. I work with inventory monitoring in a warehouse with no inventory system. So, i created one using excel only with various formulas just to automate the file (Vlookup, sumif, sumifs, sumproduct, if , iferror, & others) . These formulas slows down my file every time i make an update .
Hey Mike, would be maybe nice if you would go thru all topics of the exam with possible questions because I have personally sometimes problem to understand what they want from me even if the solution is easy. I watched all your videos :) Thanks for your work
I do take a deeper dive into the Excel Expert exam here if you are interested: www.udemy.com/course/mo-201-mos-expert-excel-2019-exam/?couponCode=47DB488876890411800E
and btw this dddd option is probably not there default, i did not have it but obviously you can type it dddd
@@MikesOffice okay Mike, take my money
@@barboragruberova8603 it absolutely will be there by default if you have that type of question on the exam, because you would have to add it into the formula as you said or change the formatting and they want you to just worry about inputting the weekday function.
Haha thank you for signing up! I will be adding a new practice exam to the course today.
Thanks a lot, Mike!
Hey Mike! I was wondering if, on the Expert exam, the test will act exactly like normal Excel by telling me what the order of the values in the cells is. Like, when I type in "concat", the cell automatically has a line under it that says "(text 1,...)" and when I type in "if" the cell below says "(logical test, [value_if_true], [value_if_false])". Thanks!
Hello, I'm learning Excel and want to get a cert, if I watch and practice just this video will I be exam-ready or should I do a udamy course as well? can someone who's taken the exam help me out?
Could you cover a little more pivochart fields pls
Could you cover more on pivot tables im a bit unclear
Could you go over MO-211?
Hi Mike.. Can you please make a video on Index function when you get the time. Also, I think it would be better if you include MO-201 ind the video title.
That's a great idea! I'll get to work on it. Also, yes, I probably should improve the title to make it more specific! Thank you for both suggestions.
Mike: Thank you for your videos, very informative. Are there questions about Macros, Cube functions and Data tables in the Excel Expert exam? How about Rand, randbetween?
Good questions! For the 2019 version there is no cube functions and very simple macros. No vba. No rand or rand between. Mostly vlookup/hlookup, averageifs, I hope that helps a little. I’ll come out with more Excel expert stuff soon.
Thanks a lot!
I just took it, I didn’t even understand the question: How to make Histogram Chart with the steps bin width of $10?
Thank you so much!
19:54 to 20:08, can we do it in one go? and put the SUM in Number of Lesson and Total Due? instead of doing it twice like that? Tx
Hi Mike do you have additional review on the advanced formulas, like a crash course?
I have one on Udemy if you are interested. The link is in the description of this video.
I have my exam in a couple days and I've done a lot of gmetrix tests getting mostly 90s and have seen a lot of videos but I'm still really afraid bc I really need to pass this exam. Is the actual test close to this or gmetrix? or is it harder?
how was the result of you exam? I'm reviewing through gmetrix too. I'll have my exam tomorrow. tips please
@@kayeiaramariedeocampo7980 to tell the truth I think with gmetrix and this video or his course in udemy it’s more than enough. I passed and it had a couple questions like gmetrix and some like the ones shown in this video. The only part I had a little rough time was with the macros and advanced formulas, it was the only part I got less than 70%. If you have passed gmetrix a couple times with ease you’re ready. Hope this helps, best of luck
Make an access one please Mike
how can i write a formula that only compares 2 cells in a given row that will have 4 values? For example, cell B1 has a value of 6 and C1 has a value of 2. the "Difference cell" will total C1-B1 = -4. then when i add a value of 3 into cell D1 of 3, the "difference cell" will total D1-C1 = 1. then when i add a value of 3 into cell E1, the "difference cell" will total E1-D1 = 0. Hope this makes sense lol
Can you share this data on the description
Hi Mike... I love your videos... just curious, what the different MO-200 with MO-201?
Thanks!! MO 200 is the core Excel exam (beginner to intermediate skills) and the MO 201 is the Expert level Excel Exam.
On the subtotal questions you used the subtotal function 2 times. Why did you not used both subtotals at the same time. In that case both subtotals would appear in one line and not in two. Would both solutions be right in the exam?
I've done it both ways but sometimes it's good to show a new step twice. You have a good point, you can also choose both right away. Both would get you full marks.
Is there a file associated with your video that I can practice with?
how to become a MOS instructor? What are exams need to do?
Hello Mr Mike's
I paid for patreon on 30.10.2021 for one month. Now after to days at 01.11.2021 another 3 dollars? First i was a big fan of your guides, now i am unsure, do i have to pay again in 3 days or what is going on? Thanks for your answer. At least amazing guide btw, thanks.
So you paid 6 dollars for exam guides that would normally cost 100 dollars through Gmetrix and you’re mad? I don’t get it. Sorry that’s just how patreon works. I didn’t set it up like that.
If I buy the Patreon for 100, do I get access to exam experts courses? That’s the one I’m currently studying to pass
Yes! I share my resources for the Word Expert and Excel Expert exams with that one.
Hey Mike..I passed MOS 2016 Word Excel and Powepoint using your Udemy classes. I am hoping to do the same for 2019 versions. I have already bought the MO 200 course.Could you please tell me when we can expect MOS 2019 Powerpoint and Word on Udemy?
I'll have the Word one completed by the end of this week, and PowerPoint 2019 the next!
@@MikesOffice Thanks Mikes..You are the best ❤️😁
New Word 2019 course here: www.udemy.com/course/microsoft-word-2019-mo-100-study-guide-to-1000-points/?couponCode=4DBEBBB7F22B0239858A
@@MikesOffice Thanks Mike. Bought it just now 😁
Thank You Very Much
Isn't that first section with the fill by 100 incorrect? Row 7 jumps by 200 not 100.
I just wanted to ask the same thing. But I think, it was enough to select only columns C-F (without B).
I got the same wondering
Hi Mike do you have a formula for time and adding to calc hours for the day and sum up to total hours for the month
Not yet but that sounds like an awesome video idea
great, thanks
Im taking my Expert Excel exam tomorrow! I'll respond my results:
I passed! Of course it wasnt verbatim, but it was truly helpful.
Some skills like SUMIFS between ranges and calculating Active Fields got me a little stuck.
@@grant4d1 what do you mean Calculating Active Fields? Tips please. I'm going to take my exam tomorrow :D
@@kayeiaramariedeocampo7980 Of course! It's a way of adding formulas to a Pivot Table for desired columns. Sadly, I didn't learn about it until after the exam. In the video "How to use a Pivot Table Calculate Field?" by Computer Tutoring explains it very well at 2:02 minutes
Also be aware of File settings such as "Protecting the Workbook Structure" and Macros. It's a large portion.
Things that were also included in Mike's videos were Fill Series, HLOOKUP, Grouping, Error Checking, Slicers, Subtotals, =WEEKDAY, and Combo Area chart. Do research on =SUMIFS!!
Best of luck to you. (Sorry my previous comment got deleted because I linked the video!)
@@kayeiaramariedeocampo7980how’d you do?
Would you please provide me some sample of excel associate exam's questions and answer
where are these data files? I can't find them even after paying on patreon
Gotta scroll down
Do I need to pass MOS 200 before attempting MOS 201?
Thanks.
No you don’t have to. But is is strongly recommended
Realmente, Muchas Gracias
Hi Mike
I am from Egypt. And they tell me that we can't get the Microsoft certification from Microsoft company because of covid 19.
Are that's true ?
Not true at all. We have been taking part in them the whole time. They moved online when the pandemic started.
Hi Mike how can I get the removed excel videos which were removed by cetripoint
Should be back tomorrow just like the other 55 videos they made a false claim on. Sorry I should have had a back up but I had no idea someone would attack this channel like that.
Are all these 55 videos related to excel?!
1:30 How is this correct? on excel expert it increases it by 200 per year if you do it that way
How? The numbers went up by 100 in the video.
@@MikesOffice Row 7
d7 e7 f7 they went up by 200
thanks
i need outlook mos 2019
Hi Ahmed, Yes! I'll be working on that soon. Probably within the next two weeks. I'll update here when I've got that one up.
İ want to help me for Microsoft Word championship and your advice
I just created a course on Word about how to get 1000 points. Its free in the next 3 days if you use this link: www.udemy.com/course/microsoft-word-2019-mo-100-study-guide-to-1000-points/?couponCode=C8B43509EB65F7D877F2
@@MikesOffice are you likely to have any upcoming discounts on this one? Thanks!
I need quick help in excel formula of vlookup. anyone please
How to enroll for exam?
I was actually going to cover that in a video. Usually you can do it through a school but I think you can go to Certiport’s website and buy an exam voucher.
Thank you very much
I need to know how to do the stupid language thing.
where are the files?
Link is in the description.
I paid for the Patrons log in thing, but cant find files.
@@MikesOffice I know that, however that link takes me to different files!
@@marianag8043 it’s there on the page. Just have to scroll down. I can pin it to the top of that’s easier
Sarah Shaw is in trouble!
For a second there I thought we worked together, because the real Sarah Shaw was always in trouble!
@@MikesOffice 🤣