Microsoft Excel 2016, Introduction

Create, Open and Save Workbooks

  • What is Excel?
  • Create a New Blank Workbook
  • Create a Workbook From a Template
  • Open Excel Files
  • Get Help
  • Save Workbooks
  • Navigate a Workbook

Explore the User Interface

  • Backstage View*
  • Ribbon Overview
  • Mini Toolbar
  • Status Bar
  • Shortcut Key Tips
  • Contextual Tabs

Work with Data

  • Enter, Edit and Delete Data
  • Data Selection Methods
  • Use Autofill and Autocomplete
  • Cut, Copy, Paste and Paste Special
  • Resize Columns and Rows
  • Insert and Delete Columns, Rows, Cells
  • Use Undo, Redo and Repeat
  • Spellcheck and AutoCorrect
  • Use Find, Replace and Go To
  • Use Basic Functions
  • Use SmartTags and Options Buttons
  • Add, Edit, and Remove Comments

Format A Workbook

  • Format Using the Home Ribbon
  • Format Using the Mini-Toolbar
  • Format Using Dialog Boxes
  • Use and Modify Conditional Formatting
  • Use the Format Painter
  • Create and Modify Styles
  • Add, Name, Move, Delete and Color Sheets

Charts

  • Create and Format a Chart
  • Modify Chart Layout and Structure
  • Change Chart Types, Options, Location and
  • Data Source
  • Save a Chart as a Template

Printing and Viewing A Workbook

  • Use the View Ribbon
  • Split and Freeze
  • Manage Multiple Windows
  • Use Page Layout, Print Preview and Basic
  • Print Options
  • Add Headers and Footers


Customize

  • Customize the Quick Access Toolbar
  • Show/Hide the Ribbon