Popular Selections:
academics tabathletics tabstudent life tabfeatured events tab

About This Event


 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

•compare workbooks



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 2013: The Basics

Bookmark and Share

Event Schedule

There are no upcoming dates for this event.