Microsoft Excel 高级课程可以帮助您学习复杂的公式、数据分析技术、数据透视表和高级图表制作。您可以掌握使用宏自动执行任务、使用条件格式化实现 Data Visualization 以及执行统计分析的技能。许多课程都会介绍用于数据操作的 Power Query 和用于创建数据模型的 Power Pivot 等工具,向您展示这些技能如何增强您有效管理和解释大型数据集的能力。
Macquarie University
您将获得的技能: Excel 宏, 数据故事, 仪表板, 数据预处理, 商业分析, Microsoft Office, 数据扫盲, 高级分析, 透视表和图表, 分析技能, 电子表格软件, 数据分析表达式 (DAX), 数据分析软件, 财务预测, 数据验证, Excel 公式, 数据建模, 数据操作, Microsoft Excel, 数据展示
初级 · 专项课程 · 3-6 个月

Macquarie University
您将获得的技能: Data-Driven Decision-Making, Microsoft Excel, Forecasting, Regression Analysis, Business Analytics, Excel Formulas, Statistical Analysis, Data Analysis Software, Time Series Analysis and Forecasting, Spreadsheet Software, Pivot Tables And Charts, Analytics, Statistical Methods, Advanced Analytics, Data Analysis, Statistics, Productivity Software, Data Visualization Software, Probability & Statistics, Statistical Inference
高级设置 · 课程 · 1-3 个月

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

Vanderbilt University
您将获得的技能: Excel Macros, Excel Formulas, Microsoft Excel, Data Visualization, ChatGPT, Spreadsheet Software, AI Enablement, Data Validation, Prototyping, Data Import/Export
初级 · 课程 · 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 个月

您将获得的技能: Microsoft Excel, Pivot Tables And Charts, Excel Formulas, Data Presentation, Data Storytelling, Data Visualization Software, Microsoft Copilot, Statistical Analysis, Data Analysis, Statistical Methods, Data Integration, Data-Driven Decision-Making
初级 · 课程 · 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 个月

您将获得的技能: 数据可视化软件, 数据故事, 仪表板, 数据分析, 数据库, 电子表格软件, 模拟和模拟软件, 透视表和图表, Excel 公式, Microsoft Excel, 制图, 数据建模, 数据展示, 数据可视化
初级 · 课程 · 1-4 周

Microsoft
您将获得的技能: 数据分析, 数据清理, Power BI, 电子表格软件, 数据处理, Microsoft Excel, 时间表, Excel 公式, 数据操作, 数据展示
初级 · 课程 · 1-4 周

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, Dashboard, Forecasting, Microsoft Copilot, Microsoft Excel, UI Components, Visual Basic (Programming Language), Data Analysis Expressions (DAX), User Interface (UI), Automation, Debugging, Scenario Testing, Programming Principles
初级 · 课程 · 1-4 周

Logical Operations
您将获得的技能: Excel Formulas, Microsoft Excel, Spreadsheet Software, Forecasting, Data Analysis Software, Pivot Tables And Charts, Data Presentation, Data Analysis, Data Sharing, Microsoft Office, Microsoft 365, Productivity Software, Automation, Data Mapping, Data Entry, Document Management, Data Security, Data Management, Data Validation, User Interface (UI)
混合 · 课程 · 1-3 个月