Excel 3 2003 - Option 2 FE

Download PDF

Next Dates:

No dates available yet

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