Latest Courses
Fullstack Serverless Engineering (AWS, Node.js, React+Redux)Check course
Unreal Engine 4 : The Complete Guide (2020)Check course
The Complete Data Structures and Algorithms Course in PythonCheck course
Learn to create a 2D Idle Miner Tycoon Game in Unity 2020Check course
How to Create a WebApp using Google Apps Script webPagesCheck course
Docker for .Net and Angular DevelopersCheck course
Scala Programming From Scratch To DepthCheck course
ASP.NET Core MVC - Up and Running Part 1 (.NET 5)Check course
The Basics of Blockchain & HyperLedger FabricCheck course
APIs in Action: Build API-Based ApplicationsCheck course
Fullstack Serverless Engineering (AWS, Node.js, React+Redux)Check course
Unreal Engine 4 : The Complete Guide (2020)Check course
The Complete Data Structures and Algorithms Course in PythonCheck course
Learn to create a 2D Idle Miner Tycoon Game in Unity 2020Check course
How to Create a WebApp using Google Apps Script webPagesCheck course
Excel/VBA for Creative Problem Solving, Part 2

Excel/VBA for Creative Problem Solving, Part 2

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

“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 …

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 2

Duration 25 hours
Year 2018
Level Intermediate
Certificate Yes
Quizzes Yes

50 reviews for Excel/VBA for Creative Problem Solving, Part 2

