Course outline for
Microsoft Office Excel 2007 - Expert

Section 1: Add-ins, Smart Tags, and Digital Security

Lesson 1.1: Add-ins and the Trust Center

What is a COM Add-in?

Add-In Management

Installing Add-ins

Using the Trust Center

Add-Ins

Step-By-Step

Skill Sharpener

Lesson 1.2: Information Rights Management

What is IRM?

Requirements for IRM.

Downloading and Installing the Rights Management Client Software

Using IRM.

Opening an IRM Protected Document

Step-By-Step

Skill Sharpener

Lesson 1.3: Digital Signatures

What is a Digital Signature?

Obtaining a Digital Signature

Attaching your Signature to a Workbook

Step-By-Step

Skill Sharpener

Lesson 1.4: Smart Tags and XML

What is a Smart Tag?

Setting Smart Tag Options

Inserting Smart Tags into a Worksheet

Creating Custom Smart Tags

Step-By-Step

Skill Sharpener

Section 1: Case Study

Section 1: Review Questions

Section 2: Macros, VBA, and Excel Programming

Lesson 2.1: Macros

Recording Macros

Playing a Macro

Macro Security

Step-By-Step

Skill Sharpener

Lesson 2.2 More Macro Tasks

Recording a Relative Reference Macro

Running a Relative Reference Macro

Assigning a Keystroke to a Macro

Copying a Macro from a Workbook or Template

Step-By-Step

Skill Sharpener

Lesson 2.3: Visual Basic and Macros

Opening the Visual Basic Editor

Adding Code to your Macro

Adding Comments to VBA Code

Declaring Variables

Prompting for User Input

Iteration over a Range

Using If-Then-Else Statements

Step-By-Step

Skill Sharpener

Section 2: Case Study

Section 2: Review Questions

Section 3: Expert Topics

Lesson 3.1: Form Controls

What is a Form Control?

Adding a Control to a Worksheet

Assigning a Macro to a Control

Using Form Controls

Step-By-Step

Skill Sharpener

Lesson 3.2: Advanced Functions

Using Financial Functions (PMT and FV)

Understanding Logical Functions

Applying Logical Functions

Step-By-Step

Skill Sharpener

Lesson 3.3: Using SharePoint

Creating a Document Workspace

Accessing a Workspace

Publishing to a Document Workspace

Step-By-Step

Skill Sharpener

Lesson 3.4: User Forms and ActiveX Controls

Creating a Blank User Form

Adding Controls to the Form

Adding Buttons and VBA Code

Starting the User Form with a Macro

Step-By-Step

Skill Sharpener

Section 3: Case Study

Section 3: Review Questions

Index