Word Processing Services in Toronto Ontario, Night School Toronto, Web Design School in Toronto, Graphic Design Schools in Toronto.
IT, Engineering & Executive Recruitment Specialists, Professional Resume Writing, Interview Coaching and Skills Development

Microsoft Excel 2003-Level 3

Duration: One Day(10AM to 4PM with One Hour Lunch Break)
                  (Weekdays & Saturday)

Cost: $699 +HST

Class Size: 1-3 Persons,Instructor lead training

Course Outline

Lesson 1: 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

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

Lesson 3: 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

Lesson 4: 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

Lesson 5: Working with Multiple Workbooks
Create a Workspace
Consolidate Data
Link Cells in Different Workbooks
Edit Links

Lesson 6: Importing and Exporting Data
Export to Microsoft Word
Import a Word Table
Import Text Files

Lesson 7: Structuring XML Workbooks
Develop XML Maps
Import, Add, and Export XML Data
Manage XML Workbooks
Apply XML View Options

For more information please call us at (647) 271-3330 or Email us at: support@writing4careers.com



©2010 | All rights reserved | Webmaster: Rachel Ma