Chevron Left
Back to Excel/VBA for Creative Problem Solving, Part 1

Learner Reviews & Feedback for Excel/VBA for Creative Problem Solving, Part 1 by University of Colorado Boulder

4.8
stars
4,131 ratings

About the Course

"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 you might encounter in the real world. To pass each module, you'll need to pass a mastery quiz and complete a problem solving assignment. This course is unique in that the weekly assignments are completed in-application (i.e., on your own computer in Excel), providing you with valuable hands-on training....

Top reviews

MS

Jan 26, 2018

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.

JH

Apr 2, 2020

Very good course with clear examples throughout to help you develop. The online format of the course is great as it allows you to pause and work through the activities presented at your own speed.

Filter by:

101 - 125 of 1,182 Reviews for Excel/VBA for Creative Problem Solving, Part 1

By Robert C R

Feb 23, 2024

Professor Nuttelman does a fine job in getting us started with the VBA programming language, which many people have access to through Excel, but never bother to learn. I certainly hadn't. This first course in the specialization teaches well over half of what one is likely to use in most business or research situations, and I'm very glad that I've added this language to my list of skills.

By shantanu c

Jul 24, 2018

I am preparing for masters in Operations Research specializing in Finance. I heard Excel and VBA is still very popular in finance, so I wanted a good reference material to wet my toes. But this course was much more than I thought I wanted to learn and it helped in achieving more than my aspirations through a very well thought out content and assessments. Well done Professor Charlie!!!

By Sujith K

Jul 10, 2018

Hi,This course is very helpful for beginners in Excel/VBA, you will learn a lot about VBA and excel at a good pace. It helps you to apply this knowledge in real world problems. The examples and assignment given with this course work will be a good hands on experience. I would love to do the subsequent courses with Excel/VBA for Creative Problem Solving.Thanks,Sujith kumar Haridasan

By Deeparnak B

Mar 10, 2019

This is one of the most useful courses I have done on coursera. I'm now equipped to go ahead and apply the concepts learnt from this course right away. The instruction by Prof. Nuttelman is extremely fluid and easy to follow, even for the most complex concepts presented in this course. This course is highly recommended to anyone who wishes to leverage their excel and VBA skills.

By Vivek K S

Aug 31, 2019

The way tutor explains is very lucid. also the screencasts are ver

The way the instructor explains is very lucid. From week 1 to 4 all screencasts are very helpful. Examples are binded to the concept he explains in the screencast and very helpful for assignment and quizzes. Assignments and quizzes are nicely prepared and not very tough. One last line, Kudos to the instructor.

By Dianadlt

Apr 17, 2020

This is an excellent course everyone should take to understand Excel Macros.

The teacher explains very well and uses many examples that help to better understand each topic.

I highly recommend this course and I am looking forward to taking the following courses.

Thank you so much, teacher Charlie Nuttelman I learned a lot thanks to you.

Greetings from Mexico,

Diana de la Toore

By Diego R M E

Feb 20, 2019

I recommend this course to everyone. The course is really well designed and useful (screencasts, examples, tutorial). Furthermore, Charlie is an excellent teacher.

As a suggestion for making the course even better, it would be interesting to know/understand why the answer is incorrect when the grader tests the assignment and gives us some feedback.

Thank you, Charlie!

By Bruno C F

Jun 24, 2020

Wow. It is so awesome to learn something, specially when you have no idea about what you are doing. The course is very friendly and clear. Very goos teacher and if never have heard about VBA ou any programming language don't worry. You'll have success. Now let's start the Week 5 (optional) and after that Part2 and 3. See you there.

Get start. what are you waiting for?

By Izabela K

Apr 5, 2020

One of the best courses here on Coursera. Lecturer provides explanation and practical tips during each lesson, projects are great and each one is verified with premade tool (usually I encounter peer graded assignments but they may not be objective, other students may give points anyway).

Moreover I don't like Excel (I prefer Python) but this course was real pleasure!

By Rebeca F O

Jul 18, 2020

I'm really happy with this course and the teacher. I honestly learned a lot and there are very interesting tools that I think everyone should learn or at least improve them if you already know how to use Excel. Even if the week 5 is optional, I recommend you to finish this course completely because in week 5 you're going to learn some amazing and very useful tools!

By Sherly C

