Excel/VBA for Creative Problem Solving, Part 1

所在平台: CourseraArchive

课程类别: 其他类别

大学或机构: CourseraNew

课程主页: https://www.coursera.org/archive/excel-vba-for-creative-problem-solving-part-1

课程评论:没有评论

第一个写评论        关注课程

课程简介

University of Colorado Boulder

课程大纲

Week 1 will introduce you to visual basic for applications (VBA) and teach you the foundational tools required to create basic procedures in VBA. You'll learn about different data types and the scope of variables, how to troubleshoot your code when it's not working, and how to record basic macros using both absolute and relative referencing modes.

课程评论(0条)

课程详情

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

用于创造性问题解决的Excel / VBA,第1部分:“用于创造性问题解决的Excel / VBA,第1部分”旨在帮助寻求通过利用Excel电子表格技能来增强,扩展,优化和提高效率的学习者。 Visual Basic for Applications(VBA)提供了强大的编程,自动化和自定义功能。 本课程是由三部分组成的系列文章和“专业化”的第一部分,其重点是在Excel / VBA中应用计算技术来解决问题。在本课程(第1部分)中,您将:1)创建宏以自动执行Excel中的过程; 2)定义自己的用户定义函数; 3)创建基本子例程以与用户交互; 4)学习VBA中的基本编程结构;和5)自动化Excel的“目标搜索”和“求解器”工具,并使用数值技术创建“实时解决方案”以解决定位和优化问题。 计算机编程新手? VBA极其直观和直观的特性非常适合教学,这是一种学习编码的有趣方式!既不需要编程知识也不需要高级数学技能,但是经验丰富的程序员会选择新的和创造性的电子表格问题解决策略。 在学习了VBA的基础知识之后,每个模块都会介绍一些基本的问题,这些问题是由您在现实世界中可能遇到的情况所启发的。要通过每个模块,您需要通过精通测验并完成问题解决任务。该课程的独特之处在于,每周的作业均在应用程序中完成(即在您自己的Excel中的计算机上),从而为您提供了宝贵的实践培训。

课程标签

0人关注该课程

主题相关的课程