|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/everyday-practical-programming-with-excel-vba/
课程评论：没有评论
**Excel VBA 实用编程入门** 本课程旨在教授您如何利用Excel VBA（Visual Basic for Applications）进行实用编程，从而大幅提高工作效率并为您的职业生涯增添亮点。课程强调从实际问题分析入手，而非直接进入编码。您将学习如何识别、分析任务，并通过VBA创建能够处理日常工作中耗时任务的解决方案。 **课程亮点：** * **解决实际问题：** 通过诸如自动化行插入、公式创建、报表格式化、数据分组求和、地址信息重排、工作表对比及差异报告、文件拆分、文件匹配与写入、库存管理与发票生成，甚至使用Active Data Objects连接SQL Server创建存储过程等九个真实世界的案例，学习如何编写VBA程序。 * **实操性强：** 课程包含四小时视频，并提供详细的案例分析，即使您是编程新手或曾学过但感到无从下手，也能快速掌握创建有用程序的技能。 * **强调“前置”工作：** 强调编程始于问题分析，而非编码。您将学习如何通过提问、记录决策点，并使用流程图工具（免费）来规划和设计解决方案，确保编程的有效性。 * **提升职业竞争力：** 学到的技能能帮助您显著缩短工作时间，减少错误，并在同事和领导面前展现解决问题的能力。 **学习目标：** * 理解VBA编程的基础构建模块。 * 掌握分析复杂任务并设计VBA解决方案的思维过程。 * 能够编写VBA代码来自动化Excel中的重复性任务。 * 学会利用VBA处理数据、生成报表以及管理文件。 * 提升解决实际工作问题的能力，从而在职业发展中脱颖而出。 本课程适合所有希望通过Excel VBA提升工作效率、解决实际问题并扩展职业可能性的学习者。
You purchase a computer. You keep your software up to date. Is it about time the computer did something for You? You can have the computer complete hours of work with 0 errors. You can really impress in your job by programming solutions. In the first two weeks of my last job I attended a meeting about a very important project. This meeting covered the 160-hour first phase of a project. I completed that first phase in 16 hours (two days) using VBA programming. This course covers the techniques I used to create programming like that. In fact, the last example is exactly the problem solved by that programming. This course moves quickly from coverage of the building blocks of programming to documenting and then creating solutions. Have you ever taken a programming class and then you don't know how to use what you've learned? I frequently work with technical people who took college programming courses that won't volunteer to create a programming solution. They have the knowledge, but have not found real-world programs to work on to increase their confidence. Do you want to see what real, practical programs look like, learn how they work and learn how to think through the analysis, design and development that takes you from beginning to end? This course uses really great examples so whether you have taken one or more programming classes or have no programming experience or training at all you can be prepared to create useful programs that can impress, speed through work and expand your career. Real-World programming does not start with coding, but with analysis of the task. This course begins at that step. When you have analyzed the problem and understand the building blocks of the programming language, then you can begin coding effectively. This course includes four hours of video and uses nine, real-world examples to illustrate the creation of programming solutions in Excel® VBA to requests frequently encountered in an IT environment. This course includes the following examples: Automating the inserting of rows, creation of formulas and application of formatting to make a report, summing up lines of data within groups Reordering Mailing Labels from One Column to One Column Per Type of Address Information Comparing two worksheets and Reporting the Differences Dividing a File into Smaller Files Opening a File and Finding Matching Lines to Write to a Different File Doing a lookup of Purchase Detail in One Worksheet, Reducing Inventory Counts in Another worksheet and Presenting the Results as an Invoice in Another Worksheet Using Active Data Objects to Gather Table Schema from SQL Server® to Programmatically Create Stored Procedures. The analysis of a problem consists of asking the right questions and documenting the decision points. This course uses a Free, Flowcharting Program to document the proposed programming solution. This is helpful for confirming programming requirements, determining program flow and identifying initial variables and constants.
