Great course! I like it goes straight to implementation and is practice-oriented. What could be improved maybe is sound quality of lectures. And maybe it would be great to have some VBA notes in pdf.
The pattern of course is really nice.It first teaches all the basic information in video and the assignments are designed in a way that all the taught information are used to solve the assignment.
von Raffaele M•
Lots and lots and lots of errors, in the slides, in the speech, and also in the quizzes (with the author writing ("I need to fix that"). Part 5 really interesting.
von Darren R•
This is an excellent course. One of the best I've taken. The pacing and level of challenge are perfect. Not too easy, not impossible. There are no surprises in the quizzes or assignments. You will have everything you need to excel by watching and following along with the videos. Even though there is an engineering bias in the course, and I don't have an engineering background, Dr. Nuttelman ensures you'll have enough explanation to follow along and complete assignments.
Dr. Nuttelman has done a fine job in creating this course. It goes to show that all you need to create a great course is a great teacher, simple videos, clear audio, and engaging and appropriately challenging material. No gimmicks, no nonsense! This course delivers!
von Hui L H•
This is an awesome course for me. I love the way Dr. Charlie teaches the course. He always goes through material step by step and re-cap a couple of important concept in the pop-up quizzes at the end or in the middle of the video to refresh your memory. You can see how the course is well thought-out by looking at the course schedule and after taking the class. For the function of my job, I need to use excel including formulas, optimization tool, VBA...etc. extensively but I have never been exposed to a complete training for it so this course is totally a livesaver for me. I highly recommended this course to people who need to excel for their job or people who are just interested in advanced excel skills. Thank you Dr. Charlie!!
von Matt F•
Great class! I have been looking at increasing my Excel skills and wanted to learn VBA, however, I really could find a class that had what I needed. This class was what I was looking for, even though it is more engineering based. I highly recommend it for getting into VBA. I liked the mini quizzes and the assignments. They both help you learn and retain the material. Dr. Nuttelman was also very responsive. Had been staring at my VBA code too long and wasn't able to figure out why my code wasn't working correctly on one of the assignments. I sent it to Dr. Nuttelman and he was able to look over my code and point out the problem. Very quick turnaround on getting an answer too! I will be signing up for Part 2 of this course.
von Sanjeev B•
I love how this course has been structured. VBA being a very expansive programming language can get very intimidating for beginners and there are plenty of course available about VBA where students quickly get overwhelmed or loose interest right from start. This course has been structured perfectly in getting rid of these two common issues.
Also, I love the solving/grading section (post quiz). It just allows the student to apply the knowledge gathered in a practical way, in order to pass on to the next level. Makes it fun and keeps the student interested in the course, needless to say that it inherently allows strengthening the fundamental concepts of VBA.
Great work professor Nuttelman, full marks to this course!
von Celso C F•
Excellent course. This course teaches the mechanics of how to create macros/VBA subroutines, key concepts related to programming and very interesting examples on how to apply everything that was learned are given throughout the course. The explanations are clear, precise and easy to understand.
I have to confess that I was afraid about how challenging this course would be, because learning how to create Excel macros has always been a big deal for me. Professor Nuttelman does and excellent job in this course, even though the course is supposed to last 5 weeks, I was able to finish the 5 modules in 2 weeks.
I am now taking Part 2 of this course and, as soon as I finish it, I plan to start working on Part 3.
von Valerie W•
This course is very comprehensive, and the hands on assignments give us plenty of opportunity to research and practice to fully comprehend what had been taught.
I had attended a 1 day basic VBA course previously with the professional body I was with before. It had been a confusing experience. Hence I really appreciate how each video gives bite size information from basic operators and logic of VBA, to the structure of the subroutine and functions, the flowcharts to guide the analytical planning of the codes for problem solving. I totally enjoyed this online course!
Highly recommended even if one has none or limited programming background. Some Excel knowledge would be helpful I feel. Awesome course.
von Nicolas M•
First of all, I want to thank Professor Charlie Nuttelman, an excellent instructor who guided us in the first steps, of learning VBA, I liked the course, because it was orientated to engineers, the way he explained the algorithm. I have been programming for almost 3 years, but I learned other loops, like do until loop, do loop. and The final week, was so interesting. Because in my career civil engineering not only we have to optimize costs, but also we have to build strong and resistance structures. Also, it was very was useful in the bisection method, because we deal with a lot of non-linear equations, and we have to solve them numerically.
von Matthew A•
Fantastic course, 5-stars!
1) In section 5 when building the algorithms you could also add a check for convergence using a tolerance. The 20x for loop seems somewhat arbitrary. This is pretty easy to do, but might be a nice addition for people who haven't coded these algorithms before.
2) Not sure if this is possible, but there's a way to pass a function as a variable in VBA, then in section 5 you could build more generalized solver/optimization algorithms (as opposed to having to re-code the algorithm for each new function you encounter).
Again, great class learning a ton!
von Murtuza B•
Really enjoyed the journey. Material is presented in a very lucid way. Also the grading style is innovative. It feels like you are finding the code to the lock which will lead you to the final treasure. One thing I would like to tell you all is, please complete the week 5 as well (it is optional). The real fun starts at week 5. The new and the fun things about excel is in week 5 material and tests. Also week 5 has all the real life applications of what you have learnt previously. I wish you all good luck. Also I would like to thank the creator for his time and great service.
von Archana M•
The course was very insightful. Prof. Nuttleman kept up with his words of providing a challenging learning environment. The quizzes and assignments were superb! They really get your mind into thinking about solving a problem. Another good part is working with excellent examples - also to note that Prof. Nuttleman subtly demonstrates a live example by making the grading part itself in VBA! The course can be relatively easier for someone who already knows some programming, but it can also be a good path to begin with programming. I would totally recommend this course!
von Vinayak N•
It taught me a lot of things in a short period of time and I look forward to using the knowledge in my day to day life for doing tedious things in an effective manner with short amount of time.
The instructor was concise and cogent and the assignments are designed to test your understanding of the concepts pretty nicely.
I feel the number of questions per assignment could be increased to give more practise or at least optional questions should be provided for interested people for the same purpose. Apart from that, great work, loved the course, Thanks Charlie!
von Natalia M•
This is a very good course! The best online course I've ever had. The structure, the order in which material is given, the difficulty of the course are very thought over. And the most important, I feel that the course is very effective. You just need continue practicing VBA (doesn't matter here or somewhere else) to improve the skills acquired here. Because those are very well developed here. I would highly recommend this course to anybody who is looking for the opportunity to learn VBA and enhance Excel skills. But I am heading to the second part! Yeah!
von Katie H•
This is a fantastic course. As someone who has fumbled my way and self taught myself this was a great back to base camp that has already taught me some good tricks that are invaluable in my day job (as an engineer in the utility sector I'm always moving data between spreadsheets). Looking forward to seeing this specialization through. Professor Charlie is a great teacher - I would have been lucky to have him at undergrad. The format is great and the visual aids during the screencasts are amongst the best I've seen (I've done a lot of online learning.).
von Diego A Q•
It's a good introduction to Excel VBA if you are completely new to it. Week 4 and 5 are certainly more intense. Basic mathematics (not so basic at week 5) are required for this in order to have a lighter experience, although I suppose people with mathematics affinity are the ones who do this kind of courses.
Anyways, I definitely learned a lot doing this course. As I work everyday with excel but never tried anything with macros, I have been kind of limited to use excel's full potential. I would actually like to continue with part II.
von Sean W•
This is a great course if you really want to use VBA beyond just recording a bunch of mouse clicks. I was already pretty familiar with Excel and some surface level VBA stuff. Thanks to this course, I have a much better handle on the available features of VBA to the point where I have already been able to implement some valuable things at work. I would imagine that this would be the case even for an Excel beginner. I would highly recommend this course for a fairly wide range of experience levels. I'm looking forward to Part 2.
von Jon F•
Excellent! The best part was Week 5, the honors section of the course. I strongly recommend doing the honors section – I learned almost as much in the honors section as I did in the prior four weeks. Prof. Nuttelman is a very good lecturer and he has a very practical and understandable approach to teaching. I always knew this thing called “VBA” was there in Excel . . . if I had known how powerful it was I would have taken this class a long time ago. I am looking forward to Prof. Nuttelman’s second Excel/VBA course.
von Wilfried K•
I encourage everyone who wants to learn something valuable to take this course. The teacher takes the time to explain the fundamentals of VBA programming thoroughly. You have the opportunity to test your knowledge at the end of most teaching videos, and this encourages you to stay focused. The quizzes and assignments are adapted to the level of the learner and in conformity with the topics covered.
Thank you Mr Nuttelman for your engagement.
Note : This is the first time that I complete the course on Coursera.
von Britt E•
I have never used VBA or any programing before. I found this course easy to follow and I have already been able to see multiple applications for my work. I am an experienced excel user, but have only used the formulas in Excel and this has resulted in some very clunky and somewhat confusing spreadsheets, some of which take up to 5 minutes to perform calculations. I see several areas where writing in some VBA macros will simplify these spreadsheets and also reduce calculation time. I plan to take part 2.
von Rizwan L•
At the start of this course, I knew nothing about VBA utilities and possibilities in daily life. It was a call from inside me that I should take this course as I knew basic stuff about MS Excel and taking this course was an opportunity to enhance my skills in this particular application i.e., MS Excel. Found it very difficult at the start but the instructor designed it so well that with little extra effort I learned the whole course and completed it with good grades.
Recommend it strongly.
von Barbara C•
Very well written and thorough with lots of activities to practice skills/coding. After completion I feel very confident in what I have learned. I really enjoyed taking this course!
*Note that if working in Microsoft's new "Cloud" based (OS) system, ensure that your assignments are located on the computer drive itself, otherwise the grading code does not work properly. I had this issue, which had me scratching my head wondering what I did wrong until I moved my files to the local drive.
von János K•
At the begining of the course I have a faintest idea about the VBA. At the end of this course I have a basic knowledge about it. I did not become a programmer specialist , but that was not a goal either. My idea to start programming at basic level came true.Thank you for everyone who contributed to this course and special thank you for the instructor!
((( at the very very end ... a workbook with lots of task and solutions would be welcome for better understanding and practice.)))
von Jéssica M•
Great course! I'm already familiar with some coding but I wanted simple solutions for some reports I run daily in excel. I was looking for something exactly like this: simple, useful and well structured. I think the course is perfect for small projects and daily solutions in the office as well. The magic of VBA/Excel is it can be applied for most of the knowledge areas. I would recommend for people who want automate repetitive tasks and optimize their work! Great job Charlie!
von Suresh R•
It was a great learning experience. I knew the basics of computer programming for a long time. But I was tired of running my codes in some compilers with those unlikely black screen. And I didn't get any chance or time to learn app development or any other advanced programming to cool and fancy stuff for real-world problem-solving, since my stream of study is not related to computer science. Thanks to this course came to the rescue to help me continue with my coding skills.
von Jhon F C M•
Hello there! That was an amazing course! I learned a lot, the screencasts were very helpful and very well explained. However, maybe share a STARTER document for every screencast would be very helpful too. I mean, a document to start to programming and follow the steps. Or maybe the code as a .txt file just to compare if we are going good, we know that there are a lot of ways to do the things.
These are just thoughts, the course was amazing. Congratulations and thanks!