Microsoft Excel 2007 Expert
Aims for this course
Course Agenda
Add-ins, Smart Tags, and Digital Security
Add-ins
and the Trust Center
What
is a COM Add-in?
Add-In Management
Installing Add-ins
Using the Trust Center
Add-Ins
Information
Rights Management
What
is IRM?
Requirements for IRM
Downloading and Installing the Rights Management Client Software
Using IRM
Opening an IRM Protected Document
Digital
Signatures
What
is a Digital Signature?
Obtaining a Digital Signature
Attaching your Signature to a Workbook
Smart
Tags and XML
What
is a Smart Tag?
Inserting Smart Tags into a Worksheet
Setting Smart Tag Options
Creating Custom Smart Tags
Review
Questions
Macros, VBA, and Excel Programming
Macros
Recording
Macros
Playing a Macro
Macro Security
Step-By-Step
Skill Sharpener
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
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
Expert Topics
Form
Controls
What
is a Form Control?
Adding a Control to a Worksheet
Assigning a Macro to a Control
Using Form Controls
Advanced
Functions
Using
Financial Functions
Understanding Logical Functions
Applying Logical Functions
Using
SharePoint
Creating
a Document Workspace
Accessing a Workspace
Publishing to a Document Workspace
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
Course Title
Microsoft Excel 2007 Advanced
Cost per delegate
£145 +vat
Who is this course for?
Experienced MS Excel 2007 users or who have attended the MS Excel 2007 Advanced course
> MS Excel 2007 Foundation
> MS Excel 2007 Intermediate
> MS Excel 2007 Advanced
When is this course running?
Click here to view the latest course schedule
