This Specialization is for learners wishing to dramatically change the way that they use Excel spreadsheets by unleashing the power to automate and optimize spreadsheets using Visual Basic for Applications (VBA). The first two courses will teach learners the basics of VBA through the use of dozens of educational screencasts and a series of quizzes and in-application programming assignments. Finally, in Part 3 of the course, learners will complete 3 "real world" and somewhat open ended projects, which are graded through peer review.
Excel/VBA for Creative Problem Solving Specialization
Discover new skills with $120 off courses from industry experts. Save now.
Excel/VBA for Creative Problem Solving Specialization
Optimize Your Excel Spreadsheets With VBA. Learn how to automate your Excel spreadsheets with Visual Basic for Applications
Instructor: Charlie Nuttelman
77,612 already enrolled
Included with 
Get in-depth knowledge of a subject
(3,821 reviews)
Beginner level
No prior experience required
1 month at 10 hours a week
Flexible schedule
Earn a career credential
Share your expertise with employers
Get in-depth knowledge of a subject
(3,821 reviews)
Beginner level
No prior experience required
1 month at 10 hours a week
Flexible schedule
Earn a career credential
Share your expertise with employers
What you'll learn
Skills you'll gain
Tools you'll learn
What’s included
Shareable certificate
Add to your LinkedIn profile
Taught in English
22 practice exercises
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 University of Colorado Boulder
Specialization - 3 course series
What you'll learn
Utilize VBA to define and implement custom user-defined functions
Create macros to automate procedures in Excel
Identify the basic programming structures in VBA
Automate Excel’s Goal Seek and Solver tools and use numerical techniques to create “live solutions” to solve targeting and optimization problems
Skills you'll gain
Category: Visual Basic (Programming Language)
Category: Excel Macros
Category: Data Cleansing
Category: Debugging
Category: Computer Programming
Category: Data Management
Category: Programming Principles
Category: Spreadsheet Software
Category: Data Structures
Category: Program Development
Category: Problem Solving
Category: Automation
Category: Algorithms
What you'll learn
Use VBA to import/export arrays from/to Excel
Describe how text strings in Excel and how to write data to .txt files and import information from .txt files
Automate the import, modification, and consolidation of information from multiple worksheets into a central worksheet
Create professional user forms to interface with the user, perform advanced calculations, and manipulate data on the spreadsheet.
Skills you'll gain
Category: Visual Basic (Programming Language)
Category: Excel Macros
Category: Data Import/Export
Category: Automation
Category: Debugging
Category: Spreadsheet Software
Category: UI Components
Category: Data Structures
Category: Programming Principles
Category: Data Validation
What you'll learn
Create a VBA user form that will implement or solve a real world scenario or problem
Skills you'll gain
Category: Simulations
Category: Data Management
Category: User Interface (UI)
Category: Peer Review
Category: Automation
Category: Project Design
Category: Microsoft Excel
Category: Debugging
Category: Visual Basic (Programming Language)
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
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."
Open new doors with Coursera Plus
Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription
Advance your career with an online degree
Earn a degree from world-class universities - 100% online
Join over 3,400 global companies that choose Coursera for Business
Upskill your employees to excel in the digital economy
Frequently asked questions
Part 1 takes 5 weeks, Part 2 takes 4 weeks, and Part 3 takes 3-4 weeks. However, many learners who can devote more time to the coursework have completed the courses at an accelerated pace.
The course is designed for those without a programming background. It will greatly help if you have a knowledge of basic algebra and at least a foundational/introductory knowledge of Microsoft Excel.
Yes, it is strongly recommended that learners take the three courses in sequential order.
More questions
Financial aid available,