Microsoft Excel 2013 (Voucher Included)

ID : 45446   
« back to classes page
Language: English

Description: If you wish to prepare for Microsoft Certification Exam 77-420: Microsoft Office Excel 2013 OR Microsoft Certification Exam 77-427 Part 1 and 77-428 Part 2: Microsoft Office Excel 2013 Expert, this course will help you build the skills and knowledge you need.
• Step-by-step video demonstrations
• Companion eBooks (PDF) with detailed instructions
• Sample presentations and images
• Practice, Quizzes and Skill Test

All materials for this program are available online.
The following resources are available to download throughout the lessons:
• Beginning, Intermediate and Advanced Guides to Microsoft® Excel 2013 (PDF)
• Microsoft Excel 2013 Beginning, Intermediate and Advanced Sample files

In Microsoft Excel Beginning, you’ll cover basic through advanced topics, including:
How to enter data and format cells and apply number formats
Practice how to create formulas and audit the cell references
Learn how to represent data as Charts
Use pictures and graphics

In Microsoft Excel Intermediate you’ll cover basic through advanced topics, including:
Create formulas that use Relative and Absolute values and audit the formulas
Use and modify TEXT formulas to combine cells (Concatenate) and format the data
Create, use and troubleshoot Named Ranges and use Named Ranges in formulas
Understand how to create and use Lookup Tables and use the IF functions
Excel In Print: Use page Layout and Page Set up to modify print settings
Excel Online: Use and modify Sparklines and hyperlinks

In Microsoft Excel Advanced, you’ll learn how to:
Analyze data visually with a PivotChart.
Create a PivotChart and Show the Field List.
Edit the Value Field Settings.
Filter the data in the PivotChart.
Edit the Chart Layouts and Chart Style.
Use Slicers

The Microsoft Excel 2013 Certification Training Program is part of the Microsoft Business Certification program: Microsoft Office Specialist (MOS). MOS certification is the globally recognized standard for validating expertise with the Microsoft Office 2013 suite. Students who wish to prepare for Microsoft Certification Exam 77-420: Microsoft Office Excel 2013 OR Microsoft Certification Exam 77-427 Part 1 and 77-428 Part 2: Microsoft Office Excel 2013 Expert, will find beginning through advanced lessons that demonstrate these required MOS topics.
This course teaches the objectives for the following certification tests:
Core Certification: Pass any 1 test:
Excel® 2013 Core: Exam 77-420
Expert Certification: Pass either test:
Excel 2013 Expert Part 1: Exam 77-427
Excel 2013 Expert Part 2: Exam 77-428

Instructor Description: Elizabeth Ann Nofs is the designer, developer, and instructor of the Comma Mama Guides. She developed a successful method for teaching visually that is based on observation, orientation and notation. The books that I wrote for this course meet the Microsoft Vendor of Approved course ware. As the instructor for this program, Elizabeth is available to provide guidance and motivation for learners throughout the duration of this program. As an expert mentor, she will provide answers to learner questions, monitor learner's program progression, and review lesson and program quiz/test results

Certification: This exam measures your ability to accomplish the technical tasks listed below. The percentages indicate the relative weight of each major topic area on the exam. The higher the percentage, the more questions you are likely to see on that content area on the exam. A core-level candidate for the Microsoft Excel 2013 exam should have a fundamental understanding of the Excel environment and the ability to complete tasks independently. They should know and demonstrate the correct application of the principal features of Excel 2013. These candidates should be able to create and edit a workbook with multiple sheets for a variety of purposes and situations. Examples include professional-looking budgets, team performance charts, sales invoices, and exercise logs. Candidate roles might include students, clerical workers, bookkeepers, instructors, and others.

Requirements
This program can only be taken on a PC. It is not compatible with a Mac. It is compatible with Windows 7 and later operating systems and IE 7 and later browsers. You need a high-speed Internet connection and an e-mail account. You should also have Microsoft Office 2013 already installed: Access, Excel, Outlook, PowerPoint and Word.
All materials for this program are available online.
The following resources are available to download throughout the lessons:
• Beginning, Intermediate and Advanced Guides to Microsoft® Excel 2013 (PDF)
• Microsoft Excel 2013 Beginning, Intermediate and Advanced Sample files.
This program does not require any additional purchases of supplementary materials.

Class Details

Sessions
Online 24/7

Location

Start Date:upon registration

Tuition: 

$1,595.00


Registration Closes On
Sunday, December 31, 2017 @ 12:00 AM

Schedule Information

Date(s) Class Days Times Location Instructor(s)
Online 24/7 TBD