|
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
|
Student Interaction:
Microsoft Excel 230
|
Richard on 10/26/2007:
This class covers Multisheet Ranges (also called 3D ranges), Go To Special, Advanced Find & Replace, Wildcard Searches, Searching by Formats, File Options, AutoRecover, Password Protecting your Sheets, Workbook Summary Information, Custom Fields, Templates (Custom and Default). |
Peter Vogl on 11/15/2007: How to fill in address labels from an excel name and address list.
Please help.
|
Richard Rost on 11/21/2007: I think you're looking for MAIL MERGE which is taking a list of names and addresses in Excel and creating mailing labels out of them. If so, I cover this in WORD 201.
|
Getty on 2/12/2008: Have you had any request for Microsoft Excel version 2007 class,very confusing trying to find things.I would like to see that class offered.Thanks enjoy the new player very much
|
Richard Rost on 2/28/2008: Yes, I'm actually putting it together now. I hope to have it out soon.
|
|
|
