Universal Class: Over 500 Online Certificate Courses
 

Visual Basic for Excel


$90.00
no certificate
- OR -
$115.00
with CEU Certificate*
Start Right Now!
Taking multiple courses? Save with our platinum program.
 
  • 27
    Lessons
  • 28
    Exams &
    Assignments
  • 17
    Hours
    average time
  • 1.7
    CEUs
  • 370
    Students
    have taken this course
 
 
 
 
 

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 users.

Show More
  • 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
 
 
 

Related Courses

  • MySQL
    MySQL
    If you've decided to build a website or need a database, MySQL is an open-source option that's very cost effective and affordable. Without knowing how to install, configure, design and maintain the database, you risk having a poor performing environ...
    $80.00
    1.0 CEUs 10h
  • Introduction to JavaScript
    Introduction to JavaScript
    JavaScript is the globally used client-side scripting language for the web. Most browsers support the language by default, so you can get started using JavaScript and HTML with a simple text editor and browser for testing. Client-side, programming l...
    $75.00
    1.0 CEUs 10h
  • Introduction to SQL
    Introduction to SQL
    This comprehensive course teaches and demonstrates all aspects of SQL. While you'll learn everything there is to do with SQL, this course assumes you have no prior SQL experience and is for the complete beginner. Structured Query Language (SQL) is t...
    $75.00
    1.7 CEUs 17h
  • C# Programming
    C# Programming
    C# is a powerful backend coding language used for Microsoft web and desktop applications. C# is a C-style language, so you can take C# and learn other languages such as Java, C and C++. This course will get you started with C# and the language style...
    $120.00
    1.7 CEUs 17h
  • Ultimate Excel Bundle
    Ultimate Excel Bundle
    Learn Excel 2016 Microsoft Excel is a spreadsheet program that comes packaged with the Microsoft Office family of software products. Just like the other programs by Microsoft, Excel can be used for a wide variety of purposes such as creating an addr...
    $125.00
    4.6 CEUs 46h
  • Office 2016: Word, Excel, PowerPoint and Outlook
    Office 2016: Word, Excel, PowerPoint and Outlook
    Microsoft Word 2016: Microsoft Word 2016 is the latest version of the popular word processing software offered as part of the Microsoft Office suite. This course will teach you all the skills you'll need to successfully use Word 2016. You'll learn ...
    $110.00
    3.2 CEUs 32h
  • JQuery Programming
    JQuery Programming
    JQuery is one of the most popular frameworks on the web that deals with client-side scripting for styling web pages and performing asynchronous events. It's built on the JavaScript language, so anyone familiar with the JavaScript language will pick ...
    $85.00
    0.9 CEUs 9h
  • Microsoft Project 2016
    Microsoft Project 2016
    Microsoft Project 2016 is a project management software program created for businesses and freelance professionals to help better manage individual projects that occur within companies. Although no project management software should be used to repla...
    $75.00
    0.8 CEUs 8h
  • Advanced Excel 2016
    Advanced Excel 2016
    Excel 2016 Advanced Skills Course With most software programs on the market today, you can thrive with just a basic knowledge of the tools and options built into the individual program. However, that is not necessarily true when it comes to Excel 20...
    $85.00
    1.7 CEUs 17h
  • Social Media Marketing 101
    Social Media Marketing 101
    The importance for modern businesses to understand the need for a strategic social media presence cannot be understated. From creating an outlet to directly connect with consumers, to providing insight into buying behavior, to boosting SEO rankings,...
    $75.00
    1.0 CEUs 10h
  • PowerPoint 2016
    PowerPoint 2016
    PowerPoint 2016 is a presentation creator that can be used to create stunning slideshows and basic videos. It can also be used to create slide presentations, handouts, transparencies, and much more. While creating presentations using some programs c...
    $75.00
    0.7 CEUs 7h
  • Microsoft Access 2016
    Microsoft Access 2016
    Microsoft Access 2016 is an information management tool that allows you to store, report, and analyze information within a relational database. If you're trying to use Excel to manage large amounts of information, then chances are Microsoft Access w...
    $95.00
    1.2 CEUs 12h
  • Excel 2016
    Excel 2016
    Microsoft Excel is a spreadsheet program that comes packaged with the Microsoft Office family of software products. Just like the other programs by Microsoft, Excel can be used for a wide variety of purposes such as creating an address book, grocery...
    $75.00
    1.2 CEUs 12h
  • Introduction to CSS
    Introduction to CSS
    Ever wonder how the latest website designs are made? Cascading Style Sheets (CSS) are the main coding files used to lay out a website and its design. CSS3 is the latest in styling standards, and it brings several new properties and declarations you ...
    $75.00
    1.1 CEUs 11h
  • Learn HTML - Create Webpages Using HTML5
    Learn HTML - Create Webpages Using HTML5
    This course teaches you how to create webpages from scratch using the most current standard in HTML -- HTML5. HTML5 is the latest standard in web page coding. Whether you're a new or seasoned web designer, you need to know the latest in HTML archite...
    $75.00
    1.0 CEUs 10h
 
 

