Microsoft Office Excel Core - Exam Prep
Demonstrate that you have the skills needed to get the most out of Office by earning a Microsoft Office Specialist (MOS) certification in a specific Office program. Holding a MOS certification can earn an entry-level business employee more in annual salary than uncertified peers.
Description
*Pricing is inclusive of MOS Exam voucher with Retake (value BDS $285)*
Here's what you'll learn:
Course Objectives
Managing the Worksheet Environment
Navigate through a worksheet
Print a worksheet or workbook
Personalize environment by using Backstage
Creating Cell Data
Construct cell data
Apply AutoFill
Apply and manipulate hyperlinks
Formatting Cells and Worksheets
Apply and modify cell formats
Merge or split cells
Create row and column titles
Hide and Unhide rows and columns
Manipulate Page Setup options for worksheets
Create and apply cell styles
Managing Worksheets and Workbooks
Create and format worksheets
Manipulate window views
Manipulate workbook views
Applying Formulas and Functions
Create formulas
Enforce precedence
Apply cell references in formulas
Apply conditional logic in a formula (<,>,=)
Apply named ranges in formulas
Apply cell ranges in formulas
Presenting Data Visually
Create charts based on worksheet data
Apply and manipulate illustrations
Create and modify images by using the Image Editor
Apply Sparklines
Sharing worksheet data with other users
Share spreadsheets by using Backstage
Manage Comments
Analyzing and Organizing Data
Filter data
Sort data
Apply Conditional Formatting
Credit toward Certification: When you pass Exam 77-420: Excel 2013, you complete the requirements for the following certification(s): Microsoft Office Specialist: Microsoft Excel 2013
Prerequisites
A core-level candidate for the Microsoft Excel 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.
Target audience
Information Workers
Detailed Syllabus
All references to Microsoft Excel 2013 should also be taken to mean Microsoft Excel 2016 or Microsoft Excel 2019.