Online Class: Visual Basic for Excel

Whether you are 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 business scenarios.

$90.00
no certificate

- OR -

$115.00
with CEU Certificate*

Start Right Now!

$115.00 (with CEU Certificate)

Taking multiple courses? Save with our platinum program.

27

Lessons
29

Exams &
Assignments
797

Students
have taken this course
17

Hours
average time
1.7

CEUs

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.

Courses Frequently Bought Together:

C# Programming

Introduction to SQL

Introduction to JavaScript

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

Course Lessons

Average Lesson Rating:

"Extraordinarily Helpful"

(1,072 votes)

Lesson 1: Getting Excel Ready

Visual Basic is a Microsoft language still used in many applications including Excel automation. Additional lesson topics: How to enable the Developer Tab; Microsoft Excel Step by Step; How to enable the Developer tab in Excel Mac Version ; Microsoft Visual Basic Step by Step 11 Total Points

Lesson 1 Video A
Lesson 1 Video B : Lesson 1 Additional Video Supplement
Lesson discussions: Reasons for Taking this Course
Complete Assignment: An Introduction
Assessment: Exam 1

Lesson 2: Using the Macro Recorder

The macro recorder captures specific activities that you can then use later in your programs. It's a convenient way to automate tasks you do in Excel frequently. Additional lesson topics: Create or delete a macro; Excel Tutorial Recording Macros Microsoft Training Lesson; Microsoft Excel 10 Total Points

Lesson 2 Video
Assessment: Exam 2

Lesson 3: Running a Macro

We'll discuss the ways you can run a macro and the type of images and graphics you can implement in your procedures. Additional lesson topics: Run a macro in Excel for Mac; Run an Excel macro 10 Total Points

Lesson 3 Video A
Lesson 3 Video B : Lesson 3 Additional Video Supplement
Assessment: Exam 3

Lesson 4: The Visual Basic Editor (VBE)

You should get used to the VBE before you begin coding to navigate through the project window without accidentally changing a setting that could make coding more difficult. Additional lesson topics: How to Use the VBA Editor 10 Total Points

Lesson 4 Video
Assessment: Exam 4

Lesson 5: Problems with the Recorder

In this lesson, we will cover some of the advantages in more detail, but we'll also cover the disadvantages with some troubleshooting tips in case you run into issues with your recorded macros. Additional lesson topics: Excel Tips; Excel Tutorial Recording Macros Microsoft Training Lesson 10 Total Points

Lesson 5 Video
Assessment: Exam 5

Lesson 6: Introduction to OOP

Object-oriented programming (OOP) is a design and structure methodology used to create code. Additional lesson topics: VBA Object Model and Object References; An Overview of the Excel Object Model 10 Total Points

Lesson 6 Video A
Lesson 6 Video B : Lesson 6 Additional Video Supplement
Assessment: Exam 6

Lesson 7: Using Message Boxes

In this lesson, we'll discuss the MsgBox function in much more detail and show you how you can use the different options to customize your Visual Basic Applications. Additional lesson topics: MsgBox Function; MsgBx Function in Excel VBA Examples 10 Total Points

Lesson 7 Video
Assessment: Exam 7

Lesson 8: Ranges and Selections

In this lesson, we'll discuss cell ranges, referencing these ranges and then using different Visual Basic functions to control the range format and data. Additional lesson topics: Useful Range Object Methods in Excel VBA Programming 10 Total Points

Lesson 8 Video A
Lesson 8 Video B : Lesson 8 Additional Video Supplement
Assessment: Exam 8

Lesson 9: Looping

In this lesson, we'll discuss the common looping structures in Visual Basic: For, While, and Do loops. Additional lesson topics: Excel VBA Loop; Excel Macros: Relative References and Do While Looping 8 Total Points

Lesson 9 Video A
Lesson 9 Video B : Lesson 9 Additional Video Supplement
Assessment: Exam 9

Lesson 10: Selection Statements

In this lesson, we'll show you the syntax for these statement using Visual Basic and what you can do with them to control logic flow throughout your programs. Additional lesson topics: MS EXCEL: HOW TO USE THE CASE STATEMENT VBA ; Power Excel vba secret, avoid using select 10 Total Points

Lesson 10 Video A
Lesson 10 Video B : Lesson 10 Additional Video Supplement
Assessment: Exam 10

Lesson 11: A1 vs. R1C1 References

In this lesson, we'll discuss the two reference types, formulas and we'll take a look at Arrays. Additional lesson topics: Excel Tutorial Naming Ranges Microsoft Training Lesson; R1C1 Reference Style; Overview of formulas in Excel for Windows; Excel – R1C1 Reference Style vs. A1 10 Total Points

Lesson 11 Video A
Lesson 11 Video B : Lesson 11 Additional Video Supplement
Assessment: Exam 11

Lesson 12: Excel Names

There are two main types of variable scopes: global and local. Additional lesson topics: Define and use names in formulas; Excel Tutorial Using Named Ranges in Formulas Microsoft Training Lesson 10 Total Points

Lesson 12 Video
Assessment: Exam 12

Lesson 13: Event Programming

