What advanced Excel formulas and functions will I learn with Copilot?

<text variant="body1">You’ll learn SUM, AVERAGE, MIN/MAX, logical, nested, conditional, and LOOKUP functions, all integrated with Copilot for faster and smarter calculations in professional tasks.

Will learning Excel with Copilot improve my career opportunities?

<text variant="body1">Yes. AI-based Excel training skills are a must-have for anyone working as a Business Analyst, Data Analyst, Project Manager, Finance Professional, or Operations Executive. Excel skills with AI Automation also make you more productive and marketable in today's data-saturated workplace.

What will I get if I purchase the Certificate?

When you purchase a Certificate you get access to all course materials, including graded assignments. Upon completing the course, your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.

Is financial aid available?

Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.

Master Microsoft Excel with Copilot

抓住节省的机会！购买 Coursera Plus 3 个月课程可享受40% 的折扣，并可完全访问数千门课程。

Master Microsoft Excel with Copilot

位教师：LearnKartS

包含在中

了解更多

3个模块

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

初级等级

推荐体验

2 周完成

在 10 小时一周

灵活的计划

自行安排学习进度

3个模块

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

初级等级

推荐体验

2 周完成

在 10 小时一周

灵活的计划

自行安排学习进度

您将学到什么

Confidently navigate Excel, manage data types, apply essential formulas, and integrate Microsoft Copilot to automate everyday data tasks.
Use Copilot to analyze datasets, filter, sort, format, generate subtotals, and optimize workflows — reducing manual effort and boosting productivity.
Apply logical, lookup, nested, mathematical, and date-time functions while cleaning, correcting, and transforming raw data into actionable insights.
Apply prompt engineering to get smarter AI results and boost productivity in Excel

您将获得的技能

您将学习的工具

要了解的详细信息

可分享的证书

添加到您的领英档案

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

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

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

该课程共有3个模块

Excel Skills Are Expected. But AI-Powered Excel Skills Make You Irreplaceable.

Still spending hours writing formulas and fixing spreadsheet errors? In today’s AI-driven workplace, basic Excel knowledge is no longer enough. This Microsoft Excel with Copilot Course helps you master Excel fundamentals and elevate your skills using Microsoft 365 Copilot to automate data analysis, generate insights instantly, and build AI-powered workflows. Inside this course, you will: • Master formulas, logical & lookup functions • Clean and structure messy datasets • Build pivot tables and business-ready reports • Automate repetitive tasks with Excel • Apply prompt engineering for smarter Copilot outputs Unlike traditional Microsoft Excel courses that stop at formulas, this course teaches you how to strategically combine Excel expertise with AI to save hours every week, reduce manual errors, and boost productivity. Designed for students and professionals who want a future-ready, high-demand skill set. By the end, you’ll confidently analyze data, automate workflows, and stand out in a data-driven world. Enroll today and gain the AI-powered Excel advantage. Note: Learners need to have Microsoft 365 Copilot license.

In this module, you will set up Microsoft Copilot and learn essential Excel functions for data analysis, filtering, sorting, and organizing data. You will also master basic data handling techniques and explore how to optimize workflows using Copilot.

涵盖的内容

18个视频3篇阅读材料7个作业

18个视频总计59分钟

Course Introduction: Start Your Journey! 2分钟
Introduction to Microsoft Copilot: Activation & Setup Guide 3分钟
Mastering Basic Data Analysis with Copilot 5分钟
How to Use Copilot for Data Q&A 9分钟
Filtering Data with Copilot: Part 1 4分钟
Filtering Data with Copilot: Part 2 4分钟
Formatting Your Data for Clarity and Insights 3分钟
Organizing Your Data: Sorting with Copilot 2分钟
Correcting Missing Data Using Copilot 3分钟
Creating Synthetic Data for Analysis with Copilot 3分钟
Using Formula Columns for Dynamic Data 4分钟
Text Functions in Excel: Working with Strings 3分钟
Mastering Date Calculations in Excel 2分钟
Using Conditional Statements for Smarter Excel Models 3分钟
Formatting Cells with Formulas for Enhanced Analysis 3分钟
Visualizing Data with Color Scales & Data Bars 2分钟
Best Practices for Editing Excel Spreadsheets 2分钟
Profiling Data to Identify Trends and Insights 3分钟

3篇阅读材料总计25分钟

Exploring the Basics of Data Analysis in Excel 10分钟
Best Practices for Data Formatting and Cleaning 10分钟
Summary 5分钟

