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 Excel 2016
    • Identify the Elements of the Excel Interface
      • Microsoft Excel 2016
      • What are Spreadsheets, Worksheets, and Workbooks?
      • What are Columns, Rows, Cells, and Ranges?
      • The Excel Interface
      • Navigation Options
      • Creating a New Blank Workbook
      • Creating a New Workbook from a Template
    • Create a Basic Worksheet
      • The Ribbon
      • The Backstage View
      • Data Types
      • Excel 2016 File Formats
      • The Save and Save As Commands
      • Saving to Microsoft OneDrive
      • Compatibility Mode
      • The Convert Option
      • The Compatibility Checker
      • Checking for Accessibility Issues
    • How to Use the Help System
      • Using Tell Me
      • Accessing Advanced Help Options
  2. Performing Calculations
    • Create Formulas in a Worksheet
      • Excel Formulas
      • The Formula Bar
      • Elements of an Excel Formula
      • Common Mathematical Operators
      • The Order of Operations
    • Insert Functions in a Worksheet
      • Functions
      • The Function Library
      • Common Functions in Excel
      • The Formula AutoComplete Feature
    • How to Reuse Formulas
      • The Cut, Copy, and Paste Commands
      • Paste Special Options
      • Relative References
      • Absolute References
      • Mixed References
  3. Modifying a Worksheet
    • Manipulate Data
      • The Undo and Redo Commands
      • The AutoFill Feature
      • AutoFill Options
      • The Transpose Option
      • Live Preview
      • The Clear Button
    • Insert, Manipulate, and Delete Cells, Columns, and Rows
      • The Insert and Delete Options
      • Column Width and Row Height Alternation Methods
      • The Hide and Unhide Options
    • Search For and Replace Data
      • Cell Names and Range Names
      • The Find Command
      • The Replace Command
      • The Go To Command
    • Spell Check a Worksheet
      • The Spelling Dialog Box
  4. Formatting a Worksheet
    • Modify Fonts
      • Fonts
      • The Font Group
      • The Format Cells Dialog Box
      • The Format Painter
      • Galleries
      • Live Preview and Formatting
      • The Mini Toolbar
    • Add Borders and Colors to Cells
      • Border Options
      • Fill Options
      • Sheet Backgrounds
      • Paste Options
    • Apply Number Formats
      • Number Formats
      • Number Formats in Excel
      • Custom Number Formats
    • Align Cell Contents
      • Alignment Options
      • The Indent Commands
      • The Wrap Text Command
      • Orientation Options
      • The Merge & Center Options
    • Apply Cell Styles
      • Cell Styles
      • The Style Dialog Box
  5. Printing Workbook Contents
    • Define the Basic Page Layout for a Workbook
      • The Print Options in Backstage View
      • The Page Setup Dialog Box
      • The Print Preview Option
      • Workbook Views
      • Headers and Footers
      • Header and Footer Settings
      • Page Margins
      • Margins Tab Options
      • Page Orientation
    • Refine the Page Layout and Apply Print Options
      • Zoom Options
      • Page Breaks
      • Page Break Options
      • The Print Area
      • Print Titles
      • Scaling Options
  6. Managing Large Workbooks
    • Format Worksheet Tabs
      • Renaming Worksheet Tabs
      • Changing Tab Color
    • Manage Worksheets
      • Grouped Worksheets
      • Repositioning Worksheets
      • Inserting or Deleting Worksheets
      • Hiding and Unhiding Worksheets
      • Worksheet References in Formulas
    • Manage the View of Worksheets and Workbooks
      • The Split Command
      • The Freeze Panes Options
      • The Arrange All Command
      • The Arrange Windows Dialog Box
      • The View Side by Side Command
      • The Switch Windows Command
      • The New Window Command