Microsoft Office Excel 2007 - Advanced Course Outline

Microsoft Office Excel 2007 - Advanced

Section 1: Advanced Topics

Lesson 1.1: Setting Excel Options

Changing Your User Name

Changing your Default Font

Changing Your Default File Format

Setting Formula Options

Changing the Appearance of Your Excel Interface


Skill Sharpener

Lesson 1.2: Excel and Windows

Searching for Documents

Using Office Diagnostics

Checking for Updates

Starting Excel Automatically when Windows Boots


Skill Sharpener

Lesson 1.3: Using the Excel Viewer

What is the Excel Viewer?

Downloading the Excel Viewer

Using Excel Viewer


Skill Sharpener

Section 1: Review Questions

Section 2: Getting the Most From Your Data

Lesson 2.1: Getting the Most from Your Data

Using Automatic Outlining

Displaying and Collapsing Levels

Grouping Data Manually

Creating Subtotals


Skill Sharpener

Lesson 2.2: PivotTables

What is a PivotTable?

Creating a PivotTable

Creating a PivotTable Frame

Specifying PivotTable Data

Rearranging PivotTable Data


Skill Sharpener

Lesson 2.3: More About PivotTables

Modifying PivotTable Calculations

Formatting a PivotTable

Refreshing a PivotTable

Charting a PivotTable

Creating a PivotTable Based on External Data


Skill Sharpener

Lesson 2.4: Exploring Scenarios

What is a Scenario?

Creating a Scenario

Creating a Scenario Summary Report

Saving Multiple Scenarios


Skill Sharpener

Lesson 2.5: What If Analysis

Using a One and Two Input Data Table

Using Goal Seek

Using Solver


Skill Sharpener

Section 2: Case Study

Section 2: Review Questions

Section 3: Excel and the Internet

Lesson 3.1: Excel and Hyperlinks

What is a Hyperlink?

Inserting Hyperlinks

Modifying Hyperlinks

Using Hyperlinks in Excel


Skill Sharpener

Lesson 3.2: Saving Workbooks as Web Pages

HTM and MHTML Files

Saving a Workbook as a Web Page

Saving a Worksheet as a Web Page

Saving a Chart as a Web Page

Saving a Range as a Web Page


Skill Sharpener

Lesson 3.3: Getting Data from the Internet

Importing from an External Data Source

Creating a Web Query

Saving a Web Query

Refreshing a Web Query


Skill Sharpener

Lesson 3.4: Excel and Office Servers

Publishing to a Document Server

Saving to a Document Management Server

Using Excel with Excel Services


Skill Sharpener

Section 3: Case Study

Section 3: Review Questions

Section 4: Advanced Excel Tasks

Lesson 4.1: Creating and Using Shared Workbooks

Sharing a Workbook

Opening and Editing a Shared Workbook

Tracking Changes

Resolving Conflicts in a Shared Workbook


Skill Sharpener

Lesson 4.2: Using Custom AutoFill Lists

What is an AutoFill List?

Creating a Custom AutoFill List

Modifying a Custom AutoFill List

Using a Custom AutoFill List


Skill Sharpener

Lesson 4.3: Using the VLOOKUP Function

Using VLOOKUP to Find Data

How to Find an Exact Match with VLOOKUP

Finding the Closest Match with VLOOKUP


Skill Sharpener

Lesson 4.4: Linking, Consolidating, and Combining Workbooks

Linking Workbooks

Consolidating Workbooks

Combining Worksheets


Skill Sharpener

Section 4: Case Study

Section 4: Review Questions


Download this course as a demo

Complete the form below and we'll email you an evaluation copy of this course:

What You Get with Velsoft Courseware

More Course Outlines in this Series