Excel VBA
The **Excel VBA** course is a 20-hour online program designed to teach students how to automate tasks in Excel using Visual Basic for Applications (VBA). Participants will learn to write simple VBA procedures, work with variables, loops, and conditionals, and create basic user interactions like InputBox and MsgBox. They will also master handling errors, manipulating worksheets, and automating tasks such as formatting and data entry. By the end of the course, students will build a practical VBA project to streamline a real-world workflow. Basic Excel and general computer knowledge are required.
- Online via Google Meet
- 20 hours on demand video.
- Certificate of completion
Key Learning Objectives:
-
Understand the fundamentals of VBA and its role in Excel automation.
Write simple VBA procedures and use variables, loops, and conditionals.
Create basic user interactions (InputBox, MsgBox) and handle errors.
Manipulate Excel worksheets and automate everyday tasks like formatting and data entry.
Build a simple VBA project to automate a real-world workflow.
Required:
- Basic Excel knowledge (working with spreadsheets, formulas, and formatting).
- Familiarity with general computer tasks (e.g., saving files, navigating applications).