NewEra Technology Facebook
Microsoft Excel 2003 Level 3 - Course Information
PRINT
SEND TO A FRIEND
Name: Microsoft Excel 2003 Level 3
Category: Microsoft Office Suite
Length (Days): 1
Course Price (CAD): 245
Description:
This course was designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, along with creating PivotTables and PivotCharts.
Prerequisites:
Excel 2003 Level 1 and Level 2 or equivalent knowledge

Participants should have basic Windows operating skills (Computers 101 class or equivalent). This includes understanding the basic operation of a mouse and keyboard, being able to navigate the Windows hierarchy, as well as being able to open and close files in an application.
Outline:
Streamlining Workflow
• Create a Macro
• Edit a Macro
• Customize Access to Excel Commands
• Apply Conditional Formatting
• Add Data Validation Criteria
• Update a Workbook's Properties
• Modify Excel's Default Settings

Collaborating with Others
• Protect Files
• Share a Workbook
• Set Revision Tracking
• Review Tracked Revisions
• Merge Workbooks
• Adjust Macro Settings
• Administer Digital Signatures

Auditing Worksheets
• Trace Cell Precedents
• Trace Cell Dependents
• Locate Errors in Formulas
• Locate Invalid Data and Formulas
• Watch and Evaluate Formulas
• Group and Outline Data

Analyzing Data
• Create a Trendline
• Create Scenarios
• Perform What-If Analysis
• Develop a PivotTable© Report
• Develop a PivotChart© Report
• 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