Course Overview

In this course, students will learn how to automate common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications.

Delivery

Classroom

Duration

1 Day

Locations

• Classroom - Brisbane, Melbourne, Perth and Sydney
• Group Bookings - All States and Territories across Australia

Related Courses

Excel 2007 - Level 1

Excel 2007 - Level 2

Course Outline

Lesson 1: Streamlining Workflow

• Create a Macro
• Edit a Macro
• Apply Conditional Formatting
• Add Data Validation Criteria
• Update Workbook 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
• Mark a Workbook as Final

Lesson 3: Auditing Worksheets

• Trace Cell Precedents
• Trace Cell Dependents
• Troubleshoot Errors in Formulas
• Troubleshoot Invalid Data and Formulas
• Watch and Evaluate Formulas
• Create a Data List Outline

Lesson 4: Analyzing Data

• Create a Trendline
• Create Scenarios
• Perform What-If Analysis
• 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 an Excel Worksheet to Microsoft Word
• Import a Word Table
• Import a Delimited Text File

Lesson 7: Using Excel with the Web

• Publish a Worksheet to the Web
• Import Data from the Web
• Create a Web Query

Lesson 8: Structuring XML Workbooks

• Develop XML Maps
• Import and Export XML Data
• Manage XML Workbooks