MOS Excel 2013 Core & Expert Tutorial Videos

by Infolearn

🗂️ Business

🆓 free

Version 1.3.0 💾 2 Mb
📅 Updated October 2, 2018

MOS Certiport 77-420, 77-427, 77-428 Exam Prep Videos-MS-Excel 2013 Certificate

Download Now Learn More

4.9/5 ( 042+ reviews)

Android application MOS Excel 2013 Core & Expert Tutorial Videos screenshort

Features 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 Workbooks1.1.
Create Worksheets and Workbooks1.2.
Navigate through Worksheets and Workbooks1.3.
Format Worksheets and Workbooks1.4.
Customize Options and Views for Worksheets and Workbooks1.5.
Configure Worksheets and Workbooks to Print or Save2.0.
Create Cells and Ranges2.1.
Insert Data in Cells and Ranges2.2.
Format Cells and Ranges2.3.
Order and Group Cells and Ranges3.0.
Create Tables3.1.
Create a Table3.2.
Modify a Table3.3.
Filter and Sort a Table4.0.
Apply Formulas and Functions4.1.
Utilize Cell Ranges and References in Formulas and Functions4.2.
Summarize Data with Functions4.3.
Utilize Conditional Logic in Functions4.4.
Format and Modify Text with Functions5.0.
Create charts and objects5.1.
Create a Chart5.2.
Format a Chart5.3.
Insert and Format an ObjectChallenging 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 Workbooks1.2.
Prepare a Workbook for Review1.3.
Manage Workbook Changes2.0.
Apply Custom Formats and Layouts2.2.
Apply Advanced Conditional Formatting and Filtering2.4.
Prepare a Workbook for Internationalization and Accessibility3.0.
Create Advanced Formulas3.2.
Look Up Data with Functions3.3.
Apply Advanced Date and Time Functions4.0.
Create Advanced Charts and Tables4.1.
Create Advanced Chart Elements4.2.
Create and Manage PivotTablesProject-Based Questions (as seen in the MOS 2013 exam)Exam 77-427 Part 2:1.0.
Manage and Share Workbooks1.1.
Manage Multiple Workbooks2.0.
Apply Custom Formats and Layouts2.1.
Apply Custom Data Formats2.3.
Apply Custom Styles and Templates3.0.
Create Advanced Formulas3.1.
Apply Functions in Formulas3.4.
Create Scenarios4.0.
Create Advanced Charts and Tables4.3.
Create and Manage Pivot ChartsProject-Based Questions (as seen in the MOS 2013 exam)Challenging Questions (Beyond MOS Syllabus)Financial FunctionsPrivacy policy update