Charlie Nuttelman
“Excel/VBA for Creative Problem Solving, Part 1” 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). This course is the first part of a three–part series and Specialization that focuses on the application of computing techniques in Excel/VBA to solve problems. In this course (Part 1), you will: 1) create macros to automate procedures in Excel; 2) define your own user–defined functions; 3) create basic subroutines to interface with the user; 4) learn the basic programming structures in VBA; and 5) automate Excel’s Goal Seek and Solver tools and use numerical techniques to create “live solutions” to solve targeting and optimization problems. New to computer programming? The extremely intuitive and visual nature of VBA lends itself nicely to teaching and learning – what a fun way to learn to code! No prior knowledge in programming nor advanced math skills are necessary yet seasoned programmers will pick up new and creative spreadsheet problem solving strategies. After you have learned the basics of VBA, each module will introduce foundational and broad problems inspired by situations that …
Instructor Details
Courses : 3
Specification: Excel/VBA for Creative Problem Solving, Part 1
|
64 reviews for Excel/VBA for Creative Problem Solving, Part 1
Add a review
| Price | Free |
|---|---|
| Provider | |
| Duration | 20 hours |
| Year | 2017 |
| Level | Beginner |
| Language | English |
| Certificate | Yes |
| Quizzes | Yes |
FREE
Bogdan B –
I’m 59 yeaars old and i had big pleasure to study this course.
Mohit M –
Practical. Well paced
Diego E –
Amazing!!
Michal P –
Challenging but rewarding at the end. One of very few courses that teaches not only the subject but the actual thinking process.
SRISHTI P –
EXCELLENT COURSE
Anna M –
Great course! thank you! I really like quizes and projects
Pablo I –
Muy buen curso, bien explicado y de gran valor para mi. Muchas gracias
Fabio B C –
This course was the best to introduce VBA in my currently routine. The teacher is very excellent explaining since the theory to application. You will learn to do a lot of things with basics commands and I certainly will use this in my sheets. Congratulations, now I’m goingo to Part 2. Thanks a lot!
Nattawat B –
Great Coruse
ZHIZHONG B –
Very good courses set up and I learned basic knowledge about VBA. The deduction of 1 star is because I wish I can get the PPT available to download 🙂 Still highly recommended for this course!
Anna H –
Loved this course! It is very well–structured and the concepts are easy to understand. What I like the most is that the course it truly hands–on – I was able to implement the tools & techniques right away to optimize my workflow. Highly recommended!
Erikos –
Very helpful and interesting course, mostly due to great teacher! I applied this knowledge (Do..Loop, For…Next) in my business valuation models to solve the issue with circular reference in financial statements. Will sign up for the second part definitely!
Abhinav S U –
This course is good for beginner coders and was also quite difficult.
Ivan A G –
This is an excelent course, and I learnt a lot about it . And I’m certantly sure that it will help me for my career
Om V –
An excellent course that starts with the basics and ends with some really advanced topics and concepts. Superb for anyone who’s in a hurry to learn VBA but also desires to learn in depth.
Sangameshwar K –
Had a wonderful experience with this course. Thank you for preparing the course(s).
Huy P T –
The best course out there for learning MS Excel/VBA. Mr. Nuttelman is so passionate about teaching this subject, and you can tell this by doing the assignments. For example, after finishing the first assignment, I wanted a quick way to get the certificate. So I decided to look at the VBA script in his GRADER file, hoping to be able to change the content. Nope, he locked it with his password. So I had to look for a way to crack the it. Surprisingly, this was actually the best way to learn how to code in VBA because I had to understand the steps and every line of code. Finally, here’s the password: nutsnutsColorado80309 (the last digits turns out to be the zip code of the university).
Suyash M –
Instructor has done a great job in creating this course.
Chun–Wing L –
very good course structure, it really helped me to learn about VBA Excel in a very pleasant and accessible way!
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.
Amanda S D –
I loved the part 1 of the course, looking forward for the next ones!
Chun Wing L –
very good course structure, it really helped me to learn about VBA Excel in a very pleasant and accessible way!
Rita –
Only for engineers. Very disappointing experience. Save your money unless you are looking to compute square roots and exponentials of pi.
Jean–Baptiste C –
Great course. Concepts are presented in a clear and simple manner.
Jean Baptiste C –
Great course. Concepts are presented in a clear and simple manner.
Anurag A –
Can you put an example for booleans?
Sabarish A –
The course content was pretty awesome but when searching for help no one came up to help me. Was hard to find help, I was lucky somehow I was able to get the assignments done
Lee C C –
Overall is great!
Xueying W –
Not MacOs user friendly. No warning about computer system in course introduction. No specific answer for assignments. No Grader file for Mac. As a Mac user I feel distressed.
Narciso L L –
Very useful for people who wants start to work with Visual Basic.
Marcello G M –
Curso muito bom! Acrescentou muito ao meu aprendizado de VBA, irei recomendar a todos e estou ansioso para continuar aprendendo nas Partes 2 e 3.
Parambir S –
The only difficulty I faced in the course was small error correction in the assignments as with very little practise you tend to make mistakes which are difficult to correct with instructions from the grade/default instructions. Nonetheless, it felt great completing this first part! Looking forward to the remaining course!
Laura V –
I appreciate the little quizzes at the end of most videos and the assignments are really challenging to make sure content is fully grasped.
scott d –
Wish they had another 2 or so projects quizzes to cement learning
Alfredo E –
Really useful course! Very good for learning how to record macros and interpret the vba code. Very nice and looking forward to part 2. Professor Nuttelman is very good and CU boulder is lucky to have him!
Alessandro C –
A very good introductory course in Excel/VBA. The video lectures are always clear and interesting. The assignments are aimed at reinforcing the concepts explained in the lectures and their difficulty is very well–balanced.
Ivana C N –
Excelent! Thank you for the explanation!
Aleksej A –
Good introduction to the basics of VBA
elghadraoui f –
the best course i have enrolled
Aqeel C –
In my opinion, this course is the best course regarding VBA fundamentals.
Marcelo S V –
Great course!! For a Part I it introduces you to useful functions and ways to approach different kind of problems. Challenging course but reasonable with low algebra. Exactly what I was looking for.
Jonathan –
This type of course should have been mandatory regardless of your major. Pursue the certificate to keep you engaged throughout. I am looking forward to part 2.
Albert L –
The course provides high–quality content, and the lecturer’s comments are very insightful. All in all, it is a great value for money!
Matthew W –
Awesome course. Learned a lot and tons of fun
Mariia D –
Excellent for a beginner, systematic, demanding and explanatory.
Brandon H –
The course was good. My focus was learning VBA and getting to a point of being able to design multi–faceted solutions. This got me on my way. The only item I noted as a downside is the focus on mathematical examples requiring order of operations to be understood. While I enjoyed this I don’t see it as essential for knowing how to design solutions in VBA and it created some blocks for others in our group who do not enjoy mathematics.
Liu C –
a good intro for me to master VBA
AJAYI S J –
Very good with very power insight into the world of VBA. This is best course on VBA the world need to see.
David S –
it was great and iIreally enjoyed it
Nguyen H Q –
very comprehensible and useful
Tyler H –
For beginner who are not familiar with programming, this is a good opportunity to understand and explore through Excel VBA. I recommend it not only for such a solid work in course design but also the confidence build–up during the process of problem solving.
Nath –
Interesting but much more math oriented than expected making it more complicated for beginner.
Charlie Z –
Very impressive
Craig D –
Too much engineering not enough real world examples (unless you’re an engineer).
Martin V M –
Great course in order to begin with VBA. Although, it contains some math problems related with engineer stuff, it’s not hard to follow since the theory is well explained and the complexity is not too high. Also, it’s interesting to see a different approach to Excel/VBA from other carreers.
Brittany M –
The course content is solid. The material will come in handy, however, I found the examples to be less than intuitive as I work in auditing and don’t have a strong science background. More understandable examples and assignments would be helpful. In addition, I felt that week 4 was a significant amount of material that could possibly be broken into 2 sections. I also thought week 4 would be easier to understand if there was a chart describing the differences between the different types of loops and possibly adding small assignments after each loop to solidify the concepts. Overall it was a good course that I would recommend,
Julius W –
Excellent course, although I had prior coding experience. While I successfully completed the five weeks, if I had got stuck somewhere, without posting my answer in the discussion forum, I am not sure who I would have went to for help if I had gotten stuck. Part of the learning process is feedback and the assignments are just yes or no without much direction. I understand the assignments are a bit too open for pre programmed feedback, but having somewhere to view more hints if I got stuck would be nice.
Evan M –
I like this course. Very helpful. But, the quizzes are “tricky” meaning the content is not too hard, but the questions are tricky. The assignments are very good, much better than the quizzes.
Alejandro V –
Muy interesante y a la vez entretenido para aprender a usar las funciones basicas de VBA
Greg L –
good intro to the topic. Quizzes could be improved with more meaningful questions, but assignments were good
Sebastian E I C –
Muy buen curso, muy entretenido
Shilpi J –
Excellent course for beginners. Its a quick introduction to VBA and has been pretty handy to automate repetitive jobs.
Nguyen H Q –
very comprehensible and useful
Gyver F S –
Very well done course, very didactic and challenging