How To Take This Class

Course Overview

In this Microsoft Excel 2016 Introduction Training course, students will learn how to create worksheets in Microsoft Excel 2016, how to use formulas and perform calculations, how to format cells and worksheets, how to setup worksheets for printing and how to manage various user options to get the most out of Microsoft Excel.

Course Prerequisites

Students attending this course should have experience using a PC and navigating the Windows environment.

Course Audience

This course is designed for students with little to no experience in using spreadsheet applications.

What You'll Learn

Upon successful completion of this course, students will be able to:
  • Identify the elements of the Excel interface, create a basic worksheet, and use the help system.
  • Create formulas in a worksheet, insert functions in a worksheet, and reuse formulas.
  • Manipulate data, as well as insert, manipulate, and delete cells, columns, and rows.
  • Search for and replace data and spell check a worksheet.
  • Modify fonts, add borders and colors to cells, apply number formats, align cell contents, and apply cell styles.
  • Define the basic page layout for a workbook, refine the page layout, and apply print options.
  • Format worksheet tabs, manage worksheets, and manage the view of worksheets and workbooks.

Course Duration

1 Day

Course Outline

  1. Getting Started with Microsoft Office Excel 2016
    • Navigate the Excel User Interface
    • Use Excel Commands
    • Create and Save a Basic Workbook
    • Enter Cell Data
    • Use Excel Help
  2. Performing Calculations
    • Create Worksheet Formulas
    • Insert Functions
    • Reuse Formulas and Functions
  3. Modifying a Worksheet
    • Insert, Delete, and Adjust Cells, Columns, and Rows
    • Search for and Replace Data
    • Use Proofing and Research Tools
  4. Formatting a Worksheet
    • Apply Text Formats
    • Apply Number Formats
    • Align Cell Contents
    • Apply Styles and Themes
    • Apply Basic Conditional Formatting
    • Create and Use Templates
  5. Printing Workbooks
    • Preview and Print a Workbook
    • Set Up the Page Layout
    • Configure Headers and Footers
  6. Managing Workbooks
    • Manage Worksheets
    • Manage Workbook and Worksheet Views
    • Manage Workbook Properties

What Students Receive

Each student will receive:
  • A printed courseware manual for use during and after class.
  • A PC headset for communicating with your instructor and fellow students during your Microsoft Excel 2016 Training Class
  • A course completion certificate upon successful completion of your Microsoft Excel 2016 Training course
  • Six months of post-class email support from a Microsoft Excel Instructor