I was asked to do like 20 different types of formulas & I only knew how to >multiply and divide values >average values >& sum values Thanks for the help, that test felt like a whole new coding language slapped on my face.
@Jerel Darden I have been working on this same type of video for the 2019 exam. I’m hoping to release that video sometime this month or next. Are you taking the exam soon? If you are, I can give you access to it early. Just send me an email.
@@Brendan_Sinclair I am military so I'm currently studying for an advancement exam on the 16th but after that my goal is to knock out Excel and Excel Expert before june. I was able to get my Word and Word Ezpert 2016 because of your videos and I am forever grateful!
I could never figure out the trick to spacing on concatenate! My text strings would always be bundled up which made it very time consuming and gave me anxiety. I feel more confident now for the exam, thanks so much! :)
Thank you for watching them. On the exam, you'll get a mix of functions. Some will be easy, and others are going to be a little more difficult. Don't forget, "You don't have to get all of the functions correct just most of them." :)
can you go in-depth about greater than for less than, on my certification exam I had a greater than question and it tripped me up hard. Please I hope you see this.
@ Kay Ganapathi This is a great question. I'm going to add this to my project list. I just need to my mind around how I would go about formatting something like this.
Hello @dabluerover the new exams are scheduled to release in Q3. No specific month has been mentioned yet, but I am guessing it will be after their annual Certified conference but before the new school year begins. Here is the Certiport link showing their timeline certiport.pearsonvue.com/Educator-resources/Exam-details/Exam-releases
Hi Brendon, Few weeks ago I enjoyed your 77-728 Excel 2016 expert exam simulations, they are great. For some reason, I cannot find them anymore on You Tube. Have you removed/deleted them ? If not, then where I can find them ? Please advise. Thank you and all the best !
@@Brendan_Sinclair, hi again. I am sorry for insisting too much, but can you please provide an answer ? I would love to find out whether 77-728 videos can be found somewhere else. Or, will you re-publish them on TH-cam ? Thank you.
Hello @Mike Orndorff. I created a few videos on Excel Expert. Here are three GMetrix Excel Expert playlists that I created Practice Exam 1 th-cam.com/play/PLEqweL5D54PAKMWUNrG82ru0KHqPc58iR.html, Practice Exam 2 th-cam.com/play/PLEqweL5D54PAI0wlFvhdJ8uhJ148qRp2G.html, and Practice Exam 3 th-cam.com/play/PLEqweL5D54PDE7Xq-rpxfQ3zfacHXmyML.html. I would also check out the Excel Expert 2016 Exam page here www.microsoft.com/en-us/learning/exam-77-728.aspx.
@Gabi Correa There isn't a magic number that you need to get right. My understanding is some questions carry more weight than other questions do. Ultimately, you need to earn a 70% (700/1000) or better. If you are worried about the functions, I tell my students that they don't have to get all of these questions correct to pass the exam, just most of them. The perform operations with formulas and functions domain only accounts for 10-15% of the exam.
Hello @upittman1. You can do a self-guided study. I would check out the exam domain page here www.microsoft.com/en-us/learning/exam-77-727.aspx. I would also recommend these books to you for practice MOS 2016 Study Guide for Microsoft Excel: amzn.to/2RH33jv, Microsoft Excel 2016 Step by Step: amzn.to/2YcA7Q5, Excel 2016 Bible:amzn.to/2PNQzTO. I also have a playlist on this exam which could be helpful to you as you prepare th-cam.com/play/PLEqweL5D54PBNNCaCWKmOQC9Z5f-7Wzdd.html.
@supriya singh here is a link to all of the domains for the exam Excel Exam Page (Certiport): certiport.pearsonvue.com/Certifications/Microsoft/MOS/Certify/Excel.aspx. Here is a playlist that I created covering many of the domain items MOS Excel 2016 Exam 77-727 th-cam.com/play/PLEqweL5D54PBNNCaCWKmOQC9Z5f-7Wzdd.html.
@JB 9595 the most important thing that you can do is practice. GMetrix is a great asset for those preparing for the exam gmetrix.com/Products/Filter?Certification=Microsoft+Office+Specialist+(MOS)&Version=Microsoft+Office+2016&Type=Tests. I also recommend this book MOS 2016 Study Guide for Microsoft Excel: amzn.to/2RH33jv. I talk about this book and two others in this video th-cam.com/video/9jGjv6S7BNc/w-d-xo.html. I would take a look at the MOS Excel exam page here www.microsoft.com/en-us/learning/exam-77-727.aspx. Finally, I would check out my playlist on the exam th-cam.com/play/PLEqweL5D54PBNNCaCWKmOQC9Z5f-7Wzdd.html.
@trang tran you can get a GMetrix access code from here gmetrix.com/Products/Filter?Certification=Microsoft+Office+Specialist+(MOS)&Version=Microsoft+Office+2016&Type=Tests.
I Am 2 certifications away from my MOS 2016 Master Certification because of you! Only Excel and Excel Expert left. THANK U!
19:30 scared the hell out of me!
Same here
@@flipkartsale.4709 same
I JUMPED OUT OF MY SEAT! 19:30
what WAS that?
Literally. I thought it was just me.
I was asked to do like 20 different types of formulas & I only knew how to
>multiply and divide values
>average values
>& sum values
Thanks for the help, that test felt like a whole new coding language slapped on my face.
thank you very much, i would make sure i subscribe to you as soon as i pass that exam
Thank you for making this video I took my Excel Certification today and passed this video really did help me
@Hatic Jr This is awesome to news! Congrats!
I passed the exam today, and your video was very helpful in doing so.
@jdvin Congrats! This is exciting news! I appreciate you taking the time to leave a comment to let me know.
Congratulations, did you remember the questions as I failed twice last week
Thank you Brendan that was a breath of fresh air. Your an excellent teacher and I enjoyed this video immensely. WTG!!!
Thanks for the kind words!
I passed thank you so much for your videos.
Great Tips, thank you.
Thank You so much helped me pass!
@Masterd that is awesome! Congrats!
@@Brendan_Sinclair Thumbs up for u
I have this test tmmr and this really help a lot, ill keep you updated on if I pass or not, but seriously what the heck was that 19:30 lmao
Good luck
Rip
Will you be continuing these videos for the 2019 versions? Please do! Your community needs you!
@Jerel Darden I have been working on this same type of video for the 2019 exam. I’m hoping to release that video sometime this month or next. Are you taking the exam soon? If you are, I can give you access to it early. Just send me an email.
@@Brendan_Sinclair I am military so I'm currently studying for an advancement exam on the 16th but after that my goal is to knock out Excel and Excel Expert before june. I was able to get my Word and Word Ezpert 2016 because of your videos and I am forever grateful!
I could never figure out the trick to spacing on concatenate! My text strings would always be bundled up which made it very time consuming and gave me anxiety. I feel more confident now for the exam, thanks so much! :)
Hello Jovani. I'm thankful to hear that this video was helpful to you. I wish you the best on the exam.
Thank you it's very helpful
This is going to be interesting! Thank you again for your time making these videos and helping us all!
Thank you for watching them. On the exam, you'll get a mix of functions. Some will be easy, and others are going to be a little more difficult. Don't forget, "You don't have to get all of the functions correct just most of them." :)
Thank you so much for this video . Very helpful!
Hello Bhawna. I’m thankful that you found this video helpful. Thanks for watching.
thank u!
Thanks for watching and taking the time to comment.
can you go in-depth about greater than for less than, on my certification exam I had a greater than question and it tripped me up hard. Please I hope you see this.
@rizi love this is a great idea. I will add it to my project list.
I feel Confident now...Sir u are great than my IT teacher !
I'm thankful you found the video helpful. Thanks for watching.
Hi Brendan... is it possible to add a printable/download pdf version of the formulas ?
@ Kay Ganapathi This is a great question. I'm going to add this to my project list. I just need to my mind around how I would go about formatting something like this.
Great video. Is there a link to download the workbook you are using so I can follow along?
@Debra Rein, I do not have a file download for this video. I made this video as more of a demonstration than as a follow along.
Do you know when the next version of the MOS exams will be?
Hello @dabluerover the new exams are scheduled to release in Q3. No specific month has been mentioned yet, but I am guessing it will be after their annual Certified conference but before the new school year begins. Here is the Certiport link showing their timeline certiport.pearsonvue.com/Educator-resources/Exam-details/Exam-releases
Hi Brendon,
Few weeks ago I enjoyed your 77-728 Excel 2016 expert exam simulations, they are great. For some reason, I cannot find them anymore on You Tube. Have you removed/deleted them ? If not, then where I can find them ? Please advise. Thank you and all the best !
@Romulus Milea I had to take them down. Sorry.
@@Brendan_Sinclair, thank you for your answer. Is there any way I can find them somewhere else ? Please help. Thank you.
@@Brendan_Sinclair, please advise if these videos could be found somewhere else. Thank you.
@@Brendan_Sinclair, hi again. I am sorry for insisting too much, but can you please provide an answer ? I would love to find out whether 77-728 videos can be found somewhere else. Or, will you re-publish them on TH-cam ? Thank you.
@Romulus Milea no the videos are no longer available and will not be re-published.
Thanks for these videos, our professor e-mails your videos to us and they've helped me immeasurably!
@Ray64 I'm thankful that you have found my videos helpful! Thanks for taking the time to comment and tell your professor that I said hello 😂
Hello and thanks for doing the video it is very informative. Could you tell me if there is a Microsoft 2016 exam for Excel past Expert?
Hello @Mike Orndorff. I created a few videos on Excel Expert. Here are three GMetrix Excel Expert playlists that I created Practice Exam 1 th-cam.com/play/PLEqweL5D54PAKMWUNrG82ru0KHqPc58iR.html, Practice Exam 2 th-cam.com/play/PLEqweL5D54PAI0wlFvhdJ8uhJ148qRp2G.html, and Practice Exam 3 th-cam.com/play/PLEqweL5D54PDE7Xq-rpxfQ3zfacHXmyML.html. I would also check out the Excel Expert 2016 Exam page here www.microsoft.com/en-us/learning/exam-77-728.aspx.
Thanks for the videos. I got 865!
@Morning Breeze this is awesome news! Congrats on earning this certification!
how many questions do we need to get right to pass?
@Gabi Correa There isn't a magic number that you need to get right. My understanding is some questions carry more weight than other questions do. Ultimately, you need to earn a 70% (700/1000) or better. If you are worried about the functions, I tell my students that they don't have to get all of these questions correct to pass the exam, just most of them. The perform operations with formulas and functions domain only accounts for 10-15% of the exam.
Can you do a self guided study or do you have to take a formal class before you take the exam? Anyone know? I appreciate it.
Hello @upittman1. You can do a self-guided study. I would check out the exam domain page here www.microsoft.com/en-us/learning/exam-77-727.aspx. I would also recommend these books to you for practice MOS 2016 Study Guide for Microsoft Excel: amzn.to/2RH33jv, Microsoft Excel 2016 Step by Step: amzn.to/2YcA7Q5, Excel 2016 Bible:amzn.to/2PNQzTO. I also have a playlist on this exam which could be helpful to you as you prepare th-cam.com/play/PLEqweL5D54PBNNCaCWKmOQC9Z5f-7Wzdd.html.
Just passed my excel test with a score of 826.Thanks alot!!!!😙😙
@Tasha Hall this is awesome news! Congrats! Thank you for taking the time to comment.
Could You share Excel files? Thanks.
@Aleksander Sosna I regrettably did not save my Excel file when I made this video. Sorry.
This is my first exam for excel ... please tell me the syllabus so that I can cover those topics please
@supriya singh here is a link to all of the domains for the exam Excel Exam Page (Certiport): certiport.pearsonvue.com/Certifications/Microsoft/MOS/Certify/Excel.aspx. Here is a playlist that I created covering many of the domain items MOS Excel 2016 Exam 77-727 th-cam.com/play/PLEqweL5D54PBNNCaCWKmOQC9Z5f-7Wzdd.html.
@@Brendan_Sinclair thank u sir..I am really lost in my career ...thanks for showing me path
how long is this test?
@John Ehmer you have 50 minutes to complete the exam. I talk more about this exam in this video th-cam.com/video/j-n8ilRlqCE/w-d-xo.html.
Hello Brendan iam super weak in excel i do plan to take excel mos in few months and iam scared..please advise
@JB 9595 the most important thing that you can do is practice. GMetrix is a great asset for those preparing for the exam gmetrix.com/Products/Filter?Certification=Microsoft+Office+Specialist+(MOS)&Version=Microsoft+Office+2016&Type=Tests. I also recommend this book MOS 2016 Study Guide for Microsoft Excel: amzn.to/2RH33jv. I talk about this book and two others in this video th-cam.com/video/9jGjv6S7BNc/w-d-xo.html. I would take a look at the MOS Excel exam page here www.microsoft.com/en-us/learning/exam-77-727.aspx. Finally, I would check out my playlist on the exam th-cam.com/play/PLEqweL5D54PBNNCaCWKmOQC9Z5f-7Wzdd.html.
You forget about Trim
Can you help me to use gmetrix together you? I am from việt Nam. I do not have Gmetrix
@trang tran you can get a GMetrix access code from here gmetrix.com/Products/Filter?Certification=Microsoft+Office+Specialist+(MOS)&Version=Microsoft+Office+2016&Type=Tests.
who are you🙂
19:30 What the f*ck man!!!!
Jumpscare alert