Online Class: Visual Basic for Excel

Name: Visual Basic for Excel
Price: 95.00 USD

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.

$120.00
no certificate

- OR -

$145.00
with CEU Certificate*

Start Right Now!

$145.00 (with CEU Certificate)

Taking multiple courses? Save with our platinum program.

27

Lessons
29

Exams &
Assignments
920

Students
have taken this course
17

Hours
average time
1.7

CEUs

Course Description

Unleashing Excel's Potential: Learn Developer Tools and VBA Mastery

Elevate your Excel game to unprecedented heights with the power of Microsoft Office's Developer Tools, a suite meticulously engineered to unlock a world of tailored applications using Visual Basic for Applications (VBA). While many use Excel to handle numbers, you'll be learning how to transform it into a dynamic powerhouse capable of executing complex, custom tasks tailored to diverse business needs.

Course Highlights:

Introduction to VBA: Begin your journey with an insightful overview of Visual Basic – the heart and soul of Microsoft's customization. Understand its omnipotent presence across Microsoft's suite, with a specialized emphasis on Excel.
Macros, Modules, and Beyond: Learn the magic of macros and witness how these tiny code snippets can catalyze monumental changes in your spreadsheets. Then, delve deeper into the realm of modules and hand-crafted macros, taking your automation skills to the next level.
Object-Oriented Brilliance: Uncover the nuances of object-oriented programming within VBA. Design and integrate bespoke classes that seamlessly weave into your Excel projects, elevating functionality and user experience.
Dynamic Data Integration: Master the techniques to mine invaluable data from a myriad of external sources. Connect with databases effortlessly, or scour the vastness of the internet to extract and assimilate content directly into your Excel canvas.
Charting, Graphing & Visualization: Breathe life into numbers. Explore the automatic generation of pivot tables, captivating charts, and insightful graphs. Add the finishing touches with sparklines and ensure your data tells a compelling story.
File Interactions & Robust Error Handling: Dive into advanced chapters that navigate interactions with external files. Learn the art and science of error management, ensuring your custom applications are resilient and user-friendly, regardless of the underlying complexities.

By the culmination of this course, you won't just be an Excel user; you'll be an Excel visionary. Whether you're an Excel novice or a seasoned user looking to expand into VBA, this course is meticulously designed to equip you with the toolkit required to conjure tailored applications apt for an array of industries and intricate business scenarios. Dive in and redefine what's possible with Excel.

Courses Frequently Bought Together:

Introduction to SQL

Ultimate Excel Training Bundle

MySQL

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,116 votes)

Lesson 1: Getting Excel Ready

12 Points

Visual Basic is a Microsoft language still used in many applications including Excel automation.

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

Lesson 2: Using the Macro Recorder

10 Points

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.

Lesson 2 Video
Assessment: Exam 2

Lesson 3: Running a Macro

10 Points

We'll discuss the ways you can run a macro and the type of images and graphics you can implement in your procedures.

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

Lesson 4: The Visual Basic Editor (VBE)

10 Points

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.

Lesson 4 Video
Assessment: Exam 4

Lesson 5: Problems with the Recorder

10 Points

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.

Lesson 5 Video
Assessment: Exam 5

Lesson 6: Introduction to OOP

10 Points

Object-oriented programming (OOP) is a design and structure methodology used to create code.

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

Lesson 7: Using Message Boxes

10 Points

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.

Lesson 7 Video
Assessment: Exam 7

Lesson 8: Ranges and Selections

10 Points

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.

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

Lesson 9: Looping

8 Points

In this lesson, we'll discuss the common looping structures in Visual Basic: For, While, and Do loops.

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

Lesson 10: Selection Statements

10 Points

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.

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

Lesson 11: A1 vs. R1C1 References

10 Points

In this lesson, we'll discuss the two reference types, formulas and we'll take a look at Arrays.

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

Lesson 12: Excel Names

10 Points

There are two main types of variable scopes: global and local.

Lesson 12 Video
Assessment: Exam 12

Lesson 13: Event Programming

9 Points

Events in any language are user input or software related actions that interact with a workbook.

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

Lesson 14: Arrays

10 Points

Arrays are beneficial when you need to store several values into one variable.

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

Lesson 15: Classes, Records, and Collections

10 Points

Classes are reusable and can plug into other programs, so you can save time in future coding projects with your classes.

Lesson 15 Video
Assessment: Exam 15

Lesson 16: User Forms

10 Points

User forms are interactive pages within your application that let you provide controls and text boxes for input.

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

Lesson 17: Data Mining with Advanced Filters

10 Points

Data mining is useful for retrieving a data set and using it for separate sheet information.

Lesson 17 Video
Assessment: Exam 17

Lesson 18: Pivot Tables

10 Points

This lesson covers pivot tables and how you can create one using VB.

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

Lesson 19: Charts

10 Points

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.

Lesson 19 Video
Assessment: Exam 19

Lesson 20: Conditional Formatting and Retrieving Data

10 Points

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.

Lesson 20 Video
Assessment: Exam 20

Lesson 21: Sparklines

10 Points

Sparklines are small line graphs that show you a visual presentation of a row of cells.

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

9 Points

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.

Lesson 22 Video
Assessment: Exam 22

Lesson 23: Text File Processing

10 Points

This lesson shows you how to create and edit text files that you use in your applications.

Lesson 23 Video
Assessment: Exam 23

Lesson 24: Automating Word Functions

10 Points

In this lesson, we'll show you how to automate Word functionality from your Excel spreadsheets.

Lesson 24 Video
Assessment: Exam 24

Lesson 25: Handling Errors

10 Points

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.

Lesson 25 Video
Assessment: Exam 25

Lesson 26: Customize the Ribbon

10 Points

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

Lesson 26 Video
Assessment: Exam 26

Lesson 27: Creating Add-Ins

110 Points

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.

Lesson 27 Video A
Lesson 27 Video B : Lesson 27 Additional Video Supplement
Review Practice Worksheet: 9770432aa55361zz.png
Lesson discussions: End of Course Poll; Course Comments; Course Comments
Assessment: Exam 27
Assessment: Final Exam

368

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

Course Title: Visual Basic for Excel

Course Number: 9770432

Lessons Rating: 4.59 / 5 Stars (1,116 votes)

Languages: English - United States, Canada and other English speaking countries

Availability: With online access available nationwide, this course reaches all U.S. states, including California, Texas, Florida, New York, Pennsylvania, Illinois, Ohio, and Georgia. Additionally, it’s open to learners in English-speaking countries such as the UK, Australia, Canada, and New Zealand.

Last Updated: August 2023

Course Type: 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 Instructional Team

Syllabus: View Syllabus

Course Fee: $145.00 U.S. dollars