Excel 2010-Managing & Analyzing Data

About the Class:

This workshop lasts 50 minutes.

Organizing and analyzing data can be made much quicker and easier in Excel by working with Excel’s table feature. This 50-minute workshop provides some simple techniques in analyzing data, such as inserting subtotals, creating tables and pivot tables, and sorting or filtering data.

What You’ll Learn:

  • Create, replace, and remove subtotals
  • Convert data to a table
  • Work with table features
  • Sort and filter data
  • Create a simple pivot table

What You Need to Know:

  • Understand spreadsheet terminology
  • Create basic formulas and functions
  • Enter text or numeric data

If you don’t have those skills, consider first taking the workshop:

  • Excel 2010 – The Basics

 

Resources

Excel 2010(PC) Excel 2011(Mac)
Microsoft Office: Create or Delete a Table  Microsoft Office: Create or Delete an Excel Table