Excel 2013 / 2016 - Introduction Training

Overview

Rating:
Duration:
( - Eastern)
Cost:
$195.00
Excel 2013 / 2016 - Introduction Logo
This course will familiarize students with spreadsheet terminology and the fundamental concepts of Microsoft Excel, including identifying Excel window components, navigating worksheets, and downloading templates. In addition, students will learn the basics of entering and editing text, values, and formulas, and how to save workbooks in the native Excel format, as well as in other formats. They will learn how to move and copy data and formulas, how to determine absolute and relative references, and how to work with ranges, rows, and columns. Students will also learn how to use simple functions, and how to easily apply formatting techniques to worksheet data. They will create and modify charts, and work with graphics. Finally, they will review workbooks for spelling errors, modify page setup, and print worksheets. This course will help students prepare for the Microsoft Office Specialist core-level exam for Excel 2013 (exam 77-420) and the Microsoft Office Specialist Expert exam for Excel 2013 (exam 77-421). It also prepares students for the Excel 2016 Core Data Analysis, Manipulation, and Presentation (exam 77-727) and the Excel 2016 Expert Interpreting Data for Insights (exam 77-728). For comprehensive certification training, students should complete the Introduction, Intermediate, and Advanced courses for Excel.

Live Online Schedule

  • Jun 11
  • Jul 16
  • Aug 15
  • Sep 10

Prerequisites

None.

Requirements

You will need the following software/setup for this class:

  • Microsoft Windows
  • Microsoft Office 2013 or 2016 (minimally, you can install only Excel)
  • Adobe Reader
  • A printer driver (An actual printer is not required, but students will not be able to complete Activity A-3 in the “Printing” unit unless a printer driver is installed.)

Topics

Excel 2013 / 2016 - Introduction

  • Getting started
    • Spreadsheet terminology
    • The Excel environment
    • Navigating a worksheet
    • Using a template
  • Entering and editing data
    • Entering and editing text and values
    • Entering and editing formulas
    • Saving and updating workbooks
  • Modifying a worksheet
    • Moving and copying data
    • Moving, copying, and viewing formulas
    • Absolute and relative references
    • Inserting and deleting ranges, rows, and columns
  • Functions
    • Entering functions
    • AutoSum
    • Other common functions
  • Formatting
    • Text formatting
    • Row and column formatting
    • Number formatting
    • Conditional formatting
    • Additional formatting options
  • Charts
    • Chart basics
    • Formatting charts
  • Graphics
    • Working with pictures
    • Conditional formatting with graphics
    • SmartArt graphics
  • Printing
    • Preparing to print
    • Page Setup options
    • Printing worksheets