Excel Data Management
O365/2021/2019/2016
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.
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