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
Lesson Objectives
PivotTable Reports in Excel 2007
- create a PivotTable report
- rearrange PivotTable data
Excel 2007's PivotTable Tools
- customize PivotTable reports
- modify the look and feel of a PivotTable report
PivotChart Reports in Excel 2007
- create a PivotChart report
- modify a PivotChart report
Calculations in Excel 2007 PivotTables Reports
- perform calculations in PivotTables reports
- recognize when to use each calculation type
Creating PivotTable Reports in Excel 2007
Creating PivotChart Reports for Data Analysis
Work with Goal Seek and Solver in Excel 2007
- use Goal Seek to perform data analysis
- use Solver to perform data analysis
Create Scenarios in Excel 2007
- create scenarios for what-if analysis
- use the Scenario Manager to modify scenarios
Create a Data Table and Project Values in Excel 2007
- create a one-variable data table for data analysis
- create a two-variable data table for data analysis
- project values in a series
Use Advanced Functions in Excel 2007
- perform advanced functions
- match advanced functions with examples of when you would use them
- consolidate data from different workbooks using a Summary function
Performing Advanced Data Analysis in Excel 2007
|
Key Concepts:
|
|
Desktop Certifications, Microsoft, Microsoft Certified Application Specialist Certification, 77-602 Using Microsoft Office Excel 2007, Desktop Curricula, Microsoft Office 2007, Microsoft Office 2007: Excel for the Power User
|
|
|
Course Appears in these Categories:
|
• Desktop Certifications >> Microsoft >> Microsoft Certified Application Specialist Certification
• Desktop Skills >> Microsoft Office 2007 >> Microsoft Excel 2007: Power User
• Continuing Professional Education >> National Association of State Boards of Accountancy (NASBA)
|
|
|
Courses you might be interested in:
|
• Programmability and Administration in Access 2007
• Database Administration in Access 2007
• Importing and Exporting Data and Data Presentation in Access 2007
• Advanced Data Management in Access 2007
• Advanced Formatting in Excel 2007
• Advanced Data Management in Excel 2007
• Advanced Customization in Excel 2007
• Customizing Outlook 2007 and Using the Journal
• Configuring Rules, Alerts, and Junk E-mail Settings in Outlook 2007
• Working with SharePoint, Calendars, and Forms in Outlook 2007
• Creating Custom Slide Shows in PowerPoint 2007
|