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
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!
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!
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!
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😊🙏🏼
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!
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!
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!
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.
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!
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 :)
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!!
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
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
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!
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.
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.
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.
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.
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!
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
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!
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
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 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
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.
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 🙏
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
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
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.
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!
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 ?
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!
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!
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
Hello Mike, I passed excel exam from your videos.
Thank you very much for your time and support very useful knowledge to everyone.
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!
Thanks, Mike. just took the exam. Learned more from you in 30 min then my profesor these past 2 months!
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?
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!
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?
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.
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?
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 :)
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!!
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
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?
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
Watched this and a couple other videos a few times the day of my exam and got an 850 i appreciate the help man
I took my exam today and passed with a score of 962! Your videos were extremely helpful.
you literally touched on every part of my exam that i missed or was confused on whatttttt you are Golden!
I just came here to thank you because yesterday i got my MOS certificate. Thank youuu mike ✨
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?
You helped me pass my Powerpoint and Word Exams 4 my MOS
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: th-cam.com/video/k1qLlbROcWM/w-d-xo.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.
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?
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?
Thank you Mike, I passed my 3 Microsoft office test with your videos. ✔️
Watching this video made everything a million times easier THANK YOU
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
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!
I just took mine using this video and got an 887/1000 he is amazing!!
Was it hard ?
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.
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!
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
JUST PASSED WITH A 900 THANK YOU
appreciate the Metal Gear Solid sound effect in there :)
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?
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
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 :)
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?
Hey Ma, look! I made it! Great video Mike. Such valuable information and you are 100% the reason I aced my Excel Exam!
Extremely helpful, thank you!
Hi Mike
Can you please make a video for MOS Access exam please and thank you for these great videos.
Bro this vid was so helpful! Keep up the great content!
Thank you! I am wondering if I need to save up in excel exam ? If I don’t save is it conider as mistakes?
when will you have an update on Excel MOS-201 Exam Preparation course?
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
Is there any truth about shortcuts not being captured by the system evaluating you? I keep hearing it at formation
This is so helpful! Thanks
Hi Mike , I am unable to register for exam , Could you please guide?
Thank you so much sir this video is very helpful
Does this apply to Excel 365?
Same thing.
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.
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 🙏
Which exam is that? Is there a more advanced one?
Thanks man
Thanks for sharing 😊
how do u get to the first part
Doing the exam in 20min, wish me luck lads
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.
I fail in WORD, POWERPOINT I hope in EXCEL I passed
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!
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.
Thank you
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
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 🥸
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 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?
microsoftprokey