Course Lessons

Average Lesson Rating:
4.6 / 5 Stars (Average Rating) 4.6 / 5 Stars (Average Rating) 4.6 / 5 Stars (Average Rating) 4.6 / 5 Stars (Average Rating) 4.6 / 5 Stars (Average Rating)
"Extraordinarily Helpful"
(286 votes)

Lesson 1: Getting Excel Ready

Visual Basic is a Microsoft language still used in many applications including Excel automation. 10 Total Points
  • Lesson 1 Video A
  • Lesson 1 Video B : Lesson 1 Additional Video Supplement
  • Review Video: How to enable the Developer Tab
  • Complete: 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. 10 Total Points
  • Lesson 2 Video
  • Review Article: Create or delete a macro
  • Review 2 Videos: Excel 2016 Tutorial Recording Macros Microsoft Training Lesson; Microsoft Excel 2016 - Recording a Macro to Import a Plain Text File
  • Complete: 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. 10 Total Points
  • Lesson 3 Video A
  • Lesson 3 Video B : Lesson 3 Additional Video Supplement
  • Review 2 Articles: Run a macro in Excel 2016 for Mac; Run an Excel macro
  • Complete: 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. 10 Total Points
  • Lesson 4 Video
  • Review Video: How to Use the VBA Editor
  • Complete: 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. 10 Total Points
  • Lesson 5 Video
  • Review Article: Excel Tips
  • Review Video: Excel 2016 Tutorial Recording Macros Microsoft Training Lesson
  • Complete: Exam 5

Lesson 6: Introduction to OOP

Object-oriented programming (OOP) is a design and structure methodology used to create code. 10 Total Points
  • Lesson 6 Video A
  • Lesson 6 Video B : Lesson 6 Additional Video Supplement
  • Review 2 Articles: VBA Object Model And Object References; An Overview of the Excel Object Model
  • Complete: 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. 10 Total Points
  • Lesson 7 Video
  • Review 2 Articles: MsgBox Function; MsgBx Function in Excel VBA Examples
  • Complete: 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. 10 Total Points
  • Lesson 8 Video A
  • Lesson 8 Video B : Lesson 8 Additional Video Supplement
  • Review Article: Useful Range Object Methods in Excel 2016 VBA Programming
  • Complete: Exam 8

Lesson 9: Looping

In this lesson, we'll discuss the common looping structures in Visual Basic: For, While, and Do loops. 8 Total Points
  • Lesson 9 Video A
  • Lesson 9 Video B : Lesson 9 Additional Video Supplement
  • Review Article: Excel VBA Loop - Easy Excel Macros
  • Review Video: Excel Macros: Relative References and Do While Looping
  • Complete: 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. 10 Total Points
  • Lesson 10 Video A
  • Lesson 10 Video B : Lesson 10 Additional Video Supplement
  • Review Article: Power Excel vba secret, avoid using select
  • Complete: 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. 10 Total Points
  • Lesson 11 Video A
  • Lesson 11 Video B : Lesson 11 Additional Video Supplement
  • Review 2 Articles: Excel ? R1C1 Reference Style vs. A1; Overview of formulas in Excel 2016 for Windows
  • Review 2 Videos: R1C1 Reference Style; Excel 2016 Tutorial Naming Ranges Microsoft Training Lesson
  • Complete: Exam 11

Lesson 12: Excel Names

There are two main types of variable scopes: global and local. 10 Total Points
  • Lesson 12 Video
  • Review Article: Define and use names in formulas
  • Review Video: Excel 2016 Tutorial Using Named Ranges in Formulas Microsoft Training Lesson
  • Complete: Exam 12

Lesson 13: Event Programming

Events in any language are user input or software related actions that interact with a workbook. 9 Total Points
  • Lesson 13 Video A
  • Lesson 13 Video B : Lesson 13 Additional Video Supplement
  • Review Article: Event data
  • Complete: Exam 13

Lesson 14: Arrays

Arrays are beneficial when you need to store several values into one variable. 10 Total Points
  • Lesson 14 Video A
  • Lesson 14 Video B : Lesson 14 Additional Video Supplement
  • Review 3 Articles: Guidelines and examples of array formulas in Excel 2016 for Windows; Keyboard shortcuts in Excel 2016 for Mac; Array Functions
  • Complete: 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. 10 Total Points
  • Lesson 15 Video
  • Review Article: Class Module Step by Step
  • Complete: Exam 15

Lesson 16: User Forms

