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: Microsoft 365
- Category: Spreadsheet Software
- Category: Data Science
- Category: Automation
- Category: Visual Basic (Programming Language)
- Category: Microsoft Excel
- Category: Debugging
- Category: Performance Improvement
- Category: Excel Macros
- Category: Program Development
- Category: Event-Driven Programming
- Category: Programming Principles
