7/23/2017 11:41:11 PM: Our web site will be going down in 9 minutes for a routine reboot. We should only be offline for a few seconds, but this may log you off momentarily. If you're placing an order, please finish up as soon as possible. Sorry for the inconvenience.   [dismiss]
 
Excel 2010/2013
Excel 2007
Excel 2003
Tips & Tricks
Excel Forum
Course Index CIG Excel Book
 
Home   News   Tips   Glossary   Templates   Forums   Help   Logon   Order   Contact Us  
 
NEW Release: Access Developer Level 3   dismiss
 
 
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 7/26/2017 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

 
 
 

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).
Richard Rost on 10/26/2007: Now that you're done with the course, log on to the web site and tell me what you think of it! Fill out my customer survey here.

The next class in the series is Excel 231.

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 News:

 

Learn
 
Accessindex
Excelindex
Wordindex
Windowsindex
PowerPointindex
Photoshopindex
Visual Basicindex
ASPindex
Seminars
More...
Customers
 
Account Login
Online Theater
Downloads
Lost Password
Free Upgrades
Insider Circle
Student Databases
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Articles
Search Our Site
Waiting List
Production Schedule
Collapse Menus
Help
 
Live Chat
Customer Support
WalkThru Tutorials
Troubleshooting
FAQs
TechHelp
Consulting Services
About Us
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
MYOLP Memberships
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Gift CDs
Contact
 
Live Chat
General Info
Support Policy
Contact Form
Email Us
Mailing Address
Phone Number
Fax Number
Course Survey
Facebook    Twitter

Google Plus    LinkedIn

Blog RSS Feed    YouTube Channel
Richard Rost Microsoft MVP