Excel: Managing Lists and Databases (Missions)

Overview

Delivery method

Virtual Classroom

Duration

1 day

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