Microsoft Excel 2016 Introduction Training

How To Take This Class

Live Instructor-Led Online Class

Cost: $225.00

  • Open enrollment class for individuals
  • Live class with an instructor
  • Free class retakes forever!
  • Six months of instructor email support
  • Hands-on exercises and student labs
  • Classes never cancelled due to low enrollment
  • Money-back guarantee

Onsite or Offsite Group Training

Cost: Based on number of students

  • For groups as small as 3 people
  • Class Held at our location or yours
  • Hands-on exercises and student labs
  • Customization at no extra charge
  • Six months of instructor email support
  • All-inclusive pricing
  • Money-back guarantee
Request Group Pricing Proposal

Course Duration

1 Day

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

Course Description

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 Objectives

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 Audience

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

Course Prerequisites

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

Course Syllabus

  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