What Excel Expert skills were new to you and which ones would you like me to cover in the next one? Let me know! 👍

@VIKUI_CO

3 жыл бұрын

This is Excel Expert 2019 ? 🤩 thanks

@MikesOffice

3 жыл бұрын

@@VIKUI_CO Yes it is! Do you have an exam coming up??

@anonymous-kv3mn

3 жыл бұрын

@@MikesOffice I have

@anaisgilbert7170

3 жыл бұрын

Dinamic chart from the pivot analysis!

@pancholitachiu23

2 жыл бұрын

Goal seek

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

@notgracie6153

2 ай бұрын

I’m so glad you said this mines tomorrow

@rohitgandhy4428

Ай бұрын

@@notgracie6153 did this video end up helping? Debating on whether to just use this video to study

@thecrypticglint4250

Ай бұрын

@@rohitgandhy4428 Taking mine in a hour, ill lyk 🤣

@jasforchrist

Ай бұрын

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 😅

@jasforchrist

Ай бұрын

@@thecrypticglint4250 Did this video end up helping? im taking my test today ahh

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.

@litosphile

3 ай бұрын

was it the expert one? i wanna appear too for the expert one

Thanks Mike. Your videos helped me a lot to score 940 in the Excel Expert test yesterday.

@mayangmokom

4 күн бұрын

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!

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

@MikesOffice

3 жыл бұрын

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

@sallyzhu7643

3 жыл бұрын

I am taking my exam next week in Australia also.

@sallyzhu7643

3 жыл бұрын

1000 is amazing!

@laurenerickson4333

3 жыл бұрын

Good luck with your exam Sally!!!

@BartM93x

Жыл бұрын

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!

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

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!

I JUST PASSED THE EXAM THANKS TO THIS VIDEO! THANK YOU SO MUCH❤

Thanks Mike, lots of good examples and walking through makes a huge difference.

Super duper great video that helped me pass with a 918. Highly recommended!

@khodosgames1644

3 жыл бұрын

Tomorrow is my day! xD

@iOnly_Snooze

3 жыл бұрын

@@khodosgames1644 same here

@soap8013

3 жыл бұрын

@@iOnly_Snooze how was it? I just passed today with 945 :)

@sidhantgoyal4327

3 жыл бұрын

Same here

@BartM93x

Жыл бұрын

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.

@BartM93x

Жыл бұрын

Did you passed na Excel Associate Cert before?how long did you need to learn since you have passed Associate Cert?

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

Thank you so much for this video you awesome human! Just aced my exam thanks to 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!

@MikesOffice

3 жыл бұрын

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

@quantum3712

3 жыл бұрын

Hi Tanvi, could you please share the resources that you've used for your prep? Thanks

@BartM93x

Жыл бұрын

Did you passed na Excel Associate Cert before?how long did you need to learn since you have passed Associate Cert?

Hi Mike! Thanks for all your help!

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

@MikesOffice

3 жыл бұрын

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?

@lauramarinello4043

3 жыл бұрын

@@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? :)

@BartM93x

Жыл бұрын

Did you passed na Excel Associate Cert before?how long did you need to learn since you have passed Associate Cert?

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!

@MikesOffice

2 жыл бұрын

Good luck, Jaqueline!!

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.

@BartM93x

Жыл бұрын

Did you passed na Excel Associate Cert before?how long did you need to learn since you have passed Associate Cert?

Questions on the exam were literally the same exact ones you showed, thank you!

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?

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

@BartM93x

Жыл бұрын

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

Thanks a lot! This video is very helpful.

great video I took the exam today and got 807. helped me a lot

Got a 925 on my MOS Excel! Thanks so much!

Thank you!!Your video help me to pass the exam.

Thanks a lot, Mike!

Wow, this was filmed perfectly. Nicely done sir

@swod1

2 жыл бұрын

Cut right to the point. Too many KZread excel videos will be 7mins+ for something that is two seconds. This so great, every second utilized

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

@marianag8043

2 жыл бұрын

did you just watch this video to pass?

