0:45 Import file 2:55 Freeze rows and columns 3:50 Create/Edit Hyperlink 4:45 Use countblank 6:00 IF Function 9:05 Insert Sparklines 10:30 Swap Data Excel Charts 11:25 Find Name Range 12:05 Insert Header and Footer 13:15 Set Print Area
Hey Mike! Thank you so much for such a helpful video! I scored 975 out of 1000 in the exam that I took yesterday just by practicing through this video over and over for the past two weeks 😂🎉 Hope anyone else gets a high score in this exam too!
hey mike. I asked you for a video before my MOS exams but please don't ignore this one. The video topic that i wanna see is: 👉 what are the most used commands that we must add in the quick access toolbar in order to complete the mos exams faster than usual?
@@MikesOffice hello mike. Since u responded, can u please create 2 more videos: 1. About whether the viewers must choose 2016 or 2019? (2016 has less competition so it will comparitively be easier to get into the national and international rounds and 2019 is more likely to last for upcoming days of office world). 2. I had a question yesterday in my word exam but I can't remember the exact word. Well, the question was (use the word feature to replace all instances of the word "****" into "****" ). Is this question referring to the autocorrect options or the replace in the home tab?? 3. Please create a single or a series of video for the options tab itself so that we can understand every unknown segment of the options tab in office suite applications.
Speaking of failing. Don't you hate when you know the subject but you messed up during the interview and you respond differently. And you know the work step by step, but on the interview for some reason maybe did not think, did not pay attention well properly and rushed the answer. And when you leave the interview the response comes clear. And I get so angry at myself.
Hi Mike. I sat for the MOS Excel Associate 2019 exam today and scored 981/1000. This is my first attempt. Thank you very much for your great teaching and knowledge sharing through youtube and udemy. Both helped me tremendously. Im extremely grateful. Looking forward to more videos of yours😊🙏🏼
Hey, you helped me out soo much!! Thank You!! I’m in an IT class, and we all watch your videos to help us with things like this, your soo helpful!! Thanks!!
I'd like to thank you for these helpful tips. Took my MOS Excel 2019 exam today and got 871/1000 points and therefore the official MOS Excel certificate!
I just finished the exam now and i got 1000/1000 ! Thanks to your tutorials it was very helpful for studying them, i was even reviewing them 30 mins prior exam. Thank you man!
Just took the MS 200 Exam last Thursday (Feb 2) in advance of my high school students taking it so as to have a better understanding of what the tasks entail and any hidden curveballs they might encounter. I got a 975! Thanks for your help in having this channel. I subbed a couple months ago and the content, especially this video, helped out a lot!
Almost the end of 2023 and I passed the Microsoft Excel Associate (Office 2019) exam 900/1000 following this video and your part one. Thank you! Now on to the Expert!
thanks Mike, I passed my word and excel exams on Friday first attempts. I didn't get a perfect score due to "subtle stylings" but I only studied for 2 days, now I'm going for PowerPoint. I am an IT professional so I can troubleshoot user issues but now feels good to be certified
Hi Mike. I just do my MOS Excel Associate 2019 exam today and scored 288/1000. This is my first attempt. Thank you very much for your great teaching and knowledge sharing through youtube and udemy. I will never give up from this failure. I will continue learn n much learn And not giving up, Your video is great to made me know excel's!
Thanks for designing a great course! It was worth every penny. I passed the Excel certification exam with flying colors. The course was easy, simple and straight to almost exactly what I was tested on.
Hey Mike, I just want to say Thank you as I passed my MOS excel expert today with the help of your videos on excel which are concise and easy to understand. Keep up with this great work, Mike!
I failed my excel exam a month ago and will be taking a retake soon. I believe my mistake was I did a Take at home exam on a 15 inch monitor so there was a smaller screen in the screen as well as the chat box and proctor camera image and empty space on the bottom. Felt like I was doing a exam in a 4x5 window and had to adjust the screen so many times so I can answer and read the questions. I end up running out of time. Update: I passed, recommend using a bigger monitor than 15" easier to navigate.
Thank you Mike for your classes. I just scored 925 on my first try. I'll be going for my expert test in a week or so after I finish your expert course.
I'm Korean and I live in an English-speaking country, so taking the Excel test was very difficult for me from language to understanding. For me, who has a short attention span, your video was concise but accurate to the point, so I couldn't take my eyes off it for a second. The day before the Excel test, I was so confused that your video that I looked for saved me and I passed with a good score. Thank you so much
Hi Mike thanks and I really appreciate your effort to upload your video for MOS preparation exam and I am proud to say that because of all your video I pass my MOS PowerPoint recently. Now next is my MOS Outlook and I already watch your video about MOS outlook but one thing I noticed is there is no part 1 on that I seen only part 2 Is there any chance that I get also the part 1 or if you have other video for MOS outlook it would be great if you can share too. Again thank you so much and God bless you and your family. Cheers
Hi Mike............I Completed MOS Word 2019.Can I get the certificate from USA Through post.I need to verify my school comes from USA. My shows "Order Official Certificate"Is it works.I'm from Sri Lanka.I waiting Positive answer.
Well done, Josh!! I’m glad the course could help you get a perfect score! What was it about the course that helped you?? Great work on a perfect score!
I want to thank you SO much for these videos. This exam has had me worried for the past week as I had no time to study, I watched a couple of your videos this morning before my exam and I PASSED. Everything you covered was on the exam, if I hadn't watched your videos before I would've failed.. THANK YOU!
Had my excel exam today. I wrote it and scored a 925/1000. I wrote it on a MacBook and unfortunately certiport blocks out greater than sign on the keyboard for Mac, so I got the if function question wrong. The other question I got wrong was alt text because certiport blocks out macs from right clicking on graphs :(. Regardless still an amazing mark and just want to say thanks for these amazing videos :)
I just took my exam and scored a 906/1000 simply from watching this video and Part 1 a couple times! Thank you so much this was soooo helpful!!! You officially have a new Subscriber :)
Juniper Hills High School in Nampa, Idaho watches you everyday. We are a juvenile correctional facility, so every day we try to RISE UP! Please shout us out!
I still remember the day I got to MOS country level, we have Word Expert, PowerPoint Expert and... Normal... Expert. This- this monstrosity is so hard to master that it didn't even need to be expert level to be on par with the others. It was hotrifying.
Hi, I have basic knowledge of Microsoft Office in general but want to take the exams and get my certificate, where do you recommend practicing to learn them more to take the exams? Thank you
Thanks this video was very helpful. There is 1 thing that I missed, was something like: "Remove all personal information from the workbook" or something like that. Like I said I missed it and had no idea what it was talking about or how to do it.
Thanks so much for this, this guide is a god, more than 8 of the questions on this were on my exam so thanks a lot and i passed with a 875 on my first try thanks so much
So I'm in Highschool and I'm in a Microsoft office class that teaches word and excel, and the teacher says we are having our final exam this week and idk what video to watch so I can pass it and get certified can anybody reccomend any tips or a video i should watch
Is MO-200 Microsoft Excel 2019 Associate Certification intermediate level while MO-201 Microsoft Excel 2019 Expert Certification is advanced? I was looking thru Udemy, and can't decide which one should i learn. Thanks!
@@MikesOffice thank you so much. Just because of your videos, I made 700/1000. And passed my exam. This Exam was required for my Accounting Degree from Louisiana State University. I'm so happy. I can't believe it when I check my grade. But 50 minute time was too short. I missed some questions just because of time. But I'm so happy
Thank you so much professor Mike I passed my exams after watching your videos thank you for the great job that are you doing, but last week I failed the Excel Expert please tell me how to reach you to help me for the next exam, I've already the questions 🙏
0:45 Import file
2:55 Freeze rows and columns
3:50 Create/Edit Hyperlink
4:45 Use countblank
6:00 IF Function
9:05 Insert Sparklines
10:30 Swap Data Excel Charts
11:25 Find Name Range
12:05 Insert Header and Footer
13:15 Set Print Area
Thanks for creating these chapters!
Hey Mike! Thank you so much for such a helpful video! I scored 975 out of 1000 in the exam that I took yesterday just by practicing through this video over and over for the past two weeks 😂🎉 Hope anyone else gets a high score in this exam too!
How long did you need to learn Excel before taking a exam?
hey mike. I asked you for a video before my MOS exams but please don't ignore this one.
The video topic that i wanna see is: 👉 what are the most used commands that we must add in the quick access toolbar in order to complete the mos exams faster than usual?
Already made that video right here: ua-cam.com/video/k1qLlbROcWM/v-deo.html
@@MikesOffice hello mike. Since u responded, can u please create 2 more videos:
1. About whether the viewers must choose 2016 or 2019? (2016 has less competition so it will comparitively be easier to get into the national and international rounds and 2019 is more likely to last for upcoming days of office world).
2. I had a question yesterday in my word exam but I can't remember the exact word.
Well, the question was (use the word feature to replace all instances of the word "****" into "****" ).
Is this question referring to the autocorrect options or the replace in the home tab??
3. Please create a single or a series of video for the options tab itself so that we can understand every unknown segment of the options tab in office suite applications.
Speaking of failing. Don't you hate when you know the subject but you messed up during the interview and you respond differently. And you know the work step by step, but on the interview for some reason maybe did not think, did not pay attention well properly and rushed the answer. And when you leave the interview the response comes clear. And I get so angry at myself.
I studied this and two other videos for literally less then a day and passed my exam. you deserve the world.
What other videos did you watch
For real which other videos did you watch?
Which videos please ?
Hi Mike. I sat for the MOS Excel Associate 2019 exam today and scored 981/1000. This is my first attempt. Thank you very much for your great teaching and knowledge sharing through youtube and udemy. Both helped me tremendously. Im extremely grateful. Looking forward to more videos of yours😊🙏🏼
Congratulations!
First try I made a 608. I found mikes videos and just passed today with 928!
Please reply the exam pattern, ie, no of question and duration
Hey, you helped me out soo much!! Thank You!! I’m in an IT class, and we all watch your videos to help us with things like this, your soo helpful!! Thanks!!
I'd like to thank you for these helpful tips. Took my MOS Excel 2019 exam today and got 871/1000 points and therefore the official MOS Excel certificate!
How long you had to learn Excel before taking the exam?
I just finished the exam now and i got 1000/1000 ! Thanks to your tutorials it was very helpful for studying them, i was even reviewing them 30 mins prior exam. Thank you man!
Hello Mike, I passed excel exam from your videos.
Thank you very much for your time and support very useful knowledge to everyone.
Just took the MS 200 Exam last Thursday (Feb 2) in advance of my high school students taking it so as to have a better understanding of what the tasks entail and any hidden curveballs they might encounter. I got a 975! Thanks for your help in having this channel. I subbed a couple months ago and the content, especially this video, helped out a lot!
How many questions were there?
Almost the end of 2023 and I passed the Microsoft Excel Associate (Office 2019) exam 900/1000 following this video and your part one. Thank you! Now on to the Expert!
How many questions and the duration of exam? Please
thanks Mike, I passed my word and excel exams on Friday first attempts. I didn't get a perfect score due to "subtle stylings" but I only studied for 2 days, now I'm going for PowerPoint. I am an IT professional so I can troubleshoot user issues but now feels good to be certified
Hello. How long had you to learn and practise Excel before taking a exam?
Hi Mike. I just do my MOS Excel Associate 2019 exam today and scored 288/1000. This is my first attempt. Thank you very much for your great teaching and knowledge sharing through youtube and udemy. I will never give up from this failure. I will continue learn n much learn And not giving up, Your video is great to made me know excel's!
I took my exam today and passed with a score of 962! Your videos were extremely helpful.
Doing the exam in 20min, wish me luck lads
Thanks for designing a great course! It was worth every penny. I passed the Excel certification exam with flying colors. The course was easy, simple and straight to almost exactly what I was tested on.
Hello. How long had you to learn and practise Excel before taking a exam?
Hey Mike, I just want to say Thank you as I passed my MOS excel expert today with the help of your videos on excel which are concise and easy to understand. Keep up with this great work, Mike!
Hello. How long had you to learn and practise Excel before taking a exam?
I fail in WORD, POWERPOINT I hope in EXCEL I passed
appreciate the Metal Gear Solid sound effect in there :)
I failed my excel exam a month ago and will be taking a retake soon. I believe my mistake was I did a Take at home exam on a 15 inch monitor so there was a smaller screen in the screen as well as the chat box and proctor camera image and empty space on the bottom. Felt like I was doing a exam in a 4x5 window and had to adjust the screen so many times so I can answer and read the questions. I end up running out of time.
Update:
I passed, recommend using a bigger monitor than 15" easier to navigate.
what helped you prepare for the exam? and did you pay for the exam pn the Microsoft website?
I just took mine using this video and got an 887/1000 he is amazing!!
Was it hard ?
Thank you Mike for your classes. I just scored 925 on my first try. I'll be going for my expert test in a week or so after I finish your expert course.
I just came here to thank you because yesterday i got my MOS certificate. Thank youuu mike ✨
Your videos have directly helped me pass the second time I took the exam!!! Should have watched you before I took it the first time haha
Bro this vid was so helpful! Keep up the great content!
I'm Korean and I live in an English-speaking country, so taking the Excel test was very difficult for me from language to understanding. For me, who has a short attention span, your video was concise but accurate to the point, so I couldn't take my eyes off it for a second. The day before the Excel test, I was so confused that your video that I looked for saved me and I passed with a good score. Thank you so much
Hi Mike thanks and I really appreciate your effort to upload your video for MOS preparation exam and I am proud to say that because of all your video I pass my MOS PowerPoint recently. Now next is my MOS Outlook and I already watch your video about MOS outlook but one thing I noticed is there is no part 1 on that I seen only part 2 Is there any chance that I get also the part 1 or if you have other video for MOS outlook it would be great if you can share too. Again thank you so much and God bless you and your family. Cheers
Hi Mike............I Completed MOS Word 2019.Can I get the certificate from USA Through post.I need to verify my school comes from USA. My shows "Order Official Certificate"Is it works.I'm from Sri Lanka.I waiting Positive answer.
Hey Mike, thanks to your course I got a perfect score on this exam! Thanks Mike!
Well done, Josh!! I’m glad the course could help you get a perfect score! What was it about the course that helped you?? Great work on a perfect score!
@@MikesOffice I just went over both practice exams in your course and they helped me on every question on the exam! Great course Mike!
Hello. How long had you to learn and practise Excel before taking a exam?
I want to thank you SO much for these videos. This exam has had me worried for the past week as I had no time to study, I watched a couple of your videos this morning before my exam and I PASSED. Everything you covered was on the exam, if I hadn't watched your videos before I would've failed.. THANK YOU!
Had my excel exam today. I wrote it and scored a 925/1000. I wrote it on a MacBook and unfortunately certiport blocks out greater than sign on the keyboard for Mac, so I got the if function question wrong. The other question I got wrong was alt text because certiport blocks out macs from right clicking on graphs :(. Regardless still an amazing mark and just want to say thanks for these amazing videos :)
I just took my exam and scored a 906/1000 simply from watching this video and Part 1 a couple times! Thank you so much this was soooo helpful!!! You officially have a new Subscriber :)
Juniper Hills High School in Nampa, Idaho watches you everyday. We are a juvenile correctional facility, so every day we try to RISE UP! Please shout us out!
I MADE THE CUT!!! hahahah I want to take the Expert exam now
Of course! Gotta give a shoutout to the 1000 point, Excel star. You better take the Excel Expert! I’ll have training for that one up soon.
I still remember the day I got to MOS country level, we have Word Expert, PowerPoint Expert and... Normal... Expert. This- this monstrosity is so hard to master that it didn't even need to be expert level to be on par with the others. It was hotrifying.
Hi, I have basic knowledge of Microsoft Office in general but want to take the exams and get my certificate, where do you recommend practicing to learn them more to take the exams?
Thank you
You helped me pass my Powerpoint and Word Exams 4 my MOS
when will you have an update on Excel MOS-201 Exam Preparation course?
Thank you! I am wondering if I need to save up in excel exam ? If I don’t save is it conider as mistakes?
Is there any truth about shortcuts not being captured by the system evaluating you? I keep hearing it at formation
Watching this video made everything a million times easier THANK YOU
Thank you Mike, I passed my 3 Microsoft office test with your videos. ✔️
Thanks this video was very helpful. There is 1 thing that I missed, was something like: "Remove all personal information from the workbook" or something like that. Like I said I missed it and had no idea what it was talking about or how to do it.
Hi Mike
Can you please make a video for MOS Access exam please and thank you for these great videos.
Impressive! Thanks for the video.
Hi Mike , I am unable to register for exam , Could you please guide?
Thanks so much for this, this guide is a god, more than 8 of the questions on this were on my exam so thanks a lot and i passed with a 875 on my first try thanks so much
you literally touched on every part of my exam that i missed or was confused on whatttttt you are Golden!
Watched this and a couple other videos a few times the day of my exam and got an 850 i appreciate the help man
Thank you so much sir this video is very helpful
Does this apply to Excel 365?
Same thing.
Extremely helpful, thank you!
Thanks man
JUST PASSED WITH A 900 THANK YOU
Which exam is that? Is there a more advanced one?
So I'm in Highschool and I'm in a Microsoft office class that teaches word and excel, and the teacher says we are having our final exam this week and idk what video to watch so I can pass it and get certified can anybody reccomend any tips or a video i should watch
Definitely not this one 🥸
Hey Ma, look! I made it! Great video Mike. Such valuable information and you are 100% the reason I aced my Excel Exam!
Thanks a lot! ur videos are very helpful & I passed my exam with 800/1000.
Your videos are very simple and straight to the point
Hello. How long had you to learn and practise Excel before taking a exam?
You are a LEGEND I passed my MOS Exam today from the first attempt.
That’s great to hear! Well done!! The Excel test can be tough!
how do u get to the first part
any way you can do all the questions from the exam. Lots of stuff on the exam you did not go over
I have a whole course on it. Link is below this video.
This is so helpful! Thanks
It was very helpful
Is MO-200 Microsoft Excel 2019 Associate Certification intermediate level while MO-201 Microsoft Excel 2019 Expert Certification is advanced? I was looking thru Udemy, and can't decide which one should i learn. Thanks!
That's exactly it! MO-200 is beginner and intermediate. MO-201 or Excel Expert is advanced/expert stuff. I'll have the Expert one up soon.
@@MikesOffice Hope u upload the Expert soon, cause i'll have certification
@@nabilakartikasari8110 working on that one right now. I do have one video on that up here while you wait for that one!
Thanks for sharing 😊
I'm taking my test today. Im so nervous😢. Will let you know what score I got. Need prayers
Good luck!!
@@MikesOffice thank you so much. Just because of your videos, I made 700/1000. And passed my exam. This Exam was required for my Accounting Degree from Louisiana State University. I'm so happy. I can't believe it when I check my grade.
But 50 minute time was too short. I missed some questions just because of time. But I'm so happy
@@rosemarry3693 Congratulations!
@@KidsLearnHTML thanks
Thank you
I just failed my 2nd take. I feel pretty bummed out
You shouldn’t. Timed exams can throw people off.
I was thinking of doing small, live group classes to help people pass these. Would you be down for that?
@@MikesOffice Is that on your Patreon? I've been practicing on my own but feedback would be appreciated.
I am a failure
Why do you say that?
Thank you so much professor Mike I passed my exams after watching your videos thank you for the great job that are you doing, but last week I failed the Excel Expert please tell me how to reach you to help me for the next exam, I've already the questions 🙏
gonna take it today,i'm not confident at all😭
It’s tough, but you got this!