VBA 课程可以帮助您学习 Excel 和其他 Microsoft Office 应用程序中的自动化技术、数据操作和自定义函数创建。您可以掌握开发用户表单、创建宏以及将 VBA 与 SQL 集成用于数据库管理的技能。许多课程都会介绍 Visual Basic 编辑器和 Excel 内置函数等工具,展示这些技能如何在各种业务环境中简化任务和提高工作效率。
Macquarie University
您将获得的技能: Excel 宏, 数据预处理, 分析技能, 数据整理, 高级分析, 交互式数据可视化, 数据操作, 仪表板, 数据展示, 商业分析, Excel 公式, 商业数学, 仪表板创建, 数据分析软件, 数据处理, 财务分析, 电子表格软件, Microsoft Excel
中级 · 课程 · 1-3 个月

您将获得的技能: Pivot Tables And Charts, Microsoft Excel, Spreadsheet Software, Excel Macros, Data Presentation, Data Analysis, Data Visualization Software, Data Security, Data Integrity, Automation
混合 · 课程 · 1-4 周

Macquarie University
您将获得的技能: 数据共享, 数据整理, 数据故事, 仪表板创建, Microsoft Excel, Power BI, 电子表格软件
中级 · 课程 · 1-3 个月

您将获得的技能: Microsoft Excel, Excel Formulas, Pivot Tables And Charts, Financial Data, Financial Analysis, Cash Flows, Data-Driven Decision-Making, Data Manipulation
初级 · 课程 · 1-4 周

您将获得的技能: Data Visualization, Microsoft Excel, Data Visualization Software, Data Import/Export, Business Reporting, Microsoft Office, Microsoft 365, Productivity Software
初级 · 指导项目 · 不超过 2 小时

John Wiley & Sons
您将获得的技能: Excel Macros, Pivot Tables And Charts, Microsoft Excel, Financial Forecasting, Spreadsheet Software, Excel Formulas, Data Visualization, Trend Analysis, Diagram Design, Visual Basic (Programming Language), Automation, Forecasting, Graphical Tools
中级 · 课程 · 1-3 个月

您将获得的技能: Dashboard, Pivot Tables And Charts, Dashboard Creation, Excel Formulas, Microsoft Excel, Excel Macros, Data Visualization, Performance Analysis, Key Performance Indicators (KPIs), Spreadsheet Software, People Analytics, Data Presentation, Human Resource Strategy, Business Analytics, Performance Measurement, Financial Analysis, Interactive Data Visualization, Trend Analysis, Human Resources, Performance Metric
初级 · 专项课程 · 3-6 个月

您将获得的技能: Bookkeeping, Variance Analysis, Dashboard, Budget Management, Financial Analysis, Data Storytelling, Data Presentation, Financial Modeling, Financial Statements, Dashboard Creation, Financial Statement Analysis, Excel Macros, Microsoft Excel, Competitive Analysis, Risk Modeling, Interviewing Skills, Excel Formulas, Spreadsheet Software, Financial Reporting, Data Visualization
高级设置 · 专业证书 · 3-6 个月

Logical Operations
您将获得的技能: Microsoft Access, Database Design, Relational Databases, Database Management, Database Development, Microsoft 365, Database Administration, Database Management Systems, Database Architecture and Administration, Data Integrity, Data Maintenance, Microsoft Windows, Databases, Microsoft Office, Data Entry, Query Languages, Data Presentation, Productivity Software, User Interface (UI), Scripting
初级 · 专项课程 · 3-6 个月

您将获得的技能: Financial Statements, Financial Statement Analysis, Financial Modeling, Excel Macros, Financial Analysis, Pivot Tables And Charts, Data Integrity, Bookkeeping, Excel Formulas, Trend Analysis, Balance Sheet, Reconciliation, Financial Data, Data Validation, Ledgers (Accounting), Data Quality, Spreadsheet Software, Microsoft Excel, Data Cleansing, Automation
中级 · 专项课程 · 3-6 个月

John Wiley & Sons
您将获得的技能: Excel Formulas, Microsoft Excel, Excel Macros, Spreadsheet Software, Pivot Tables And Charts, Data Presentation, Proofreading, Data Visualization, Editing, Financial Forecasting, Financial Modeling, Productivity Software, Consolidation, Data Analysis, Data Validation, Trend Analysis, Data Entry, Diagram Design, Visual Basic (Programming Language), Automation
初级 · 专项课程 · 3-6 个月

您将获得的技能: Pivot Tables And Charts, Dashboard, Dashboard Creation, Microsoft Excel, Financial Modeling, Excel Macros, Data Presentation, Interactive Data Visualization, Data Import/Export, Spreadsheet Software, Data Modeling, Data Literacy, Forecasting, Workflow Management, Statistical Methods, Excel Formulas, Simulation and Simulation Software, Data Storytelling, Finance, Data Analysis
初级 · 专项课程 · 3-6 个月