Thanks you Mike ❤ I get 1000 in my excel expert exam

@premiimk

2 жыл бұрын

Can you please share the tips ? if not a perfect score.. atleast 999...:)

Thumbs Up Enjoyed The Tutorial...Thank You Mike

@MikesOffice

3 жыл бұрын

I'm glad you liked it Darryl! Were there any surprises in this one?

@darrylmorgan

3 жыл бұрын

No surprises Mike mind you it's been a long time since I did this exam lol

Thank you man this helped a lot

Thank you so much!

Mike Please, Please, finish the MOS Access Projects I really would love to practice with them.

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

@ashvinvaradaraju3407

2 жыл бұрын

Meant to say Mike not Mime

@krishna5581

2 жыл бұрын

And me!!!😁🤣😂

@ashvinvaradaraju3407

2 жыл бұрын

@@krishna5581 yes u too

@amit484

2 жыл бұрын

Me too!

Excellent. Thanks Mike. It’s really useful. I want to be Microsoft certified Excel expert. Need your kind advice please.

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.

@huuongbui7146

Жыл бұрын

Hi bạn bạn có bộ excam Excel and word Expert 2019 thì cho mình xin với nha!

Thank you very much.

great, thanks

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!

Realmente, Muchas Gracias

Thank you so much

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, i am really appreciate your video. Most of the questions are came as per this video. Please put same for PL-300 exam.

Thank You Very Much

You are the best, really thank you very much. Today I passed my certification thanks to your videos!!!

OMG THANK YOU I PASSED IT

@MikesOffice

2 ай бұрын

Yes!!! Well done!

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!

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

@MikesOffice

3 жыл бұрын

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.

@diyachatterjee5794

3 жыл бұрын

@@MikesOffice Oh wow thank you so much... Also is 828 a good score? I wanna take part in the mos championships😅

@quantum3712

3 жыл бұрын

Hi Diya could you please share the resources you've used for preparation for excel Mo 201 exam? Thanks

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 .

Hi Mike. Can you please make a video on Create custom Documents Elements in word expert 2019 when you get the time.

Excellent tutorial! can you please share excel and word documents (sample data files), that you used in this tutorial ?

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.

@MikesOffice

3 жыл бұрын

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.

Hi Mike... I love your videos... just curious, what the different MO-200 with MO-201?

@MikesOffice

3 жыл бұрын

Thanks!! MO 200 is the core Excel exam (beginner to intermediate skills) and the MO 201 is the Expert level Excel Exam.

Hi Mike do you have additional review on the advanced formulas, like a crash course?

@MikesOffice

3 жыл бұрын

I have one on Udemy if you are interested. The link is in the description of this video.

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

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

@MikesOffice

3 жыл бұрын

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

3 жыл бұрын

and btw this dddd option is probably not there default, i did not have it but obviously you can type it dddd

@barboragruberova8603

3 жыл бұрын

@@MikesOffice okay Mike, take my money

@MikesOffice

3 жыл бұрын

@@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.

@MikesOffice

3 жыл бұрын

Haha thank you for signing up! I will be adding a new practice exam to the course today.

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?

@cubeermaui

3 жыл бұрын

The exam is timed. 50 minutes for 25 exercises

@saarakhalid9795

3 жыл бұрын

@@cubeermaui Ah thank you! So I discovered! I took it and passed, largely thanks to these videos!

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

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?

@MikesOffice

2 жыл бұрын

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.

@pancholitachiu23

2 жыл бұрын

Thanks a lot!

Sir I have a doubt if the search option is available on the exam

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 more on pivot tables im a bit unclear

Could you cover a little more pivochart fields pls

Make an access one please Mike

Nah mikes the boy, if u put reps into this video I promise you will pass!!!

Is there a file associated with your video that I can practice with?

Could you go over MO-211?

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

@MM-nn7vw

Жыл бұрын

Good question. I was wondering the same thing.

@Swizzletwice

2 ай бұрын

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.

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?

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

@MikesOffice

2 жыл бұрын

