Excel and Copilot Fundamentals

通过 Coursera Plus 提高技能，仅需 239 美元/年（原价 399 美元）。立即节省

Excel and Copilot Fundamentals

本课程是多个项目的一部分。

位教师： Microsoft

113,160 人已注册

包含在中

了解更多

5个模块

深入了解一个主题并学习基础知识。

330 条评论

初级等级

推荐体验

灵活的计划

2 周在 10 小时一周

自行安排学习进度

94%

大多数学生喜欢此课程

5个模块

深入了解一个主题并学习基础知识。

330 条评论

初级等级

推荐体验

灵活的计划

2 周在 10 小时一周

自行安排学习进度

94%

大多数学生喜欢此课程

您将学到什么

Activate and effectively use Excel Copilot for basic tasks and queries.
Navigate the Excel interface and utilize basic features efficiently.
Apply fundamental Excel formulas and functions to perform calculations and data manipulation.
Develop basic prompt engineering skills for Copilot in Excel.

您将获得的技能

您将学习的工具

要了解的详细信息

可分享的证书

添加到您的领英档案

作业

20 任务¹

AI 评分请参见免责声明

授课语言：英语（English）

了解顶级公司的员工如何掌握热门技能

了解关于 Coursera for Business 的更多信息

Petrobras, TATA, Danone, Capgemini, P&G 和 L'Oreal 的徽标

积累特定领域的专业知识

此课程作为的一部分提供

在注册此课程时，您还需要选择一个特定的合作项目。

向行业专家学习新概念
获得对主题或工具的基础理解
通过实践项目培养工作相关技能
获得可共享的职业证书

该课程共有5个模块

This course introduces you to the basics of Microsoft Excel and its powerful Copilot feature, equipping you with essential skills for efficient data handling and analysis. You will learn to navigate Excel’s interface, apply fundamental formulas and functions, and develop prompt engineering techniques to leverage Excel Copilot for various tasks. By the end of this course, you will have a strong foundation in Excel, enabling you to perform basic data manipulations and utilize Copilot to streamline your workflow.

By the end of the course, you’ll be able to: - Activate and effectively use Excel Copilot for basic tasks and queries. - Navigate the Excel interface and utilize basic features efficiently. - Apply fundamental Excel formulas and functions to perform calculations and data manipulation. - Develop basic prompt engineering skills for Excel Copilot. Tools you’ll use: - Microsoft Excel - Copilot in Excel Required Course Materials: A Copilot license is required to complete this course. If you don’t have a Microsoft 365 Personal or Family license, you can start a free 30-day trial using the link provided in the course.

This module covers the activation and basic usage of Copilot in Excel, helping you understand its environments and how to effectively utilize it for various tasks.

涵盖的内容

12个视频11篇阅读材料4个作业

12个视频总计81分钟

Activating Excel Copilot 7分钟
Performing basic tasks with Copilot 7分钟
Hands-on activity debrief: Activating Copilot 8分钟
Hands-on activity debrief: Create a travel budget 4分钟
Optimizing workflows with Excel Copilot Part 1 of 2 5分钟
Optimizing workflows with Excel Copilot Part 2 of 2 7分钟
Using conditional formatting with Copilot 6分钟
Enhancing data presentation with Excel Copilot 5分钟
Hands-on activity debrief: Optimize workflows with Copilot 7分钟
Evaluating Copilot performance 7分钟
Improving Copilot performance through customization 8分钟
Hands-on activity debrief: Evaluating Copilot performance 9分钟

11篇阅读材料总计127分钟

Welcome to Excel and Copilot fundamentals 10分钟
Introduction to the Coursera Community 10分钟
Getting started with Copilot in Excel 2分钟
How to Get Started with Microsoft Copilot 10分钟
Guide to performing basic tasks using Copilot in Excel 10分钟
Hands-on activity: Activating Copilot 20分钟
Hands-on activity: Create a travel budget 5分钟
Using Excel add-ins to extend functionality 10分钟
Hands-on activity: Optimize workflows with Copilot 20分钟
Copilot performance metrics 10分钟
Hands-on activity: Evaluating Copilot performance 20分钟

