Excel/VBA for Creative Problem Solving, Part 2

所在平台: CourseraArchive

课程类别: 其他类别

大学或机构: CourseraNew

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

课程评论:没有评论

第一个写评论        关注课程

课程简介

University of Colorado Boulder

课程大纲

In Week 1, you will learn all about arrays and array functions. You will learn how to iterate through arrays using nested For...Next loops and For Each...Next statements; you will learn how to import data to VBA from Excel and export data to Excel from VBA; you will learn how to create user-defined array functions; and you will learn about the ReDim Preserve statement for resizable arrays. Week 1 is concluded with a quiz, which unlocks Assignment 1.

课程评论(0条)

课程详情

"Excel/VBA for Creative Problem Solving, Part 2" builds off of knowledge and skills obtained in "Excel/VBA for Creative Problem Solving, Part 1" and 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). In Part 2 of the course, learners will: 1) learn how to work with arrays and import/export arrays from/to Excel using VBA code; 2) learn how to work with text strings and write data to .txt files and import information from .txt files; 3) automate the import, modification, and consolidation of information from multiple worksheets into a central worksheet as well as the import of information from multiple workbooks to a central workbook; and 4) gain experience with creating professional user forms to interface with the user, perform advanced calculations, and manipulate data on the spreadsheet. Learners who have a foundational understanding of VBA code and programming structures can jump right into Part 2 of the course without taking Part 1 and use the screencasts in Part 1 as reference. 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,第2部分:“用于创造性问题解决的Excel / VBA,第2部分”建立在“用于创造性问题解决的Excel / VBA,第1部分”中的知识和技能的基础上,针对的学习者是通过利用Visual Basic for Applications(VBA)提供的强大编程,自动化和自定义功能,寻求增强,扩展,优化和提高Excel电子表格技能的效率。 在本课程的第2部分中,学习者将:1)学习如何使用VBA代码使用数组以及如何从Excel中导入/导出数组。 2)学习如何使用文本字符串并将数据写入.txt文件以及从.txt文件导入信息; 3)自动将多个工作表中的信息导入,修改和合并到一个中央工作表中,以及将多个工作簿中的信息导入到一个中央工作簿中;和4)在创建专业的用户表单以与用户交互,执行高级计算以及处理电子表格中的数据方面获得经验。 对VBA代码和编程结构有基本了解的学习者可以直接进入本课程的第2部分,而无需参加第1部分,并使用第1部分中的截屏视频作为参考。 每个模块都会介绍一些基本问题和广泛问题,这些问题是由您在现实世界中可能遇到的情况所激发的。要通过每个模块,您需要通过精通测验并完成问题解决任务。该课程的独特之处在于,每周的作业均在应用程序中完成(即在您自己的Excel中的计算机上),从而为您提供了宝贵的实践培训。

课程标签

0人关注该课程

主题相关的课程