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:
•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
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
•create simple charts
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.