Excel/VBA for Creative Problem Solving, Part 3 (Projects)
FREE
Add your review
Add to wishlistAdded to wishlistRemoved from wishlist 1
Add to compare9.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
Charlie Nuttelman
Courses : 3
Votes: 1
Courses : 3
Specification: Excel/VBA for Creative Problem Solving, Part 3 (Projects)
|
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
Add a review Cancel reply
This site uses Akismet to reduce spam. Learn how your comment data is processed.
Price | Free |
---|---|
Provider | |
Duration | 28 hours |
Year | 2018 |
Level | Expert |
Language | English |
Certificate | Yes |
Quizzes | Yes |
Excel/VBA for Creative Problem Solving, Part 3 (Projects)
FREE
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.
Ronald d R –
Challenging and rewarding. Very useful and complete. Great tutor support. A course i am enjoying very, very much.
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.
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!
Chan w l –
Useful !
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.
Carlos A F C –
Very good course. I have learned along ober this course.
Alan A A Q –
Best course to learn Visual Basic
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
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!
Caetano C –
Awesome course. Challenging but yet easy–going.
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.
Manoel L C N –
Great course!!
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.
Luis E B –
great course! chellenging and enriching!
Douglas G A F –
Awesome course for all of us that want develop advanced VBA apps for Excel data analysis and management.
prem –
one of the best courses i have done . It provides the right kind of exposure needed
Johannes H –
Great projects that test what you’ve learned in the first two courses. Thank you Charlie, for the classes!
Deleted A –
An excellent practical problem–based course. The best way to learn is by doing.
Nedko Y S –
Excellent course!
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.
JONATHAN A G –
Great course, great instructor!
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.
Ng T E –
Good course for learners to build projects from scratch.
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.
Idriss B –
The best course I’ve taken so far, I can’t thank you enough for the great content.
HALAH A –
Excellent for beginners learning Excel VBA
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!
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…
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.
Lowell D –
This was much more difficult. Peer grading was challenging.
Michail T –
Absolutely amazing. Exactly what an analyst needs.
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.
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.
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!
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).
Jose A –
Excellent course! Thank you very much for the oportunity of joining this course!
Juan M F M –
Excellent course and excellent specialization. Charlie, thank you so much, you are a great professor and a nice person.
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.
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.
Deviatkin V –
This peer check thing is kind of frustrating as there are not so many peers so it takes too much time
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.
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..)
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.
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!
Jose V –
Amazing! I recommend it 100%