Fully Customizable Courseware For Trainers
Microsoft 365 Excel: VBA
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
Coming Soon
Course outline
About This Course
Course Prerequisites
Course Overview
Course Objectives
How to Use This Book
Lesson 1: Analyzing Data with Logical and Lookup Functions
TOPIC A: Use Text Functions
Text Functions
Logging into Office 365
Launching Excel Online
The LEFT and RIGHT Functions
The MID Function
The LEN Function
The TRIM Function
The UPPER, LOWER, and PROPER Functions
The CONCATENATE Function
The TRANSPOSE Function
Activity 1-1: Analyzing Data Using Text Functions
TOPIC B: Use Logical Functions
Logical Functions
Logical Operators
The AND Function
The OR Function
The IF Function
Activity 1-2: Analyzing Data Using Logical Functions
TOPIC C: Use Lookup Functions
Lookup Functions
The LOOKUP Function
The VLOOKUP Function
The HLOOKUP Function
The MATCH Function
The INDEX Function
Activity 1-3: Analyzing Data Using Lookup Functions
TOPIC D: Use Date Functions
The TODAY Function
The NOW Function
Serializing Dates and Times with Functions
Activity 1-4: Analyzing Data Using Date Functions
TOPIC E: Use Financial Functions
The IPMT Function
The PPMT Function
The NPV Function
The FV Function
Activity 1-5: Using Financial Functions
Summary
Review Questions
Lesson 2: Organizing Worksheet Data with Tables
TOPIC A: Create and Modify Tables
Tables
Table Components
The Create Table Dialog Box
Table Modification Options
Activity 2-1: Creating and Modifying a Table
TOPIC B: Sort and Filter Data
The Difference Between Sorting and Filtering
Sorting Data
Filter Operators
Removing Duplicate Values
Activity 2-2: Sorting Data
Summary
Review Questions
Lesson 3: Visualizing Data with Charts
TOPIC A: Create Charts
Charts
Chart Types
Chart Insertion Methods
Resizing and Moving the Chart
Adding Additional Data
Activity 3-1: Creating Charts
TOPIC B: Modify and Format Charts
The Difference Between Modifying and Formatting
Chart Elements
Minimize Chart Elements
The Chart Tools
Activity 3-2: Modifying and Formatting Charts
Summary
Review Questions
Lesson 4: Enhancing Workbooks
TOPIC A: Customize Workbooks
Comments
Hyperlinks
Pictures
Activity 4-1: Customizing Workbooks
TOPIC B: Preparing a Workbook for Multiple Audiences
Adding Alternative Text to Objects
Modifying Worksheets Using the Accessibility Checker
Managing Fonts
Activity 4-2: Preparing a Workbook for Multiple Audiences
Summary
Review Questions
Lesson Labs
Lesson 1
Lesson Lab 1-1
Lesson Lab 1-2
Lesson 2
Lesson Lab 2-1
Lesson 3
Lesson Lab 3-1
Lesson 4
Lesson Lab 4-1
Course Wrap-Up
Post-Course Assessment
Course Summary
Appendices
Keyboard Shortcut Quick Reference Sheet
Glossary
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.
$495
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.