
Develop MOS Excel 2016 exam readiness through three practice exams with 26 tasks, five projects each, and solution videos to build timing and pass the 50-minute exam.
This is a really important lecture to review before you start the course. It explains how I've structured the curriculum and the best approach to completing the practice exams.
This lecture provides guidance on how to sign on for the exam and on the Concole 8 exam interface.
Master Excel 2016 expert practices by building if condition logic, calculating averages, and using pivot tables with slicers, then create a combo pivot chart to analyze pilots and passengers.
Apply structured references in a table to compute the average and total, use absolute referencing in a conditional formatting rule, and save charts as templates while password-protecting sheets.
Learn to build Excel formulas with nested if statements, apply conditional formatting, create pivot table combo charts, use cube values with a data model, and calculate monthly payments with PMT.
Excel 2016 practice on an event planner uses the custom option, conditional formulas for guests and staff, weekday date handling, and pivot table, slicers, and line chart with markers.
Learn to use structured references to calculate averages with the total row, apply conditional formatting with exact formulas, protect worksheets with a password, and save a reusable advertising budgets template.
Discover how to build an aircraft parts data solution in Excel 2016, using average calculations, conditional formatting with formulas, lookup tables, absolute references, and workbook structure protection.
Apply advanced Excel techniques to a mobile homes project, using if with and conditions, conditional formatting rules, Irish euros formatting, and pivot tables and charts with a secondary axis.
Use cube set to create a value set from the merchandise dimension and apply cube rank member to identify the top item by last month sales, with sorting by measures.
Explore two types of courses for Microsoft Office specialist qualifications: techniques courses with comprehensive tuition and practice exams with timed attempts and video solutions.
Important Note February 2026
Please note that the Microsoft Excel 2016 Certification exams will be discontinued in June 2026.
The Microsoft Office Specialist (MOS) 2016 certification exams, which include the 77-728 (Microsoft Excel 2016) exam, are scheduled to retire on June 30, 2026.
Key details regarding this retirement:
Availability: After June 30, 2026, the 77-728 exam will no longer be available for testing.
Replacement: Candidates are advised to transition to the Microsoft Office 2019 (MO-201) or Microsoft 365 Apps (MO-211) certification exams.
Context: This is part of a broader retirement of the MOS 2016 suite by Microsoft and Certiport.
It is highly recommended to complete this certification before this date if you are currently preparing for it.
________________________________________________________
The purpose of this course is to provide you with three complete practice tests which are prepared at the level required to pass the 77-728 Microsoft Certification exam to become an Excel Expert.
Each practice exam is divided into five projects with a total of 26 tasks for each exam. That's 15 projects and 78 project tasks all geared towards the 77-728 exam.
Advice on preparation, how to approach the exam, what the interface will look like and which areas of the Objective Domain to focus on is provided.
Tips on issues you will encounter with particular questions types is also included.
The solutions to all of the practice projects are provided in the form of video lectures in which the instructor explains how to approach the project and how the solutions are derived.
If you can master the practice projects included in this course you will be confident in your abilities to master the 77-728 exam.
Understanding and being expert in the techniques examined in the 77-728 is of course essential for certification success. However, being ready for the exam requires that you are confident in your ability to complete all of the set projects in the 50 minutes allocated. That requires practice and this course will provide you with excellent practice set to the style and standard of the 77-728 exam. Enrol today!"