Excel 3 2007

Download PDF

Next Dates:

Tue, 10. Jul. 2012

Length:

1 day

Location:

Ottawa

Language:

Max Attendees:

10 students

Price:

$ 235

Target audience & Prerequisites:

In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets, collaborating on worksheets with others, and sharing Excel data with other applications. Microsoft Office Excel 2007: Level 2 & 3.

Learning objectives:

You will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications.

Course Outline:

Streamlining Workflow

Create a Macro
Edit a Macro
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
Administer Digital Signatures
Restrict Document Access

Auditing Worksheets

Trace Cells
Troubleshoot Errors in Formulas
Troubleshoot Invalid Data and Formulas
Watch and Evaluate Formulas
Create a Data List Outline

Analyzing Data

Create a Trendline
Create Scenarios
Perform What-If Analysis
Perform Statistical Analysis with the Analysis ToolPak

Working with Multiple Workbooks

Create a Workspace
Consolidate Data
Link Cells in Different Workbooks
Edit Links

Importing and Exporting Data

Export Excel Data
Import a Delimited Text File

Using Excel with the Web

Publish a Worksheet to the Web
Import Data from the Web
Create a Web Query
Structuring Workbooks with XML
Develop XML Maps
Import and Export XML Data

Remember that we build our schedule around your requests. Check out our Courses List, call us at (613) 235-6161 or email us at training@compuease.ca:

Calendar

Search

Course List