NewEra Technology Facebook
Microsoft Excel 2007 Level 2 - Course Information
PRINT
SEND TO A FRIEND
Name: Microsoft Excel 2007 Level 2
Category: Microsoft Office Suite
Length (Days): 1
Course Price (CAD): 245
Description:
The target students for this course are those who desire to gain the skills necessary to create templates, sort and filter data, analyze data, create charts and Pivot tables.

Participants will also continue to build on the skills learned in Level 1 regarding the creation of formulas.
Prerequisites:
Excel 2007 Level 1 or equivalent knowledge
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

Inserting Graphic Objects
• Insert and Modify Pictures and ClipArt
• Draw and Modify Shapes
• Illustrate Workflow Using SmartArt Graphics
• Layer and Group Graphic Objects

Customizing and Enhancing Workbooks and the Excel Environment
• Customize the Excel Environment
• Customize Workbooks
• Manage Themes
• Create and Use Templates
Guaranteed to run courses