"Excel/VBA for Creative Problem Solving, Part 2" builds off of knowledge and skills obtained in "Excel/VBA for Creative Problem Solving, Part 1" and is aimed at learners who are seeking to augment, expand, optimize, and increase the efficiency of their Excel spreadsheet skills by tapping into the powerful programming, automation, and customization capabilities available with Visual Basic for Applications (VBA).
Excel/VBA for Creative Problem Solving, Part 2
Excel/VBA for Creative Problem Solving, Part 2
This course is part of Excel/VBA for Creative Problem Solving Specialization
Instructor: Charlie Nuttelman
41,078 already enrolled
Included with 
Gain insight into a topic and learn the fundamentals.
4.9
(1,302 reviews)
Intermediate level
Some related experience required
Flexible schedule
Approx. 20 hours
Learn at your own pace
95%
Most learners liked this course
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.
Details to know
Shareable certificate
Add to your LinkedIn profile
Assessments
8 assignments
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 Excel/VBA for Creative Problem Solving 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
Earn a career certificate
Add this credential to your LinkedIn profile, resume, or CV
Share it on social media and in your performance review
There are 4 modules in this course
In Week 1, you will learn all about arrays and array functions. You will learn how to iterate through arrays using nested For...Next loops and For Each...Next statements; you will learn how to import data to VBA from Excel and export data to Excel from VBA; you will learn how to create user-defined array functions; and you will learn about the ReDim Preserve statement for resizable arrays. Week 1 is concluded with a quiz, which unlocks Assignment 1.
What's included
14 videos9 readings2 assignments3 discussion prompts
Week 2 deals with text strings and text (.txt) files. You will learn about the string functions in Excel and VBA. You will gain practice with string functions as you learn how to create functions in VBA that utilize string functions. You will learn how to extract strings, such as email addresses, from a spreadsheet of mixed string formats. You will also learn how to write information from Excel to .txt files and also to import information in .txt files to Excel. The module is concluded with a quiz and Assignment 2.
What's included
12 videos3 readings2 assignments3 discussion prompts
Week 3 is all about iterating through (automating) worksheets and workbooks. You will learn how to consolidate information from multiple worksheets into a single worksheet and you will learn how to automatically consolidate information found within multiple workbooks into a single worksheet of a single workbook. The automation principles you learn in this module are priceless. Week 3 is concluded with a quiz and a very challenging assignment.
What's included
12 videos2 readings2 assignments2 discussion prompts
In Week 4, you will learn about advanced input and message boxes and event handlers. You will learn how to interface with the user in a professional manner using user forms that validate input and prevent the "debug" window and VBE from appearing. You will also learn how to place combo boxes on user forms and populate those combo boxes with information on the spreadsheet. Finally, you will learn how to put it all together and implement a solving technique (bisection method) to solve a real world problem in a user form. Week 4 is concluded with a quiz, which unlocks Assignment 4.
What's included
14 videos1 reading2 assignments2 discussion prompts
Instructor
Instructor ratings
4.9 (274 ratings)Offered by
Recommended if you're interested in Algorithms
Coursera Project Network
Microsoft
Coursera Project Network
Illinois Tech
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."
Learner reviews
4.9
1,302 reviews
- 5 stars
89.80%
- 4 stars
8.35%
- 3 stars
0.99%
- 2 stars
0.38%
- 1 star
0.46%
Showing 3 of 1302
BT
5
Reviewed on Feb 8, 2020
I benefited from the course both in terms of utilizing VBA and programming in general. I used to use merely record macro and a few do loops. Now my programming prowess is much deeper.
PP
5
Reviewed on Dec 13, 2021
Excellent use of Quizzes and questions in the videos to encourage engagement. Assignment problems are challenging, but attainable if you watch all of the screencasts. Lessons build linearly.
DL
5
Reviewed on Jun 9, 2021
Great course! I feel confident in my ability to develop, structure, and troubleshoot my code after taking this course. I look forward to solidifying the foundations built here in part 3.
New to Algorithms? Start here.
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
Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:
The course may not offer an audit option. 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. If you only want to read and view the course content, you can audit the course for free.
If you subscribed, you get a 7-day free trial during which you can cancel at no penalty. After that, we don’t give refunds, but you can cancel your subscription at any time. See our full refund policy.