Excel 2007 Expert
Course Description
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
View other Excel Courses available
1 Day
Contact us for pricing
Prerequisites
To ensure the successful completion of the Expert course, the completion of the Advanced course or equivalent knowledge is recommended.Add-ins, Smart Tags, and Digital Security
Add-ins and the Trust CenterWhat 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
Macros, VBA, and Excel Programming
MacrosRecording Macros
Playing a Macro
Macro Security
More Macro Tasks
Recording a Relative Reference MacroRunning 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 EditorAdding 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 ControlsWhat is a Form Control?
Adding a Control to a Worksheet
Assigning a Macro to a Control
Using Form Controls
Advanced Functions
Using Financial FunctionsUnderstanding Logical Functions
Applying Logical Functions
Using SharePoint
Creating a Document WorkspaceAccessing a Workspace
Publishing to a Document Workspace
User Forms and ActiveX Controls
Creating a Blank User FormAdding Controls to the Form
Adding Buttons and VBA Code
Starting the User Form with a Macro
Excel 2007Microsoft Excel 2007