Excel 2016 Certification Project
HTML-код
- Опубликовано: 14 окт 2024
- In this video, I go over an Excel project that I created covering concepts found on the Excel 2016 Exam 77-727. This project isn't meant to be flashy, but cover concepts that students and teachers struggle with. You will find more task questions in this project than you will on the actual exam. With some practice, you should be able to complete this project in 50 minutes or less.
The project files can be downloaded here: drive.google.c...
Excel Exam Page (Certiport): certiport.pear...
Excel Exam Page (Microsoft): docs.microsoft...
BELOW ARE ADDITIONAL RESOURCES
RECOMMENDED READING
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
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 2019: amzn.to/2HYCpg2
Microsoft Office 365 Home (PC/MAC): amzn.to/2ulshqo
Adobe Creative Cloud: amzn.to/2RFy5rT
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!
Without your help I wouldn't have passed my 77-727 exam this morning. I can't thank you enough for your great tutorials/instructions on how to be successful.
@Scott McLean this is awesome! Congrats on earning your certification!
Scored 893 on this exam today over the moon thank you so much for your help your videos have helped me a great deal
Noor
@Mohammad Noor Uddin You did well on the exam. Congrats on earning this certification! I'm thankful to hear that my videos were helpful to you.
Thank you sooo much i never done anything on excel until the day before my exam and all I did was watch this video!! and some of your other and I got 935!!! thank you I'm not a noob anymore!!
@Victoria Star this is really awesome! You did very well. Thank you for taking the time to comment and let me know. It really means a lot. Congrats again on earning your certification!
It was beneficial. I liked most that you uploaded the project for us, which allowed me to practice and prepare with confidence. I passed my exam on the first try. Your video was clearly grateful. Thank you.
@Fariha Akter This is awesome to hear! Congrats!
Hi Brendan! I think this Test Project will really help Students with there practice for the MOS Excel Exam!Massive Thumbs Up.
@darryl morgan I really appreciate the comment! Thanks for taking the time to comment.
Passed the certification test today for MO-200 Excel 2019 with 930/1000
This video helped give me an idea of what the exam looked like though my 2019 exam had more focus on table and chart manipulation and labeling.
But the video is spot on for the real exam questions involving creating tables, Banded rows, Total/Average/Max, import text file, Left/Right function, conditional formatting, creating simple math formulas, move chart to separate page. The exam also had a lot of jumping around between sheets for each question just like you said.
Thank you so much for your videos!! This project one specifically and the formulas is what helped me out the most! I got 100% on the formula portion and the ones that I thought I would do better in which are the sorting and ranges etc., are the ones I did the worst on hahaha but I still passed and got 828 as a score! Again, thank you so much and you definitely deserve more subscribers!
I have my excel certification tomorrow and this video has really helped me. I hope I do well. I’ll be here to give my testimony.
@Life with jomi I wish you the best and look forward to hearing about your experience.
How long does it take to obtain your certificate after finishing the exam?
Thank you for the video!!! I am going to take the exam today!! Wish me luck!!
@Inayah Wulandari How'd it go?
Great resource, this has confirmed to me that i think i am ready for the exam.
Would be good to have a Macro check the answers so we can see if we got them right. I did a macro checker on the first worksheet and seems to be possible.
keep up the good work
@Alan Reynolds I'm glad to hear that you found my project helpful to you. A Macro would be a great resource. I just need to find time. :)
Brendan,
I have my students watch your videos before testing. They have already completed the prep materials, but your videos are a wonderful review. They loved the Excel project! My students said it was immensely helpful!
Do you have any recommendations for instructional materials for the Excel Expert exam? I have a couple of students who are very interested in pursuing this certification. I would like to provide them with some prep materials.
Thank you!! I'm gonna test out of a class, you saved me some monies!
@TyroSlayed This is awesome to hear.
So usefull, thank you for the help, i'm about to do my certification, and this video help me a lot
I’m glad to hear this! I wish you the best on the exam.
Hi Brendan, I just want to thank you for your videos, they were very helpful for my preparation!!
@Fabiana Carvalho I'm thankful to hear this! Thank you for taking the time to comment.
I think the projects will help me with the exam
For the first task on project 3 I had to enable and use the Text Import legacy wizard in the Options menu.
@Stan R Yes, that is something that you might have to do if you are using Excel 2019.
at 29:40 how come Amount owed - Amount paid = 8048? 8047 - 0 = 8047 but excel rounded up. Thanks for making this project
In Project 3, Task 4 was a little confusing. Frm that I assumed you were talking about the actual header in cell A11
@Teara Peeples I can understand why you thought that, and that is a reason that the task question is worded that way. You could easily see a task like this on the certification exam. I doubt you are going to see a task question that says apply the Excel feature called Wrap Text to row 12. A11 is more of a title for that data. Additionally, the text in row 12 cannot fit in the cells because of the column widths. On the exam, you are going to have to analyze the data carefully to make these decisions. On a task question like this, if you are questioning what you need to do, I would look for things like text that doesn't fit in the cell knowing that the feature called wrap text will answer the task question. I hope my answer helps.
Hi, I was doing fine until Project 3. I was unable to import the "Planets" file as I could not find it. I am using MS Office 2021 so my ribbon looked different than yours to some extent. Instead of "Get External Data" it has "Get Data" and gives ytou options on where to look for it. That's a shame because I could not complete the Project.
Hello I have a question. can we do something more advanced than you showed or in a different way? for example to convert to table I use Ctrl t. also in project 5 I used sumproduct to calculate gross pay. Also for the full name on the same project is it wrong to use the & instead of Concatenate? The question says use a formula and not a function, so I believe it would be ok. What do you think?
In task 2 of project 1 you say "use a formula" but you are using a function (concatenate) instead of a formula (with &s).
Hello sir! do questions differ according to country?
I also entered the MOS competition but the MOS faq site says to look for skills beyond the skills required for certification.
I also haven't taken the certification program. I've signed up for excel 2016 and the exam is around the end of next month.
It would be very amazing if you'd make a video on the MOS competition exam of this year. if not provide some tips.
(BTW I'm from Nepal)
thank you!
@Poof !! I can only comment on the MOS American competition. They have a paper based exam that isn't released until the time the exam is given. To my knowledge, the exam isn't released after the event. I can only speculate on what could be asked. I would make sure that you have a firm grasp of the concepts that Certiport says that you should know. Those concepts can be found here certiport.pearsonvue.com/Certifications/Microsoft/MOS/Certify/Excel.aspx. I have also made a playlist on the same content here ruclips.net/p/PLEqweL5D54PBNNCaCWKmOQC9Z5f-7Wzdd. You might want to check out some of the 2019 formulas and domains for extra prep.
@@Brendan_Sinclair ok. I'll try whatever i can.
Thank you ! :)
Thank you so much
Hi Brendan, is 77-727 certification worth ? is it enough for career advancement , it seems like 77-727 is all the fundamental . Should I skip straight to the expert test, but I'm just beginner, trying to catch up all the expert exam syllabus . Is it possible to pass the expert test in 2 month learning ?
@Li Shen Thia If you have a choice, I would take the MO-200 exam of the 77-727 exam because it is newer. Every person's circumstances dictate whether they should peruse the certification. Some careers require you to have certain certifications to apply for the job. Other people want to take it to validate their skills. You can skip the core Excel exam and move to the Excel Expert exam if you would like. Depending on your skill level, you could pass the exam with 2 months of learning. I will caution you that the Excel Expert exam is extremely difficult though. I would familiarize yourself with the exam domains. Here is a link for the MO-201 exam docs.microsoft.com/en-us/learn/certifications/exams/mo-201. You should be very comfortable carrying out the functions that are listed. I would recommend this book for the Excel Expert exam: MOS Study Guide for Microsoft Excel Expert Exam MO-201: amzn.to/3aX8uAs
Give more of projects for practice
Hi Brendan, do you have power point project? i search from your channel, but i couldn't find the exercise project for PPT. Thank you
@FIERA WARDHANI GLADISA unfortunately, I do not have a project for PowerPoint.
@@Brendan_Sinclair thank you. Alhamdulillaah biidznillaah i passed my excel and ppt exam, thank you for your tutorials.
Mine assignments only go up to Project 6? is there a new link?
One of the tabs is hidden in the file. You have to unhide the worksheet tab.
Hello friend , what's the difference between 77-727 and the 77-728 ? thnx in advanced
@Erick Helena The differences are the complexity of the exams and what is tested. Below are links for both exams which outline what is on each exam. Just a word of caution, if you are looking to take the Excel Expert exam, make sure to be prepared. The exam is much more difficult than the core exam.
Core Excel 77-727: docs.microsoft.com/en-us/learn/certifications/exams/77-727
Excel Expert 77-728: docs.microsoft.com/en-us/learn/certifications/exams/77-728
@@Brendan_Sinclair i see it , thnx so much , do u have any video for the 728 exam ?
@Erick Helena I don’t have anything specifically geared toward that exam. I used this book when I was preparing for the exam MOS 2016 Study Guide for Microsoft Excel Expert: amzn.to/2RCYLtE. I felt it helped me with a few task questions on the exam specifically on custom formatting questions.
@@Brendan_Sinclair thank you so much
Not sure why, I get an extra row of column1 ,column 2 when I import the planet txt file using Data tab
@Pooja Deshmukh I’m not sure why you are having extra information imported. It’s hard to troubleshoot from afar. The best advice that I can give is to make sure that you know how to correctly do this type of task. That way on the exam you can do it without any issues. Sorry that you are having issues.
sir i am continuously watching your video and i have a test on Monday
sir i want to take four exam in one day is it goof for me?
@Wajiha Khan I don’t know if I would recommend taking four exams in one day. The most that I have done in one day is three and the most I’ve had my students do in one day is two. It is possible though. If outlook is one of the exams make sure that you are familiar with the testing format because it is different than the other exams.
@@Brendan_Sinclair sir i have to take word,excel.powerpoint and acces 2016 in one day
@Wajiha Khan I wish you the best. All of those test formats are the same. I think Access might have a few less tasks for you to complete. Most test takers rank the difficulty of the exams as 1. Access 2. Excel 3. Word 4. PowerPoint. The advice that I would give you is if you feel overwhelmed at any point, take a step back and take a deep breath. Then after a moment of collecting yourself reread the task question. Also, don’t waste a bunch of time on any one task question. If your not sure what to do, mark it for review and move to the next task. If you have time left on your exam, then you can go back to task questions that you marked for review.
@@Brendan_Sinclair sir plz tell me that mcq will be asked on exam on mos
Hello ,
I want to apply for Microsoft Certified Trainer(MCT)
is Exam 77-728 is enough?
@Ahmed Hassan Individual MOS certifications are listed out here docs.microsoft.com/en-us/learn/certifications/mct-certification. I would reach out to them to verify.
I type 2 but your image is still way bigger than mine :S
@Pwn my thought is that maybe your units of measure is setup differently than mine. Without being there it is difficult to troubleshoot. The main things for this is that you know how to do it. You won't have those same issues on the exam.
@@Brendan_Sinclair ok thank you!
it is not an expert certification exam. so easy
Im in school and I have a test soon I'm scared
@Error TV I'll give you the same advice I give to my students. Take a deep breath and walk into the test with a clear head. You don't have to get all of the function questions right on the exam to pass. Make sure to do the ones that you know how to do and skip the ones that you are unsure of how to do. My final piece of advice is to mark for review any questions that you are not immediately sure how to answer. If you have time at the end of the exam, go back and work on the ones that you marked for review. Overall just give it 100% for 50 minutes and then regardless of the exam result, you know that you did your absolute best. I wish you the best.
Joe Mama