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

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

您将获得的技能: QuickBooks (Accounting Software), Vendor Management, Ledgers (Accounting), Accounting Software, Inventory and Warehousing, Payroll Processing, Financial Reporting, Business Reporting, Customer Data Management, Management Reporting, Financial Analysis, Payroll, Billing & Invoicing, Sales Management, Project Accounting, Small Business Accounting, Accounting Systems, Business Software, Business, Business Analysis
初级 · 专项课程 · 3-6 个月

University of Colorado Boulder
中级 · 课程 · 1-4 周

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 个月

您将获得的技能: Data Entry, Microsoft Excel, Pivot Tables And Charts, Excel Formulas, Spreadsheet Software, Data Visualization Software, Dashboard, Data Analysis, Data Management, Business Analytics, Data Visualization, Exploratory Data Analysis, Productivity Software, Data Analysis Expressions (DAX), Data Presentation, Trend Analysis, Graphing, Decision Making, Data Manipulation, Debugging
初级 · 专项课程 · 1-3 个月

您将获得的技能: Excel Macros, Dashboard, Forecasting, Microsoft Copilot, Microsoft Excel, UI Components, Visual Basic (Programming Language), Data Analysis Expressions (DAX), User Interface (UI), Automation, Debugging, Scenario Testing, Programming Principles
初级 · 课程 · 1-4 周

您将获得的技能: Microsoft Excel, Excel Formulas, Data Visualization, Dashboard, Forecasting, Predictive Modeling, Data Analysis, Data Validation, Data Entry, Financial Modeling, Data Management, Data Integrity, Data Security
混合 · 课程 · 1-3 个月

Vanderbilt University
您将获得的技能: Excel Macros, Excel Formulas, Microsoft Excel, Data Visualization, ChatGPT, Spreadsheet Software, AI Enablement, Data Validation, Prototyping, Data Import/Export
初级 · 课程 · 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
您将获得的技能: 电子表格软件, 数据完整性, 数据验证, 业务建模, Microsoft Excel, 自动化, Excel 宏, 数据建模, 财务预测, Excel 公式, Data Validation
中级 · 课程 · 1-3 个月

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 个月
Macquarie University
您将获得的技能: 电子表格软件, 商业分析, Microsoft Excel, 分析技能, 数据分析表达式 (DAX), Microsoft Office, 微软办公软件, 数据分析软件, Excel 公式, 生产力软件
初级 · 课程 · 1-3 个月