Microsoft^® Excel 2007 Level III Advanced

Target Student: builds on the skills and concepts taught in Excel 2007: Intermediate. Students will work with advanced formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX. In addition, students will learn about data validation and database functions such as DSUM. They will learn how to work with PivotTables and PivotCharts, how to import and export data, and how to query external databases. Finally, students will learn about the analytical features of Excel (such as Goal Seek and Solver), running and recording macros, and sharing Excel data via the Web.

Click here for a Table of Contents!

Course Content:

Lesson 1: Advanced Topics        

Setting Excel Options

Excel and Windows

Using the Excel Viewer

Lesson 2: Getting the Most from your Data

Getting the Most From Your Data

PivotTables

More About PivotTables

Exploring Scenarios

What If Analysis

Lesson 3: Excel and the Internet

Excel and Hyperlinks

Saving Workbooks as Web Pages

Getting Data from the Internet

Excel and Office Servers      

Lesson 4: Advanced Excel Tasks

Creating and Using Shared Workbooks

Using Custom AutoFill Lists

Using the VLOOKUP Function

Linking, Consolidating, and Combining Workbooks

Lesson 5: Macros, VBA, and Excel Programming

Macros

More Macro Tasks

Lesson 6: Expert Topics  

Form Controls

Advanced Functions