Latest Courses
Statistical Decision Making in Data Science with Case StudyCheck course
SQLite Studio Tutorial for beginnersCheck course
Editor X Masterclass - Build Amazing Websites | No CodingCheck course
C++ Intermediate to Advanced Course with ProjectCheck course
Algorithms in Python : Design Techniques And ApproachCheck course
Learn Advanced AI for Games with Behaviour TreesCheck course
Bootstrap Bootcamp (featuring Bootstrap 5)Check course
SQL Essentials - A Whole New Way of Learning SQL for Anyone!Check course
Unreal Engine 5: Blueprints for BeginnersCheck course
Azure Functions MasterclassCheck course
Statistical Decision Making in Data Science with Case StudyCheck course
SQLite Studio Tutorial for beginnersCheck course
Editor X Masterclass - Build Amazing Websites | No CodingCheck course
C++ Intermediate to Advanced Course with ProjectCheck course
Algorithms in Python : Design Techniques And ApproachCheck course
Excel/VBA for Creative Problem Solving, Part 3 (Projects)

Excel/VBA for Creative Problem Solving, Part 3 (Projects)

FREE

Add your review
Add to wishlistAdded to wishlistRemoved from wishlist 0
Add to compare
9.2/10 (Our Score)
Product is rated as #4 in category Excel

In this course, learners will complete several VBA projects. It is highly recommended that learners first take “Excel/VBA for Creative Problem Solving, Part 1” and “Excel/VBA for Creative Problem Solving, Part 2”. This course builds off of skills learned in those two courses. This is a project–based course. Therefore, the projects are quite open–ended and there are multiple ways to solve the problems. Through the use of Peer Review, other learners will grade learners’ projects based on a grading rubric.

Instructor Details

I earned my B.S., M.S., and Ph.D. degrees from the Department of Chemical and Biological 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.

Specification: Excel/VBA for Creative Problem Solving, Part 3 (Projects)

Duration

28 hours

Year

2018

Level

Expert

Certificate

Yes

Quizzes

Yes

46 reviews for Excel/VBA for Creative Problem Solving, Part 3 (Projects)

