I had an if function on my exam, and it said to leave the if false box blank, how would i do that
@MikesOffice3 күн бұрын
@@ryant256 false statement would be: “”
@laurenhyde41673 күн бұрын
how straight forward, exactly what i was looking for!
@KateMcLeod-i5g3 күн бұрын
I have failed twice in the past, and am required to pass for my Junior year classes! I been watching your excel videos for two months, and have memorized your tips and tricks! I took it last week and scored a 965, one of the highest scores of the Summer! Thank you so much for your help, and easy access to prepping for the exam. You are such an encouragement to students!
@ahlimanabdullayev84973 күн бұрын
great, thanks
@JiaqiAn-di7vb5 күн бұрын
Thanks Mike, this video is definitely help me understanding excel.
@tannermcnabb483610 күн бұрын
Problem for me is that the dimensions of the table don't translate from Google Sheet to Outlook. It still messes up and doesn't stay the same size like yours does. So frustrating
@monivid310 күн бұрын
Hey Mike, this is an excellent study tool and I appreciate your help! Just a question on the manage contacts section near 8:53 point on the video. Adding a contact to a group is not working out for me. Yikes! I'm stuck. Could the process have changed for newer versions of outlook?
@grant4d111 күн бұрын
=FORMULATEXT() is very useful, especially for professors to prevent "hey can you click on the formula" questions or for easy access. It simply just shows the formula in a cell.
@grant4d111 күн бұрын
Im taking my Expert Excel exam tomorrow! I'll respond my results:
@grant4d110 күн бұрын
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.
@najayfoster826111 күн бұрын
Good video watch it 3x easy pass
@JusnaBegum-t7l11 күн бұрын
M
@andreeaceoca651612 күн бұрын
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!
@user-fq2nx6yr3h13 күн бұрын
Thanks Mike. Your videos helped me a lot to score 940 in the Excel Expert test yesterday.
@mayangmokom4 күн бұрын
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!
@josepablovasquezsalinas277218 күн бұрын
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?
@anthonylois405222 күн бұрын
I just passed my exams. Thanks for this video 🎉
@mariaangienelabaldoza852925 күн бұрын
Bless your heart, Mike! Thank you for this tutorial.
@user-wn8xj4xy8r26 күн бұрын
this video help me alot
@Val-pw4sd27 күн бұрын
thank you for this!
@prity868527 күн бұрын
Very helpful 🎉😊
@ClaudiaAndriamanantoa27 күн бұрын
I am having my Certiport Exam, next Monday and freaking out right now. I'm watching lots of your videos and they help. I just need to remember them when doing the exam. Thanks for all you do!
@user-hk6cc8kt8t29 күн бұрын
thank you very Mutch, very helpful.
@chiderachukelu880129 күн бұрын
nice
@okiedokie577029 күн бұрын
Thank youu so much!! I got a 1000!! Really appreciate it🤩
@SRR0247Ай бұрын
Hi Mike! New to your enlightening channel and was wondering if there's a way to get the practice workbooks and/or worksheets you use in order to practice alongside w/you (your video tutorials)?? As a 'do-er', i learn best by doing while watching so it would be tremendously helpful to be able to use the practice workbooks you use on the videos.
@leidytatiana3681Ай бұрын
Yesterday I got my certificate with 978 points, thank you very much! 🎉😁
@M0T0CR055Ай бұрын
Took the exam today 01.07.2024. and passed it (940/1000). One minor mistake because a question was not that clear. (To me) Want to say that your videos still up to date regarding the content and your tips! Anyone who’s looking forward to passing the exam, should have a look at your videos 😉
@ananttiwari9615Ай бұрын
Passed with 1000 on my first attempt thank you so much Mike. You are very good trainer. I have watched your all video so many time .
@prasantchettri133Ай бұрын
TY...With all your videos I have passed all exam except for PowerPoint. There are lots of question we have to rely on tool tops or descriptions to make right descriptions before applying. I had this issue using MAC, as pointing to effect, color, slide name in master would not show description. Did anyone get similar issue?
@prasantchettri133Ай бұрын
In exam I have issues getting the description after pointing with mouse. Getting the description of right slide name
@saieshagovender9219Ай бұрын
Watched this video, excel,and outlook, and Mike's videos helped more than a gmetrix subscription. Tasks were almost the same as the test. Got 900+ on all 3. Thank you Mike!
@jwright4862Ай бұрын
Can you, or anyone else, explain why the cell A1 is unable to be a part of the chart? Thanks!
@albertfavela1627Ай бұрын
Thanks you Mike and Jesus Christ. I was able to pass this test after watching your videos and joining the Patreon page. Thanks, Appreciate you.
@albertfavela1627Ай бұрын
Thank you, Mike and Jesus Christ, after watching your video and joining Patreon page, I was able to successfully pass the Word 2019 test. I had been using it for years, but found I really did use all of the software until your videos. Thanks!!
@CnithTheOnliestOneАй бұрын
Doesn't work! I'm so frustrated! insert page break only gave me an extra page, didn't change the numbering at all.
@hungphamxuan7816Ай бұрын
how can i download that file and parallely practice with you ?
@imashafernando2507Ай бұрын
how to become a MOS instructor? What are exams need to do?
@imashafernando2507Ай бұрын
how to become a MOS instructor? What are exams need to do?
@nguyenminhtriet1137Ай бұрын
Thanks!
@fatibenkhaled7343Ай бұрын
Thank you I passed today 😊.
@stopplzsАй бұрын
just got a 925 my second try after getting 517 my first time. exam questions were almost identical to what you went over in both videos
@andreasandoval5039Ай бұрын
Hi Mike, thank you so very much for your exam tutorials, I have been able to obtain several certifications due to you! Im scheduled to take the word expert (365) today and am hoping the questions are similar to what you have demonstrated here! If not, please add a tutorial on the word expert 365 side as I’m sure it would help many folks, not just me! Thanks again!! 🙏🏻👍🏼🙌🏼
@cinspain08Ай бұрын
can you do this all from word by any chance
@mariogaldamez6319Ай бұрын
Today I passed my exam on the first try with 850/1000 points. After some other tutorials I watched, finally I found your video which helped me feel more confident. It was really instructive. By far the most useful video I watched to prepare for this test. Thank you so much! *To test takers, manage your time wisely and take advantage of the 'mark for review option' on the exam. I wasted some time during the exam and that affected my score in the end.
@J-tp5pwАй бұрын
Did not work, did not help
@salimatakane9223Ай бұрын
Thank you so much I have 850/1000 because of your video.
@lavelclaytorsProjectswPurposeАй бұрын
Do you have any trainings for office 365?
@MutahiCarolАй бұрын
Thanks alot Mike, you're the best! I was finally able to add and align my logo on outlook after so many unsuccessful attempts.
@robertsteinman2145Ай бұрын
Hi Mike. Very cool. Is there a way to make a chart that would fill a person up (like you may see on a charity event where they are filling in a whiteboard when a certain amount is received)?