Chevron Left
Back to Excel/VBA for Creative Problem Solving, Part 2

Learner Reviews & Feedback for Excel/VBA for Creative Problem Solving, Part 2 by University of Colorado Boulder

4.9
stars
1,285 ratings

About the Course

"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....

Top reviews

PN

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!

MC

Feb 25, 2019

Part 1 was great, but in part 2 i feel like i can now actually provide innovative solutions using VBA. It's a very well taught course that keeps you engaged through great quizzes and assignments.

Filter by:

301 - 325 of 334 Reviews for Excel/VBA for Creative Problem Solving, Part 2

By Lei Y

Apr 27, 2020

V

By Suraj M

May 1, 2020

The course was really good and having learnt the basics in the Part 1 of the course, I really found this course very good in terms of the content . But in general , I feel both part 1 and 2 the sample excels of the example problems could have been provided that contains the code. This is the only reason why I am giving a 4 star for this course. Having completed another Excel specialization, I really feel having the code would help individuals to easily modify and play with the code to understand what works and how things change when lines of code is changed. The assignment question in week 4 was a little tough, it would have really helped if an algorithm or flow chart had been provided.

I like the approach of the quiz format that shows the answers only after you have passed the quiz and the grading sheet that allows us to enter the code alone as part of the solution.

By Michael P

Oct 14, 2020

This is a good course, but be ready to work - the projects are challenging. Charlie does a nice job explaining the concepts but I think he intentionally leaves a few holes to force the students to figure some things out for themselves. I wish there was some method to get help from the teacher of a TA, but other than that, have no complaints. Good course!

By Ítalo F d P

Aug 8, 2020

The course is really interesting and pushes the level foward. There are still some minor points to improve: half of the course have detailed explanations for the final quizzes' answers, but the last two weeks still don't have these explanatory texts. Also, the volume of the videos is quite low. Still, I really recommend it.

By wang x

Sep 8, 2019

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 Ehtisham R

Jul 28, 2020

Fantastic course if any one wants to learn Excel, VBA for professional level. I only have some concerns related to quizzes. They are normally more difficult and contains some un-necessary details. They can be made easy. Overall it is very interesting and informative course.

By Jasper v g

Apr 27, 2020

Great course that teached me a lot! Part 2 enabled me to build further on the basis of part 1 and really allowed me to start implementing creative problem solving in real life. Can't wait to start implementing this in my job.

By Leonel G P

Jun 1, 2020

Great course, complements the 1st part presenting a serie new topics; in my opinion include more information / examples related with the userforms and their different elements is necessary (due to this I rated 4 stars).

By Diego A

Mar 22, 2021

A very clear and usefull course for vba, however the only way to interact and solve your doubts are the forums where the teacher is not very participative, so if no one answer your question good luck !.

By Claire J

Oct 22, 2020

This was an interesting course and taught me how to use userforms and make much more sophisticated excel/vba files.

I would have liked to learn more about how VBA interacts with charts though.

By Alejandro V

Apr 15, 2020

Ha sido un curso muy entretenido, una buena continuación del programa especializado para profundizar en las capacidades de que tiene la programación VBA en Excel.

By Natan B

Apr 12, 2022

The course is really good to learn new skills about VBA. But the audio is very low in many videos, this is bad for the learning and understand what is going on.

By Monica Y

Sep 15, 2018

It's getting more and more interesting. Learning User Forms is definitely the coolest thing I can now do with Excel

By Pablo I

Dec 2, 2019

Very nice course. Challenging but very well explained. I look forward whith anxiety to start part 3 of the course.

By Diwakar J

Dec 29, 2018

The course is well structured, but some assignments need a real brain storming. Some sort of help is needed.

By Sophia S

Jun 4, 2022

I really liked this section of the certification. I would have appreciated harder assignments.

By jordan g

Jan 24, 2022

I wished he covered on using VBA to create graph/chart, pivot table, and dashboard.

By Chee J L

Apr 18, 2020

Great course. One less star because all video's audio is soft at max volume

By Gabriel V

Nov 28, 2020

It´s a very profound course of vba. Recomendable. Thank you Charlie!!!

By Ponciano R

Apr 7, 2018

Fantastic course, very useful, although I wish it were more slow paced

By Alexander A C

Dec 18, 2020

nice course, but no option to get a certificate with honors.

By Jean P C G

Sep 2, 2020

I really love this secod course, its help me so good

By Wee H G

Feb 16, 2024

A very interesting introductory course for VBA

By NGUYEN T

Apr 6, 2020

Give you a great foudation for VBA

By Jimmy K M M

Aug 3, 2020

I learn a lot of things