|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-vba-mis-analytics-training/
课程评论：没有评论
**Coursera Excel VBA 入门 - 数据分析系列 1 课程总结** 本课程旨在帮助学员掌握 Excel VBA 编程，即使是零基础的初学者也能从中受益。课程从宏录制器入门，教授如何录制、回放、编辑、运行、删除宏以及设置快捷键，并介绍执行宏的多种方式。 课程深入讲解了如何确定数据区域的最后一行、选择数据，并详细阐述了静态和动态方法的优缺点。此外，课程还涵盖了如何纠正录制错误的宏，以及如何通过单步执行进行代码调试。 在 Excel 工作表操作方面，课程讲解了如何切换工作表，以及工作表名称变更可能引起的错误及解决方法。 编程基础方面，课程系统介绍了变量的概念、作用、声明方法、各种数据类型（字符串、整型、单精度、字节、双精度、变体型）及其重要性，并重点讲解了变量相关的常见错误（溢出、类型不匹配）的成因与解决办法。 课程还强调了 `Local` 窗口在代码测试中的作用，讲解了如何激活和使用它。`Option Explicit` 的作用与益处也得到详细说明。 此外，课程还将变量相关的常见面试问题进行解答，并讲解了 `Call` 关键字的使用。变量的作用域（局部、模块、私有、公共）得到了全面细致的讲解。 本课程提供作业解决方案（文件形式和教学视频），并通过实际项目讨论和练习，帮助学员在学习 VBA 的同时，了解如何在实际工作中应用。课程承诺让学员在学习过程中获得物超所值的体验。
I am here to make you awesome in Excel VBA. Let us take a deep dive into VBA and learn it from the beginning. We are starting with Macro recorder introduction. How to record steps and play it later using VBA. How to Edit the existing macros if your boss want you to change few lines. How to Run macros or delete macros or give shortcut keys. There are different ways to execute your program or macro. Know all of them.How to find out last row and how to select the data. We have discussed Static and Dynamic , both approaches and their advantages ,disadvantages over each other. Everything is discussed in full detail. Great for freshers who do not know anything about programming.How to correct Macros if they are recorded with wrong steps. How to run macro step by step which we need it for debugging.How to move from one sheet to another. What errors we can expect if sheet name changes and how to sort out your issues.Introduction to Variables. What are variables and why do we need them. How to declare them.Data types of Variables and their significance in your project. Strings. Integer, Single, byte, Double , Variants - we have covered all.Grip over variable related errors - overflow and type mismatch - Why they come and how to resolve the issues.Use of Local window for better testing of your code. How to activate it and how to use this window.Option Explicit - How to declare it and what benefit it provides.Frequently asked Questions related to Variables asked in your interview.Call key word.Scope of Variable - Local, module, private and Public level variables. In full detail everything is covered.Assignments solutions are also provided in the form of file as well as lecture video explaining it.We have a long way to go and i promise you wont be disappointed after taking this program. We have live project discussions and assignments for you to practice. You will not only learn here but also know how to implement the VBA in real environment.
