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
Date: July 16, 2020
Location: 1000 Waverley St. Winnipeg
Time: 8:30 am to 4:00 pm
Member Pricing: $75.00
Non-Member Pricing: $125.00
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.