iCellini Computer Training

San Diego’s Onsite Computer Training Company

home icon email icon

Microsoft Excel 2007 Class 3

Duration: 1 day (about 6 hours)
Prerequisite: Excel Intermediate or equivalent experience.
Course Materials: Course manual with CD containing exercises, 144 pages
Prices: $225 for 1 student (one-on-one training)
$160 each for 2 to 3 students
$130 each for 4 to 6 students
$130 for the first 6 students, $100 for each additional student
Description: Templates can save you a lot of time by saving a worksheet—all it's formatting, formulas, and labels—so it can be used again. You'll learn how to create templates. The V-LOOKUP function is another function that is very useful. You will learn how to create different variations of the V-LOOKUP function. You will create different scenarios of your worksheet and also learn what goals you need to seek in order to get a certain result. You will also learn to protect your worksheet and workbook so no one can accidentally or purposely sabotage your work. Lastly, you will learn to automate your work with macros.

Templates

Lookup, Reference, and Information Functions

The Anatomy of the VLOOKUP Function

Scenarios and Goal Seeking

Protecting Your Workbooks

Exchanging Data With Other Programs

Automating Tasks with Macros

Top of Page

Return to Microsoft Excel list of classes