To round out your data-analysis skills in VBA for Excel, you'll display a custom dialog box and program form events. You'll also use VBA to get file and directory structure, read from text files, and write to text files. Then, you'll clean and transform data by automating Power Query, transform data using VBA and workbook functions, using regular expressions, and managing errors in data. Lastly, you'll run other programs and commands and share your VBA projects.
Excel VBA Macros: Forms, Files, and Data Handling
Ends soon: Gain next-level skills with Coursera Plus for $199 (regularly $399). Save now.
Gain insight into a topic and learn the fundamentals.
7 hours to complete
Flexible schedule
Learn at your own pace
What you'll learn
You will use VBA to develop custom forms, read/ write data, clean and transform data, run programs outside of Excel, and share VBA projects.
Skills you'll gain
- Microsoft Office
- Query Languages
- Data Import/Export
- Excel Macros
- Computer Programming
- Microsoft Excel
- File Management
- File I/O
- Spreadsheet Software
- Visual Basic (Programming Language)
- Data Cleansing
- Data Wrangling
- Performance Improvement
- Automation
- Debugging
- Data Manipulation
- Extensible Markup Language (XML)
- Data Science
- Microsoft 365
- Data Transformation
Details to know
Shareable certificate
Add to your LinkedIn profile
Recently updated!
January 2026
Assessments
1 assignment
Taught in English
See how employees at top companies are mastering in-demand skills
Build your subject-matter expertise
This course is part of the Programming and Data Wrangling with VBA and Excel Specialization
When you enroll in this course, you'll also be enrolled in this Specialization.
- Learn new concepts from industry experts
- Gain a foundational understanding of a subject or tool
- Develop job-relevant skills with hands-on projects
- Earn a shareable career certificate
There are 5 modules in this course
Sometimes you need to support more complex interactions with a user than Microsoft® Excel's built-in dialog boxes can provide.
What's included
1 reading4 plugins
Not all data is going to be provided to you in a tidy Microsoft® Excel® workbook or relational database. It is common for business analysts to have to work with a wide array of different file types, including XML, JSON, CSV, HTML, and all sorts of proprietary file formats. While Excel includes an extensive toolset for importing such data, there may be circumstances in which you need to import a file that requires custom VBA code to extract, transform, and load the data.
What's included
5 plugins
You have developed procedures to import and aggregate data. In many cases, the data you import from other sources may not be ready for analysis until you perform a variety of data cleaning and transformation tasks.
What's included
6 plugins
You have extended Excel's capabilities by automating tasks within Microsoft® Excel®, adding new custom workbook functions, custom forms, and the ability to read and write external files and data. With VBA, you can reach beyond Excel's normal sphere of influence by automating external programs. And as you expand Excel's capabilities in this way, you can share what you develop so other users can take advantage of your efforts
What's included
4 plugins
You'll wrap things up and then validate what you've learned in this course by taking an assessment.
What's included
1 reading1 assignment
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
Explore more from Business Essentials
Logical Operations
Logical Operations
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
To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.
More questions
Financial aid available,