MOS Excel 2013 Core & Expert Tutorial Videos

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

You will find more than 625 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-420, 77-427 and 77-428, 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.

Syllabus:

Exam 77-420:

Prerequisites (Before MOS Syllabus)

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 to Print or Save

2.0. Create Cells and Ranges

2.1. Insert Data in Cells and Ranges

2.2. Format Cells and Ranges

2.3. Order and Group Cells and Ranges

3.0. Create Tables

3.1. Create a Table

3.2. Modify a Table

3.3. Filter and Sort a Table

4.0. Apply Formulas and Functions

4.1. Utilize Cell Ranges and References in Formulas and Functions

4.2. Summarize Data with Functions

4.3. Utilize Conditional Logic in Functions

4.4. Format and Modify Text with 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)

Project-Based Questions (Version 1 - MOS Syllabus)

Project-Based Questions (as seen in the MOS 2013 exam)

Exam 77-427 Part 1:

1.0. Manage and Share Workbooks

1.2. Prepare a Workbook for Review

1.3. Manage Workbook Changes

2.0. Apply Custom Formats and Layouts

2.2. Apply Advanced Conditional Formatting and Filtering

2.4. Prepare a Workbook for Internationalization and Accessibility

3.0. Create Advanced Formulas

3.2. Look Up Data with Functions

3.3. Apply Advanced Date and Time Functions

4.0. Create Advanced Charts and Tables

4.1. Create Advanced Chart Elements

4.2. Create and Manage PivotTables

Project-Based Questions (as seen in the MOS 2013 exam)

Exam 77-427 Part 2:

1.0. Manage and Share Workbooks

1.1. Manage Multiple Workbooks

2.0. Apply Custom Formats and Layouts

2.1. Apply Custom Data Formats

2.3. Apply Custom Styles and Templates

3.0. Create Advanced Formulas

3.1. Apply Functions in Formulas

3.4. Create Scenarios

4.0. Create Advanced Charts and Tables

4.3. Create and Manage Pivot Charts

Project-Based Questions (as seen in the MOS 2013 exam)

Challenging Questions (Beyond MOS Syllabus)

Financial Functions