MOS Excel 2016 Core & Expert Tutorial Videos

This provides the users with the opportunity to get an initial picture about the MOS Certiport 77-727 & 77-728 Exams, which lead to the respective Certificate acquisition for MS-Excel 2016.

You will find more than 609 questions, accompanied by theis video-solutions. Watching the videosolutions will allow you to get a good idea concerning the skills that you have, so as to assess your level in order to become fully competent during the Exams.

The videosolutions are classified into categories so as to let you focus wherever you believe there is some skill shortage. This is how there is almost no time wasted in repeating the parts that you are already familiar with.

The candidates can access the full training package in order to be able to respond successfully to the Certification Examinations not only for MS-Excel, MOS 77-727 and 77-728, but for the rest of the Examinations at the Basic or the Advanced level of Microsoft-Certiport MS-Word, and the Basic level of MS-PowerPoint and MS-Access.

The full version is known as TEST4U and constitutes a complete self-study, interactive guide, available since 2003, with more than 700.000 satisfied users.
TEST4U is available only for PCs, because it requires the existence of the installed applications of the MS-Office 2016 suite in order to cooperate adequately.

We encourage you to test your skills at the TEST4U Demo at https://www.test4u.eu/en/download-demo, in order to practice and prepare for the MOS Exams.

Syllabus:

Exam 77-727:
1.0. Create and Manage Worksheets and Workbooks
1.1. Create Worksheets and Workbooks
1.2. Navigate through Worksheets and Workbooks
1.3. Format Worksheets and Workbooks
1.4. Customize Options and Views for Worksheets and Workbooks
1.5. Configure Worksheets and Workbooks for Distribution
2.0. Manage Data Cells and Ranges
2.1. Insert Data in Cells and Ranges
2.2. Format Cells and Ranges
2.3. Summarize and Organize Data
3.0. Create Tables
3.1. Create and Manage Tables
3.2. Manage Table Styles and Options
3.3. Filter and Sort a Table
4.0. Perform Operations with Formulas and Functions
4.1. Summarize Data by using Functions
4.2. Perform Conditional Operations by using Functions
4.3. Format and Modify Text by using Functions
5.0. Create charts and objects
5.1. Create a Chart
5.2. Format a Chart
5.3. Insert and Format an Object
Challenging Questions (Beyond MOS Syllabus)
Multi-Project Questions (as seen in the MOS 2016 exam)

Exam 77-728:
1 Manage Workbook Options and Settings
1.1 Manage Workbooks
1.2 Manage Workbook Review
2 Apply Custom Data Formats and Layouts
2.1 Apply Custom Data Formats and Validation
2.2 Apply Advanced Conditional Formatting and Filtering
2.3 Create and Modify Custom Workbook Elements
2.4 Prepare a Workbook for Internationalization
3 Create Advanced Formulas
3.1 Apply Functions in Formulas
3.2 Look up data by using Functions
3.3 Apply Advanced Date and Time Functions
3.4 Perform Data Analysis and Business Intelligence
3.5 Troubleshoot Formulas
3.6 Define Named Ranges and Objects
4 Create Advanced Charts and Tables
4.1 Create Advanced Charts
4.2 Create and Manage PivotTables
4.3 Create and Manage Pivot Charts
Multi-Project Questions (as seen in the MOS 2016 exam)
Financial Functions