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.

Cultivate your career with expert-led programs, job-ready certificates, and 10,000 ways to grow. All for $25/month, billed annually. Save now


Data Analysis and Visualization with Copilot in Excel
This course is part of Microsoft 365 Copilot for Productivity Specialization

Instructor: Microsoft
Included with
Recommended experience
What you'll learn
Learn to manipulate and analyze data with Copilot.
Generate insights and create visualizations in Excel.
Summarize information and automate tasks using AI tools.
Details to know

Add to your LinkedIn profile
30 assignments
See how employees at top companies are mastering in-demand skills

Build your subject-matter expertise
- Learn new concepts from industry experts
- Gain a foundational understanding of a subject or tool
- Develop job-relevant skills with hands-on projects
- Earn a shareable career certificate


Earn a career certificate
Add this credential to your LinkedIn profile, resume, or CV
Share it on social media and in your performance review

There are 5 modules in this course
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.
What's included
9 videos17 readings7 assignments
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.
What's included
12 videos10 readings9 assignments
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.
What's included
9 videos3 readings6 assignments1 plugin
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.
What's included
10 videos4 readings6 assignments
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.
What's included
2 videos6 readings2 assignments1 plugin
Recommended if you're interested in Business Essentials
Why people choose Coursera for their career




New to Business Essentials? Start here.

Open new doors with Coursera Plus
Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription
Advance your career with an online degree
Earn a degree from world-class universities - 100% online
Join over 3,400 global companies that choose Coursera for Business
Upskill your employees to excel in the digital economy
Frequently asked questions
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.
More questions
Financial aid available,