Analyzing Data in Excel 2007

Overview/Description
Excel 2007 provides powerful data analysis tools that enable you to explore large amounts of data and to make educated business decisions based on that data. With PivotTable reports you can interactively summarize data, making it easier to analyze and present the results. PivotChart reports provide a graphical view of PivotTable report data. Using Goal Seek and Solver enables you to retrieve required results from formulas by determining the data the formula requires. You can also use additional what-if analysis components, data tables and scenarios, to view how value changes in formulas affect the formula results and to forecast worksheet outcome models respectively. This course covers advanced data analysis features, such as PivotTable and PivotChart reports, Goal Seek, Solver, scenarios, data tables, and OLAP.

Target Audience
End users seeking proficiency in the use of Microsoft Excel 2007 at a power user level or seeking to obtain Microsoft Office Specialist (MOS) certification in Microsoft Excel 2007 at an Expert level or an equivalent.

Prerequisites
Some knowledge of word processing, computing, and spreadsheets; familiarity with the Microsoft Office work environment; an understanding of the Internet and web-page functionality

Expected Duration (hours)
3.5

Lesson Objectives

Analyzing Data in Excel 2007

create a PivotTable report

rearrange PivotTable data

customize PivotTable reports

modify the look and feel of a PivotTable report

create a PivotChart report

modify a PivotChart report

perform calculations in PivotTables reports

recognize when to use each calculation type

create a PivotTable report

customize a PivotTable report

change the summary calculation in a PivotTable report

create a calculation with a formula

create a PivotChart

use Goal Seek to perform data analysis

use Solver to perform data analysis

create scenarios for what-if analysis

use the Scenario Manager to modify scenarios

create a one-variable data table for data analysis

create a two-variable data table for data analysis

project values in a series

perform advanced functions

match advanced functions with examples of when you would use them

consolidate data from different workbooks using a Summary function

use Goal Seek

use Solver to perform what-if analysis

create a data table to perform what-if analysis

use advanced functions and consolidate data