MICROSOFT EXCEL 230
76 minutes
Lesson 1. Multisheet Ranges
Selecting Multisheet (3D) Ranges
Tracking sales for multiple years
Formatting multiple sheets with one selection
Creating a summary sheet
Lesson 2. Go To > Special
Comments, Formulas, Blanks,
Current Region, Objects, Row & Column Differences
Precedents & Dependents, Last Cell
Visible Cells Only, Conditional Formats,
Data Validation
Lesson 3. Advanced Find & Replace
Find, Replace Options
Wildcards: *, ?
using tilde ~ to find a wildcard character
Find Format > Choose Format From Cell
Find in Sheet, Workbook
Find All
Selecting all found cells
Find in Formulas, Values, Comments
Match Case
Match Entire cell
Careful when doing Replace All, esp w numbers!
Lesson 4. File Options
AutoRecover
AutoRecover Options
Saving Your AutoRecover file
File Save Options
Creating Automatic Backups
Password to Open, Modify
Encryption
Workbook Summary
Summary Fields (Subject, Title, etc.)
Custom Fields - creating a workbook database
Item, Type, Data
Lesson 5. Templates
Understanding templates
Modifying the default Excel template
Setting up custom workbook templates
Book.xlt, Sheet.xlt
XLStart Folder
|