Excel 宏课程可以帮助您学习如何自动执行重复性任务、创建自定义函数以及简化数据分析流程。您可以掌握编写 VBA 代码、Debugging 宏以及为电子表格设计用户友好界面的技能。许多课程介绍 Visual Basic for Applications 编辑器和 Excel 功能区等工具,展示这些技能如何提高数据管理和报告的生产力和效率。

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

University of Colorado Boulder
您将获得的技能: UI 组件, 文件输入/输出, 电子表格软件, Data Validation, Visual Basic(编程语言), 编程原则, 用户界面(UI), 数据导入/导出, 自动化, 调试, Excel 宏
中级 · 课程 · 1-4 周

Simplilearn
您将获得的技能: Data Analysis Expressions (DAX), Microsoft Excel, Excel Formulas, Pivot Tables And Charts, Dashboard, Data Processing, Data Presentation, Data Transformation, Data Analysis, Data Visualization, Barcoding, Microsoft PowerPoint, 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 周

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 周

您将获得的技能: 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 个月

您将获得的技能: Sampling (Statistics), Logistic Regression, SAS (Software), Predictive Analytics, Automation, Data Integration, Advanced Analytics, Debugging, Statistical Programming, SQL, Statistical Methods, Report Writing, Data Manipulation, Model Evaluation, Data Analysis, Statistical Reporting, Data Access, Microsoft Excel, Analysis, Finance
初级 · 专项课程 · 3-6 个月

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 周

Logical Operations
您将获得的技能: Excel Macros, Microsoft Excel, Data Transformation, Data Import/Export, File I/O, Data Wrangling, Extensible Markup Language (XML), Data Manipulation, Visual Basic (Programming Language), Data Cleansing, Spreadsheet Software, Automation, Microsoft 365, Microsoft Office, Data Science, Query Languages, File Management, Debugging, Performance Improvement, Computer Programming
中级 · 专项课程 · 3-6 个月

您将获得的技能: 微软Excel, 信息隐私, 数据清理, 电子表格软件, 谷歌工作表, 数据分析, 数据操作, 数据质量, Excel 公式, 透视表和图表, 数据导入/导出, 数据科学, 数据整理
初级 · 课程 · 1-3 个月

University of Colorado Boulder
您将获得的技能: 财务分析, 微软Excel, 数据管理, 数据清理, Data Validation, 电子表格软件, 数据输入, 数学建模, 分析, 解决问题, 预测建模, 数据导入/导出, 统计建模, 透视表和图表, 解决复杂问题, 数据可视化软件, 金融建模, Excel 公式, 回归分析, Data Analysis 表达式(DAX)
初级 · 专项课程 · 3-6 个月

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