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

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 周

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

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

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 周

Logical Operations
您将获得的技能: Microsoft Excel, Spreadsheet Software, Excel Formulas, Microsoft Office, Pivot Tables And Charts, Excel Macros, Data Presentation, Microsoft 365, Business Intelligence, Data Visualization Software, Productivity Software, Data Visualization, Data Integration, Data Entry, Key Performance Indicators (KPIs), Data Management, Document Management, File Management, Performance Management, User Interface (UI)
初级 · 专项课程 · 3-6 个月

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

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

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

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

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