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,289 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

RL

Feb 21, 2018

The screencasts are very clear and concise but the assignments were too easy. I would suggest adding some assignments related with finance (e.g., bond calculators and portfolio optimization problems).

PP

Apr 18, 2020

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.

Filter by:

826 - 850 of 1,224 Reviews for Excel/VBA for Creative Problem Solving, Part 1

By Negaye F

•

Aug 25, 2022

Excercise-based course and loved it!

By Claudio B

•

Feb 1, 2021

Excellent: clear, concise, effective

By Vishnu S

•

Sep 17, 2020

Absolutely Loved doing this course!!

By Rohith G

•

Aug 1, 2020

Good Platform to learn the Scripting

By David S

•

Feb 2, 2020

it was great and iIreally enjoyed it

By Kunal D

•

Oct 4, 2019

Excellent for beginners, must learn.

By RENATO E L B

•

Nov 20, 2022

Me parecio bastante util y completo

By Artem G

•

Jan 5, 2021

Very useful and interesting course!

By CRISTELL S M S

•

Dec 11, 2020

Very interesting course and helpful

By JOAQUIN F S C

•

Oct 25, 2020

Great course, you will learn a lot.

By Parth A D

•

Sep 28, 2020

nice and learnt new things in excel

By Ana C L A

•

Apr 20, 2020

An amazing course! Really recommend

By JUAN F G Y

•

Apr 14, 2020

A fabulous course for Excel lovers.

By andres f o

•

Oct 30, 2018

Se aprende muchisimo. Es muy bueno.

By karthick s

•

Jul 12, 2018

One of the best courses in coursera

By MOHIT

•

Jul 25, 2020

Good lectures for VBA. Appreciate!

By Pham D D N

•

Jun 21, 2020

Nice course with suitable workload

By Aishwarya J

•

May 4, 2020

It was a great learning experience

By Dennis P

•

Oct 17, 2023

Very good and applicable lessons!

By Rémy M

•

Mar 8, 2021

Very interesting and well explain

By JHONATAN D S V

•

Mar 3, 2021

Muchas gracias por el aprendizaje

By Fernando U U

•

Dec 11, 2020

Very well explained and complete.

By A J

•

Jul 12, 2020

A really good course for starters

By Ricardo A

•

Jun 14, 2020

Great course, enjoying it so far.

By Liu C

•

Jan 28, 2020

a good intro for me to master VBA