Training & Events

Excel Level 3 Training

Microsoft Excel is a key tool in the Microsoft Office family. As a modern-day professional, it is important to be able to maximize the usage of this tool and leverage it to ensure smooth operations for your organization.

Who should attend?

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

Prerequisites

Microsoft Excel 2016 - Level 2 or 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, 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.

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

Course Instructor: Claudette Craig

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.

Date:

October 5, 2021

Location:

1000 Waverley St, Winnipeg

Time:

8:30am to 4:00pm

Food:

Lunch and coffee provided

Member Pricing (level 1 only):

$100

Member Pricing (Level 1, 2 and 3 bundle*):

$250

Student Pricing (Level 1 only):

$75 - please email. info@biomb.ca for the discount code

Student Pricing (Level 1, 2, and 3 bundle*):

$225 - please email info@biomb.ca for discount code

Non-member Pricing (Level 1 only):

$200

Non-member Pricing (Level 1, 2 and 3 bundle*):

$500

*Bundle only valid for Level 1 on Sept 22 and Level 2 on Sept 29 

Excel Level 3 - Oct 6, 2021

  • $200.00 (Members pay $100.00)

Back