Excel VBA Macros: Custom Functions and Structures
Completed by Armand Wilfried TEZE
March 3, 2026
7 hours (approximately)
Armand Wilfried TEZE'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: Programming Principles
- Category: Computational Logic
- Category: Program Development
- Category: Performance Improvement
- Category: Spreadsheet Software
- Category: Data Wrangling
- Category: Computer Programming
- Category: Microsoft Excel
- Category: Performance Tuning
- Category: Scripting
- Category: Debugging
- Category: Visual Basic (Programming Language)
