|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-2010-vba-and-advanced-2-course-bundle/
课程评论：没有评论
课程名称：Excel 2010 VBA与高级（双课程包） 课程概述：通过购买这两个课程可节省20%。该课程包包括：Excel 2010 VBA 和 Excel 2010 高级。Excel 2010 VBA 课程的主要目标是教授用户正确的 Visual Basic 编程技巧，并理解 Excel 的对象结构。课程内容涵盖了准确的变量声明、控制结构的使用、循环以及用户表单的创建。最后一部分介绍了 Microsoft VBA 编辑器中包含的调试工具及其有效使用方法。 Excel 2010 高级课程则深入探讨了超出基础知识的多个主题。您将学习如何使用各种财务、逻辑、文本和统计函数；使用情景管理器分析数据；应用条件格式化；以及使用新的迷你图（Sparklines）功能。课程还详细讲解了数据库管理、数据透视表、数据透视图和切片器，并介绍了如何在不同应用程序之间导入和导出 Excel 数据。 通过这门课程，您将能提升 Excel 的高级应用能力和 VBA 编程技巧，进一步提高工作效率。
Save 20% by buying both courses. This bundle includes: Excel 2010 VBA Excel 2010 Advanced In the Excel 2010 VBA course, the overall focus is to teach the user proper Visual Basic programming techniques along with an understanding of Excel's object structure. Other topics in this course include: proper variable declaration, control structure use, looping, and UserForm creation. The final section deals with the debugging tools included in the Microsoft VBA editor and methods on how to effectively use them. The Excel 2010 Advanced course delves into a variety of topics beyond the basics. You will learn how to use a wide range of financial, logical, text, and statistical functions; analyze data with the scenario manager; apply conditional formatting; and use the new Sparklines feature. Database management, PivotTables, PivotCharts, and Slicers are covered in detail, as well as importing and exporting Excel data to and from other applications.
