Excel: Managing Lists and Databases (Headquarters)
Upcoming sessions
To register, you will be prompted to sign in.
June 13, 2024
Virtual
9:00 am to 12:00 pm (ET)
English
June 27, 2024
Virtual
9:00 am to 12:00 pm (ET)
French
View more details
Overview
Delivery method
Classroom
Virtual Classroom
Duration
3 hours
Audience
Employees
Description
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 | Available seats | |
---|---|---|---|---|---|
June 13, 2024, 9:00 am to 12:00 pm (ET) | IT9577-EN-2024-001 | Virtual | English | 2 | Sign in to register |
June 27, 2024, 9:00 am to 12:00 pm (ET) | IT9577-FR-2024-001 | Virtual | French | 6 | Sign in to register |