Fully Customizable Courseware For Trainers
Microsoft Office Excel 2007: Expert
Our mission is to provide you with the best possible courseware so you can teach incredible classes and workshops
High quality course content - written for you
Save hundreds of hours in developing training materials. Download our proven content used by trainers in 164 countries worldwide.
Enjoy confidence in the classroom
Facilitate perfect workshops everytime with high-quality training material with all the training components you need.
Save time & money with pre-written materials
Focus your attention on the training and we'll take care of the materials.
Course description
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).
Course outline
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
What you get
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.
Sample Files
Each Velsoft courseware title comes with a Lab Workbook loaded with activities and exercises to practice and reinforce the learners' understanding of the course objectives. 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 workshop. This includes PowerPoint slides for classroom use, 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 in two pages the most important elements in each courseware title.
The best courseware in the world has Velsoft on the cover.
Our goal is to improve the daily life of those who train the world.
Velsoft empowers training providers with course material and educational technologies that get results.
Fully customizable
Easily make any changes to the material you like. Simply open in MS Word or Google Docs and localize the content to meet your training needs.
Unlimited reprinting
Print only what you need, when you need it. Print as many copies at your location as you like - forever. This includes editing and printing.
Unlimited users
Train as many people at your location as you like - forever. There is no per-user pricing or limit on the number of people that can be trained.
No annual renewal fees
This course comes with a perpetual license which means once you purchase it you never have to pay anything ever again.
COURSEWARE SAMPLE
Courseware you can customize.
View an eLearning Course
SCORM COMPLIANT
Available as an eLearning Course
ELEARNING SAMPLE
eLearning you can customize.
COURSEWARE SAMPLE
Courseware you can customize.
Safe & Inclusive Workplace
By Velsoft
Seeing Double
August Only
COURSEWARE SAMPLE
Courseware you can customize.