Excel VBA Macros: Custom Functions and Structures
Completed by Romain Pouchele
April 19, 2026
7 hours (approximately)
Romain Pouchele's account is verified. Coursera certifies their successful completion of Excel VBA Macros: Custom Functions and Structures
What you will learn
Write custom, reusable Excel formulas by defining input parameters, implementing If...Then...Else logic, and utilizing Select Case control blocks.
Manage memory and data structures using explicit variable declarations, strong data typing, Option Explicit, arrays, and iterative collection loops.
Troubleshoot runtime exceptions and improve macro execution speed.
Data files for this course are provided in the first course of this specialization, "Excel VBA Macros: Automating Tasks".
Skills you will gain
- Category: Excel Macros
- Category: Program Development
- Category: Computer Programming
- Category: Data Wrangling
- Category: Performance Tuning
- Category: Microsoft Excel
- Category: Debugging
- Category: Microsoft 365
- Category: Spreadsheet Software
- Category: Data Science
- Category: Code Reusability
- Category: Event-Driven Programming
