Excel: Managing Lists and Databases (Headquarters)

Product code: IT9577

Upcoming sessions

To register, you will be prompted to sign in.


July 14, 2025

Virtual

9:00 am to 12:00 pm (ET)


July 15, 2025

Virtual

9:00 am to 12:00 pm (ET)


View more details

Overview

Delivery method

Delivery method

Classroom

Virtual Classroom

Duration

Duration

3 hours

Audience

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
April 23, 2025, 9:00 am to 12:00 pm (ET) IT9577-FR-20250423 Virtual French Full
April 28, 2025, 9:00 am to 12:00 pm (ET) IT9577-EN-20250428 Virtual English Full
July 14, 2025, 9:00 am to 12:00 pm (ET) IT9577-FR-20250714 Virtual French 9
July 15, 2025, 9:00 am to 12:00 pm (ET) IT9577-EN-20250715 Virtual English 5
Date modified: 2022-07-11