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
@MikesOffice
Жыл бұрын
Thanks for creating these chapters!
@user-ms6mn4nn6w
Жыл бұрын
I studied this and two other videos for literally less then a day and passed my exam. you deserve the world.
@michaelzimmerman5186
Жыл бұрын
What other videos did you watch
@edwardrobles9860
11 ай бұрын
For real which other videos did you watch?
@kadijahdiallo565
9 ай бұрын
Which videos please ?
@ryleynail
Жыл бұрын
First try I made a 608. I found mikes videos and just passed today with 928!
@anithabs9501
5 ай бұрын
Please reply the exam pattern, ie, no of question and duration
@Itsmuhdd
6 ай бұрын
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!
@Bucketlistexplorer
5 ай бұрын
Hello Mike, I passed excel exam from your videos. Thank you very much for your time and support very useful knowledge to everyone.
@MM-nn7vw
Жыл бұрын
I took my exam today and passed with a score of 962! Your videos were extremely helpful.
@gawrinaidu86
Жыл бұрын
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😊🙏🏼
@StopWhining491
11 ай бұрын
Congratulations!
@TonzChannel27
Жыл бұрын
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!
@edbee816
9 ай бұрын
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!
@anithabs9501
5 ай бұрын
How many questions and the duration of exam? Please
@RidiculousCombo
2 жыл бұрын
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!
@BartM93x
Жыл бұрын
How long you had to learn Excel before taking the exam?
@jeremyrondonuwu8836
Жыл бұрын
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!
@BartM93x
Жыл бұрын
How long did you need to learn Excel before taking a exam?
@andreeaceoca6516
Ай бұрын
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!
@ElzMCgamer
2 жыл бұрын
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!!
@Komiroya
9 ай бұрын
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.
@user-pk9ry6jj7z
Жыл бұрын
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
@tashafoster3249
4 ай бұрын
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 :)
@EvaRadio
2 жыл бұрын
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
@BartM93x
Жыл бұрын
Hello. How long had you to learn and practise Excel before taking a exam?
@KidsLearnHTML
Жыл бұрын
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!
@Jacob-mf5yq
Жыл бұрын
How many questions were there?
@615w6
6 ай бұрын
Watched this and a couple other videos a few times the day of my exam and got an 850 i appreciate the help man
@AlexisMontgomery-mn3qs
4 ай бұрын
I just took mine using this video and got an 887/1000 he is amazing!!
@bluvs_tae
4 ай бұрын
Was it hard ?
@shameenamir3213
2 жыл бұрын
I just came here to thank you because yesterday i got my MOS certificate. Thank youuu mike ✨
@renatoj.desideria.3309
Жыл бұрын
Thank you Mike, I passed my 3 Microsoft office test with your videos. ✔️
@kareyrademacher1593
9 ай бұрын
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!
@cartereckblad
Жыл бұрын
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
@faroukalhoni6070
Жыл бұрын
You are a LEGEND I passed my MOS Exam today from the first attempt.
@MikesOffice
Жыл бұрын
That’s great to hear! Well done!! The Excel test can be tough!
@jessicabarajas4463
Жыл бұрын
Watching this video made everything a million times easier THANK YOU
@user-nr6kr5yo3f
9 ай бұрын
you literally touched on every part of my exam that i missed or was confused on whatttttt you are Golden!
@flobama7200
11 күн бұрын
appreciate the Metal Gear Solid sound effect in there :)
@FATIMA-mx4sl
2 жыл бұрын
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.
@BartM93x
Жыл бұрын
Hello. How long had you to learn and practise Excel before taking a exam?
@ayecherryaung2992
2 жыл бұрын
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!
@BartM93x
Жыл бұрын
Hello. How long had you to learn and practise Excel before taking a exam?
@Xyxle410
5 ай бұрын
You helped me pass my Powerpoint and Word Exams 4 my MOS
@Sanosan5249
2 жыл бұрын
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.
@torigarcia9302
2 жыл бұрын
what helped you prepare for the exam? and did you pay for the exam pn the Microsoft website?
@nivekg992
Жыл бұрын
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.
@nayanghimire5663
2 жыл бұрын
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
2 жыл бұрын
Already made that video right here: kzitem.info/news/bejne/zGensqCYi4GUioI
@nayanghimire5663
2 жыл бұрын
@@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.
@minty380
Жыл бұрын
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
@Zuko214
2 жыл бұрын
Hey Mike, thanks to your course I got a perfect score on this exam! Thanks Mike!
@MikesOffice
2 жыл бұрын
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!
@Zuko214
2 жыл бұрын
@@MikesOffice I just went over both practice exams in your course and they helped me on every question on the exam! Great course Mike!
@BartM93x
Жыл бұрын
Hello. How long had you to learn and practise Excel before taking a exam?
@wahaabraja6049
9 ай бұрын
JUST PASSED WITH A 900 THANK YOU
@navyntune8158
Жыл бұрын
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.
@ChampagneDream
9 ай бұрын
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 :)
@shaliyahschannel2143
2 жыл бұрын
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
@jidatakieddin6679
Жыл бұрын
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
@BartM93x
Жыл бұрын
Hello. How long had you to learn and practise Excel before taking a exam?
@kayleenicholaspotts519
2 жыл бұрын
Hey Ma, look! I made it! Great video Mike. Such valuable information and you are 100% the reason I aced my Excel Exam!
@logananderson8507
Жыл бұрын
Bro this vid was so helpful! Keep up the great content!
@hrkmmmfr0008
Жыл бұрын
Hi Mike Can you please make a video for MOS Access exam please and thank you for these great videos.
@ellieshoulders3577
5 ай бұрын
Extremely helpful, thank you!
@elizabethMOSCertification
8 ай бұрын
Impressive! Thanks for the video.
@MansagarSinghShorts
Жыл бұрын
Thank you so much sir this video is very helpful
@robertabrego-mf1be
Жыл бұрын
This is so helpful! Thanks
@davidmazigh1791
Жыл бұрын
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 🙏
@Azfoltzo
5 ай бұрын
Doing the exam in 20min, wish me luck lads
@Sderot.bringthemhome
9 ай бұрын
Thank you! I am wondering if I need to save up in excel exam ? If I don’t save is it conider as mistakes?
@ahmedmofreh7236
2 жыл бұрын
Thanks man
@shaylamordue7796
2 жыл бұрын
I MADE THE CUT!!! hahahah I want to take the Expert exam now
@MikesOffice
2 жыл бұрын
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.
@terrychan6889
Жыл бұрын
when will you have an update on Excel MOS-201 Exam Preparation course?
@prisaataei3086
Жыл бұрын
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
@zuradean849
Жыл бұрын
Thanks for sharing 😊
@imashafernando2507
8 ай бұрын
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.
@Faiz_Muzakky
2 жыл бұрын
Thank you
@Ammu_Yazhini
2 жыл бұрын
It was very helpful
@vertigoz
8 ай бұрын
Is there any truth about shortcuts not being captured by the system evaluating you? I keep hearing it at formation
@tutukumari7098
Жыл бұрын
Hi Mike , I am unable to register for exam , Could you please guide?
@tutsecret499
Жыл бұрын
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.
@ennykraft
Жыл бұрын
Which exam is that? Is there a more advanced one?
@kendallquillin1334
Жыл бұрын
any way you can do all the questions from the exam. Lots of stuff on the exam you did not go over
@MikesOffice
Жыл бұрын
I have a whole course on it. Link is below this video.
@rosemarry3693
Жыл бұрын
I'm taking my test today. Im so nervous😢. Will let you know what score I got. Need prayers
@MikesOffice
Жыл бұрын
Good luck!!
@rosemarry3693
Жыл бұрын
@@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
@KidsLearnHTML
Жыл бұрын
@@rosemarry3693 Congratulations!
@rosemarry3693
Жыл бұрын
@@KidsLearnHTML thanks
@mollymcbride2474
Жыл бұрын
how do u get to the first part
@DrPixel07
Жыл бұрын
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
@MikesOffice
Жыл бұрын
Definitely not this one 🥸
@eugenecaidoy1220
3 ай бұрын
I fail in WORD, POWERPOINT I hope in EXCEL I passed
@julieballs3994
11 ай бұрын
gonna take it today,i'm not confident at all😭
@MikesOffice
11 ай бұрын
It’s tough, but you got this!
@gari9163
2 жыл бұрын
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
2 жыл бұрын
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.
@nabilakartikasari8110
2 жыл бұрын
@@MikesOffice Hope u upload the Expert soon, cause i'll have certification
@MikesOffice
2 жыл бұрын
@@nabilakartikasari8110 working on that one right now. I do have one video on that up here while you wait for that one!
@lavelclaytorsProjectswPurpose
5 ай бұрын
Does this apply to Excel 365?
@MikesOffice
5 ай бұрын
Same thing.
@yoshibeast12
Жыл бұрын
I just failed my 2nd take. I feel pretty bummed out
@MikesOffice
Жыл бұрын
You shouldn’t. Timed exams can throw people off.
@MikesOffice
Жыл бұрын
I was thinking of doing small, live group classes to help people pass these. Would you be down for that?
@yoshibeast12
Жыл бұрын
@@MikesOffice Is that on your Patreon? I've been practicing on my own but feedback would be appreciated.
Пікірлер: 111