Analyzing Data in Excel 2007

Course details

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.

• 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