7个作业总计152分钟

Checkpoint Quiz 20分钟
Checkpoint Quiz 20分钟
Checkpoint Quiz 16分钟
Checkpoint Quiz 16分钟
Proficiency Quiz 40分钟
Proficiency Quiz 20分钟
Proficiency Quiz 20分钟

This Module focuses on advanced Excel functions, including SUM, AVERAGE, and SUBTOTAL. You will also enhance your productivity with Copilot’s features for data analysis, budgeting, and workflow optimization.

涵盖的内容

19个视频3篇阅读材料7个作业

19个视频总计61分钟

Using the Sum Function with Copilot 5分钟
Calculating Averages in Excel with Copilot 1分钟
Using Min & Max Functions with Copilot 2分钟
How to Add Formulas in Excel with Copilot 2分钟
Summarizing Data: Using Subtotals with Copilot 2分钟
Using Copilot to Create a Travel Budget 2分钟
Optimizing Excel Workflows with Copilot: Part 1 4分钟
Optimizing Excel Workflows with Copilot: Part 2 3分钟
Applying Conditional Formatting with Copilot 3分钟
Making Your Data Stand Out with Copilot 3分钟
Streamlining Workflows with Copilot 5分钟
How to Evaluate Copilot's Performance 5分钟
Enhancing Copilot Performance Through Customization 4分钟
Measuring Copilot’s Performance and Improvements 6分钟
Navigating Excel: Getting Started with the Interface 3分钟
Understanding Data Types in Excel 2分钟
How to Convert Data Types in Excel 2分钟
Effective Techniques for Working with Data Types 3分钟
Mastering Data Types for Better Analysis 3分钟

3篇阅读材料总计25分钟

Working with Excel Functions and Formulas 10分钟
Optimizing Your Workflow with Excel Functions 10分钟
Summary 5分钟

7个作业总计175分钟

Checkpoint Quiz 20分钟
Checkpoint Quiz 20分钟
Checkpoint Quiz 20分钟
Checkpoint Quiz 20分钟
Proficiency Quiz 25分钟
Proficiency Quiz 45分钟
Proficiency Quiz 25分钟

In this final module, you will master complex Excel formulas, pivot tables, and data validation techniques. Additionally, you’ll learn to optimize Copilot’s capabilities with advanced prompt engineering for efficient data management and analysis.

涵盖的内容

30个视频3篇阅读材料12个作业

30个视频总计120分钟

Mastering Basic Arithmetic Functions in Excel 4分钟
Applying Mathematical Functions for Complex Calculations 6分钟
Mastering Logical Functions in Excel 3分钟
Advanced Data Analysis with Logical & Lookup Functions 3分钟
Leveraging Conditional & Time Functions for Smarter Excel Models 4分钟
Mastering Nested Functions for Complex Calculations 3分钟
Mastering Data Entry Techniques in Excel 1分钟
How to Use Data Validation for Error-Free Data Entry 3分钟
Hands-on Activity: Practicing Data Entry Techniques 2分钟
Mastering Data Formatting in Excel 5分钟
Activity: Enhancing Formatting Techniques 5分钟
Enhancing Data Presentation for Clear Insights 6分钟
Creating Basic Pivot Tables in Excel 4分钟
Activity: Advanced Formatting Techniques in Excel 8分钟
Crafting Effective Prompts for Excel Copilot 3分钟
Advanced Prompt Engineering for Maximum Copilot Efficiency 3分钟
Hands-on: Writing Basic Prompts for Copilot 5分钟
Crafting Effective Prompts to Enhance Copilot Performance 4分钟
How to Evaluate Prompt Performance with Copilot 3分钟
Optimizing Prompts for Better Results with Copilot 3分钟
Activity: Evaluating and Improving Prompt Performance with Copilot 7分钟
Cleaning and Processing Data with Copilot in Excel 2分钟
Correcting Data Errors with Copilot 5分钟
Identifying Common Data Errors in Excel 3分钟
How to Detect and Correct Errors in Datasets 2分钟
Using Copilot to Address Data Errors 7分钟
Correcting Data Errors 6分钟
Transposing Data for Trend Analysis 2分钟
Date-time Formatting Techniques for Accurate Analysis 4分钟
Congratulations on Completing the Course! 1分钟

3篇阅读材料总计30分钟

Mastering Logical & Lookup Functions for Complex Analysis 10分钟
Effective Techniques for Accurate Data Entry 10分钟
Data Error Identification and Troubleshooting in Excel 10分钟