Jul 13, 2020

Content is clear and easy to follow. I liked all the examples. I do think that someone without any Excel background may struggle a bit. The only challenge, on my part, was getting support on submitting assignments. That needs to be simplified or students need to be warned of compatibility issues from the start to reduce frustration. I am looking forward to part 2.

By Charlotte C

Sep 26, 2021

I really like this course! It is very well structured, beginner-friendly and all the videos are well-explained! One of the best course I had ever attended on VBA. I always find programming language is abstract and hard to grasp an image of it but I gained a clearer picture of it after finishing the course. The teaching is top-notch! Thank you Mr. Charlie!

By Diego R

Aug 3, 2023

One of the best courses on this platform that I've really enjoyed. The course structure was very nice; it delved straight into VBA programming without being too overwhelming for learners, thus ensuring that time wasn't wasted. I would rate it 10/10. I highly recommend this course if you're truly determined to start learning Visual Basic for Applications.

By Mohd R

May 26, 2022

I found tremendous value in this course. After finishing week three I was able to use my skills, which was obviously very basic, to write a piece of code that saved me and my colleagues in my department hours of meaningless work. My colleagues were very appreciative and pleased with what I had done. Looking forward to the next two parts of the program.

By Anja H

Sep 27, 2022

This course was a great Intro do Excel VBA. I am definately continuing with the specialization.

The instructor is friendly and explains everything clearly.

I liked the assignments and I am looking forward to solving more of the assignments (feels like little puzzles, I love that).

I am sure that the course content is going to be helpful for my work.

By Yingli W

Aug 19, 2018

I would highly recommend this course to my friends! The course introduce several basic concepts and gradually some practical and advanced applications. The quiz and assignments might not be as difficult as the lessons are (my opinion only). And the mentors as well as professors are eager to help you in the discussion forum, which is really helpful.

By Apurv G

May 27, 2020

what an experience ! this is perhaps the most impactful online course that i have done. the exercises and quizzes were top notch and really assisted in proper learning. learnt a lot about macros and vba and surely have become more comfortable in dealing with it. hoping to implement some of this in my office work. thanks a lot. highly recommended.

By Eduardo A V

Jun 16, 2020

Great! I am very advanced when using Excel. i didnt know hoe much I was missing with VBA. Few lines in VBA can make some routines that take hours to minutes!

The course is focused towards solutions to everyday problems. If you are a heavy user on Excel and looking to increase your exposure in programming, this is the course to start with!

By matthew o

Apr 4, 2020

Videos and teaching methods are very effective. Quizzes and assignment are also challenging but rewarding when you were able to resolved it.

Hopefully in the succeeding lectures, you can devise a way to have a portal wherein students that are having difficulty to have someone to ask to that can provide a quicker response.

Regards,

Matthew

By MARCOS E V Y

Feb 1, 2021

This course is one of the best I have taken, not just on Coursera. Professor Charlie Nuttelman made a challenging course like this an enriching experience. From screencasts to quizzes, the materials seen in the course are very helpful during the VBA learning process.

Excellent work and I look forward to more courses like this.

By Ninad M

Aug 26, 2020

This type of course is for those, who already have learnt every other function in the Excel, that is there to learn. But after that, VBA in Excel provides us to write our own interesting custom functions and intuitive subroutines. The instructor of this course is also very enthusiastic and his teachings are easy to understand.

By Tony M

Dec 21, 2020

Couse content is clear and exactly what I needed, as the description promised.

My only quibble is the audio quality. Each video seems to be at widely divergent sound levels, so I adjust the volume for each module. Worse, the instructor seems to be tapping the mic or the nearby desk causing a series of random, jarring thumps.

By Thi T D T

Mar 18, 2022

I like the quizzes and the assignments. They are very interesting and challenging but not too hard! The instructor has done everything nicely and explains/gives examples that are easy to understand. I was able to apply what I've learned in this course to my work to speed it up. Can't wait to finish the whole specialization

By Parambir S

Jan 10, 2020

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!

By Pemika M

Jul 25, 2019

The instructor can explain clearly step-by-step and visualize in his videos perfectly. I got a lot knowledge of VBA from this course and it works for me as it starts from basic. The lecturer also provide some useful tricks and know how to create quizzes that can make learners have to think about it again. Highly recommend!