Overview
Google, IBM & Meta Certificates – 40% Off
One Coursera Plus subscription covers most Professional Certificates on Coursera.
Unlock All Certificates
This course teaches how to write and modify VBA code in Excel to automate tasks and build tools. Learners work with the Excel object model, procedures, variables, forms, program flow, PivotTables, debugging, and error handling.
Syllabus
Start
VBA Basics
Excel Object Model Hierarchy and Collections
Modules and Procedures
Variables, Data Types, and Intrinsic Functions
Object Variables
Controlling Program Execution
Forms and Controls
Pivot Tables
Debugging Code
Conclusion
Taught by
Learnit Training