Course Description

Developer tools in Microsoft Office give you the functionality to create custom applications in Excel. These tools require Visual Basic for Applications (VBA). The developer can create custom spreadsheets, workbooks, controls, and even toolbar add-ins for users.

Visual Basic is a specific Microsoft language, so it integrates into any Microsoft productivity tool. This course focuses on Excel customizations and applications. To create these customizations, you first need to learn macros and what they can do for your projects. We then go into modules and custom coded macros. Visual Basic is an object-oriented language, so we show you how to create custom classes that plug into your Excel modules.

This course not only focuses on Visual Basic syntax, but we also focus on working with classes, properties and methods specific to the Visual Basic version for Excel. We show you how to data mine from external source, connect to databases, and even scrape Internet content to include in a local spreadsheet.

We also work with pivot tables, charts and graphs that you can automatically draw and render within an Excel spreadsheet. Later chapters include instructions and tutorials on sparklines and working with external files. We help you develop skills in error handling to provide better ways to work with errors in your code.

Whether you're new to Excel or just new to the Visual Basic for Application language, this course will help you develop the skills necessary to build custom applications that work with a variety of industries and complex business scenarios.

  • Completely Online
  • Self-Paced
  • Printable Lessons
  • Full HD Video  
  • 6 Months to Complete
  • 24/7 Availability
  • Start Anytime
  • PC & Mac Compatible
  • Android & iOS Friendly
  • Accredited CEUs
Universal Class is an IACET Accredited Provider
 

Learning Outcomes

By successfully completing this course, students will be able to:
  • Describe what VBA is.
  • Demonstrate using the macro recorder.
  • Demonstrate running a macro.
  • Describe the visual basic editor (VBE).
  • Describe what OOP is.
  • Demonstrate using message boxes.
  • Demonstrate ranges and selections.
  • Summarize looping.
  • Describe selection statements.
  • Describe event programming.
  • Summarize arrays.
  • Summarize classes, records, and collections.
  • Describe charts and pivot tables.
  • Recognize conditional formatting and retrieving data.
  • Describe text file processing.
  • Summarize handling errors.
  • Demonstrate mastery of lesson content at levels of 70% or higher.
 
 

Assessment Guide

Assessment Points
An Introduction 1 points
Exam 1 10 points
Exam 2 10 points
Exam 3 10 points
Exam 4 10 points
Exam 5 10 points
Exam 6 10 points
Exam 7 10 points
Exam 8 10 points
Exam 9 8 points
Exam 10 10 points
Exam 11 10 points
Exam 12 10 points
Exam 13 9 points
Exam 14 10 points
Exam 15 10 points
Exam 16 10 points
Exam 17 10 points
Exam 18 10 points
Exam 19 10 points
Exam 20 10 points
Exam 21 10 points
Exam 22 9 points
Exam 23 10 points
Exam 24 10 points
Exam 25 10 points
Exam 26 10 points
Exam 27 10 points
Final Exam 100 points
How to Position Elements in CSS
How to Position Elements in CSS
Ultimate Excel Training Bundle
Ultimate Excel Training Bundle
Advanced Excel 2019
Advanced Excel 2019
How to Use Conditional Formatting in Excel 2019
How to Use Conditional Formatting in Excel 2019
Google Sheets
Google Sheets
Overview of MySQL
Overview of MySQL
Business Writing Courses
Business Writing Courses
Microsoft Excel Courses
Microsoft Excel Courses
Introduction to CSS
Introduction to CSS
Microsoft Office 2021: Word, Excel, PowerPoint and Outlook
Microsoft Office 2021: Word, Excel, PowerPoint and Outlook
QuickBooks Courses
QuickBooks Courses
Microsoft Word Courses
Microsoft Word Courses
Google Docs
Google Docs
How to Use Goal Seek and Solver in Excel 2019
How to Use Goal Seek and Solver in Excel 2019
Operations Management Courses
Operations Management Courses
Excel 2016: Using Worksheets and Workbooks
Excel 2016: Using Worksheets and Workbooks
What Are the Most Popular Data Functions in Excel 2019?
What Are the Most Popular Data Functions in Excel 2019?
Communications Courses
Communications Courses