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.

Clear
SKU: N/A Category:

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. Those who are totally new to Excel should take our Excel Level-1 or Level-2 course first.

Prerequisites: Skills learned in our Excel Level-1 or Level-2 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 training is currently not available due to the COVID-19 pandemic)
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

06-Jan-2022, 03-Mar-2022, 28-Apr-2022, 23-Jun-2022, 18-Aug-2022, 13-Oct-2022, 08-Dec-2022, 20-Jan-2022, 17-Mar-2022, 12-May-2022, 07-Jul-2022, 01-Sep-2022, 27-Oct-2022, 22-Dec-2022