Fully Customizable Courseware For Trainers
Microsoft Excel 2016 and VBA
DOWNLOAD A FREE SAMPLE
Give students the chance to expand on the knowledge they gained in previous Velsoft Excel 2016 courseware by introducing them to Microsoft Excel 2016 and VBA course.
Microsoft Office Excel 2016 and VBA continues Velsoft’s in-depth training material for Excel 2016. This course gives students the skills they need to harness Visual Basic for Applications, or VBA, to automate many tasks they encounter while using Excel 2016.
This comprehensive training package explores the following topics:
- Developing Macros
- Formatting Worksheets Using Macros
- Creating an Interactive Worksheet
- Working with Multiple Worksheets
- Performing Calculations
Each component in this Microsoft Excel 2016 and VBA training package is completely customizable. You can add your logo, rearrange lessons, create different examples, and much more. Each training package contains an instructor guide, student manual, quick reference guide, and PowerPoint slides.
Download a free sample today and see how easy training can be.
About This Course
Course Prerequisites
Course Overview
Course Objectives
How To Use This Book
Lesson 1: Developing Macros
Visual Basic for Applications
Object-Oriented Programming
Macros
Macro Options
The Macro Recorder
Personal Macro Workbooks
How to Create a Macro Using the Macro Recorder
Activity 1-1
The Visual Basic Editor
Projects
Modules
The Modules Folder
Objects
Properties
Methods
VBA Comments
How to Edit a Macro
Activity 1-2
The Debugging Process
Debugging Tools
How to Debug a Macro
Activity 1-3
How to Customize the Quick Access Toolbar and Hotkeys
Activity 1-4
Digital Certificates
Digital Signatures
Macro Security Settings
How to Set Macro Security
Activity 1-5
Summary
Review Questions
Lesson 2: Formatting Worksheets Using Macros
The Selection Property
The ActiveSheet Property
The Name Property
The Value Property
Concatenation
How to Insert Text
Activity 2-1
How to Format Text
Activity 2-2
The Range Object
The Select Method
The CurrentRegion Property
How to Sort Data
Activity 2-3
Data Types
Variables
Variable Naming Rules
Operators
The Assignment Operator
Arithmetic Operators
Comparison Operators
Logical Operators
The For Next Loop
Do Loops
The Worksheets Object
The Count Property
The Offset Property
The Copy Method
The Paste Method
How to Duplicate Data
Activity 2-4
The Columns Property
The AutoFit Method
The Address Property
The Call Statement
The Font Property
The End Property
How to Generate a Report
Activity 2-5
Summary
Review Questions
Lesson 3: Creating an Interactive Worksheet
Message Boxes
Input Boxes
Activity 3-1
The InputBox Function
Constants
The MsgBox Function
The Code Continuation Character
The vbCrLf Constant
Decision Structures
The Select Case Statement
The If Then Structure
The Else Clause
How to Capture User Input
Activity 3-2
Summary
Review Questions
Lesson 4: Working with Multiple Worksheets
The Add Method
The Copy Method
The Delete Method
How to Insert, Copy, and Delete Worksheets
Activity 4-1
Expressions
The DateSerial Function
The Format Function
How to Rename Worksheets
Activity 4-2
The Move Method
How to Modify the Order of Worksheets
Activity 4-3
The PrintPreview Method
The PrintOut Method
How to Print Worksheets
Activity 4-4
Summary
Review Questions
Lesson 5: Performing Calculations
User-Defined Functions
Types of Functions
Arguments
How to Create User-Defined Functions
Activity 5-1
Declared Range Objects
The Set Statement
Range Object Cell Addressing
The Rows Property
The Formula Property
The Columns Property
Address Property Cell Reference Settings
How to Automate SUM Functions
Activity 5-2
Summary
Review Questions
Lesson Lab 1-1
Lesson Lab 1-2
Lesson Lab 2-1
Lesson Lab 2-2
Lesson Lab 3-1
Lesson Lab 4-1
Lesson Lab 4-2
Lesson Lab 5-1
Appendices
Keyboard Shortcut Quick Reference Sheet
Glossary
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.
