Lesson 11 - Using Templates
Working with Templates
Saving a Workbook as a Template
Using a Template
Editing a Template
Inserting a New Worksheet
Deleting a Template
Creating Default Templates
Lesson 12 - Using Paste Special
Working with Paste Special
Copying Values between Worksheets
Copying Formulas between Worksheets
Performing Mathematical Operations
Lesson 13 - Customizing Excel Preferences
Setting View Options
Setting Edit Options
Setting General Options
Lesson 14 - Using Worksheet Protection
Unlocking Cells in a Worksheet
Protecting a Worksheet
Unprotecting a Worksheet
Creating Allow-Editing Ranges
Deleting Allow-Editing Ranges
Protecing Workbook Windows
Workshop Information Page |
Lesson 14 - Using Worksheet Protection
Unprotecting Workbook Windows
Assigning a Password
Opening a Password-protected File
Removing a Password
Setting Manual Calculation
Resetting Automatic Calculation
Using the Document Recovery Pane
Lesson 15 - Sharing Workbooks
Using Shared Workbooks
Saving a Shared Workbook
Viewing Users Sharing a Workbook
Viewing Shared Workbook Changes
Changing the Update Frequency
Highlighting Changes
Managing Conflicting Changes
Resolving Conflicting Changes
Setting Change History Options
Adding a History Worksheet
Reviewing Tracked Changes
Merging Shared Workbook Files
|
