Excel 2007 Expert
This Expert course is designed for experienced Excel users who wish to use begin to programme Excel 2007 using Add-Ins, XML, Macros, VBA and ActiveX controls.
View other Excel Courses available
- Cost: Price on application
- Duration: 1 Day
- This course is not available as part of our public schedule but can be provided on a customised client specific basis.
To ensure the successful completion of the Expert course, the completion of the Advanced course or equivalent knowledge is recommended.
Add-ins and the Trust Center
What is a COM Add-in?
Using the Trust Center
What is IRM?
Requirements for IRM
Downloading and Installing the Rights Management Client Software
Opening an IRM Protected Document
What is a Digital Signature?
Obtaining a Digital Signature
Attaching your Signature to a Workbook
What is a Smart Tag?
Inserting Smart Tags into a Worksheet
Setting Smart Tag Options
Creating Custom Smart Tags
Playing a Macro
Recording a Relative Reference Macro
Running a Relative Reference Macro
Assigning a Keystroke to a Macro
Copying a Macro from a Workbook or Template
Opening the Visual Basic Editor
Adding Code to your Macro
Adding Comments to VBA Code
Prompting for User Input
Iteration over a Range
Using IF Then Else Statements
What is a Form Control?
Adding a Control to a Worksheet
Assigning a Macro to a Control
Using Form Controls
Using Financial Functions
Understanding Logical Functions
Applying Logical Functions
Creating a Document Workspace
Accessing a Workspace
Publishing to a Document Workspace
Creating a Blank User Form
Adding Controls to the Form
Adding Buttons and VBA Code
Starting the User Form with a Macro