Skip to product information
1 of 1

The Management Sherpa

Excel 2016 Essentials

Excel 2016 Essentials

Regular price $29.00 USD
Regular price $59.00 USD Sale price $29.00 USD
Sale Sold out
Shipping calculated at checkout.
View full details

About the Course

Participants will gain a fundamental understanding of the Excel environment and the ability to complete tasks independently. They will know and demonstrate the correct application of the principal features of Excel 2016. Participants will create and edit a workbook with multiple sheets, and use a graphic element to represent data visually. Workbook example include professional looking budgets, financial statements, team performance charts, sales invoices, and data-entry logs.

Course Outline

Module One: Create and Manage Worksheets and Workbooks

  • Create Worksheets and Workbooks
  • Navigate in Worksheets and Workbooks
  • Format Worksheets and Workbooks
  • Customize Options and Views for Worksheets and Workbooks
  • Configure Worksheets and Workbooks for Distribution

Module Two: Manage Data Cells and Ranges

  • Insert Data in Cells and Ranges
  • Format Cells and Ranges
  • Summarize and Organize Data

Module Three: Create tables

  • Create and Manage Tables
  • Manage Table Styles and Options
  • Filter and Sort a Table

Module Four: Perform Operations with Formulas and Functions

  • Summarize Data by Using Functions
  • Perform Conditional Operations by Using Functions
  • Format and Modify Text by Using Functions

Module Five: Create Charts and Objects

  • Create Charts
  • Format Graphic Elements
  • Insert and Format Objects