|
|
|
|
Course Number:
|
07XL04 |
 |
Course Title:
|
Microsoft Excel 2007 Expert |
No classes scheduled.
|
Know someone who
needs this course? |
 |
|
|
Length:
|
1 Day(s)
|
|
Description:
Use COM add-ins; manage and install Add-Ins; use the Trust Center; download and install the IRM client software; use IRM to protect a workbook; view an IRM protected workbook; obtain a digital signature; attach a signature to your workbook; insert a Smart Tag into your workbook; set up Smart Tag options; create your own custom Smart Tag.
What you will learn:
- Add-ins and the Trust Center; Information Rights Management; digital Signatures; Smart Tags and XML; Macros; Visual Basic and Macros; Advanced Functions; using SharePoint, Forms and ActiveX Controls.
Audience:
Expert Level - comprehension of Foundation, Intermediate and Advanced Levels
Prerequisites:
- Understanding of Excel 2007 Foundation, Intermediate & Advanced level concepts.
Outline:
- Section One: Add-Ins, Smart Tags and Digital Security
- Lesson 1.1: Add-Ins and the Trust Center
- Lesson 1.2: Information Rights Management
- Lesson 1.3: Digital Signatures
- Lesson 1.4: Smart Tags and XML
- Section Two: Macros, VBA, and Excel Programming
- Lesson 2.1: Macros
- Lesson 2.2: More Macro Tasks
- Lesson 2.3: Visual Basic and Macros
- Section Three: Expert Topics
- Lesson 3.1: Form Controls
- Lesson 3.2: Advanced Functions
- Lesson 3.3: Using SharePoint
- Lesson 3.4: User Forms and ActiveX Controls
|
|
|