John Wiley & Sons

Microsoft 365 Excel VBA Programming For Dummies Specialization

Build in-demand skills with a full year of Coursera Plus, now $239. Save now.

John Wiley & Sons

Microsoft 365 Excel VBA Programming For Dummies Specialization

Excel VBA Automation Mastery.

Automate tasks, build interfaces, and enhance Excel with VBA.

Included with Coursera PlusLearn more

Get in-depth knowledge of a subject
Beginner level

Recommended experience

4 weeks to complete
at 10 hours a week
Flexible schedule
Learn at your own pace
Get in-depth knowledge of a subject
Beginner level

Recommended experience

4 weeks to complete
at 10 hours a week
Flexible schedule
Learn at your own pace

What you'll learn

  • Record and modify macros to automate repetitive tasks in Excel.

  • Implement variables, program flow, and error handling in VBA code.

  • Design user interfaces, custom functions, and Excel add-ins for advanced automation.

Details to know

Shareable certificate

Add to your LinkedIn profile

Taught in English
Recently updated!

October 2026

See how employees at top companies are mastering in-demand skills

 logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

Advance your subject-matter expertise

  • Learn in-demand skills from university and industry experts
  • Master a subject or tool with hands-on projects
  • Develop a deep understanding of key concepts
  • Earn a career certificate from John Wiley & Sons

Specialization - 3 course series

Excel VBA Foundations and Object Model

Excel VBA Foundations and Object Model

Course 1, 5 hours

What you'll learn

  • Build custom functions using VBA code

  • Integrate Excel with Copilot for AI-assisted coding

  • Design interactive forms using UserForms

Skills you'll gain

Category: Automation
Category: Microsoft Copilot
Category: Code Review
Category: Microsoft 365
Category: Integrated Development Environments
Category: Development Environment
Category: Web Applications
Category: Programming Principles
Category: Visual Basic (Programming Language)
Category: Application Deployment
Category: Excel Macros
Excel VBA Programming: Advanced Automation

Excel VBA Programming: Advanced Automation

Course 2, 6 hours

What you'll learn

  • Build custom functions using VBA code

  • Integrate Excel with Copilot for AI-assisted coding

  • Design interactive forms using UserForms

Skills you'll gain

Category: Event-Driven Programming
Category: Web Applications
Category: Visual Basic (Programming Language)
Category: Automation
Category: Application Deployment
Category: Microsoft Copilot
Category: Microsoft 365
Category: Excel Macros
Category: Debugging
Category: Programming Principles
Category: Maintainability
Category: Spreadsheet Software

What you'll learn

  • Build custom functions using VBA code

  • Integrate Excel with Copilot for AI-assisted coding

  • Design interactive forms using UserForms

Skills you'll gain

Category: Debugging
Category: Visual Basic (Programming Language)
Category: Code Reusability
Category: Automation
Category: Microsoft 365
Category: Integrated Development Environments
Category: User Interface (UI) Design
Category: Event-Driven Programming
Category: UI Components
Category: Microsoft Copilot
Category: Development Environment
Category: Excel Macros
Category: Web Applications
Category: User Interface (UI)
Category: Maintainability
Category: Application Deployment
Category: Data Entry

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.

Instructor

Wiley Skills Network
John Wiley & Sons
252 Courses31,703 learners

Offered by

Why people choose Coursera for their career

Felipe M.

Learner since 2018
"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021
"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

What brings you to Coursera today?

Frequently asked questions