4.4 out of 5
45
2
2
0
1
Write a review
Show all Most Helpful Highest Rating Lowest Rating
  1. Avatar

    Lindsey L

    Enjoyable course. Helped expand my skills with VBA. Encourage anyone who wants to be a wiz at VBA to take this course.

    Helpful(0) Unhelpful(0)You have already voted this
  2. Avatar

    JONATHAN A G

    Great Course, great instructor. Highly recommended. Thank you Charlie!!

    Helpful(0) Unhelpful(0)You have already voted this
  3. Avatar

    Rob B

    This course teaches you the “magic” part of VBA that allows you to create custom userforms that clearly differentiate your excel project from other typical spreadsheets. The course also helps you work across multiple worksheets and workbooks. All of this is useful for consolidating and standardizing data entry. And the custom userforms will help you stand out among your peers. (I can’t wait to see the looks on my co–workers faces when I debut some of these elements in our standard reports!)

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

    Moira C

    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.

    Helpful(0) Unhelpful(0)You have already voted this
  5. Avatar

    Catherine R L

    Very helpful! Highly recommend to VBA beginners!

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

    Richard C

    The material was helpful, but there were two flaws: first, I never got a sense of what I don’t know about VBA that I still would need to learn to be effective on the job. Second, I posted six questions to the discussion forums over the course of two weeks and none of them were ever answered. After two weeks I had finished the course material for Parts 1 and 2. Overall, useful material, thank you very much!

    Helpful(0) Unhelpful(0)You have already voted this
  7. Avatar

    Shivam P

    great

    Helpful(0) Unhelpful(0)You have already voted this
  8. Avatar

    Todd C

    The course is well structured, and the instructor (Charlie) makes it simple to follow and gives clear guidance on the topics presented

    Helpful(0) Unhelpful(0)You have already voted this
  9. Avatar

    Moreno C

    Another excellent course. As expected, part 2 was more demanding than part 1. The assignments were challenging but feasible. To gain the most from the course, I would recommend to work along with the instructor during the lectures in order to develop your own macros for future reference.

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

    Lauren K

    This course was very informative, easy to follow, and the assignments were challenging enough to apply the principles learned in the screen casts.

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

    Idriss B

    great course, thanks alot !

    Helpful(0) Unhelpful(0)You have already voted this
  12. Avatar

    Darren R

    Again, another stellar course. VBA, Part 2 really leaves you with a solid foundation upon which you can continue to develop your Office development skills. And that’s the beauty of this course. By learning Excel/VBA from Dr. N, you’re really developing the ability to program any Office application. I’ve already written macros in Outlook, for example, using the knowledge Dr. N has imparted in both parts 1 and 2. Besides for the fulfillment Dr. N might get from reaching so many students with his excellent courses, I hope he’s getting ample remuneration for his efforts because he deserves every penny of it, and I hope it encourages him to continue producing content on Coursera. I’d have no hesitation in completing more problem solving courses from him!

    Helpful(1) Unhelpful(0)You have already voted this
  13. Avatar

    Meenu S

    Excellent content with short modules, make the entire learning exercise very enjoyable !

    Helpful(0) Unhelpful(0)You have already voted this
  14. Avatar

    Daniel E Y M

    Nice Course, Helps to improve your excel skills (Macro). Recommended.

    Helpful(0) Unhelpful(0)You have already voted this
  15. Avatar

    Paula J

    Great VBA courses part 1 & 2!!!

    Helpful(0) Unhelpful(0)You have already voted this
  16. Avatar

    Santiago

    Un curso bastante interesante, con buenas indicaciones y buenos retos.

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

    Shradha J

    The course provides one the opportunity to work with a lot of concepts/objects in Vba.Be it arrays,working with diffreent workbooks/worksheets/user forms,you have it all in the course.

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

    Juan D G Q

    Excelente curso, como en la primer parte, la dinamica es increiblemente pedagogica y las tareas realmente te retan a hacer las cosas bien

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

    Gerardo G

    Great Course, please make a part 4!

    Helpful(0) Unhelpful(0)You have already voted this
  20. Avatar

    Zhen G

    Awesome courses, I love the content (super useful and fun to learn), as well as the way how the courses are organized – I took half to one hour a day after work or during lunch break to watch the videos and I can always know which page I’m on. The only things that I wish could change a little bit would be: 1. increase the volume (too low if not wear headphones); 2. answers and explanations for quiz (wk3–4); 3. if possible i really want to have a assignments answers so I can compare with mine even though I can pass. Nothing would change the great experience of this course, I’m happy that I passed and super happy that i can apply what i learnt from here to my job! 🙂

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

    Andres B

    Just awesome course to go deeper into excel vba. Highly recommended

    Helpful(0) Unhelpful(0)You have already voted this
  22. Avatar

    Juan M F M

    Nuevamente el curso me sigue sorprendiendo. Con cada leccion he aprendido un monto que ha ayudado en mi vida academica. Muchas gracias profesor Charlie, usted es increible. Nos vemos en la parte 3 del curso 🙂

    Helpful(0) Unhelpful(0)You have already voted this
  23. Avatar

    Anas

    It’s really an interesting and informative course to learn how to create User Form. I highly recommend this course if you are looking to be a professional in Excel. The way how the instructor illustrates the ideas is very clear and easy.

    Helpful(0) Unhelpful(0)You have already voted this
  24. Avatar

    Emre C E

    Nice coure. This part can be used easily in professional life in engineering.

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

    Abraham L C

    Very useful! Really tangible results, I didn’t need to finish it up to start applying everything. Great help for work so far!

    Helpful(0) Unhelpful(0)You have already voted this
  26. Avatar

    JunyanLiu

    please have a tech assistance to answer the question in assignment, I mean before the grade, students can have different kind of problems, they can’t solve alone.

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

    Andy M

    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.

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

    Markus K

    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

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

    Gintare D

    This one was good fun. Thank you!

    Helpful(0) Unhelpful(0)You have already voted this
  30. Avatar

    Navendu R

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

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

    wang x

    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!

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

    Jose P F

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

    Helpful(0) Unhelpful(0)You have already voted this
  33. Avatar

    Nathaniel N

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

    Helpful(0) Unhelpful(0)You have already voted this
  34. Avatar

    TAOUMI H

    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.

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

    Thuc T

    Awesome, super helpful class.

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

    Ivan R

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

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

    Daniel F V d O

    100% Recommended course to learn VBA

    Helpful(0) Unhelpful(0)You have already voted this
  38. Avatar

    Edmond J E

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

    Helpful(0) Unhelpful(0)You have already voted this
  39. Avatar

    ZHIZHONG B

    Very nice course!

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

    Corey F

    I highly recommend this course to anyone interested in learning Excel VBA. This course deservedly contains the words “Creative Problem Solving”, as I feel it to be an accurate description. Charlie comes across as a very knowledgeable and nice professor. His videos are short and to the point; and they will set you up for success. I personally found this learning approach to be satisfying because there is no one right answer to the assignments, which allows students to find their own way to solve problems. To do well in this course I recommend taking notes by hand to avoid using the computer as a crutch. While it seems counter–intuitive, I found writing out the code forced me to “think like the computer”.

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

    Pablo I

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

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

    Mariana P

    Dr. Nuttleman is the best professor to teach VBA!

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

    Jose A

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

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

    Fabio B C

    The best course of Excel that I had ever seen. Go on and embrave yourself with the best classes and teacher.

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

    Aleksej A

    Really enjoyed this course, gives you a practical knowledge of the possibilities of VBA in your day to day work life.

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

    Albert L

    Completed this course in parallel with the 1st part. The content and the structure of both courses are amazing, and I can already feel the benefit at my workplace: the knowledge has allowed me to optimize some menial tasks which I previously used to avoid. Looking forward to Part 3!

    Helpful(0) Unhelpful(0)You have already voted this
  47. Avatar

    Mariia D

    Excellent. The whole series is ceratinly worth taking.

    Helpful(0) Unhelpful(0)You have already voted this
  48. Avatar

    Lee C C

    Excellent!

    Helpful(0) Unhelpful(0)You have already voted this
  49. Avatar

    Yannick N K N

    Excellent course, I decided to continue after I concluded Part I. Part II made me really love MS Excel. Would be better if there was some pdf files for learners support, but nevertheless the course quality and the teacher exceeded my expectations.

    Helpful(0) Unhelpful(0)You have already voted this
  50. Avatar

    Irakli B

    An amazing course that taught me a lot in a short period of time. Suggest everyone who wants to learn VBA. However, Part 1 is crucial especially for beginners, to make through this part. Definitely going to take part 3 as well.

    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 2
    Excel/VBA for Creative Problem Solving, Part 2

    Price tracking

    Register New Account
    Reset Password
    Compare items
    • Total (0)
    Compare