4.4 out of 5
36
8
1
1
0
Write a review
Show all Most Helpful Highest Rating Lowest Rating
  1. Brad H

    The projects in this course were challenging, but at no point did I feel completely loss. The lessons leading into the projects were very informative. I had to refer to Level 2 a few times and rewatch the videos, but never really had to search the internet. Overall a very good course.

    Helpful(3) Unhelpful(0)You have already voted this
  2. Ronald d R

    Challenging and rewarding. Very useful and complete. Great tutor support. A course i am enjoying very, very much.

    Helpful(1) Unhelpful(0)You have already voted this
  3. Maria C

    Thanks a lot for the great course and great specialization!Working in Supply Chain Planning, I need deep knowledge of Excel, especially now, when companies tend to save on expensive tools like SAP or Oracle. I always wanted to learn Excel VBA, but it seemed not easy to me.It was a surprise for me that VBA can be explained so well, in a structured way and with great examples! Instructor Charlie creates very nice and friendly atmosphere in the course and provides great and very talented teaching!Thank you for that! I will recommend excel VBA specialization to my friends and colleagues.

    Helpful(0) Unhelpful(0)You have already voted this
  4. Gina K

    I really enjoyed those free projects! Very challenging. However, I am not the biggest fan of peer reviews. For people wanting to finish the subscription earlier and not go with 3 month fees it is basically impossible. Either one doesn’t get reviews – even after posting into discussion forums – or one cannot upload because it is not open yet as the course officially hasn’t started. Or one switches sessions backwards and one is too late in submitting and doesn’t get reviews in time either. I would prefer much more having grader and the peer review just as a second option to learn from others in case one gets absolutely stuck or to see other ways to do it. But to make passing and timing dependable on this: not helpful. Other than that, again, loved the class. 🙂 Thanks!

    Helpful(2) Unhelpful(0)You have already voted this
  5. Chan w l

    Useful !

    Helpful(0) Unhelpful(0)You have already voted this
  6. David C

    Projects were enjoyable and challenging. Instructor is excellent –– does a great job of explaining the material and interacting with learners. Content very relevant to real–world projects.

    Helpful(0) Unhelpful(0)You have already voted this
  7. Carlos A F C

    Very good course. I have learned along ober this course.

    Helpful(0) Unhelpful(0)You have already voted this
  8. Alan A A Q

    Best course to learn Visual Basic

    Helpful(0) Unhelpful(0)You have already voted this
  9. Varun K V

    The course was really good. It helped me gain knowledge about the various aspects of excel which had been untouched by me. It has helped me in my professional endeavours too. Thank You

    Helpful(0) Unhelpful(0)You have already voted this
  10. Arturo M

    All the spcialization is absolutely amazing, you will not only learn how to make impressive tools in excel VBA, but also a lot of other things!

    Helpful(0) Unhelpful(0)You have already voted this
  11. Caetano C

    Awesome course. Challenging but yet easy–going.

    Helpful(0) Unhelpful(0)You have already voted this
  12. Kennie N H

    I liked the projects as they allowed you to showcase what you have learned through part 1 and 2. And if you have any issues, you receive a very quick response from the course instructor via the forum. Prior to this specialization I already had some experience with VBA, a large part of my master’s thesis was done using it, but I was still able to learn new stuff, and more importantly, just get a better understanding of VBA and becoming more confident in using it.

    Helpful(1) Unhelpful(0)You have already voted this
  13. Manoel L C N

    Great course!!

    Helpful(0) Unhelpful(0)You have already voted this
  14. Diego A Q

    I did not know any VBA before this specialization, but now thanks to it, I do! In this third part of the specialization, you have to develop some challenging projects where you will use all what you have learned on part I and II. You can even choose in the first three weeks which projects suits best to your learning goals. Although I did not required extra help, I noticed that the Instructor Nuttelman responses via the forum, which is great. Also, even though there is no grader but peer reviews , I received nice and useful feedback from other students, who at this point are all capable of reviewing and commenting other’s work. In my opinion, this course is very well structured! and Nuttelman’s english pronuntiation is very clear which is important for me as a non native English speaker.

    Helpful(1) Unhelpful(0)You have already voted this
  15. Luis E B

    great course! chellenging and enriching!

    Helpful(0) Unhelpful(0)You have already voted this
  16. Douglas G A F

    Awesome course for all of us that want develop advanced VBA apps for Excel data analysis and management.

    Helpful(0) Unhelpful(0)You have already voted this
  17. prem

    one of the best courses i have done . It provides the right kind of exposure needed

    Helpful(0) Unhelpful(0)You have already voted this
  18. Johannes H

    Great projects that test what you’ve learned in the first two courses. Thank you Charlie, for the classes!

    Helpful(0) Unhelpful(0)You have already voted this
  19. Deleted A

    An excellent practical problem–based course. The best way to learn is by doing.

    Helpful(0) Unhelpful(0)You have already voted this
  20. Nedko Y S

    Excellent course!

    Helpful(0) Unhelpful(0)You have already voted this
  21. Lindsey L

    Excellent course. Charlie is very good communicator. Encourage anyone learning Excel VBA to take it. The Week 5 problem was challenging but not difficult. There are some things I wished had been covered such as coding best practices, variable naming, in code documentation. Also, would appreciate suggestions as to other course to continue improving my programming skills.

    Helpful(0) Unhelpful(0)You have already voted this
  22. JONATHAN A G

    Great course, great instructor!

    Helpful(0) Unhelpful(0)You have already voted this
  23. Kristopher M J

    Course material was great, and continued to learn a lot in VBA. The peer grading process did not work very smoothly and was a general headache to deal with. Much preferred the way assignments worked in parts 1 and 2.

    Helpful(0) Unhelpful(0)You have already voted this
  24. Ng T E

    Good course for learners to build projects from scratch.

    Helpful(0) Unhelpful(0)You have already voted this
  25. Moreno C

    Course 3 is the most demanding but also the most rewarding of the specialization. The projects go well beyond the mere application of the set of skills developed during the first two courses. Fortunately, the instructor provides useful videos that make all the projects feasible, with the due amount of effort. I would recommend to complete all the projects, not only those that are required to obtain the certificate since each project contributes to strengthen different abilities.

    Helpful(1) Unhelpful(0)You have already voted this
  26. Idriss B

    The best course I’ve taken so far, I can’t thank you enough for the great content.

    Helpful(0) Unhelpful(0)You have already voted this
  27. HALAH A

    Excellent for beginners learning Excel VBA

    Helpful(0) Unhelpful(0)You have already voted this
  28. aashray k

    I have been a portfolio manager at a hedge fund for some time, so I approached this series of courses with a view to using VBA professionally. The first two parts of the 3–course series are fantastic – lectures and assignments. The third part had excellent assignments, exactly the sorts of problems one tackles professionally. The only negative feedback I have is that I found the peer review system a bit hit or miss – some reviewers were very diligent, while others were a bit cursory or failed a project because of an error I and other peer reviewers didn’t see (maybe due to an older version of Excel, etc.). I have taken a few different Coursera courses and in terms of utility to time ratio, this series is fantastic. Thanks Professor Nuttelman!

    Helpful(0) Unhelpful(0)You have already voted this
  29. Akos N

    Part 3 is somewhat a disappointing finish for the terrific P1 and P2 courses. There are simply not enough course takers so that the peer review system would make sense. Moreover, it really only focuses on user forms which is a very limited tool compared to other alternatives available in Excel. I highly recommend taking P1 and P2, but the only thing that kept me going is to get the set fully complete…

    Helpful(0) Unhelpful(0)You have already voted this
  30. Lei W I

    I think the whole specialization has very good a learning curve, from introducing concepts and getting your hands on working. Part 3 certainly gives you an opportunity to work with more complicated stuffs and gives you a sense of accomplishment. I feel like the marking scheme can be delegate down a bit more, right now for some parts it is either 0 point or 4 points which can be hard to reflect sometimes. Also there isn’t too many people taking this course unfortunately, so the peer reviews can be a bit annoying since you don’t have projects to review sometimes. Overall, this course has it all, and I think it could definitely help if your job needs to use excel in some sort of way.

    Helpful(0) Unhelpful(0)You have already voted this
  31. Lowell D

    This was much more difficult. Peer grading was challenging.

    Helpful(0) Unhelpful(0)You have already voted this
  32. Michail T

    Absolutely amazing. Exactly what an analyst needs.

    Helpful(0) Unhelpful(0)You have already voted this
  33. Timothy J T

    The projects were definitely challenging, the 2nd one more so than the first or third, but it allowed me enough practice to get good at both user forms as well as coding / debugging. Extremely well put together course. At first I wasn’t a fan of the peer grading, but each assignment is graded by 3 people, and then it takes the median of the score given by those 3 people. For example if someone wasn’t paying attention, and marked you as 0 for a rubric part that gives 0 or 3 points, but the other 2 graders did give you 3 points, then you would get 3 points for that section. Very fair.

    Helpful(1) Unhelpful(0)You have already voted this
  34. Nian L

    This series of VBA courses from UC Boulder is one of the best for beginner to learn VBA coding. The materials and videos are well organized; Charlie is an excellent instructor to guide you through different topics step by step. The assignments are very helpful to enhance and improve your ability to be able to code independently if you put in the work. Part 3 is project–oriented, the projects involved are all very practical and can be applied in various real–life/working environment. I feel extremely grateful that Charlie has put this course on Coursera, I loved the experience. One minor issue is that since the grades are from peer–review, sometime it’s hard to wait for/find other classmates to grade. My approach is to use sharable link and leave messages while review others/ in the discussion forum. Hope this little tip will help the later classmates to get their grades smoothly.

    Helpful(0) Unhelpful(0)You have already voted this
  35. Yuan L

    I love this specialization! Charlie is a very nice and patient instructor. He starts from the very basic knowledge of programming language. He explains each project from the sketch and the structure of each project is very clear. He is good at using concise words to describe a complicated issue. I learned a lot from these real projects in this part3. Thanks!

    Helpful(0) Unhelpful(0)You have already voted this
  36. Roger W

    I really enjoyed this course. I believe VBA is an underappreciated language because many individuals undervalue its practical application. Part 3 allows your understanding of VBA to migrate toward this more valuable aspect of VBA. In terms of course content, Charlie is a fantastic lecturer willing to go above and beyond for all course–related matters. Also, the slow peer–reviewing issue can be fixed by using the discussion forums as a medium to negotiate quicker reviews. I would 100% recommend this course to any individual looking to transform/optimise excel–related processes (or any process that can be completed in excel).

    Helpful(0) Unhelpful(0)You have already voted this
  37. Jose A

    Excellent course! Thank you very much for the oportunity of joining this course!

    Helpful(0) Unhelpful(0)You have already voted this
  38. Juan M F M

    Excellent course and excellent specialization. Charlie, thank you so much, you are a great professor and a nice person.

    Helpful(1) Unhelpful(0)You have already voted this
  39. Mark D

    Instructor and videos are very good. Peer review process and coursera’s software for grading could be improved. Students should be able to see how many times their project has been graded while they wait for a grade to be finalized. Students should be able to see a history of the projects they graded for others and be able to change grades if there was a mistake in the grading process.

    Helpful(0) Unhelpful(0)You have already voted this
  40. Pablo I

    Great course! I’ve learned new and very productive skills that will enhance my capabilities. Sometimes peer review does not work as expected because. This is an issue to improve.

    Helpful(0) Unhelpful(0)You have already voted this
  41. Deviatkin V

    This peer check thing is kind of frustrating as there are not so many peers so it takes too much time

    Helpful(0) Unhelpful(0)You have already voted this
  42. Aleksej A

    Best course in the series as you really get to put your acquired knowledge into practice. I though the projects were diverse enough to find interesting applications across various fields. The final project was very interesting and worth doing as you get to create a sizeable application from scratch with a large amount of code that was as tricky to troubleshoot as it was to write and you had to learn from your mistakes over and over again.

    Helpful(0) Unhelpful(0)You have already voted this
  43. francesco n

    I like it . Well done and clear. I would prefer less macro with userform and more macro with special funcionality ( sent mail, hide macro, protect sheet and cells in excell, ect..)

    Helpful(0) Unhelpful(0)You have already voted this
  44. Mariia D

    Projects are focused mainly on userforms, which was not exactly what I’d be primarily interested in. However, still good final for good series.

    Helpful(0) Unhelpful(0)You have already voted this
  45. Albert L

    I would like to thank the instructor for his engagement, high quality material, and useful comments. This course has helped me cement the knowledge from the previous 2 courses, and I am now a confident user of VBA. Even though it is impossible for any course to cover all the aspects of a programming language, it does provide a solid basis which one can further develop their skills upon. Keep up the good work!

    Helpful(0) Unhelpful(0)You have already voted this
  46. Jose V

    Amazing! I recommend it 100%

    Helpful(0) Unhelpful(0)You have already voted this

    Add a review

    Your email address will not be published. Required fields are marked *

    This site uses Akismet to reduce spam. Learn how your comment data is processed.

    Excel/VBA for Creative Problem Solving, Part 3 (Projects)
    Excel/VBA for Creative Problem Solving, Part 3 (Projects)

    Price tracking

    Java Code Geeks
    Logo
    Register New Account
    Reset Password
    Compare items
    • Total (0)
    Compare