Charlie Nuttelman
“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
Courses : 3
Specification: Excel/VBA for Creative Problem Solving, Part 2
|
50 reviews for Excel/VBA for Creative Problem Solving, Part 2
Add a review
| Price | Free |
|---|---|
| Provider | |
| Duration | 25 hours |
| Year | 2018 |
| Level | Intermediate |
| Language | English |
| Certificate | Yes |
| Quizzes | Yes |
FREE
Lindsey L –
Enjoyable course. Helped expand my skills with VBA. Encourage anyone who wants to be a wiz at VBA to take this course.
JONATHAN A G –
Great Course, great instructor. Highly recommended. Thank you Charlie!!
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!)
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.
Catherine R L –
Very helpful! Highly recommend to VBA beginners!
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!
Shivam P –
great
Todd C –
The course is well structured, and the instructor (Charlie) makes it simple to follow and gives clear guidance on the topics presented
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.
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.
Idriss B –
great course, thanks alot !
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!
Meenu S –
Excellent content with short modules, make the entire learning exercise very enjoyable !
Daniel E Y M –
Nice Course, Helps to improve your excel skills (Macro). Recommended.
Paula J –
Great VBA courses part 1 & 2!!!
Santiago –
Un curso bastante interesante, con buenas indicaciones y buenos retos.
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.
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
Gerardo G –
Great Course, please make a part 4!
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! 🙂
Andres B –
Just awesome course to go deeper into excel vba. Highly recommended
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 🙂
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.
Emre C E –
Nice coure. This part can be used easily in professional life in engineering.
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!
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.
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.
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
Gintare D –
This one was good fun. Thank you!
Navendu R –
An excellent course, recommended for all of those who work with numbers. This course is well suited for design engineers.
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!
Jose P F –
Excellent Course! Learned a lot of useful skills that I will put in practice immediately at work.
Nathaniel N –
I liked the user forms a lot. It was the most relevant part for my work.
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.
Thuc T –
Awesome, super helpful class.
Ivan R –
Very informative, quite demanding. I don’t hesitate to recommend this course.
Daniel F V d O –
100% Recommended course to learn VBA
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.. 🙂
ZHIZHONG B –
Very nice course!
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”.
Pablo I –
Very nice course. Challenging but very well explained. I look forward whith anxiety to start part 3 of the course.
Mariana P –
Dr. Nuttleman is the best professor to teach VBA!
Jose A –
Excellent course! Thank you very much for the oportunity of joining this course!
Fabio B C –
The best course of Excel that I had ever seen. Go on and embrave yourself with the best classes and teacher.
Aleksej A –
Really enjoyed this course, gives you a practical knowledge of the possibilities of VBA in your day to day work life.
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!
Mariia D –
Excellent. The whole series is ceratinly worth taking.
Lee C C –
Excellent!
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.
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.