" rel="stylesheet">
Page Content
This event has ended

# Pivots, Subtotals and Data Analysis in Excel 2007

## Birmingham, AL

### Ticket Information

 Ticket Type Sales End Price Fee Quantity Pivots, Subtotals and Data Analysis in Excel 2007 Ended \$175.00 \$0.00

Share Pivots, Subtotals and Data Analysis in Excel 2007

# Pivots, subtotals and data analysis in excel 2007

### Course Description

This course covers some of Excel's advance feature functionality in regards to Pivots, Subtotals and Data Analysis.

### COURSE OBJECTIVES

Upon completion of this course, the student will be able to:

·        Perform basic data analysis

·        Sort and filter data.

·        Subtotal Data

·        Work with Pivots

#### Lesson 1 – Working with Data Analysis

·        What If Analysis?

·        Scenarios

·        Merge Scenarios

·        Goal Seek

#### Lesson 2 – Sort and Filter Data

·        Sort Data

·        Filter Data

·        Clear Filters

#### Lesson 3 – Subtotal Data

·        Subtotal Data

·        Expand and Collapse Subtotals

·        Move Subtotals to other locations

#### Lesson 4 – Pivot Data

·        Create a Pivot Table

·        Format Pivots

·        Drill Down on Pivot Data

·        Add a Calculated Field to a Pivot

·        Create a Pivot Chart

·        Linking data from Pivot Table to Worksheet

·        Refresh Pivots

·        Difference From Calculations

Have questions about Pivots, Subtotals and Data Analysis in Excel 2007? Contact ThinkData Solutions, Inc