Excel 2016 Exam 77-727 - All of the Formulas and Functions on the Excel 2016 Certification Exam
HTML-код
- Опубликовано: 13 сен 2024
- This video covers every function that you could be asked to perform on the Microsoft Excel 2016 certification exam.
**At around 19:30 something happened with the audio and video. You should turn the volume down a little around that mark due to a buzzing noise.**
BELOW ARE ADDITIONAL RESOURCES
RECOMMENDED READING
EXCEL
Microsoft Excel 2019 Step by Step: amzn.to/2M2Fa0D
Excel 2019 Bible: amzn.to/2M9IJSV
MOS 2016 Study Guide for Microsoft Excel: amzn.to/2RH33jv
MOS 2016 Study Guide for Microsoft Excel Expert: amzn.to/2RCYLtE
WORD
Microsoft Word 2019 Step by Step: amzn.to/2SN2bai
MOS 2016 Study Guide for Microsoft Word: amzn.to/2VJizKL
MOS 2016 Study Guide for Microsoft Word Expert: amzn.to/2M3LFjD
POWERPOINT
Microsoft PowerPoint 2016 Step by Step: amzn.to/2C9pC6G
MOS 2016 Study Guide for Microsoft PowerPoint: amzn.to/2RJoRLe
OUTLOOK
Microsoft Outlook 2016 Step by Step: amzn.to/2CaBNAi
MOS 2016 Study Guide for Microsoft Outlook: amzn.to/2RJ3t92
MY RUclips GEAR
CAMERAS
Logitech BRIO: amzn.to/2M1Ky44
Logitech HD Pro Webcam C920: amzn.to/2Cfnr1x
MICROPHONES
Rode NT-USB: amzn.to/2M4wlDt
Blue Yeti USB Microphone: amzn.to/2H4BPiS
HEADSETS
Bose QuietComfort 35: amzn.to/2D00T6u
Logitech H800: amzn.to/2CgZ3g6
SOFTWARE
Camtasia 2018: amzn.to/2FkJo2p
Adobe Creative Cloud: amzn.to/2RFy5rT
Microsoft Office 365 Home (PC/MAC): amzn.to/2ulshqo
TubeBuddy: www.tubebuddy....
DISCLAIMER: This video and description contain affiliate links, which means that if you click on one of the product links, I’ll receive a small commission. This helps support the channel and allows me to continue to make videos like this. Thank you for your support!
I Am 2 certifications away from my MOS 2016 Master Certification because of you! Only Excel and Excel Expert left. THANK U!
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 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
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.
thank you very much, i would make sure i subscribe to you as soon as i pass that exam
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!
Great Tips, thank you.
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 so much helped me pass!
@Masterd that is awesome! Congrats!
@@Brendan_Sinclair Thumbs up for u
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 it's very helpful
I feel Confident now...Sir u are great than my IT teacher !
I'm thankful you found the video helpful. Thanks for watching.
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.
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
Thank you so much for this video . Very helpful!
Hello Bhawna. I’m thankful that you found this video helpful. Thanks for watching.
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!
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.
thank u!
Thanks for watching and taking the time to comment.
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 😂
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
Thanks for the videos. I got 865!
@Morning Breeze this is awesome news! Congrats on earning this certification!
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.
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 ruclips.net/p/PLEqweL5D54PAKMWUNrG82ru0KHqPc58iR, Practice Exam 2 ruclips.net/p/PLEqweL5D54PAI0wlFvhdJ8uhJ148qRp2G, and Practice Exam 3 ruclips.net/p/PLEqweL5D54PDE7Xq-rpxfQ3zfacHXmyML. I would also check out the Excel Expert 2016 Exam page here www.microsoft.com/en-us/learning/exam-77-728.aspx.
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 ruclips.net/p/PLEqweL5D54PBNNCaCWKmOQC9Z5f-7Wzdd.
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.
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 RUclips ? Thank you.
@Romulus Milea no the videos are no longer available and will not be re-published.
You forget about Trim
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 ruclips.net/p/PLEqweL5D54PBNNCaCWKmOQC9Z5f-7Wzdd.
@@Brendan_Sinclair thank u sir..I am really lost in my career ...thanks for showing me path
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.
Could You share Excel files? Thanks.
@Aleksander Sosna I regrettably did not save my Excel file when I made this video. Sorry.
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 ruclips.net/video/9jGjv6S7BNc/видео.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 ruclips.net/p/PLEqweL5D54PBNNCaCWKmOQC9Z5f-7Wzdd.
how long is this test?
@John Ehmer you have 50 minutes to complete the exam. I talk more about this exam in this video ruclips.net/video/j-n8ilRlqCE/видео.html.
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