Learn how to use lists to extract and manipulate data. Participants will explore Excel’s table-related features in this workshop, as well as creating custom lists, validating data entry, sorting and filtering data, creating and removing subtotals, and recording a macro. This workshop also introduces pivot tables and pivot charts.

(Description continued below)

Participants will:

• work with built-in and custom lists
• specify data validation criteria
• protect a worksheet
• work with text functions to separate and concatenate text
• edit and delete named ranges using the Name Manager
• convert data to a table and work with table features
• sort and filter data
• create, replace, and remove subtotals
• record and use a macro
• create and format a pivot table
• link data between worksheets
• create a pivot chart

The following workshops are suggested prerequisites to this workshop:

• Excel: The Basics

Participants should already be able to:

• understand spreadsheet terminology
• create and modify Excel spreadsheets
• enter text or numeric data and formulas or functions
• create named ranges
• format worksheets
• create simple charts