Excel 2016 Essentials Course

Participants will create and edit a workbook with multiple sheets, and use a graphic element to represent data visually. Workbook example includes professional-looking budgets, financial statements, team performance charts, sales invoices, and data-entry logs.

Course curriculum

  • 1

    Module 1: 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

  • 2

    Module 2: Manage Data Cells and Ranges

    • Insert Data in Cells and Ranges

    • Format Cells and Ranges

    • Summarize and Organize Data

  • 3

    Module 3: Create Tables

    • Create and Manage Tables

    • Manage Table Styles and Options

    • Filter and Sort a Table

  • 4

    Module 4: Perform Operations With Formulas and Functions

    • Summarize Data by Using Functions

    • Perform Conditional Operations by Using Functions

    • Format and Modify Text by Using Functions

  • 5

    Module 5: Create Charts and Objects

    • Create Charts

    • Format Graphic Elements

    • Insert and Format Objects