IUPUI

This workshop lasts 3 hours, and is part of the certificate series Excel 2010 End-User

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. Participants will also learn how to work with multiple worksheets and how to save a workspace. This workshop also introduces pivot tables.

    What You'll learn Available Downloads

• specify data validation criteria

• separate and concatenate text strings

• record and use a macro

• protect a worksheet

• work with custom lists

• convert data to a table and work with table features

• sort and filter data

• create and remove subtotals

• create a pivot table

• link data between worksheets

• work with multiple worksheets

• compare workbooks and save a workspace

• Workshop Materials (PDF)

• Exercise Files (Win) (ZIP)

What you need to know

• 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

If you don't have those skills, consider first taking the workshop:

• Excel 2010: The Basics