Excel: Managing Lists and Databases (Missions)

Product code: IT9578

Overview

Delivery method

Delivery method

Virtual Classroom

Duration

Duration

1 day

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: 00012460

No Current Offerings

Related products

Course
IT9577

Excel: Managing Lists and Databases (Headquarters)

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.
Date modified: 2022-07-11