Excel: Managing Lists and Databases (Headquarters)

Product code: IT9577

Upcoming sessions

To register, you will be prompted to sign in.


17 January 2023

Virtual

09:00 to 12:00 EST


See more dates

Overview

Delivery method

Delivery method

Classroom

Virtual Classroom

Duration

Duration

3 hours

Audience

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 More Info
07 September 2022 09:00 to 12:00 EST IT9577-EN-2022-002 Virtual English Full More Info
16 January 2023 09:00 to 12:00 EST IT9577-EN-2022-005 Virtual English Full More Info
17 January 2023 09:00 to 12:00 EST IT9577-FR-2022-001 Virtual French Full More Info
24 April 2023 09:00 to 12:00 EST IT9577-EN-2023-001 Virtual English Full More Info
25 April 2023 09:00 to 12:00 EST IT9577-FR-2023-001 Virtual French Full More Info
Date modified: 2022-07-11