Microsoft EXCEL 2007: Level 3

Duration: 15 Hrs

Cost: $599 + HST

Enrollment for additional Course or second kid - 10% discount.

Grades 5 to 12 recommended.

Course Content

1. Lesson 1: Streamlining Workflow
1. Topic 1A: Create a Macro
2. Topic 1B: Edit a Macro
3. Topic 1C: Customize Access to Excel Commands
4. Topic 1D: Apply Conditional Formatting
5. Topic 1E: Add Data Validation Criteria
6. Topic 1F: Update a Workbook's Properties
7. Topic 1G: Modify Excel's Default Settings
2. Lesson 2: Collaborating with Others
1. Topic 2A: Protect Files
2. Topic 2B: Share a Workbook
3. Topic 2C: Set Revision Tracking
4. Topic 2D: Review Tracked Revisions
5. Topic 2E: Merge Workbooks
6. Topic 2F: Adjust Macro Settings
7. Topic 2G: Administer Digital Signatures
3. Lesson 3: Auditing Worksheets
1. Topic 3A: Trace Cell Precedents
2. Topic 3B: Trace Cell Dependents
3. Topic 3C: Locate Errors in Formulas
4. Topic 3D: Locate Invalid Data and Formulas
5. Topic 3E: Watch and Evaluate Formulas
6. Topic 3F: Group and Outline Data
4. Lesson 4: Analyzing Data
1. Topic 4A: Create a Trendline
2. Topic 4B: Create Scenarios
3. Topic 4C: Perform What-If Analysis
4. Topic 4D: Develop a PivotTableｩ Report
5. Topic 4E: Develop a PivotChartｩ Report
6. Topic 4F: Perform Statistical Analysis with the Analysis ToolPak
5. Lesson 5: Working with Multiple Workbooks
1. Topic 5A: Create a Workspace
2. Topic 5B: Consolidate Data
3. Topic 5C: Link Cells in Different Workbooks
4. Topic 5D: Edit Links
6. Lesson 6: Importing and Exporting Data
1. Topic 6A: Export to Microsoft Word
2. Topic 6B: Import a Word Table
3. Topic 6C: Import Text Files
7. Lesson 7: Structuring XML Workbooks
1. Topic 7A: Develop XML Maps
2. Topic 7B: Import, Add, and Export XML Data
3. Topic 7C: Manage XML Workbooks
4. Topic 7D: Apply XML View Options

For more information on any course, please call us at (647)-430-7478 or Email us at: hr@whizkids.ca