Online Class: Visual Basic for Excel
no certificate
with CEU Certificate*
-
27Lessons
-
29Exams &
Assignments -
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 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
Course Lessons
Lesson 1: Getting Excel Ready
- 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
- Lesson 2 Video
- Assessment: Exam 2
Lesson 3: Running a Macro
- Lesson 3 Video A
- Lesson 3 Video B : Lesson 3 Additional Video Supplement
- Assessment: Exam 3
Lesson 4: The Visual Basic Editor (VBE)
- Lesson 4 Video
- Assessment: Exam 4
Lesson 5: Problems with the Recorder
- Lesson 5 Video
- Assessment: Exam 5
Lesson 6: Introduction to OOP
- Lesson 6 Video A
- Lesson 6 Video B : Lesson 6 Additional Video Supplement
- Assessment: Exam 6
Lesson 7: Using Message Boxes
- Lesson 7 Video
- Assessment: Exam 7
Lesson 8: Ranges and Selections
- Lesson 8 Video A
- Lesson 8 Video B : Lesson 8 Additional Video Supplement
- Assessment: Exam 8
Lesson 9: Looping
- Lesson 9 Video A
- Lesson 9 Video B : Lesson 9 Additional Video Supplement
- Assessment: Exam 9
Lesson 10: Selection Statements
- Lesson 10 Video A
- Lesson 10 Video B : Lesson 10 Additional Video Supplement
- Assessment: Exam 10
Lesson 11: A1 vs. R1C1 References
- Lesson 11 Video A
- Lesson 11 Video B : Lesson 11 Additional Video Supplement
- Assessment: Exam 11
Lesson 12: Excel Names
- Lesson 12 Video
- Assessment: Exam 12
Lesson 13: Event Programming
- Lesson 13 Video A
- Lesson 13 Video B : Lesson 13 Additional Video Supplement
- Assessment: Exam 13
Lesson 14: Arrays
- Lesson 14 Video A
- Lesson 14 Video B : Lesson 14 Additional Video Supplement
- Assessment: Exam 14
Lesson 15: Classes, Records, and Collections
- Lesson 15 Video
- Assessment: Exam 15
Lesson 16: User Forms
- Lesson 16 Video A
- Lesson 16 Video B : Lesson 16 Additional Video Supplement
- Assessment: Exam 16
Lesson 17: Data Mining with Advanced Filters
- Lesson 17 Video
- Assessment: Exam 17
Lesson 18: Pivot Tables
- Lesson 18 Video A
- Lesson 18 Video B : Lesson 18 Additional Video Supplement
- Assessment: Exam 18
Lesson 19: Charts
- Lesson 19 Video
- Assessment: Exam 19
Lesson 20: Conditional Formatting and Retrieving Data
- Lesson 20 Video
- Assessment: Exam 20
Lesson 21: Sparklines
- 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
- Lesson 22 Video
- Assessment: Exam 22
Lesson 23: Text File Processing
- Lesson 23 Video
- Assessment: Exam 23
Lesson 24: Automating Word Functions
- Lesson 24 Video
- Assessment: Exam 24
Lesson 25: Handling Errors
- Lesson 25 Video
- Assessment: Exam 25
Lesson 26: Customize the Ribbon
- Lesson 26 Video
- Assessment: Exam 26
Lesson 27: Creating Add-Ins
- 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
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.
- 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 600+ courses
Includes certificate | |
Includes CEUs | |
Self-paced | |
Instructor support | |
Time to complete | 12 Months |
No. of courses | 600+ |
Certificates & CEUs
Includes all 600+ courses
Includes certificate | |
Includes CEUs | |
Self-paced | |
Instructor support | |
Time to complete | 24 Months |
No. of courses | 600+ |
Related Courses
- 45 hours 4.5 CEUs Ultimate Excel Training Bundle $125.00
- 8 hours 0.8 CEUs Learn HTML - Create Webpages Using HTML5 $95.00
- 7 hours 0.7 CEUs PowerPoint 2021 $95.00
- 6 hours 0.6 CEUs Google Docs $95.00
- 7 hours 0.7 CEUs Google Slides $95.00
- 9 hours 0.9 CEUs Microsoft Project 2021 $95.00
- 16 hours 1.6 CEUs Advanced Excel 2019 $95.00
- 11 hours 1.1 CEUs Introduction to CSS $95.00
- 7 hours 0.7 CEUs Google Sheets $95.00
- 11 hours 1.1 CEUs Excel 2021 $80.00
- 8 hours 0.8 CEUs Microsoft Access 2019 $95.00