|
CompuEase ~ Microsoft & Adobe Software Training Ottawa Cancellation Policy
Description: 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
Pre-Requisites: Participants must have good working knowledge of Excel Introduction and Excel Intermediate.
Certificates offered: Certificate of completion
Duration Details: 1 day
9:00am - 4:00pm
Facility Location: CompuEase Training Classroom
124 O'Connor, Suite 204
Ottawa
ON
Canada
K1P 5M9
|
