|
所在平台: Coursera |
课程主页: https://www.coursera.org/learn/excel-vba-for-creative-problem-solving-part-1
课程评论：没有评论
课程名称：Excel/VBA 创意问题解决，第1部分 课程概述：《Excel/VBA 创意问题解决，第1部分》旨在帮助学习者增强、扩展、优化其Excel电子表格技能，通过利用Visual Basic for Applications (VBA) 强大的编程、自动化和定制能力，提升工作效率。本课程是为期三部分系列的第一部分，专注于在Excel/VBA中应用计算技术以解决问题。在本课程中，您将学习：1) 创建宏以自动化Excel中的程序；2) 定义用户自定义函数；3) 创建基本子程序以与用户进行交互；4) 学习VBA中的基础编程结构；5) 自动化Excel的目标寻求和求解工具，并使用数值技术创建“实时解决方案”以解决目标和优化问题。 您是否是编程新手？VBA的直观和视觉特性非常适合教学和学习——这是学习编码的有趣方式！无需编程基础或高级数学技能，但有经验的程序员也能学到新的创意电子表格问题解决策略。 在您掌握VBA基础知识后，每个模块将引入灵感来自现实世界情况的基础广泛问题。为了通过每个模块，您需要通过掌握测验并完成问题解决作业。本课程的独特之处在于每周的作业在实际应用中完成（即在您自己的电脑上使用Excel），为您提供宝贵的动手训练。 课程大纲： 1. 宏录制、VBA过程和调试：第1周将介绍应用程序中的Visual Basic (VBA)，教授创建基本VBA过程所需的基础工具。您将学习不同的数据类型和变量的作用域，如何排查代码故障，以及如何使用绝对和相对引用模式录制基本宏。 2. VBA基础，第1部分：第2周您将学习如何编写合适的VBA语法和基本数学表达式。您将了解对象、属性、方法和事件，还将学习如何使用VBA代码借用常见的Excel函数，以及如何在Excel与Visual Basic编辑器 (VBE) 之间移动信息。 3. VBA基础，第2部分：第3周将教授如何创建自己的用户自定义函数；调用其他文件中的子程序和函数；以及基于模块化方法设计子程序，最后了解VBA中的基本错误处理。 4. VBA编程结构：第4周我们将进入VBA编程的“核心”，开始一些令人兴奋的问题解决。您将学习VBA中的常见编程结构（顺序、选择和重复），这些结构是高级编程过程的基础，通过多个示例展示这些编程结构的实用性。 5. 使用VBA进行数据管理：本模块将探索VBA在Excel中管理大型数据集的巨大价值。您将学习如何自动化筛选、排序和删除重复项的过程，以及额外的数据清理策略，这些策略将使您成为受欢迎的VBA用户。 6. R1C1样式：本课程的最后一个模块专注于使用R1C1单元格格式。这种样式与Excel中默认的A1引用样式相对比，使执行对Excel工作表的高级操作变得更加简单直接。多个示例演示了R1C1样式的实用性。
Name:Macro recording, VBA procedures, and debugging
Description: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.
Name:VBA Nuts & Bolts, Part 1
Description:In Week 2, you will learn how to write proper VBA syntax and basic mathematical expressions; you will learn about objects, properties, methods, and events; and you will learn how to borrow common Excel functions using VBA code. In addition, you will learn how to move information to and from Excel and the Visual Basic Editor (VBE).
Name:VBA Nuts & Bolts, Part 2
Description:In Week 3, you will learn how to create your own user-defined functions. You will also learn how to call other subroutines and functions that reside in other files and you will learn how to design subroutines based on a modular approach. Finally, ,you will learn basic error handling in VBA.
Name:Programming structures in VBA
Description:Week 4 begins the "meat" of programming in VBA, and we are finally moving into some exciting problem solving. You will learn about the common programming structures in VBA (sequence, selection, and repetition) that form the foundation for advanced programming procedures. Several examples will highlight the utility of these programming structures.
Name:Data Management Using VBA
Description:One of the most valuable uses of VBA is to manage large data sets in Excel. In this module, you'll learn how to automate the processes of filtering, sorting, and removing duplicates. You'll learn additional strategies for cleaning up data. The strategies learned in this week will make you a valued VBA user.
Name:R1C1 Style
Description:The final module of this course focuses on using the R1C1 style of cell formatting. This style, in contrast to the default A1 style of referencing in Excel, makes it much easier and straightforward to perform advanced manipulations to Excel worksheets. Several examples demonstrate the utility of the R1C1 style.
"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.
