Microsoft Excel 2007 Class 3
| Duration: | 1 day (7 hours) |
| Prerequisite: | Excel Intermediate or equivalent experience. |
| Course Materials: | Course manual with CD containing exercises, 144 pages |
| Prices: | $195 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
- Understanding Templates
- Creating a New Workbook from a Template
- Creating Templates
Lookup, Reference, and Information Functions
- The Basic Lookup
- Information Functions
The Anatomy of the VLOOKUP Function
- The Function Description
- Building a Basic VLOOKUP Function
- Using the VLOOKUP Function to Fill in Data
- Using the VLOOKUP Function to Find an Approximate Match
- Nesting a VLOOKUP in an IF Function
Scenarios and Goal Seeking
- Using Scenarios
- Using Goal Seek
Protecting Your Workbooks
- Understanding Excel's Safeguards
- Data Validation
- Locked and Hidden Cells
Exchanging Data With Other Programs
- Sharing Information in Windows
- Embedding and Linking Objects
- Transferring Data
Automating Tasks with Macros
- Macros 101
- The Macro Recorder
- Macro Security
- Creating Practical Macros