This workshop is specifically designed for any IU staff member who uses Excel to format IUIE data. Participants will learn how to format text and numeric data, create and remove subtotals, convert data to a table, sort and filter data, automate work using macros, and analyze data using pivot tables.

Note: This workshop was previously entitled: "Excel: Reporting for IUIE Users" and teaches IU staff members how to format and analyze data in Excel instead of how to extract and manipulate data from the IUIE.

(Description continued below)

Participants will:

• format text and numeric data
• use macros to automate tasks
• use AVERAGE, COUNTIF, and VLOOKUP functions
• create and remove subtotals
• convert data to a table and work with table features
• sort and filter data
• analyze data using pivot tables

The following workshops are suggested prerequisites to this workshop:

• Excel: The Basics

Participants should already be able to:

• navigate an Excel spreadsheet
• switch back and forth between Windows applications
• enter and edit data
• work with basic formulas and functions
• save and print a worksheet