NewEra Technology Facebook
Microsoft Excel 2003 Level 3 - Course Information
Name: Microsoft Excel 2003 Level 3
Category: Microsoft Office Suite
Length (Days): 1
Course Price (CAD): 245
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.
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.
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