SkillSoft Analyzing Data in Excel 2007
By admin • Mar 13th, 2009 • Category: Uncategorized
SkillSoft Analyzing Data in Excel 2007
by:
SkillSoft Analyzing Data in Excel 2007
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
Please Login or Register to read the rest of this content.
Related Posts
Leave a Reply
You must be logged in to post a comment.
