|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/hyper-disambiguated-excel-vba-programming/
课程评论：没有评论
课程名称：Excel VBA宏：超清晰的Excel VBA编程 课程概述： Excel VBA编程初学者常常感到困惑，特别是在不完全理解需要编写的代码时。本课程旨在帮助Excel用户，尤其是那些没有太多编程经验的用户，从零开始学习如何编写Excel VBA宏，以自动化Microsoft Excel的任务和操作。 在课程的介绍部分，将介绍一种编程风格，强调您所编写的每一行代码的重要性。这意味着当您重新审视代码时，您可以通过语法清楚地理解每一行的意义，而不是越来越感到陌生。同时，本节还展示了如何充分利用IntelliSense，微软的代码完成工具。 高级主题： 完成基础知识的学习后，我们将进入高级主题。您将学习如何创建仅允许授权用户打开的工作簿，如何实现图表事件钻取解决方案，如何创建可为用户提供动态音频反馈的可访问工作簿，及如何构建一个可以对工作簿内所有表格应用过滤器的解决方案。此外，您还将构建一个复杂的活动日志记录解决方案，用于记录在隐藏工作表中的每个用户操作，并建立一个强制用户通过用户表单输入数据的应用程序，而底层工作表保持隐藏。您还将学习如何添加一个可替代的右键菜单，并使其成为Excel的永久功能。 不论您是希望通过将Excel VBA技能添加到简历中来提升职业前景，还是想为公司节省开支或提高工作效率，这系列Excel VBA课程将帮助您拓宽您的Office编程技能。课程附带的所有材料均可下载，以便您跟随学习（请记得解压下载的文件）。
Introduction to Excel VBA ProgrammingExcel VBA programming can seem baffling, especially when you don't fully understand the code you are asked to write. Learn to write Excel VBA macros, from scratch, to automate Microsoft Excel tasks and operations.This course is aimed particularly at Excel users without much programming experience, who struggle to remember the syntax and structure of the VBA (Visual Basic for Applications) programming language. During the introductory section, you will be introduced to a style of programming which emphasizes the significance of each line of code that you write. This means that when you revisit the code, the meaning of each line is apparent from the syntax, rather than becoming more and more unfamiliar. This introduction also demonstrates how to get the maximum benefit from IntelliSense, Microsoft's code completion feature.Advanced TopicsOnce we've covered the basics of Excel VBA programming, we'll move onto advanced topics.You'll learn how to create a workbook which can only be opened by a list of authorized users. How to create a chart event drill-down solution. You will learn how to create an accessible workbook which provides dynamic audio feedback to its users. You will create a solution which allows users to apply a filter to all tables within a workbook. You will build a sophisticated activity logging solution, which records every user action in a hidden worksheet. You will build an application which forces users to enter data via a user form while the underlying worksheet remains hidden. And you'll learn how to add an alternative right-click menu and how to make it a permanent feature of Excel. Whether you are looking to enhance your career prospects by adding Excel VBA to your C.V., save your company money or increase your productivity, this series of Excel VBA courses will help you to broaden your Office programming skill set. You can download all of the materials used in the lectures, so that you can follow along. (Please, remember to unZIP the downloaded files.)
