Popular Selections:
academics tabathletics tabstudent life tabfeatured events tab
 

About This Event

Summary

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.