12个作业总计255分钟

Checkpoint Quiz 12分钟
Checkpoint Quiz 12分钟
Checkpoint Quiz 16分钟
Checkpoint Quiz 16分钟
Checkpoint Quiz 16分钟
Checkpoint Quiz 12分钟
Checkpoint Quiz 16分钟
Checkpoint Quiz 16分钟
Proficiency Quiz 24分钟
Proficiency Quiz 40分钟
Proficiency Quiz 35分钟
Proficiency Quiz 40分钟

位教师

LearnKartS

136 门课程 180,329 名学生

提供方

LearnKartS

从 Business Essentials 浏览更多内容

状态：预览
Knowledge Accelerators
Microsoft Copilot in Excel: Smarter Data Analysis Made Easy
课程
状态：免费试用
Microsoft
Excel and Copilot Fundamentals
课程
状态：免费试用
Microsoft
Automation & Advanced Techniques with Copilot in Excel
课程
状态：预览
Maven Analytics
Microsoft Copilot for Excel: AI-Powered Data Analysis
课程

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

Felipe M.

自 2018开始学习的学生

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

Jennifer J.

自 2020开始学习的学生

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

Larry W.

自 2021开始学习的学生

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

Chaitanya A.

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

通过 Coursera Plus 开启新生涯

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

了解更多

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

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

探索学位

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

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

了解更多

常见问题

Yes. This course is designed for beginners as well as working professionals. It starts with Excel basics like navigation, data types, formulas, sorting, filtering, and pivot tables, then gradually moves to advanced Excel functions, data cleaning, and AI-powered automation using Copilot.

You will learn Excel fundamentals, logical and lookup functions, data validation, error handling, pivot tables, data preparation techniques, workflow optimization, and prompt engineering. You’ll also learn how to use Copilot to automate calculations, generate insights, and improve productivity.

The majority of Excel courses spend hours on formula writing and reporting. This AI in Excel course combines fundamental Excel skills with AI-enabled Copilot workflows and prompt engineering. You’re not just learning how Excel works, but how to use AI to save time, increase accuracy, and make decisions more easily.

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.

Master Microsoft Excel with Copilot

Master Microsoft Excel with Copilot

您将学到什么

您将获得的技能

您将学习的工具

要了解的详细信息

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

该课程共有3个模块

Getting Started with Copilot & Core Data Operations in Excel

涵盖的内容

18个视频总计59分钟

3篇阅读材料总计25分钟

7个作业总计152分钟

Excel Fundamentals: Interface, Functions & Copilot Applications

涵盖的内容

19个视频总计61分钟

3篇阅读材料总计25分钟

7个作业总计175分钟

Excel Productivity: Formulas, Data Preparation & Copilot Prompting

涵盖的内容

30个视频总计120分钟

3篇阅读材料总计30分钟

12个作业总计255分钟

位教师

提供方

从 Business Essentials 浏览更多内容

Microsoft Copilot in Excel: Smarter Data Analysis Made Easy

Excel and Copilot Fundamentals

Automation & Advanced Techniques with Copilot in Excel

Microsoft Copilot for Excel: AI-Powered Data Analysis

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

Felipe M.

Jennifer J.

Larry W.

Chaitanya A.

通过 Coursera Plus 开启新生涯

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

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

常见问题

更多问题

Master Microsoft Excel with Copilot

Master Microsoft Excel with Copilot

您将学到什么

您将获得的技能

您将学习的工具

要了解的详细信息

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

该课程共有3个模块

Getting Started with Copilot & Core Data Operations in Excel

涵盖的内容

Excel Fundamentals: Interface, Functions & Copilot Applications

涵盖的内容

Excel Productivity: Formulas, Data Preparation & Copilot Prompting

涵盖的内容

位教师

提供方

从 Business Essentials 浏览更多内容

Microsoft Copilot in Excel: Smarter Data Analysis Made Easy

Excel and Copilot Fundamentals

Automation & Advanced Techniques with Copilot in Excel

Microsoft Copilot for Excel: AI-Powered Data Analysis

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

Felipe M.

Jennifer J.

Larry W.

Chaitanya A.

通过 Coursera Plus 开启新生涯

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

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

常见问题

Is this Microsoft Excel with Copilot course suitable for beginners?

What will I learn in this Excel Copilot course?

How is this course different from other Excel courses on Coursera?

更多问题