Excel VBA 课程可以帮助您学习自动化技术、如何创建自定义函数以及高效处理数据的方法。您还可以掌握调试代码、设计用户表单和生成可简化工作流程的报告的技能。许多课程都会介绍 Visual Basic 编辑器和 Excel 宏记录器等工具,这些工具可以帮助您有效地实施 VBA 技能。

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 个月
Macquarie University
您将获得的技能: 电子表格软件, Excel 公式, 业务建模, 财务预测, Microsoft Excel, 自动化, Excel 宏, 数据建模, 数据完整性, 数据验证
中级 · 课程 · 1-3 个月

Logical Operations
您将获得的技能: Microsoft Excel, Excel Formulas, Excel Macros, Data Visualization, Consolidation, Forecasting, Spreadsheet Software, Microsoft 365, Microsoft Office, Pivot Tables And Charts, Data Sharing, Data Mapping, Productivity Software, Data Analysis, Data Entry, Data Security, Data Validation, Document Management, Data Management, User Interface (UI)
高级设置 · 课程 · 1-3 个月
Macquarie University
您将获得的技能: 仪表板, 电子表格软件, 数据管理, 合并, Microsoft Excel, 数据整合, 数据分析表达式 (DAX), 业务报告, 数据清理, 自动化
中级 · 课程 · 1-3 个月

您将获得的技能: Excel Macros, Data Validation, Scatter Plots, Pivot Tables And Charts, Microsoft Excel, Data Visualization, Regression Analysis, Excel Formulas, Histogram, Data Analysis, Data Integrity, Statistical Modeling, Descriptive Statistics, Data Visualization Software, Spreadsheet Software, Analytics, Statistical Analysis, Data Analysis Expressions (DAX), Statistical Methods, Automation
初级 · 专项课程 · 1-3 个月

Coursera
您将获得的技能: Microsoft Excel, Excel Formulas, Spreadsheet Software, Microsoft Office, Data Entry, Microsoft 365
中级 · 指导项目 · 不超过 2 小时

Logical Operations
您将获得的技能: Key Performance Indicators (KPIs), Microsoft Excel, Data Integration, Performance Measurement, Pivot Tables And Charts, Data Visualization Software, Spreadsheet Software, Trend Analysis, Cloud-Based Integration, Time Series Analysis and Forecasting, Data Analysis, Data Modeling, Business Intelligence, Data Manipulation, Microsoft 365, Microsoft Office, Productivity Software
混合 · 课程 · 1-4 周

Logical Operations
您将获得的技能: Data Analysis Expressions (DAX), Microsoft Excel, Pivot Tables And Charts, Report Writing, Data Modeling, Management Reporting, Business Reporting, Data Analysis, Performance Reporting, Data Presentation, Data Visualization Software, Data Visualization, Microsoft Office, Microsoft 365, Productivity Software
混合 · 课程 · 1-4 周
Macquarie University
您将获得的技能: 商业分析, 电子表格软件, Excel 公式, Microsoft Office, Microsoft Excel, 分析技能, 数据分析表达式 (DAX), 数据分析软件, 生产力软件
初级 · 课程 · 1-3 个月

Logical Operations
您将获得的技能: Excel Formulas, Microsoft Excel, Microsoft Office, Spreadsheet Software, Microsoft 365, File Management, Document Management, Data Management, Productivity Software, Data Entry, Microsoft Windows, Data Import/Export, User Interface (UI)
混合 · 课程 · 1-3 个月

Logical Operations
您将获得的技能: Data Presentation, Data Visualization, Microsoft Excel, Data Visualization Software, Spreadsheet Software, Pivot Tables And Charts, Data Analysis, Data Science, Exploratory Data Analysis, Productivity Software, Microsoft Office, Microsoft 365
混合 · 课程 · 1-4 周

您将获得的技能: Microsoft Excel, Excel Formulas, Pivot Tables And Charts, Spreadsheet Software, Business Reporting, Data Visualization, Productivity Software, Data Management, Computer Literacy
混合 · 课程 · 1-4 周