4个作业总计63分钟

Quiz: Performing basic tasks using Copilot in Excel 12分钟
Quiz: Optimizing workflows with Copilot 12分钟
Quiz: Copilot performance 9分钟
Quiz: Introduction to Copilot in Excel and activation 30分钟

This module introduces the Excel interface and its basic features. You will become familiar with the layout, essential elements, and basic functionalities to use Excel efficiently and be able to compare these functionalities to the abilities of Copilot.

涵盖的内容

11个视频8篇阅读材料4个作业

11个视频总计82分钟

Introduction to Excel: Basic navigation 6分钟
Introduction to Excel: Backstage view and shortcuts 7分钟
Creating and managing Excel workbooks 7分钟
Hands-on activity debrief: Navigating and using basic features 14分钟
Introduction to data types 5分钟
Converting data types 6分钟
Working with data types 7分钟
Hands-on activity debrief: Understanding data types 9分钟
Creating lists 6分钟
Creating tables 7分钟
Hands-on activity debrief: Creating lists and tables 8分钟

8篇阅读材料总计105分钟

Basic features in Excel 10分钟
Using Excel templates for efficiency 5分钟
Hands-on activity: Navigating and using basic features 20分钟
Mastering data types in Excel: Tips and tricks for effective data management 10分钟
Hands-on activity: Understanding data types 20分钟
Guide to Excel tables and best practice 10分钟
Hands-on activity: Creating lists and tables 20分钟
Discussion: Customizing the Excel interface 10分钟

4个作业总计84分钟

Quiz: Excel interface customization 18分钟
Quiz: Data types 18分钟
Quiz: Lists and tables 18分钟
Quiz: Excel interface and basic features 30分钟

This module focuses on Excel formulas and how to do this with Copilot as well as functions, covering essential arithmetic operations and key functions to manipulate and analyze data effectively.

涵盖的内容

9个视频10篇阅读材料4个作业

9个视频总计69分钟

Using basic arithmetic in Excel 7分钟
Applying mathematical functions in Excel 7分钟
Hands-on activity debrief: Practicing arithmetic functions 8分钟
Applying logical functions in Excel 7分钟
Combining logical and LOOKUP functions for advanced data analysis 7分钟
Hands-on activity debrief: Practicing logical and LOOKUP functions 8分钟
Using conditional, date, and time functions with Copilot 7分钟
Using nested functions for complex calculations in Excel 8分钟
Hands-on activity debrief: Practicing conditional, date, and time functions 10分钟

10篇阅读材料总计130分钟

Applying BODMAS 10分钟
Understanding cell references (relative, absolute, and mixed) 10分钟
Hands-on activity: Practicing arithmetic functions 20分钟
Using LOOKUP functions overview 10分钟
Creating and managing named ranges 10分钟
Hands-on activity: Practicing logical and LOOKUP functions 20分钟
Applying the date and time functions overview 10分钟
Understanding Excel's error messages and troubleshooting techniques 10分钟
Hands-on activity: Practicing conditional, date, and time functions 20分钟
Discussion: Optimizing patient data analysis with Excel 10分钟

4个作业总计84分钟

Quiz: Arithmetic functions 18分钟
Quiz: Logical and LOOKUP functions 18分钟
Quiz: Conditional, date, and time functions 18分钟
Quiz: Excel formulas and functions 30分钟

This module focuses on basic data entry and formatting tasks using Excel Copilot, ensuring you can enter, edit, and format data efficiently.

涵盖的内容

9个视频5篇阅读材料4个作业

9个视频总计70分钟

Data entry techniques 7分钟
Using data validation for accurate data entry 7分钟
Hands-on activity debrief: Practicing data entry techniques 7分钟
Formatting data in Excel 7分钟
Creating custom styles and templates in Excel 8分钟
Hands-on activity debrief: Formatting techniques practice 8分钟
Enhancing data presentation 8分钟
Creating basic pivots in Excel 8分钟
Hands-on activity debrief: Advanced formatting practice 11分钟

5篇阅读材料总计80分钟

Overview of shortcuts 10分钟
Hands-on activity: Practicing data entry techniques 20分钟
Formatting best practices 10分钟
Hands-on activity: Formatting techniques practice 20分钟
Hands-on activity: Advanced formatting practice 20分钟

