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.
It is recommended that IU staff take the IUIE Reporting Basics workshop or at least have some experience using the IUIE environment before taking this Excel workshop.
What you'll learn:
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
What you need to know:
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
If you don't have those skills, consider first taking the workshop:
IT – Informatics & Communications Technology Complex (ICTC)
535 W. Michigan St.
Indianapolis, IN 46202
There are no upcoming dates for this event.