Fully Customizable Courseware For Trainers
Microsoft Office Excel 2007: Expert
DOWNLOAD A FREE SAMPLE
Microsoft Office Excel 2007: Expert training materials can help you make sure that your students are ready for expert status!? Have they already received training in the foundation, intermediate and advanced level curriculum? Velsoft courseware and training materials can help you take them to the next level!
Are you an expert? Are you looking to create a group of experts to deploy throughout your organization as efficiency stimulators?
Here are just a few of the topics and lessons covered in this Microsoft Office Excel 2007: Expert courseware:
- What is a COM Add-in?
- Add-In Management
- What is IRM?
- Requirements for IRM
- What is a Digital Signature?
- What is a Smart Tag?
- Recording Macros
- Recording a Relative Reference Macro
- Running a Relative Reference Macro
- Opening the Visual Basic Editor
- What is a Form Control?
- Using Financial Functions (PMT and FV)
- Creating a Document Workspace
- Accessing a Workspace
- Adding Buttons and VBA Code
And many more topics!
Are you ready?
Our Microsoft Office Excel 2007: Expert courseware is fully customizable so the instructor can add whatever content they deem necessary (or take away whatever is not).
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
Everything you need to deliver amazing training
Each courseware title is a trainers' kit that comes with the following course components:
Instructor Guide
Velsoft Instructor Guides are the core of each training course. Our Instructor Guides lay out the training in simple, easy-to-follow instructions. You can also customize the Instructor Guides in order to personalize your training.
Student Manual
Each Instructor Guide - for each course - is paired with a Student Manual that you can present to your participants. This customizable Student Manual gives each participant the ?student? version of the course you will be teaching.
Exercise Workbook
Velsoft offers an Exercise Workbook (also customizable) that is specific to the course you are offering. You can choose whether this is something you would like to present to your students.
Sample Files
Pre-made Sample Exercise Files are provided for use with the Lab Workbook so that you, as the trainer, do not have to prepare activity working files.
PowerPoint Deck
Courseware from Velsoft is designed to give you everything you need for use in the classroom or for your workshop. This includes the PowerPoint versions of all the courses, prepared for you in advance.
Quick Reference Guide
Quick Reference Guides are a favorite tool for trainers to provide to their learners. Each Quick Reference Guide summarizes the most important elements in each courseware title down to two pages.
Fully Customizable
Make any changes you like including easily taking our branding off and replacing it with yours.
Unlimited Users
Train as many participants at your location as you like - forever!
Unlimited Printing Rights
Print-on-demand only what you need for as many participants with no limits.
No Annual Renewal Fees
One-off pricing. Never pay again to use the materials.
