Excel 3 2003 - Option 2

Download PDF

Next Dates:

Fri, 02. Mar. 2012
Mon, 28. May. 2012

Length:

1 day

Location:

Ottawa

Language:

Max Attendees:

10 students

Price:

$ 235

Target audience & Prerequisites:

This course is designed for users who are familiar with Excel and want to expand their knowledge. Participants must have good working knowledge of Excel Introduction and Excel Intermediate.

Learning objectives:

Upon completion of the course, you will be able to protect and unprotect worksheets and workbooks, use goal seek, auditing toolbar, data tables, scenarios as well as create and edit macros.

Course Outline:

WORKSHEET PROTECTION

Assigning a Password
Opening a Protected File
Removing a Password
Unlocking Cells in a Worksheet
Protecting a Worksheet
Unprotect a Worksheet

SHARING WORKBOOKS

Using Shared Workbooks
Saving a Shared Workbook
Viewing Users Sharing a Workbook
Using Track Changes
Workbook Protection

WORKING WITH MACROS

Creating Macros

Running, Editing and Deleting Macros

Assigning Macros to the Toolbar and Macro Buttons

Using Relative References
Deleting a Macro from a Menu

Deleting a Macro

WHAT-IF SCENARIOS

Creating Scenarios
Editing Scenarios
Scenarios Reports

ADVANCED FEATURES

Using Goal Seek
Using Data Tables

AUDITING TOOLBAR

Auditing Toolbar Menu
Trace Dependents and Precedents
Trace Error
Show Watch Window

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