MOS Excel Expert 2016 Microsoft Certification Exam 77-728

  • Course provided by Udemy
  • Study type: Online
  • Starts: Anytime
  • Price: See latest price on Udemy
Udemy

Course Description

----UPDATED January 2021----

Featured questions in the Q & A section of the course


---- UPDATED June 2019 ----

Added additional project assignments


---- UPDATED March 2019 ----

Added additional assignments


The TEST4U MOS Excel Expert 2016 Microsoft Certification Exam 77-728 Course

The TEST4U team realized that there is a need for a complete hands-on Training system for the 77-728 exam, so we created the MOS Excel Expert 2016 Microsoft Certification Exam 77-728 course. It is targeted to people, who want to succeed in the 77-728 exam.


The Course at a glance

In this course you will find:

  • 52 assignments properly categorized

  • 52 distinct files for each of the above assignments

  • 52 solution videos for every assignment

  • 10 project questions similar to the ones you will face in the exam

  • 40 lectures explaining certain interesting subjects of the MOS 77-728 syllabus

  • 2 lectures explaining the examination process and the structure of the multi-project question



The Course in detail


52 assignments properly categorized

In this course you will practice on the following categories:

1. Manage Workbook Options and Settings

2. Apply Custom Data Formats and Layouts

3. Create Advanced Formulas

4. Create Advanced Charts and Tables

5. Financial Functions

6. Features present in Excel 2016 Pro

7. Projects


52 distinct files for each of the above assignments

Each and every assignment comes with its distinct file(s) that are necessary to answer the assignment


52 solution videos for every assignment

All assignments are accompanied by detailed video solutions. We recommend you try to solve the assignments without viewing the solution. This way you will better understand your limitations and be able to focus on them. You can then see the video after you have solved it, to know if you answered the question correctly.


10 project questions similar to the ones you will face in the exam

Since the release of Office 2016, Microsoft introduced a new kind of examination. This examination consists of multiple project questions. We have included 10 such project questions in this course


Fast feedback from our instructors

We give feedback to all assignments, usually within one or two working days. Although in many cases we have been known to answer within a few hours.


Who this course is for:

  • Students preparing for the MOS 77-728 exam

