Microsoft Excel Level 3 – Data Management (2016, 2019)

Learn how to manage your data in Excel using forms, filters, database functions, PivotTables, PivotCharts and Slicers.

Topics include:

  • Maintaining Data
  • Sorting Lists
  • Filtering Lists
  • Summarizing Data
  • Working with PivotTables
  • Working with External Data

What you'll learn

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

  • Create and use Excel tables
  • Add, edit, search for, and delete records in a data list using a form
  • Lookup data, sort records in a data list using a variety of methods
  • Filter data in a list using a variety of methods
  • Work with filtered data
  • Create and work with subtotaled lists
  • Use various database functions to summarize data, create, modify
  • Work with PivotTables, PivotCharts, and Slicers
  • Import external data from a variety of sources into Excel

Who should attend

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

Prerequisites

The learners are expected to be familiar with concepts covered in MS Excel Level 2

Course Materials and Fees

Course materials will be provided to each learner. Required Software: MS Excel 2016 or MS Excel 2019 required (not included with course materials). MS Excel 2013 or earlier not supported. This course does not support Mac computers.

Microsoft Learn for Educators (MSLE) Member

$350

1 day

4 session(s) available

Loading session(s)

Choose a session

Select a date to register

For more information about individual or group registration please call 1-833-282-6852 or email training@algonquincollege.com.

Government of Canada Employees

Take advantage of our Standing Offers and Supply Arrangements with the Government of Canada to receive a discount when you register for training.

Download the course brochure