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
1,627 人已注册
包含在 中
您将学到什么
Learn to manipulate and analyze data with Copilot.
Generate insights and create visualizations in Excel.
Summarize information and automate tasks using AI tools.
您将获得的技能
- Trend Analysis
- Predictive Analytics
- Data Synthesis
- Data Analysis
- Report Writing
- Excel Formulas
- Microsoft Excel
- Microsoft Copilot
- Spreadsheet Software
- Data-Driven Decision-Making
- Dashboard
- Data Storytelling
- Data Manipulation
- Data Visualization Software
- Forecasting
- Data Presentation
- Prompt Engineering
- Data Transformation
- Predictive Modeling
- Data Cleansing
要了解的详细信息

添加到您的领英档案
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个作业1个插件
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 个人资料、简历或履历中。在社交媒体和绩效考核中分享。
从 Business Essentials 浏览更多内容
- 状态:预览
Maven Analytics
- 状态:免费试用
Coursera Project Network
- 状态:免费试用
Macquarie University
人们为什么选择 Coursera 来帮助自己实现职业发展




常见问题
This course is part of a professional certification program designed for anyone looking to learn how to use Copilot within Excel to work more efficiently. It’s suitable for professionals across various fields who want to boost their productivity with AI-powered tools in Excel. Whether you're new to Excel or already using it, this course will help you streamline tasks, analyze data, and visualize information more effectively with Copilot.
Basic proficiency in Microsoft 365 applications such as Word, Excel, PowerPoint, Outlook, and Teams is required. It is necessary to have access to Microsoft 365 with Copilot enabled, although no prior experience with Copilot is needed.
This program, designed by industry experts, helps individuals who regularly use Microsoft 365 applications in their work boost productivity with AI-assisted tools like Copilot. Ideal for office workers, managers, knowledge workers, project managers, business analysts, and content creators, it equips you with the skills to streamline workflows, enhance document creation, and improve collaboration across various industries. Upon completion, you will earn a professional certificate that demonstrates your expertise and boosts your career potential.
更多问题
提供助学金,