In this course, it is necessary to have access to Microsoft 365 with Copilot enabled, although no prior experience with Copilot is needed. You'll explore how to use Copilot Pro and Microsoft 365 Copilot in Excel to work with data more efficiently. You'll learn to transform raw data into meaningful insights and eye-catching visualizations, all with the help of AI. You'll cover advanced techniques for manipulating data, generating insights, creating visualizations, and summarizing information using Copilot in Excel.

Data Analysis and Visualization with Generative AI in Excel
本课程是 Microsoft 365 with Generative AI 专业证书 的一部分

位教师: Microsoft
访问权限由 New York State Department of Labor 提供
2,799 人已注册
您将学到什么
Learn to manipulate and analyze data with Copilot.
Generate insights and create visualizations in Excel.
Summarize information and automate tasks using AI tools.
您将获得的技能
- Data Cleansing
- Data Storytelling
- Spreadsheet Software
- Data-Driven Decision-Making
- Microsoft Copilot
- Data Analysis
- Data Synthesis
- Trend Analysis
- Microsoft Excel
- Data Visualization Software
- Prompt Engineering
- Predictive Modeling
- Data Transformation
- Report Writing
- Data Manipulation
- Predictive Analytics
- Forecasting
- Data Presentation
- Dashboard
- Excel Formulas
- 技能部分已折叠。显示 10 项技能,共 20 项。
要了解的详细信息

添加到您的领英档案
30 项作业
了解顶级公司的员工如何掌握热门技能

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

该课程共有5个模块
In this module, you will learn how to manipulate and analyze data using Copilot in Excel. You’ll explore various data manipulation techniques, including creating efficient filters and custom sorts, generating and modifying formulas, and building comprehensive pivot tables with Copilot's assistance. This module also explores trend and pattern identification, providing you with the skills to generate valuable insights and data-driven narratives using Copilot's natural language processing. By the end of this module, you will be equipped to transform raw datasets into structured, insightful models and uncover key trends and patterns within your data.
涵盖的内容
9个视频17篇阅读材料7个作业
Insight Generation with Copilot helps you analyze data, identify trends, and generate actionable insights using Microsoft Copilot. You’ll develop skills in uncovering patterns in Excel, combining and analyzing data across Microsoft 365 tools, building basic predictive models, and crafting data-driven narratives. Through hands-on activities, you’ll analyze datasets, integrate data from multiple sources, create forecasts, and generate written explanations, all while applying Copilot’s natural language processing capabilities for generating valuable insights.
涵盖的内容
12个视频10篇阅读材料9个作业
This module focuses on mastering data visualization techniques using Microsoft Copilot. You’ll learn how to create a variety of charts and graphs, customize visualizations for clear communication, and design interactive dashboards. The lessons cover generating basic charts with natural language prompts, creating advanced visualizations like scatter plots and tree maps, and building interactive dashboards with multiple charts. Through hands-on activities, you'll strengthen your skills, enabling you to effectively use Copilot for dynamic and impactful data presentations in Excel.
涵盖的内容
9个视频3篇阅读材料6个作业
This module equips you with the skills to synthesize data into clear, actionable insights and create impactful summaries and reports. You’ll learn how to distill data into key points, develop executive summaries, and generate comprehensive reports using Copilot. The lessons cover summarizing datasets into concise overviews, crafting executive summaries by extracting insights from Excel into Word, and producing detailed reports with narrative explanations and visualizations. Hands-on activities will give you practical experience in creating data-driven presentations and reports using Microsoft tools.
涵盖的内容
10个视频4篇阅读材料6个作业
This module presents the final project you'll complete before successfully finishing the course. Along with the hands-on report, you’ll complete a self-review and course summary. You’ll also gain valuable insights into what you can expect once you’ve completed the course.
涵盖的内容
2个视频6篇阅读材料2个作业1个插件
获得职业证书
将此证书添加到您的 LinkedIn 个人资料、简历或履历中。在社交媒体和绩效考核中分享。
人们为什么选择 Coursera 来帮助自己实现职业发展

Felipe M.

Jennifer J.

Larry W.

Chaitanya A.
学生评论
- 5 stars
81.81%
- 4 stars
18.18%
- 3 stars
0%
- 2 stars
0%
- 1 star
0%
显示 3/11 个
已于 Sep 23, 2025审阅
Great overall. Need to update one assignment for forcing the wrong answer






