Microsoft Office Excel Core – Exam Prep

BarbadosUnited StatesEastern Caribbean

Interested in attending? Have a suggestion about running this course near you?
Register your interest now

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.