Visual Basic for Excel

no certificate
with CEU Certificate*
-
27Lessons
-
28Exams &
Assignments -
722Students
have taken this course -
17Hours
average time -
1.7CEUs
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.
- 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

Course Lessons
Lesson 1: Getting Excel Ready
Lesson 1 Video A
Lesson 1 Video B : Lesson 1 Additional Video Supplement
Review Video: How to enable the Developer Tab
Take Survey: Reasons for Taking this Course
Complete: Exam 1
Lesson 2: Using the Macro Recorder
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
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)
Lesson 4 Video
Review Video: How to Use the VBA Editor
Complete: Exam 4
Lesson 5: Problems with the Recorder
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
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
Lesson 7 Video
Review 2 Articles: MsgBox Function; MsgBx Function in Excel VBA Examples
Complete: Exam 7
Lesson 8: Ranges and Selections
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
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
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
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
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
Lesson 13 Video A
Lesson 13 Video B : Lesson 13 Additional Video Supplement
Review Article: Event data
Complete: Exam 13
Lesson 14: Arrays
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
Lesson 15 Video
Review Article: Class Module Step by Step
Complete: Exam 15
Lesson 16: User Forms
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
Lesson 17 Video
Review Video: Excel 2016 Tutorial Creating Advanced Filters Microsoft Training Lesson
Complete: Exam 17
Lesson 18: Pivot Tables
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
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
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
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
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
Lesson 23 Video
Review Video: Visual Basic .Net Read Text File
Complete: Exam 23
Lesson 24: Automating Word Functions
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
Lesson 25 Video
Review 2 Articles: Handle Run-Time Errors in VBA; Error Handling
Complete: Exam 25
Lesson 26: Customize the Ribbon
Lesson 26 Video
Complete: Exam 26
Lesson 27: Creating Add-Ins
Lesson 27 Video A
Lesson 27 Video B : Lesson 27 Additional Video Supplement
Take Poll: End of Course Poll
Take Survey: Course Comments
Take Survey: Program Evaluation Follow-up Survey (End of Course)
Complete: Exam 27
Complete: Final Exam
Learning Outcomes
- 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, and
- 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

Choose Your Subscription Plan
No Certificate / No CEUs
This course only
Includes certificate | X |
Includes CEUs | X |
Self-paced |
![]() |
Instructor support |
![]() |
Time to complete | 6 months |
No. of courses | 1 course |
Certificate & CEUs
This course only
Includes certificate |
![]() |
Includes CEUs |
![]() |
Self-paced |
![]() |
Instructor support |
![]() |
Time to complete | 6 months |
No. of courses | 1 course |
Certificates & CEUs
Includes all 500+ courses
Includes certificate |
![]() |
Includes CEUs |
![]() |
Self-paced |
![]() |
Instructor support |
![]() |
Time to complete | 12 Months |
No. of courses | 500+ |
Certificates & CEUs
Includes all 500+ courses
Includes certificate |
![]() |
Includes CEUs |
![]() |
Self-paced |
![]() |
Instructor support |
![]() |
Time to complete | 24 Months |
No. of courses | 500+ |