VBA 课程可以帮助您学习 Excel 和其他 Microsoft Office 应用程序中的自动化技术、数据操作和自定义函数创建。您可以掌握开发用户表单、创建宏以及将 VBA 与 SQL 集成用于数据库管理的技能。许多课程都会介绍 Visual Basic 编辑器和 Excel 内置函数等工具,展示这些技能如何在各种业务环境中简化任务和提高工作效率。

Macquarie University
您将获得的技能: Pivot Tables And Charts, Data Visualization, Statistical Inference, Data Visualization Software, Correlation Analysis, Microsoft Excel, Probability & Statistics, Regression Analysis, Statistical Hypothesis Testing, Data Analysis, Excel Formulas, Statistical Analysis, Sampling (Statistics), Trend Analysis, Forecasting, Variance Analysis
中级 · 课程 · 1-3 个月

您将获得的技能: Data Presentation, Data Visualization Software, Data Analysis, Data Manipulation
初级 · 课程 · 1-4 周

您将获得的技能: Scatter Plots, Data Visualization, Regression Analysis, Excel Formulas, Microsoft Excel, Data Analysis, Descriptive Statistics, Data Visualization Software, Analytics, Statistical Analysis, Statistical Methods, Descriptive Analytics, Correlation Analysis, Statistics, Analysis, Exploratory Data Analysis, Pivot Tables And Charts, Trend Analysis
初级 · 课程 · 1-4 周

您将获得的技能: 集成开发环境, COBOL(编程语言), 文件输入/输出, 计算机编程工具, z/OS, 主机计算, 单元测试, 调试, 软件测试, 测试驱动开发(TDD)
初级 · 课程 · 1-3 个月

您将获得的技能: Business Process Automation, Data Presentation, Java, Productivity Software, C# (Programming Language), Data Capture, File I/O, Programming Principles, Scalability, Debugging
初级 · 课程 · 1-4 周

Logical Operations
您将获得的技能: Microsoft Access, Database Management, Excel Macros, Microsoft 365, Database Development, Database Administration, Database Architecture and Administration, Data Maintenance, Microsoft Windows, Database Software, Databases, Relational Databases, Query Languages, Database Design, Data Entry, Microsoft Office, Data Presentation, Productivity Software, Scripting, User Interface (UI)
混合 · 课程 · 1-3 个月

您将获得的技能: Automation, SAS (Software), Debugging, SQL, Stored Procedure, Data Manipulation, Data Processing, Statistical Programming, Data Management
中级 · 课程 · 1-3 个月

您将获得的技能: SAS (Software), Scripting, Debugging, Computational Logic, Statistical Programming, Automation, Data Processing, Data Manipulation, Maintainability
初级 · 课程 · 1-4 周

您将获得的技能: Hypertext Markup Language (HTML), Usability Testing, Cascading Style Sheets (CSS), Functional Testing, Web Development, Development Environment, Microsoft Visual Studio, Scripting, Visual Basic (Programming Language), Web Applications, Real Time Data, Web Design, Integrated Development Environments
混合 · 课程 · 1-4 周