The IUPUI Events system is being retired on December 1, 2015 and will be moving to the new One.IU Calendar system.
Please contact for more information on how to be migrated.

Popular Selections:
academics tabathletics tabstudent life tabfeatured events tab

About This Event


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

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:

Bookmark and Share

Event Schedule

There are no upcoming dates for this event.