Cultivate your career with expert-led programs, job-ready certificates, and 10,000 ways to grow. All for $25/month, billed annually. Save now
This course is part of Excel/VBA for Creative Problem Solving Specialization
Instructor: Charlie Nuttelman
41,534 already enrolled
Included with 
(1,308 reviews)
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.
Add to your LinkedIn profile
8 assignments
Add this credential to your LinkedIn profile, resume, or CV
Share it on social media and in your performance review
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.
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.
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.
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.
14 videos1 reading2 assignments2 discussion prompts
University of Colorado Boulder
University of Colorado Boulder
University of Colorado Boulder
Coursera Instructor Network
1,308 reviews
89.77%
8.39%
0.99%
0.38%
0.45%
Showing 3 of 1308
Reviewed on Dec 26, 2020
very interesting course, very nicely and deeply explained all topics in course. All assignments were quite challenging and very useful for real world applications. looking forward to part 3 of course!
Reviewed on Jun 19, 2020
Tough Course but definitely not impossible. Thank you Charlie for putting in so much efforts into this course. Part 3 ready and exited. Also, can you suggest any other platform to practice VBA?
Reviewed on Jun 6, 2020
This course is equally useful and is a must-have follow up if you have done Part 1. I have completed a number of projects at work successfully following these two courses. Highly recommended!
Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription
Earn a degree from world-class universities - 100% online
Upskill your employees to excel in the digital economy
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.
Financial aid available,
