Microsoft Excel 2007 Level 3
| Duration: | 1 day |
| Prerequisite: | Excel Introduction or equivalent experience. |
| Course Materials: | Course manual with CD containing exercises, 160 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: | This class covers the Advanced concepts of Microsoft Excel 2007 with performing "what if" analysis, creating PivotTables, exchanging Excel data with other programs, controlling worksheet properties and calculations, and programming with Excel. The manual is recognized as a Microsoft Approved Study Guide for the Microsoft Office Specialist Program Certification Exam. The manual is also a great reference for after the class. |
Lookup, Reference, and Information Functions
The Basic Lookup
Advanced Lookups
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
Pivot Tables
Summary Tables Revisited
Building Pivot Tables
Multi-Layered Pivot Tables
Fine-Tuning Pivot Table Calculations
Filtering a Pivot Table
Pivot Charts
Protecting Your Workbooks
Understanding Excel's Safeguards
Data Validation
Locked and Hidden Cells
Worksheet Collaboration
Preparing Your Workbook
Adding Comments
Tracking Changes
Sharing Your Workbook
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