Excel

ACADEMIC TECHNOLOGY SUPPORT

Microsoft Excel:

Tables & Pivot Tables

ats@etsu.edu | 439-8611 www.etsu.edu/ats

Table of Contents:

Overview................................................................................................................ 1 Objectives .............................................................................................................. 1 1. What is an Excel Table? ................................................................................... 2 2. Creating Pivot Tables........................................................................................ 4 3. Using Pivot Tables to Analyze Data................................................................ 7

Overview

The purpose of the workshop is to provide participants with an introduction to tables and pivot tables in Excel. Tables and pivot tables are extremely useful tools for performing a variety of very quick analyses on large data sets.

Objectives

At the completion of the workshop, participants should be able to: x x x Create a table and name the advantages of tables over ranges Create and modify pivot tables Customize pivot tables to specific needs

Support Contact: Jim Fulbright (fulbrigj@etsu.edu; 439-8568)

1

1. What is an Excel Table?

A table in Excel is a special structure that used to be simply a range of data. In this range, each row is a single entity… a transaction, an employee, a customer, a sale, etc. Typically, each column in a table contains a piece of information about the data, and has a descriptive label. Tables normally have a header row, and also a total row, but each of these can be turned off. To create a table from a range of data, simply click on the Insert tab, then Table.

Excel will then try to guess the range of your data, and by default, assume that your data has column headings. You’ll know that Excel has successfully created a table because now your header row will look different and you’ll see “Table Tools”...