Online Class: Visual Basic for Excel
We're sorry, this course is no longer open for enrollment.
-
27Lessons
-
29Exams &
Assignments -
17Hours
average time -
1.7CEUs
Course Description
Unleashing Excel's Potential: Dive Deep into 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.
- 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.
Related Courses
- 32 hours 3.2 CEUs Microsoft Office: Word, Excel, PowerPoint and Outlook + More Info
- 7 hours 0.7 CEUs Google Slides + More Info
- 6 hours 0.6 CEUs Google Docs + More Info
- 8 hours 0.8 CEUs Learn HTML - Create Webpages Using HTML5 + More Info
- 8 hours 0.8 CEUs Microsoft PowerPoint Level 1 + More Info
- 9 hours 0.9 CEUs Microsoft Project Level 1 + More Info
- 7 hours 0.7 CEUs Microsoft Excel Level 3 + More Info
- 12 hours 1.2 CEUs Microsoft Excel Level 1 + More Info
- 11 hours 1.1 CEUs Introduction to CSS + More Info
- 8 hours 0.8 CEUs Microsoft Access Level 1 + More Info
- 7 hours 0.7 CEUs Google Sheets + More Info