EXC16DLM: Microsoft Excel 2016 Level 3 - Data List Management

Start Date Time Days Price GTR Availability
May 30, 2017 09:00 (EST) 1 $355.00 Register
May 30, 2017 09:00 (EST) 1 $355.00 Register
July 12, 2017 09:00 (EST) 1 $355.00 Register
August 31, 2017 09:00 (EST) 1 $355.00 Register
October 19, 2017 09:00 (EST) 1 $355.00 Register
December 14, 2017 09:00 (EST) 1 $355.00 Register

Duration: 1 Day

Prerequisites
Microsoft Office Excel 2016 – Level 2 or equivalent experience.

Course Objectives
Upon completion of the course, participants will be able to accomplish the following:

  • Create and use Excel tables, as well as add, edit, search for, and delete records in a data list using a form, as well as look up data.
  • Sort records in a data list using a variety of methods
  • Filter data in a list using a variety of methods, as well as work with filtered data
  • Create and work with subtotaled lists, as well as use various database functions to summarize data
  • Create, modify, and work with PivotTables, PivotCharts and Slicers
  • Import external data from a variety of sources into Excel

Audience
This course is intended for participants who are familiar with Microsoft Office Excel 2016.

Coure Content

Maintaining Data

  • Data List and Excel Table Concepts
  • Using Data Forms
  • Using Lookup Tables

Sorting Lists

  • Sorting Concepts
  • Sorting Lists
  • Custom Sort Orders

Filtering Lists

  • Filtering Concepts
  • Using AutoFilter
  • Using Advanced Filter
  • Working with Filtered Data

Summarizing Data

  • Automatic Subtotals
  • Working with Subtotaled Lists
  • Using Functions to Summarize Data

PivotTables

  • PivotTable Concepts
  • Creating PivotTables
  • Modifying PivotTable Layouts
  • Working with PivotTables
  • PivotCharts
  • Slicers

External Data

  • External Data Concepts
  • Importing Query Data from Access
  • Importing Query Data from Web Pages
  • Importing Query Data from Text Files