NewEra Technology Facebook
Become an Excel 2007 Power User - Course Information
PRINT
SEND TO A FRIEND
Name: Become an Excel 2007 Power User
Category: Microsoft Office Suite
Length (Days): 1
Course Price (CAD): 495
Description:
Length: 1 day

DESCRIPTION
The objective of this 1-day workshop is to help bring individuals up to speed in some of the more advanced functions of MS Excel 2007 such as Analyzing Pivot Tables, what-if scenarios and other advanced formulas. After this workshop, individuals should be able to efficiently use Excel to increase the user productivity. It is a compilation of some of the most popular topics from our Excel level 2 and 3 courses combined into a single day.
Prerequisites:
Students should have Excel 2007 Level 1 class or equivalent knowledge (approximately 1 year experience with Excel). Students should already have prior knowledge on how to work through worksheets, do basic calculation, format worksheets and print workbooks.
Outline:
Calculating Data with Advanced Formulas
• Manage Cell and Range Names
• Calculate Data Across Worksheets
• Use Specialized Functions
• Analyze Data with Logical and Lookup Functions
Organizing Worksheet and Table Data
• Create and Modify Tables
• Format Tables
• Sort or Filter Worksheet or Table Data
• Calculate Data in a Table or Worksheet
Presenting Data Using Charts
• Create a Chart
• Modify Charts
• Format Charts
Analyzing Data Using PivotTables and PivotCharts
• Create a PivotTable Report
• Analyze Data Using PivotCharts
Customizing & Enhancing Workbooks and the Excel Environment
• Customize the Excel Environment
• Customize Workbooks
• Manage Themes
• Create and Use Templates
Auditing Worksheets
• Trace Cell Precedents
• Trace Cell Dependents
• Troubleshoot Errors in Formulas
• Troubleshoot Invalid Data and Formulas
• Watch and Evaluate Formulas
• Create a Data List Outline
Analyzing Data
• Create a Trendline
• Create Scenarios
• Perform What-If Analysis
• Perform Statistical Analysis with the Analysis ToolPak
Working with Multiple Workbooks
• Create a Workspace
• Consolidate Data
• Link Cells in Different Workbooks
• Edit Links
Guaranteed to run courses