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

您将获得的技能: Data Cleansing, Financial Data, Microsoft Excel, Excel Formulas, Management Reporting, Data Transformation, Data Manipulation, Automation, Financial Reporting, Extract, Transform, Load, Data Import/Export, Spreadsheet Software, Data Validation
中级 · 课程 · 1-4 周

您将获得的技能: Database Design, Relational Databases, Event-Driven Programming, Database Application, .NET Framework, Visual Basic (Programming Language), Maintainability, Service Management, Application Design, Business Logic, SQL, Data Validation, Debugging, User Interface (UI)
初级 · 课程 · 1-4 周

Coursera
中级 · 课程 · 1-4 周

您将获得的技能: Excel Macros, Financial Modeling, Prompt Engineering, Financial Forecasting, Generative AI, Automation, Process Optimization, Microsoft Excel, Excel Formulas, Financial Acumen, Simulation and Simulation Software, Visual Basic (Programming Language), Financial Reporting, Financial Planning, Code Review
中级 · 课程 · 1-4 周
Macquarie University
您将获得的技能: 数据操作, 仪表板, Power BI, 数据可视化, 数据可视化软件, 数据故事, 交互式数据可视化, 数据预处理, Excel 宏, 数据共享, 数据清理, 数据整合, Microsoft Excel, 透视表和图表, 数据转换, 信息图表, 数据分析, Excel 公式, 电子表格软件, 数据展示
中级 · 专项课程 · 3-6 个月

Logical Operations
您将获得的技能: Pivot Tables And Charts, Microsoft Excel, Key Performance Indicators (KPIs), Data Integration, Spreadsheet Software, Excel Formulas, Performance Measurement, Excel Macros, Business Intelligence, Data Visualization Software, Data Presentation, Data Visualization, Microsoft Office, Microsoft 365, Productivity Software, Data Entry, File Management, Document Management, Data Management, User Interface (UI)
初级 · 专项课程 · 3-6 个月

Logical Operations
您将获得的技能: Data Storytelling, Data Analysis Expressions (DAX), Excel Formulas, Data Transformation, Data Presentation, Microsoft Excel, Data Visualization, Sampling (Statistics), Dashboard, Data Visualization Software, Spreadsheet Software, Report Writing, Pivot Tables And Charts, Data Analysis, Statistical Analysis, Data Cleansing, Microsoft Office, Geospatial Mapping, Microsoft 365, Productivity Software
中级 · 专项课程 · 3-6 个月

Microsoft
您将获得的技能: 数据操作, 业务指标, 数据清理, Microsoft Excel, 透视表和图表, 数据分析, Excel 公式, 电子表格软件, 数据展示
初级 · 课程 · 1-3 个月

您将获得的技能: Database Design, Stored Procedure, Microsoft SQL Servers, Database Management, Database Development, Relational Databases, Database Architecture and Administration, SQL, Databases, Database Management Systems, Transaction Processing, Visual Basic (Programming Language), Data Management, Verification And Validation, Debugging, User Interface (UI)
初级 · 课程 · 1-4 周
Rice University
您将获得的技能: 数据操作, 数据可视化软件, 柱状图, 制图, 散点图, Microsoft Excel, 透视表和图表, 数据分析, 数据导入/导出, Excel 公式, 电子表格软件
混合 · 课程 · 1-4 周

您将获得的技能: Database Design, Relational Databases, Database Application, Microsoft SQL Servers, Data Integrity, Databases, Database Management, Data Modeling, Visual Basic (Programming Language), Application Development, User Interface (UI)
初级 · 课程 · 1-4 周

您将获得的技能: Excel Formulas, Microsoft Excel, Spreadsheet Software, Business Reporting, Analytical Skills, Business Analytics, Data Integrity, Microsoft Office, Data Management, Productivity
初级 · 课程 · 1-4 周