|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-2007-vba-and-advanced-2-course-bundle/
课程评论：没有评论
Coursera 课程汇总：Excel 2007 VBA 和高级应用（双课程套餐） 此套餐节省 20%，包含以下两门课程： **1. Excel 2007 VBA** 本课程将带您学习如何使用 Microsoft 的 Visual Basic for Applications (VBA) 进行 Excel 宏编程。核心目标是教授您正确的 Visual Basic 编程技巧，以及对 Excel 对象结构的理解。课程涵盖的主题包括：宏录制、编程基础、变量的正确声明、Visual Basic 函数、控制结构的应用、循环以及 UserForm 的创建。最后一部分将重点介绍 Microsoft VBA 编辑器内置的调试工具及其有效使用方法。 **2. Excel 2007 高级应用** 本课程建立在 Excel 入门和中级课程的基础上。在“Microsoft Office Excel 2007 高级应用”课程中，您将学习如何分析和管理数据。您将探索 Excel 中提供的多种数据分析工具，例如公式审核、单变量求解、方案管理器以及分类汇总。此外，本课程还将教授您使用高级函数、应用条件格式、筛选和管理数据列表、创建和操作数据透视表和数据透视图，以及录制基础宏。
Save 20% by buying both courses. This bundle includes: Excel 2007 VBA Excel 2007 Advanced The Excel 2007 VBA course introduces you to Excel Macro programming using Microsoft's Visual Basic for Applications (VBA). The overall focus of this course is to teach you proper Visual Basic programming techniques along with an understanding of Excel's object structure. Other topics in this course include recording macros, programming basics, proper variable declaration, Visual Basic functions, 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 2007 Advanced course builds on knowledge gained in the Introduction and Intermediate courses. In Advanced Microsoft Office Excel 2007, you learn how to analyze and manage your data. You will explore the many data analysis tools available in Excel, such as formula auditing, goal seek, Scenario Manager, and subtotals. Additionally, during this course, you will use advanced functions, learn how to apply conditional formatting, filter and manage your data lists, create and manipulate PivotTables and PivotCharts, and record basic Macros.
