Training & Events

Excel Level 3

Course Objectives

  • 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, modify, and work with PivotTables, PivotCharts, and Slicers.
  • Import external data from a variety of sources into Excel.
  • Create and work with subtotalled lists, as well as use various database functions to summarize data.

Excel 365 Level 2 is a prerequisite for this course.


Course 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 Subtotalled Lists; Using Functions to Summarize Data
  • Working with PivotTables: PivotTable Concepts; Creating PivotTables; Modifying PivotTable Layouts; Working with PivotTables; PivotCharts; Slicers
  • Working with External Data: External Data Concepts; Importing Query Data from Access; Importing Query Data from Web Pages; Importing Query Data from Text Files

Date: June 27, 2023

Time: 8:30 am - 4:00 pm

Location 1000 Waverley Street | PC lab

Pricing

Member: $100.00 plus gts | Non-Member: $200 plus gst

Course Instructor


Claudette Craig is the owner of CD Consulting. She has more than 25 years of experience coordinating and facilitating courses, with a primary focus on the design and instruction of various Microsoft products. She has her Microsoft Office Specialist (MOS) certification at the Master Level. Her background includes working with a wide client-base in all business sectors, developing and implementing database applications and designing user reference materials and online training videos.

Back