| |
| |
|
Courses - Microsoft
Excel 230 |
| Description: |
Intermediate Microsoft Excel |
| Running Time: |
76 minutes |
| Pre-Requisites: |
Excel 224 strongly recommended |
| Versions: |
|
We use Excel XP in this course,
but the lessons are valid for all versions of Excel from 95 to 2003.
There are cosmetic changes in Excel 2007. Order before 8/30/2008 to
get a FREE upgrade to our 2007 version when released!
|
|
|
|
|
|
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
|
| |
|
Try a FREE Demo Lesson |
| |
| |
|
 |
Huge Discounts Available
When you purchase multiple classes together - up to 50% off! |
|
| |
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. |
|
|
| |
| |
|
You may want to read these articles from the 599CD Blog: |
|
| |
|
 |
Need
Help? |
| |
|
| Do you have
questions about
Word, Excel, Access, Web Design, or computers in general? Just
ask us anything you'd like. |
|
|
|
|
|
| |
|
CLICK HERE for a FREE
lesson |
Order
your first 599CD course now.
Your Satisfaction is Guaranteed!
|
|
|
|
|
|
|
|
|
|