4个作业总计66分钟

Quiz: Data entry techniques 12分钟
Quiz: Formatting techniques 12分钟
Quiz: Advanced formatting 12分钟
Quiz: Basic data entry and formatting with Copilot 30分钟

This module introduces prompt engineering techniques to effectively use Excel Copilot for various advanced tasks.

涵盖的内容

10个视频8篇阅读材料4个作业1次同伴评审

10个视频总计79分钟

Engineering prompts for Excel Copilot 8分钟
Advanced prompt engineering techniques 7分钟
Hands-on activity debrief: Writing basic prompts 7分钟
Writing effective prompts 8分钟
Improving your prompts 6分钟
Hands-on activity debrief: Practicing effective prompts 10分钟
Evaluating prompt performance 7分钟
Optimizing prompts for better results 7分钟
Hands-on activity debrief: Evaluating prompt performance 9分钟
Cumulative project debrief: Attendance tracker 9分钟

8篇阅读材料总计105分钟

List of Copilot tasks available and starter prompts 10分钟
Understanding natural language processing (NLP) basics 10分钟
Hands-on activity: Writing basic prompts 20分钟
Techniques for effective prompts 5分钟
Hands-on activity: Practicing effective prompts 20分钟
Metrics for prompt performance 10分钟
Hands-on activity: Developing effective prompts 20分钟
Cumulative project: Discussion 10分钟

4个作业总计57分钟

Quiz: Prompt engineering basics 9分钟
Quiz: Effective prompts 9分钟
Quiz: Prompt performance 9分钟
Quiz: Introduction to prompt engineering for Excel Copilot 30分钟

1次同伴评审总计35分钟

Cumulative project: Attendance tracker 35分钟

获得职业证书

将此证书添加到您的 LinkedIn 个人资料、简历或履历中。在社交媒体和绩效考核中分享。

位教师

授课教师评分

(95个评价)

Microsoft

287 门课程 2,382,020 名学生

提供方

Microsoft

从 Data Analysis 浏览更多内容

Microsoft
Automation & Advanced Techniques with Copilot in Excel
课程
LearnKartS
Master Microsoft Excel with Copilot
课程
Microsoft
Advanced Data Analysis & Visualization with Copilot in Excel
课程
Microsoft
Data Cleaning & Processing with Copilot in Excel
课程

人们为什么选择 Coursera 来帮助自己实现职业发展

Felipe M.

自 2018开始学习的学生

''能够按照自己的速度和节奏学习课程是一次很棒的经历。只要符合自己的时间表和心情，我就可以学习。'

Jennifer J.

自 2020开始学习的学生

''我直接将从课程中学到的概念和技能应用到一个令人兴奋的新工作项目中。'

Larry W.

自 2021开始学习的学生

''如果我的大学不提供我需要的主题课程，Coursera 便是最好的去处之一。'

Chaitanya A.

''学习不仅仅是在工作中做的更好：它远不止于此。Coursera 让我无限制地学习。'

学生评论

5 stars
65.45%
4 stars
15.75%
3 stars
3.93%
2 stars
4.54%
1 star
10.30%

显示 3/330 个

已于 Sep 5, 2025审阅

Bastante bueno para principiantes e intermedios, con una estructura apta para poder complementar los conocimientos con copilot

已于 Feb 17, 2025审阅

Excellent Skills and knowledge for Microsoft Excel and Copilot Fundamentals

已于 Nov 13, 2025审阅

the was good and informative. The only thing I didn't like was that i did not cover taking data from one workbook to another workbook, it it was part of the final cumulative project.

查看更多评论

通过 Coursera Plus 开启新生涯

无限制访问 10,000+ 世界一流的课程、实践项目和就业就绪证书课程 - 所有这些都包含在您的订阅中

了解更多

通过在线学位推动您的职业生涯

获取世界一流大学的学位 - 100% 在线

探索学位

加入超过 3400 家选择 Coursera for Business 的全球公司

提升员工的技能，使其在数字经济中脱颖而出

了解更多

常见问题

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.