Skip to content
Write a review
CourseraExcelFree courseCertificate

Excel/VBA for Creative Problem Solving, Part 2

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.

4.8
86 reviews

Created by: Charlie Nuttelman

icon
Course Description

"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).In Part 2 of the course, learners will: 1) learn how to work with arrays and import/export arrays from/to Excel using VBA code; 2) learn how to work with text strings and write data to .txt files and import information from .txt files; 3) automate the import, modification, and consolidation of information from multiple worksheets into a central worksheet as well as the import of information from multiple workbooks to a central workbook; and 4) gain experience with creating professional user forms to interface with the user, perform advanced calculations, and manipulate data on the spreadsheet.Learners who have a foundational understanding of VBA code and programming structures can jump right into Part 2 of the course without taking Part 1 and use the screencasts in Part 1 as reference.Each module will introduce foundational and broad problems inspired by situations that you might encounter in the real world. To pass each module, you'll need to pass a mastery quiz and complete a problem solving assignment. This course is unique in that the weekly assignments are completed in-application (i.e., on your own computer in Excel), providing you with valuable hands-on training.
Read More product length iconTime: 25h

icon
Instructor Details

placeholder

I earned my B.S., M.S., and Ph.D. degrees from the Department of Chemical and logical Engineering in 1999, 2001, and 2005, respectively. I have been an instructor in the department since 2007 and have taught a total of 15 different chemical and biological engineering courses totaling over 15,000 student credit hours in 46 courses. These courses have ranged from introductory engineering courses to advanced (i.e. senior design) and have ranged in size from very small lab courses to large lecture classes of more than 400 students. Of all of the courses I have taught, introductory computing is my favorite course to teach. I have taught this freshman level course a total of 11 times and love the creativity and open-endedness of many of the problems and love teaching computing to those who have never been exposed to programming and engineering problem solving. This is the first Coursera course that I have taught.

Read More

icon
More Excel courses

$39.99

Free

$99.99

Free

$15.99

$119.99

All Excel courses

icon
Reviews

4.8

86 reviews in total

Select a bar to show only those reviews.Select the bar again to show every rating.

Write a review

By ezechukwu on 22-Oct-19

I learned a lot on how to use VBA, and it is so fun trying out these stuffs. Thanks for making this course interesting Charlie.. :)

By PRAVEEN K S on 20-Oct-19

100% Recommended course to learn VBA

By Omar Z on 15-Oct-19

Very informative, quite demanding. I don't hesitate to recommend this course.

By Belal M on 3-Oct-19

Awesome, super helpful class.

By Benjamin B on 21-Sep-19

I just finished with the second part of the course Excel/VBA for creative problem solving. it was a nice and challenging course. I feel that I took the basics of programming in VBA thanks to this course.Thank you so much Pr. Charlie for your explanation and for making this course as challenging and beneficial.

By Peter on 20-Sep-19

I liked the user forms a lot. It was the most relevant part for my work.

By Ashok S on 19-Sep-19

Excellent Course! Learned a lot of useful skills that I will put in practice immediately at work.

By Diego B on 8-Sep-19

I am going to take Course 3 of this specialization. Is it possible in that course you release the right answer of the assignment after the deadline is passed in the sense that I may not able to get the point for the course but I may still be able to learn why I could not make it through the assignment. Thanks!

By Jabberwoo on 6-Sep-19

An excellent course, recommended for all of those who work with numbers. This course is well suited for design engineers.

By Casey C on 6-Sep-19

This one was good fun. Thank you!

By Alexey G on 3-Sep-19

Same statement as for Part 1; A really good course, taught by a very nice and competent instructor. I have learned many things that I can actually apply at work. VBA is very helpful in many situations - Excel is almost everywhere, The instructor introduces new concepts by demonstrating their application in small real world projects, in the weekly assignment you then have to apply those conepts in a different context. I found this a very motivating and effective approach

By Kevin P on 2-Sep-19

I am a VBA expert taking this course for fun. In my opinion this is not a VBA programming course meant to take advantage of the language. It is more like a brain exercise because of the innecesary complexity of the codes in the quizzes, and some misunderstood programming concepts. If you are looking to learn VBA as a programming language, this course is not for you. If you are interested in mental agility, then it could help. I struggled reading the macros because of the bounch of bad practices.

Showing 12 of 86 reviews

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 96 / 100

Excel/VBA for Creative Problem Solving, Part 2
Visit course on Coursera Write a review
  • Video Duration: icon 25h
  • Price: Free
  • Provider: icon Coursera
  • University: icon University of Colorado Boulder
  • Language: icon English
  • Certificate: icon Yes

Coursera Coupon Price Tracker

Udemy price history

For any issues or feature requests please email CourseDuck's Co-Founder at mkuhlman12@gmail.com