Excel: Managing Lists and Databases (Headquarters)
Upcoming sessions
To register, you will be prompted to sign in.
17 January 2023
Virtual
09:00 to 12:00 EST
French
See more dates
Overview
Delivery method
Classroom
Virtual Classroom
Duration
3 hours
Audience
Employees
This course at the intermediate/advanced level teaches participants how to use the many file management tools and checkers available in Excel 2010. Participants will learn how to add and edit tables, perform sort and filter operations, and how to use Excel as a database. Participants will learn about Excel's automatic grouping, outlining, and subtotalling features.
Learning Objectives
Upon completion of this course, participants will be able to:
- work with tables
- use Excel as a database and work with records and fields
- filter and sort data
- cell Formatting/Conditional Formatting
- use Custom AutoFill Lists
- work with Range Names
- insert Headers and Footers
- print the Worksheet/Workbook
Legacy course code: 00012459
Additional upcoming sessions
Date and Time | Session code | Location | Language | Status | |||
---|---|---|---|---|---|---|---|
|
03 August 2022 09:00 to 12:00 EST | IT9577-EN-2022-001 | Virtual | English | Full | Sign in to enrol | More Info |
|
07 September 2022 09:00 to 12:00 EST | IT9577-EN-2022-002 | Virtual | English | Full | Sign in to enrol | More Info |
|
16 January 2023 09:00 to 12:00 EST | IT9577-EN-2022-005 | Virtual | English | Full | Sign in to enrol | More Info |
|
17 January 2023 09:00 to 12:00 EST | IT9577-FR-2022-001 | Virtual | French | Full | Sign in to enrol | More Info |
|
24 April 2023 09:00 to 12:00 EST | IT9577-EN-2023-001 | Virtual | English | Full | Sign in to enrol | More Info |
|
25 April 2023 09:00 to 12:00 EST | IT9577-FR-2023-001 | Virtual | French | Full | Sign in to enrol | More Info |