Events in any language are user input or software related actions that interact with a workbook. Additional lesson topics: Event data 9 Total Points

Lesson 13 Video A
Lesson 13 Video B : Lesson 13 Additional Video Supplement
Assessment: Exam 13

Lesson 14: Arrays

Arrays are beneficial when you need to store several values into one variable. Additional lesson topics: Array Functions; Guidelines and examples of array formulas in Excel for Windows; Keyboard shortcuts in Excel for Mac 10 Total Points

Lesson 14 Video A
Lesson 14 Video B : Lesson 14 Additional Video Supplement
Assessment: Exam 14

Lesson 15: Classes, Records, and Collections

Classes are reusable and can plug into other programs, so you can save time in future coding projects with your classes. Additional lesson topics: Class Module Step by Step 10 Total Points

Lesson 15 Video
Assessment: Exam 15

Lesson 16: User Forms

User forms are interactive pages within your application that let you provide controls and text boxes for input. Additional lesson topics: Overview of forms, form controls, and ActiveX controls on a worksheet in Excel for Windows; Create a simple Database Userform in Excel , Tips and Tricks 10 Total Points

Lesson 16 Video A
Lesson 16 Video B : Lesson 16 Additional Video Supplement
Assessment: Exam 16

Lesson 17: Data Mining with Advanced Filters

Data mining is useful for retrieving a data set and using it for separate sheet information. Additional lesson topics: Excel Tutorial Creating Advanced Filters Microsoft Training Lesson 10 Total Points

Lesson 17 Video
Assessment: Exam 17

Lesson 18: Pivot Tables

This lesson covers pivot tables and how you can create one using VB. Additional lesson topics: Introduction to PivotTable Microsoft Excel Beginner Lecture; Manipulating PivotTable Data Microsoft Excel Beginner Lecture 10 Total Points

Lesson 18 Video A
Lesson 18 Video B : Lesson 18 Additional Video Supplement
Assessment: Exam 18

Lesson 19: Charts

One of the most commonly used components in Excel is charts. Charts create a visual representation of your data, which is important during presentations and reports. Additional lesson topics: Creating Charts in Excel VBA; Inserting a chart so you can display your data visually; Microsoft Excel Tutorials 10 Total Points

Lesson 19 Video
Assessment: Exam 19

Lesson 20: Conditional Formatting and Retrieving Data

In this lesson, we'll first pull data from an external location and then use conditional formatting to change the way it's displayed to the user. Additional lesson topics: Need help with Conditional Formatting highlighting formula for Visual Basic; Excel Conditional Formatting macro 10 Total Points

Lesson 20 Video
Assessment: Exam 20

Lesson 21: Sparklines

Sparklines are small line graphs that show you a visual presentation of a row of cells. Additional lesson topics: Create sparklines in Excel for Mac; Creating incell charts with sparklines 10 Total Points

Lesson 21 Video A
Lesson 21 Video B : Lesson 21 Additional Video Supplement
Assessment: Exam 21

Lesson 22: Reading from and Writing to the Web

In this lesson, we'll discuss how you can connect to the Internet, read information from a web page, and then write data back to the Internet. Additional lesson topics: How to automate Excel from Visual Basic .NET to fill or to obtain data in a range by using arrays 9 Total Points

Lesson 22 Video
Assessment: Exam 22

Lesson 23: Text File Processing

This lesson shows you how to create and edit text files that you use in your applications. Additional lesson topics: Visual Basic .Net Read Text File 10 Total Points

Lesson 23 Video
Assessment: Exam 23

Lesson 24: Automating Word Functions

In this lesson, we'll show you how to automate Word functionality from your Excel spreadsheets. Additional lesson topics: How to create MS Word document automatically with Dynamic fields; Excel best new features 10 Total Points

Lesson 24 Video
Assessment: Exam 24

Lesson 25: Handling Errors

Visual Basic has error handling functionality that lets you send a message to the user, trap the error, and avoid crashing the application. This lesson discusses error handling and how you can work it into your code. Additional lesson topics: Handle Run-Time Errors in VBA; Error Handling 10 Total Points

Lesson 25 Video
Assessment: Exam 25

Lesson 26: Customize the Ribbon

In this lesson, we will work with the Excel ribbon and show you how to edit it for your own application customizations. 10 Total Points

Lesson 26 Video
Assessment: Exam 26

Lesson 27: Creating Add-Ins

Excel and VBA offer you the ability to customize a user's interface using add-ins. Add-ins are workbooks you create and save using the XLA file extension. 110 Total Points

Lesson 27 Video A
Lesson 27 Video B : Lesson 27 Additional Video Supplement
Lesson discussions: End of Course Poll; Course Comments; Program Evaluation Follow-up Survey (End of Course)
Assessment: Exam 27
Assessment: Final Exam

367

Total Course Points

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.

Additional Course Information

Document Your Lifelong Learning Achievements
Earn an Official Certificate Documenting Course Hours and CEUs
Verify Your Certificate with a Unique Serial Number Online

View and Share Your Certificate Online or Download/Print as PDF
Display Your Certificate on Your Resume and Promote Your Achievements Using Social Media