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