Popular Selections:
academics tabathletics tabstudent life tabfeatured events tab
 

About This Event

Summary

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.