Not yet but that sounds like an awesome video idea

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?

@MikesOffice

3 жыл бұрын

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.

Everything he went over in this video was literally on the exam I’m sad I didn’t watch the other one.

Im taking my Expert Excel exam tomorrow! I'll respond my results:

@grant4d1

10 күн бұрын

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.

Can you share this data on the description

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

@MikesOffice

3 жыл бұрын

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?

@MikesOffice

3 жыл бұрын

I'll have the Word one completed by the end of this week, and PowerPoint 2019 the next!

@alexeyvarghesegeorge7668

3 жыл бұрын

@@MikesOffice Thanks Mikes..You are the best ❤️😁

@MikesOffice

3 жыл бұрын

New Word 2019 course here: www.udemy.com/course/microsoft-word-2019-mo-100-study-guide-to-1000-points/?couponCode=4DBEBBB7F22B0239858A

@alexeyvarghesegeorge7668

3 жыл бұрын

@@MikesOffice Thanks Mike. Bought it just now 😁

I just took it, I didn’t even understand the question: How to make Histogram Chart with the steps bin width of $10?

thanks i need outlook mos 2019

@MikesOffice

3 жыл бұрын

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.

Would you please provide me some sample of excel associate exam's questions and answer

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.

@MikesOffice

2 жыл бұрын

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.

how to become a MOS instructor? What are exams need to do?

Do I need to pass MOS 200 before attempting MOS 201? Thanks.

@MikesOffice

2 жыл бұрын

No you don’t have to. But is is strongly recommended

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

where are these data files? I can't find them even after paying on patreon

@MikesOffice

2 жыл бұрын

Gotta scroll down

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 ?

@MikesOffice

2 жыл бұрын

Not true at all. We have been taking part in them the whole time. They moved online when the pandemic started.

I need quick help in excel formula of vlookup. anyone please

İ want to help me for Microsoft Word championship and your advice

@MikesOffice

3 жыл бұрын

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

@laurenerickson4333

3 жыл бұрын

@@MikesOffice are you likely to have any upcoming discounts on this one? Thanks!

Hi Mike how can I get the removed excel videos which were removed by cetripoint

@MikesOffice

2 жыл бұрын

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.

@amalali656

2 жыл бұрын

Are all these 55 videos related to excel?!

Isn't that first section with the fill by 100 incorrect? Row 7 jumps by 200 not 100.

@KruczaBaba

4 ай бұрын

I just wanted to ask the same thing. But I think, it was enough to select only columns C-F (without B).

@jmk8390

3 ай бұрын

I got the same wondering

1:30 How is this correct? on excel expert it increases it by 200 per year if you do it that way

@MikesOffice

Жыл бұрын

How? The numbers went up by 100 in the video.

@brusslee1814

Жыл бұрын

@@MikesOffice Row 7 d7 e7 f7 they went up by 200

How to enroll for exam?

@MikesOffice

3 жыл бұрын

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.

@abhishektelang2880

3 жыл бұрын

Thank you very much

تعبت من الدراسه

Sarah Shaw is in trouble!

@MikesOffice

Жыл бұрын

For a second there I thought we worked together, because the real Sarah Shaw was always in trouble!

@kyriakos9300

Жыл бұрын

@@MikesOffice 🤣

I need to know how to do the stupid language thing.

where are the files?

@MikesOffice

2 жыл бұрын

Link is in the description.

@marianag8043

2 жыл бұрын

I paid for the Patrons log in thing, but cant find files.

@marianag8043

2 жыл бұрын

@@MikesOffice I know that, however that link takes me to different files!

@MikesOffice

2 жыл бұрын

@@marianag8043 it’s there on the page. Just have to scroll down. I can pin it to the top of that’s easier

If anyone knows excel good please message me I’d like to pay to get some help!

Could you put subtitles in Spanish? Please...

@MikesOffice

3 жыл бұрын

I was thinking of doing that for some of the top videos! I'll get on that.

@monserratrodriguez2755

3 жыл бұрын

@@MikesOffice It would be incredible, thank you!