Chevron Left
返回到 Excel/VBA for Creative Problem Solving, Part 1

学生对 University of Colorado Boulder 提供的 Excel/VBA for Creative Problem Solving, Part 1 的评价和反馈

4.8
星
4,310 个评分

课程概述

"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....

热门审阅

OV

Nov 29, 2019

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.

DL

Mar 14, 2021

Well done, thank you. I had a very limited understanding of loops in programming. After this class, I feel much more comfortable with understanding and designing effective loops and more.

筛选依据：

901 - Excel/VBA for Creative Problem Solving, Part 1 的 925 个评论（共 1,231 个）

创建者 Jean P A S C P

•

Jul 13, 2020

Very useful course. Thanks

创建者 Pablo A

•

Mar 7, 2020

Gran curso, bien explicado

创建者 Teagan O

•

May 7, 2018

Very helpful. Well taught!

创建者 Hannah L T

•

Apr 23, 2018

Thanks Professor Nuttelman

创建者 Ayura J

•

Jul 24, 2024

Basics are well captured.

创建者 Parimal R

•

Nov 12, 2021

Highly recommended course

创建者 Anh V N

•

Aug 1, 2021

This course is wonderful.

创建者 Deleted A

•

Mar 21, 2021

Very good and interesting

创建者 ANGELICA P F G

•

Jul 8, 2020

It's a really good course

创建者 Loïc J

•

Jun 19, 2018

Véry interesting course !

创建者 Michael D S Y

•

May 5, 2020

Excellent for beginners

创建者 Houssein K

•

Jul 20, 2018

Very challenging course

创建者 Imrankhan A

•

May 6, 2024

Very good and helpful.

创建者 Jorge C M

•

Sep 24, 2020

Un curso excellente!!!

创建者 David L

•

Aug 4, 2020

Best course in my life

创建者 YAIR L A C

•

Jul 1, 2020

The Best that I've had

创建者 Aditya T

•

Apr 24, 2020

It was a Good Course .

创建者 Умаев А С

•

Dec 18, 2024

мне очень понравилось

创建者 Alexis H R

•

Aug 24, 2023

Un curso muy practico

创建者 sanket s

•

Sep 26, 2020

Very Very Helpful !!!

创建者 Pitipat W

•

Jul 11, 2020

great and challenging

创建者 Mohit M

•

Nov 2, 2019

Practical. Well paced

创建者 Rohan B

•

Dec 29, 2018

awesome to start with

创建者 Emilyn D

•

Jul 6, 2018

Nuttelman is the man!