Expected Outcomes

  1. By completion of the course, the students will be well prepared to take the MOS 77-728 exam Requirements The students should have basic knowledge of Excel Description ----UPDATED January 2021---- Featured questions in the Q & A section of the course ---- UPDATED June 2019 ---- Added additional project assignments ---- UPDATED March 2019 ---- Added additional assignments The TEST4U MOS Excel Expert 2016 Microsoft Certification Exam 77-728 Course The TEST4U team realized that there is a need for a complete hands-on Training system for the 77-728 exam , so we created the MOS Excel Expert 2016 Microsoft Certification Exam 77-728 course. It is targeted to people, who want to succeed in the 77-728 exam . The Course at a glance In this course you will find: 52 assignments properly categorized 52 distinct files for each of the above assignments 52 solution videos for every assignment 10 project questions similar to the ones you will face in the exam 40 lectures explaining certain interesting subjects of the MOS 77-728 syllabus 2 lectures explaining the examination process and the structure of the multi-project question The Course in detail 52 assignments properly categorized In this course you will practice on the following categories: 1. Manage Workbook Options and Settings 2. Apply Custom Data Formats and Layouts 3. Create Advanced Formulas 4. Create Advanced Charts and Tables 5. Financial Functions 6. Features present in Excel 2016 Pro 7. Projects 52 distinct files for each of the above assignments Each and every assignment comes with its distinct file(s) that are necessary to answer the assignment 52 solution videos for every assignment All assignments are accompanied by detailed video solutions . We recommend you try to solve the assignments without viewing the solution. This way you will better understand your limitations and be able to focus on them. You can then see the video after you have solved it, to know if you answered the question correctly. 10 project questions similar to the ones you will face in the exam Since the release of Office 2016, Microsoft introduced a new kind of examination. This examination consists of multiple project questions. We have included 10 such project questions in this course Fast feedback from our instructors We give feedback to all assignments , usually within one or two working days. Although in many cases we have been known to answer within a few hours. Who this course is for: Students preparing for the MOS 77-728 exam Show more Show less Course content 11 sections • 44 lectures • 5h 0m total length Expand all sections Introduction 1 lecture • 2min How to submit an assignment Preview 01:41 Manage Workbook Options and Settings 2 lectures • 2min Copy Macros Between Workbooks Preview 01:03 Protect a Worksheet 00:39 1257 1 question 1407 1 question 1439 1 question 1448 1 question 1528 1 question 1578 1 question 1990 1 question 1445 1 question Apply Custom Data Formats and Layouts 4 lectures • 4min Removing a custom number format Preview 00:39 Apply Advanced Conditional Formatting using a formula Preview 01:30 Work with Form Controls Preview 01:28 Use the Accessibility Checker 00:48 1114 1 question 1455 1 question 1456 1 question 1457 1 question 1462 1 question 1860 1 question 1459 1 question Create Advanced Formulas 13 lectures • 1hr 12min The SUMIFS Function Preview 05:29 The AVERAGEIFS Function 05:20 The COUNTIFS Function 05:16 The INDEX Function Preview 05:55 The MATCH Function 05:35 The OFFSET Function 04:38 The VLOOKUP Function Preview 05:46 The HLOOKUP Function 05:24 Advanced Lookup Formulas I (VLOOKUP-MATCH, VLOOKUP-HLOOKUP) 08:47 Advanced Lookup Formulas II (OFFSET-MATCH-MATCH) 04:37 Advanced Lookup Formulas III (INDEX-MATCH, INDEX-MATCH-MATCH) Preview 06:00 Goal Seek 03:52 The TRANSPOSE Function 04:59 1074 2 questions 1096 1 question 1263 2 questions 1384 1 question 1409 1 question 1421 1 question 1486 1 question 1941 1 question 1970 1 question 1991 1 question Create Advanced Charts and Tables 4 lectures • 24min Pivot Tables 05:48 Calculated Fields and Items 06:51 Pivot Charts 04:22 Slicers 06:53 1039 1 question 1041 1 question 1044 1 question 1054 1 question 1281 2 questions 1859 1 question 1917 1 question 1919 1 question 1988 1 question CUBE Functions 7 questions Financial Functions 14 lectures • 1hr 29min Introduction to Financial Functions 00:38 The Functions PMT, IPMT, PPMT 11:16 The Functions PV, FV, NPER, RATE 10:20 The Functions NPV, XNPV 06:18 The Functions IRR, MIRR, XIRR 07:12 The Functions DOLLARFR, DOLLARDE 03:47 The Functions YIELD, YIELDDISC, YIELDMAT 04:35 The Functions DISC, RECEIVED, INTRATE 03:59 The Functions PRICE, PRICEMAT, PRICEDISC 05:53 The Functions ACCRINT, ACCRINTM 07:45 The Functions COUPDAYBS, COUPDAYS, COUPDAYSNC, COUPNCD, COUPNUM, COUPPCD 08:53 The Functions DURATION, MDURATION 03:10 The Functions SLN, SYD, DB, DDB, VDB 09:20 The Functions TBILLEQ, TBILLPRICE, TBILLYIELD 05:25 1489 1 question 1491 1 question 1498 1 question 1551 1 question Features present in Excel 2016 Pro 2 lectures • 12min Power Pivot 06:21 Power Pivot Hierarchies 05:41 1047 1 question 1058 1 question 1436 1 question 1441 1 question Multi-Project Question (as seen in the exam) 2 lectures • 8min MOS 2016 exam procedure Preview 02:36 MOS 2016 Multi-project questions description Preview 04:54 Project 1 of 5: CAR-PART company sales 7 questions Project 2 of 5: Movie Fans video club rentals 7 questions Project 3 of 5: Hyper Market stock price analysis 6 questions Project 4 of 5: Theopetra Cave guest data 6 questions Project 5 of 5: PCI-X computer hardware company sales 6 questions Multi-Project Question 2 (as seen in the exam) 0 lectures • 0min Project 1 of 5: CAR-PART company sales 7 questions Project 2 of 5: Movie Fans video club rentals 7 questions Project 3 of 5: Hyper Market stock price analysis 7 questions Project 4 of 5: Theopetra Cave guest data 6 questions Project 5 of 5: PCI-X computer hardware company sales 6 questions Epilogue 1 lecture • 1min Epilogue 00:31 1 more section Instructor TEST4U Testing, Training, Evaluation Platform Testing, Training, Evaluation Platform 4.3 Instructor Rating 1,546 Reviews 7,085 Students 86 Courses TEST4U is a Testing, Training and Assessment platform, where the user is assessed by performing Real Working Conditions tasks. Training with TEST4U is interactive, which ensures the best possible result, with the least possible effort. The way TEST4U works is by cooperating with the actual, installed applications. In simple words, it sets the conditions for training on in-application (or Live) questions, which actually assess the result, not the way of answering questions. Our vision is to provide the best training and preparation software for the candidates interested in broadening their skill sets, within or outside the enterprise environment, or for those taking the UBER Analytics Test, MOS Microsoft Certiport, IC3, ECDL/ICDL etc. exams. Since 2003, when TEST4U was launched for the first time, more than 700.000 candidates have relied upon it for their proper preparation. Since its first version, TEST4U has evolved. Currently it contains more than 6.000 questions and supports more than 19 applications in 6 languages: English, Spanish, German, Italian, Russian and of course Greek. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781722de97ae698',m:'70be5a38311e5adeb05dc752d7054bc66d11de2b-1627845860-1800-Aer2Oh4EiGHB0+xVPj158lHeL6qt6FHIqpjNrkjJ2RGVMbwujecI5j6aq6qINBdekEWm+bb/UqpCrQHAMjuNdBCGTzh+TdGrarpUaKC501SJC1qjyHOYGmQ5xcJ20UG0kN9jXEgdUcBpFEkhIlISlYfp5s3G+MkBj6WAZTlL9w6CzfZEB2iHMclra2zRrcs9uI+RvyHXl5zvuQSFCi+IxX4=',s:[0x92cadb5a08,0x984fff958d],}})();