Training & Events

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.