Microsoft Excel 高级课程可以帮助您学习复杂的公式、数据分析技术、数据透视表和高级图表制作。您可以掌握使用宏自动执行任务、使用条件格式化实现 Data Visualization 以及执行统计分析的技能。许多课程都会介绍用于数据操作的 Power Query 和用于创建数据模型的 Power Pivot 等工具,向您展示这些技能如何增强您有效管理和解释大型数据集的能力。

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

您将获得的技能: Hedge Accounting, International Financial Reporting Standards, Financial Reporting, Business Valuation, Reconciliation, Consolidation, Intercompany Accounting, Regulation and Legal Compliance, Inventory Accounting, Technical Accounting, Financial Analysis, Financial Accounting, Mergers & Acquisitions, Financial Statement Analysis, Specialized Accounting, International Finance, Accounting, Tax Compliance, Capital Markets, Business Mathematics
初级 · 专项课程 · 3-6 个月

Knowledge Accelerators
您将获得的技能: Power BI, Data Presentation, Data Modeling, Data Visualization, Microsoft Excel, Data Visualization Software, Dashboard, Interactive Data Visualization, Business Intelligence, Pivot Tables And Charts, Data Import/Export, Excel Formulas, Spreadsheet Software, Data Analysis Expressions (DAX), Data Transformation, Data Analysis, Data Storytelling, Analytics, Trend Analysis, Data Management
初级 · 专项课程 · 3-6 个月
Macquarie University
您将获得的技能: 数据叙事, 财务分析, 微软Excel, 电子表格软件, 数据预处理, 数据展示, 商业数学, 数据操作, 分析技能, 商业分析, 高级分析, 仪表板, 透视表和图表, 数据扫盲, 数据分析软件, Excel 宏, 财务预测, Excel 公式
中级 · 课程 · 1-3 个月

您将获得的技能: Microsoft Excel, Pivot Tables And Charts, Excel Formulas, Spreadsheet Software, Business Reporting, Data Visualization, Excel Macros, Dashboard, Forecasting, Data Analysis, Data Visualization Software, Predictive Modeling, Data Validation, Productivity Software, Data Entry, Data Management, Financial Modeling, Data Security, Data Integrity, Computer Literacy
初级 · 专项课程 · 1-3 个月

您将获得的技能: Microsoft Excel, Excel Formulas, Pivot Tables And Charts, Spreadsheet Software, Data Analysis Expressions (DAX), Financial Forecasting, Financial Modeling, Financial Analysis, Business Analysis, Data-Driven Decision-Making, Data Manipulation
初级 · 课程 · 1-4 周

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

您将获得的技能: Excel Formulas, Data Storytelling, Microsoft Excel, Dashboard, Pivot Tables And Charts, Power BI, Data-Driven Decision-Making, Microsoft Copilot, Spreadsheet Software, Data Literacy, Data Presentation, Data Visualization Software, Generative AI, Data Visualization, Data Analysis, Business Intelligence, Data Processing, Data Collection, Interactive Data Visualization, Business Metrics
初级 · 专项课程 · 3-6 个月
Macquarie University
您将获得的技能: 数据叙事, 数据建模, 电子表格软件, 微软Excel, 数据预处理, 微软办公软件, 商业分析, 数据展示, 数据操作, 分析技能, 仪表板, 高级分析, 数据扫盲, 数据分析软件, Data Analysis 表达式(DAX), Excel 宏, 透视表和图表, 财务预测, Excel 公式, Data Validation
初级 · 专项课程 · 3-6 个月

Corporate Finance Institute
您将获得的技能: Star Schema, Data Modeling, Tableau Software, Interactive Data Visualization, Business Intelligence, Extract, Transform, Load, Dashboard, Performance Tuning, Technical Analysis, Database Design, Data Visualization Software, Data Warehousing, Market Data, Data Transformation, Data Presentation, Investment Banking, Exploratory Data Analysis, Tree Maps, Data Storytelling, Data Visualization
高级设置 · 专项课程 · 3-6 个月

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

Coursera
您将获得的技能: Excel Macros, Microsoft Excel, Data Analysis Expressions (DAX), Excel Formulas, Visual Basic (Programming Language), Productivity Software, Data Transformation, Debugging, Spreadsheet Software, Data Cleansing, Automation, Strategic Decision-Making, Programming Principles
初级 · 课程 · 1-4 周