User forms are interactive pages within your application that let you provide controls and text boxes for input. 10 Total Points
  • Lesson 16 Video A
  • Lesson 16 Video B : Lesson 16 Additional Video Supplement
  • Review Article: Overview of forms, form controls, and ActiveX controls on a worksheet in Excel 2016 for Windows
  • Review Video: Create a simple Database Userform in Excel 2013,2016 Tips and Tricks
  • Complete: 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. 10 Total Points
  • Lesson 17 Video
  • Review Article: Create Advanced Excel Filters using Excel VBA
  • Review 2 Videos: Excel 2016 Tutorial Creating Advanced Filters Microsoft Training Lesson; Excel for Mac 2016 Tutorial Part05 03 Filtering worksheet data
  • Complete: Exam 17

Lesson 18: Pivot Tables

This lesson covers pivot tables and how you can create one using VB. 10 Total Points
  • Lesson 18 Video A
  • Lesson 18 Video B : Lesson 18 Additional Video Supplement
  • Review 2 Videos: Introduction To PivotTable Microsoft Excel 2016 Beginner Course; Manipulating PivotTable Data Microsoft Excel 2016 Beginner Course
  • Complete: 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. 10 Total Points
  • Lesson 19 Video
  • Review 3 Videos: Inserting a chart so you can display your data visually; Microsoft Excel 2016 Tutorials; Creating Charts in Excel VBA
  • Complete: 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. 10 Total Points
  • Lesson 20 Video
  • Review 2 Articles: Need help with Conditional Formatting highlighting formula for Visual Basic; Excel Conditional Formatting macro
  • Complete: Exam 20

Lesson 21: Sparklines

Sparklines are small line graphs that show you a visual presentation of a row of cells. 10 Total Points
  • Lesson 21 Video A
  • Lesson 21 Video B : Lesson 21 Additional Video Supplement
  • Review Article: Create sparklines in Excel 2016 for Mac
  • Review Video: Creating incell charts with sparklines
  • Complete: 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. 10 Total Points
  • Lesson 22 Video
  • Review Article: How to automate Excel from Visual Basic .NET to fill or to obtain data in a range by using arrays
  • Complete: Exam 22

Lesson 23: Text File Processing

This lesson shows you how to create and edit text files that you use in your applications. 10 Total Points
  • Lesson 23 Video
  • Review Video: Visual Basic .Net Read Text File
  • Complete: Exam 23

Lesson 24: Automating Word Functions

In this lesson, we'll show you how to automate Word functionality from your Excel spreadsheets. 10 Total Points
  • Lesson 24 Video
  • Review Article: Excel 2016 best new features
  • Review Video: How to create MS Word document automatically with Dynamic fields
  • Complete: 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. 10 Total Points
  • Lesson 25 Video
  • Review 2 Articles: Handle Run-Time Errors in VBA; Error Handling
  • Complete: 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
  • Complete: 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. 121 Total Points
  • Lesson 27 Video A
  • Lesson 27 Video B : Lesson 27 Additional Video Supplement
  • Complete: Exam 27
  • Complete: Final Exam
378
Total Course Points
Show More
 

Additional Course Information

Online CEU Certificate
  • 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
Document Your CEUs on Your Resume
 
Course Title: Visual Basic for Excel
Course Number: 9770432
Languages: English - United States, Canada and other English speaking countries
Category:
Course Type: Computer Skill (Self-Paced, Online Class)
CEU Value: 1.7 IACET CEUs (Continuing Education Units)
CE Accreditation: Universal Class, Inc. has been accredited as an Authorized Provider by the International Association for Continuing Education and Training (IACET).
Grading Policy: Earn a final grade of 70% or higher to receive an online/downloadable CEU Certification documenting CEUs earned.
Assessment Method: Lesson assignments and review exams
Instructor: UniversalClass Staff Instructor
Syllabus: View Syllabus
Duration: Continuous: Enroll anytime!
Course Fee: $90.00 (no CEU Certification) || with Online CEU Certification: $115.00

Choose Your Subscription Plan

Course Only
One Course
No Certificate / No CEUs
$90
for 6 months
 
Billed once
This course only
Includes certificate X
Includes CEUs X
Self-paced Yes
Instructor support Yes
Time to complete 6 months
No. of courses 1 course
Certificate Course
One Course
Certificate & CEUs
$115
for 6 months
 
Billed once
This course only
Includes certificate Yes
Includes CEUs Yes
Self-paced Yes
Instructor support Yes
Time to complete 6 months
No. of courses 1 course
Platinum Yearly
ALL COURSES
Certificates & CEUs
$189
per year
You save 50%!
Billed once
Includes all 500+ courses
Includes certificate Yes
Includes CEUs Yes
Self-paced Yes
Instructor support Yes
Time to complete 12 Months
No. of courses 500+
Platinum 2 Years
ALL COURSES
Certificates & CEUs
$299
for 2 years
You save $427.00!
Billed once
Includes all 500+ courses
Includes certificate Yes
Includes CEUs Yes
Self-paced Yes
Instructor support Yes
Time to complete 24 Months
No. of courses 500+
 
Follow Us Online
  • Follow us on Google Plus Follow us on FaceBook Follow us on Twitter Follow us on YouTube
© Copyright 1999-2018 Universal Class™ All rights reserved.