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

University of Colorado Boulder
您将获得的技能: Data Management, 调试, Microsoft Excel, 用户界面(UI), 自动化, 代码审查, 数据管理, 模拟, Visual Basic(编程语言)
高级设置 · 课程 · 1-3 个月

Coursera
您将获得的技能: Excel Formulas, Data Validation, Microsoft Excel, Accounting and Finance Software, Accounting Records, Spreadsheet Software, Data Quality, Data Maintenance, Financial Analysis
初级 · 课程 · 1-4 周

Simplilearn
您将获得的技能: Data Visualization, Microsoft Excel, Excel Formulas, Pivot Tables And Charts, Dashboard, Excel Macros, Data Analysis, Analytics, Data Cleansing, Regression Analysis, Descriptive Statistics
初级 · 课程 · 1-4 周

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

您将获得的技能: Microsoft Excel, Excel Formulas, Pivot Tables And Charts, Working Capital, Cash Flows, Spreadsheet Software, Income Statement, Financial Analysis, Financial Accounting, Revenue Recognition, Business Valuation, Generally Accepted Accounting Principles (GAAP), Business Reporting, Balance Sheet, Data Visualization, Capital Expenditure, Accounts Receivable, Financial Modeling, Finance, Corporate Finance
初级 · 专项课程 · 3-6 个月

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

Logical Operations
您将获得的技能: Excel Formulas, Pivot Tables And Charts, Microsoft Excel, Spreadsheet Software, Data Validation, Data Visualization, Data Analysis, Interactive Data Visualization, Productivity Software, Data Integrity, Microsoft Office, Microsoft 365
混合 · 课程 · 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 个月
Macquarie University
您将获得的技能: 业务建模, Excel 宏, 财务预测, 自动化, Microsoft Excel, 数据建模, 数据验证, Data Validation, 电子表格软件, 数据完整性, Excel 公式
中级 · 课程 · 1-3 个月

您将获得的技能: 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, Data Validation, Scatter Plots, Pivot Tables And Charts, Microsoft Excel, Data Visualization, Regression Analysis, Excel Formulas, Histogram, Data Analysis, Data Integrity, Descriptive Statistics, Data Visualization Software, Spreadsheet Software, Analytics, Statistical Analysis, Data Analysis Expressions (DAX), Statistical Methods, Descriptive Analytics, Automation
初级 · 专项课程 · 1-3 个月
Macquarie University
您将获得的技能: 商业分析, 数据故事, Excel 宏, 数据操作, 高级分析, 财务分析, Microsoft Excel, 数据展示, 数据扫盲, 仪表板, 财务预测, 数据预处理, 分析技能, 电子表格软件, Excel 公式, 商业数学, 透视表和图表, 数据分析软件
中级 · 课程 · 1-3 个月