Introduction

In today's fast-paced work environment, data-driven decision-making is essential—but not everyone has the time or technical expertise to analyze complex datasets. That's where Microsoft Copilot in Excel and the Analyst agent come in. These AI-powered tools are designed to help you work smarter by transforming raw data into meaningful insights with just a few prompts. Whether you're preparing a performance report, tracking trends, or summarizing key takeaways, these tools can dramatically reduce the time and effort required.

Imagine you're part of a growing retail business, tasked with preparing a quarterly performance report for your team. You need to analyze sales data and identify trends. However, you're short on time and lack advanced technical skills to process the data effectively. With Microsoft Copilot, you can upload your sales data, ask questions, and receive instant visual reports and actionable insights. You can then use Copilot in Word to create a summary report to share with your team.

In this module, you'll use Copilot in Excel to analyze data, generate visual charts, analyze text for themes and sentiments, and build workbooks—all through natural language prompts. You'll then explore the Analyst agent, which takes your analysis further by reasoning across multiple files to surface deeper insights and produce shareable reports. Along the way, you'll learn when to reach for each tool so you can choose the right approach for any data task.

By the end of this module, you're able to:

• Use Copilot in Excel to analyze data, visualize trends, and build workbooks using natural language.
• Access and use the Analyst agent to perform deep data analysis and generate actionable insights.
• Understand how Copilot in Excel, the Analyst agent, and Copilot Chat each serve different data analysis needs.