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

Logical Operations
您将获得的技能: Microsoft Access, Database Design, Relational Databases, Database Management, Database Development, Microsoft 365, Database Administration, Database Management Systems, Database Architecture and Administration, Data Integrity, Data Maintenance, Microsoft Windows, Databases, Microsoft Office, Data Entry, Query Languages, Data Presentation, Productivity Software, User Interface (UI), Scripting
初级 · 专项课程 · 3-6 个月

您将获得的技能: Dashboard, Dashboard Creation, Excel Formulas, Pivot Tables And Charts, Excel Macros, Performance Analysis, Key Performance Indicators (KPIs), Spreadsheet Software, Microsoft Excel, Performance Measurement, Performance Metric, Business Analytics, Data Presentation, Interactive Data Visualization, Advanced Analytics, Visual Basic (Programming Language), Data Transformation, Data Processing
混合 · 课程 · 1-4 周

您将获得的技能: Excel Formulas, Data Storytelling, Microsoft Excel, Dashboard Creation, Dashboard, Pivot Tables And Charts, Power BI, Data-Driven Decision-Making, Microsoft Copilot, Spreadsheet Software, Extract, Transform, Load, Data Presentation, Data Visualization Software, Generative AI, Data Visualization, Data Analysis, Business Intelligence, Data Collection, Interactive Data Visualization, Business Metrics
★ 4.5 (811) · 初级 · 专项课程 · 3-6 个月
Macquarie University
您将获得的技能: 数据可视化软件, Excel 宏, 数据预处理, 数据清理, 交互式数据可视化, 数据整理, 树木地图, 数据操作, 仪表板, 数据分析, 数据展示, Excel 公式, 数据故事, 仪表板创建, Microsoft Excel, 数据处理, Power BI, 透视表和图表, 数据可视化, 电子表格软件
★ 4.8 (6069) · 中级 · 专项课程 · 3-6 个月

您将获得的技能: Microsoft 365, Microsoft Teams, Microsoft Outlook, Microsoft Office, Pivot Tables And Charts, Calendar Management, Excel Macros, Microsoft Copilot, Microsoft Excel, Collaborative Software, Excel Formulas, Data Validation, Productivity Software, Email Automation, Spreadsheet Software, Project Management Software, Organizational Skills, Collaboration, Presentations, Visual Basic (Programming Language)
初级 · 专项课程 · 3-6 个月

John Wiley & Sons
您将获得的技能: Microsoft Excel, Spreadsheet Software, Proofreading, Editing, Productivity Software, Consolidation, Excel Formulas, Data Validation, Data Entry, Data Management, Data Presentation
初级 · 课程 · 1-3 个月

您将获得的技能: Dashboard, Microsoft Excel, Excel Macros, Performance Analysis, Excel Formulas, People Analytics, Compensation Analysis, Payroll, Trend Analysis, Key Performance Indicators (KPIs), Business Metrics, Performance Measurement, Data Visualization, Data Integration, Database Management
混合 · 课程 · 1-3 个月

您将获得的技能: Dashboard, Pivot Tables And Charts, Dashboard Creation, Data Visualization, Spreadsheet Software, Data Presentation, Performance Analysis, Microsoft Excel, Interactive Data Visualization, Sales, Data Transformation, Data Manipulation
混合 · 课程 · 1-4 周

您将获得的技能: Pivot Tables And Charts, Dashboard, Dashboard Creation, Microsoft Excel, Spreadsheet Software, Excel Formulas, Financial Modeling, Excel Macros, Data Presentation, Interactive Data Visualization, Workflow Management, Finance, Business Analytics, Data Manipulation, Financial Analysis, Analytical Skills, Analysis, Data Management, Key Performance Indicators (KPIs), Strategic Decision-Making
混合 · 课程 · 1-3 个月

您将获得的技能: Microsoft Excel, Pivot Tables And Charts, Business Intelligence, Spreadsheet Software, Business Reporting, Data Visualization, Interactive Data Visualization, Data Presentation, Dashboard, Dashboard Creation, Data Analysis, Data Visualization Software, Data-Driven Decision-Making, Data Transformation, Analysis, Predictive Analytics, Data Management
混合 · 课程 · 1-3 个月

您将获得的技能: Microsoft Excel, Forecasting, Excel Formulas, Simulation and Simulation Software, Financial Forecasting, Simulations, Excel Macros, Business Analysis, Statistical Modeling, Pivot Tables And Charts, Spreadsheet Software, Data-Driven Decision-Making, Risk Analysis, Financial Modeling, Analysis, Risk Modeling, Data Analysis, Interactive Data Visualization, Data Validation, Automation
混合 · 课程 · 1-4 周

Microsoft
您将获得的技能: 数据清理, 数据管理, 数据操作, Excel 公式, 数据分析, Data Management, 数据转换, 透视表和图表, 电子表格软件, 数据综合, Microsoft Excel
★ 4.7 (343) · 初级 · 课程 · 1-3 个月