This course introduces learners to Excel Macros and VBA, focusing on automating tasks to enhance productivity. Starting with the macro recorder, learners will automate repetitive tasks without needing to write code. They will explore VBA programming fundamentals, such as working with variables, built-in functions, and loops to optimize workflows. Advanced topics include creating interactive dashboards using Excel Copilot, incorporating predictive and scenario analysis, and building user-friendly interfaces with ActiveX controls and UserForms. By the end of the course, learners will be proficient in using Macros and VBA to streamline tasks and create dynamic Excel solutions.
Automation & Advanced Techniques with Copilot in Excel
Automation & Advanced Techniques with Copilot in Excel
本课程是 Microsoft Excel 专业证书 的一部分
位教师： Microsoft
5,473 人已注册
包含在 
中
您将学到什么
Utilize Excel Macros to automate repetitive tasks and enhance efficiency.
Navigate the Developer tab and use the macro recorder to streamline workflows.
Debug and edit macro code using the VBA editor for optimal performance.
Apply advanced VBA techniques to create custom macros and interactive dashboards.
您将获得的技能
要了解的详细信息
了解顶级公司的员工如何掌握热门技能
积累 Data Analysis 领域的专业知识
本课程是 Microsoft Excel 专业证书 专项课程的一部分
在注册此课程时，您还会同时注册此专业证书。
- 向行业专家学习新概念
- 获得对主题或工具的基础理解
- 通过实践项目培养工作相关技能
- 通过 Microsoft 获得可共享的职业证书
该课程共有4个模块
This module focuses on leveraging Excel macros to automate repetitive tasks and enhance efficiency. You will use the macro recorder to capture actions and automate tasks without needing to write code.
涵盖的内容
15个视频16篇阅读材料5个作业
In this module, you will learn the fundamentals of VBA programming, including how to declare variables to store and manipulate data effectively. We will cover the use of built in VBA functions and how to implement conditional statements, such as loops, to automate repetitive tasks and enhance decision-making processes. By the end of this module, you will be equipped with the skills to create more efficient and dynamic Excel solutions using VBA.
涵盖的内容
10个视频8篇阅读材料4个作业
This module, you will learn the essentials of using Active X controls, design Userforms and implement effective error handling. We will also explore workflow automation techniques through the use of user forms, allowing you to build interactive and user-friendly Excel applications. By the end of this module, you will have the skills to enhance productivity and streamline processes using VBA in Excel.
涵盖的内容
10个视频10篇阅读材料4个作业
This module covers the practical aspects of creating an interactive dashboard using Excel Copilot, integrating predictive and scenario analysis techniques. You will create dynamic dashboards and incorporate interactive elements such as slicers and filters.
涵盖的内容
11个视频7篇阅读材料4个作业1次同伴评审
获得职业证书
将此证书添加到您的 LinkedIn 个人资料、简历或履历中。在社交媒体和绩效考核中分享。
从 Data Analysis 浏览更多内容
状态：免费试用Microsoft
状态：免费试用
状态：预览Knowledge Accelerators
状态：免费试用
人们为什么选择 Coursera 来帮助自己实现职业发展
Felipe M.
自 2018开始学习的学生
''能够按照自己的速度和节奏学习课程是一次很棒的经历。只要符合自己的时间表和心情，我就可以学习。'
Jennifer J.
自 2020开始学习的学生
''我直接将从课程中学到的概念和技能应用到一个令人兴奋的新工作项目中。'
Larry W.
自 2021开始学习的学生
''如果我的大学不提供我需要的主题课程，Coursera 便是最好的去处之一。'
Chaitanya A.
''学习不仅仅是在工作中做的更好：它远不止于此。Coursera 让我无限制地学习。'
学生评论
4.7
34 条评论
- 5 stars
77.14%
- 4 stars
20%
- 3 stars
0%
- 2 stars
0%
- 1 star
2.85%
显示 3/34 个
TM
5
已于 Jul 15, 2025审阅
Amazing Course. Definitely inspired to learn more!
MD
4
已于 Aug 21, 2025审阅
Course is good. Stress on CoPilot is more than required.
常见问题
To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
When you enroll in the course, you get access to all of the courses in the Certificate, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.
更多问题
提供助学金，
¹ 本课程的部分作业采用 AI 评分。对于这些作业，将根据 Coursera 隐私声明使用您的数据。