Excel Data Management

CAD 285.00

Intensive, hands-on, half-day Excel Data Management course delivered online by a Live Trainer and not recorded Videos. Please read prerequisites and other details in the description below.

We have distinct course dates for Pacific and Eastern Time zones. You can explore both options below.

Excel Data Management

This course is designed for office users who work with or are likely to work with extensive data stored in Excel. The course will give you the tools to maintain a list database and massage and manipulate the data to obtain desirable results. Get a good handle on advanced sorting and filtering of data by taking this course. You should have a good working understanding of Excel.

Prerequisites: Skills learned in our Excel Beginner and Intermediate course or equivalent everyday work experience of using MS Excel. Proficiency in Windows environment with excellent mouse skills. Some keyboard skills also required.
Software Version: Microsoft Excel 2013/2016/2019/365
Course Duration: Half Day
Class Times-1: 9:00 AM to 1:00 PM Pacific Time (Vancouver)
Class Times-2: 9:00 AM to 1:00 PM Eastern Time (Toronto)
Course Pace and Style: Medium-to-Fast; Hands-on, Intensive, Interactive
Course Delivery Format: OnLine and In-Person
(In-Person option is available for group training only)
Course Outline Download: Excel Data Management
Cancellation & Date Change Policy: Cancellation Policy
Technical Requirements for Taking OnLine Courses: OnLine Tech Requirements

Course Outline

What is covered in the course?

  • Excel as a List Database: Important considerations
  • Using Data Validation for accurate data entry
  • Using GO TO command effectively
  • Cleaning your database: TRIM & CLEAN functions
  • Fixing numbers stored as text
  • How to create and manage an Excel Table
  • Excel Tables: Structured References for formulas
  • Multi-Column Sort (vertical & horizontal)
  • Creating a Custom List
  • Using Custom Sort when a normal sort won’t do
  • Sorting by a partial value in a column
  • Filtering data
  • How to use the Advanced Filter with complex criteria
  • Advanced Conditional Formatting for filtering
  • Using Excel Database Functions with complex criteria
  • Working with nested SUBTOTALs
  • Working with visible cells only


Class Start Time

9:00 AM Pacific Time, 9:00 AM Eastern Time

Course Date

12-Oct-2023, 07-Dec-2023, 04-Jan-2024, 29-Feb-2024, 25-Apr-2024, 20-Jun-2024, 15-Aug-2024, S, 26-Oct-2023, 21-Dec-2023, 18-Jan-2024, 14-Mar-2024, 09-May-2024, 04-Jul-2024, 29-Aug-2024