Microsoft Excel 2007 - Level 3

Course Code:

nh3165LGEE

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

Related Courses

Course Schedule

Classroom

NSW - Sydney

St Martins Tower
Level 6, 31 Market Street