Excel VBA Macros: Custom Functions and Structures
Completed by Mikko Sulamaa
April 14, 2026
7 hours (approximately)
Mikko Sulamaa'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: Data Wrangling
- Category: Performance Tuning
- Category: Computer Programming
- Category: Performance Improvement
- Category: Microsoft Excel
- Category: Program Development
- Category: Event-Driven Programming
- Category: Debugging
- Category: Automation
- Category: Scripting
- Category: Visual Basic (Programming Language)
