Copilot in Excel: Supercharge Your Productivity
18mGeneral2026-06-17
Authors

Jon Acampora
Course details
Imagine creating sophisticated Excel spreadsheets and charts using nothing more than a simple chat prompt. With Microsoft 365 Copilot, which brings the power of large language models (LLMs) to your favorite productivity apps, this can be your reality today. Excel expert Jon Acampora (Excel Campus) shows you how to maximize Copilot in Excel beyond basic automation. This course focuses on strategic applications that transform your workflow. Learn when to use Copilot versus traditional methods, how to combine Copilot with your Excel expertise for complex analysis, and techniques for validating and refining AI-generated results. Discover the latest Copilot features and develop practical skills that make you more efficient, not just dependent on AI.
Learning objectives
Perform common Excel tasks (including sorting, filtering, and formatting) with chat prompts.
Get answers about your data using natural language queries.
Create charts, PivotCharts, and PivotTables using Copilot.
Clean messy data with the COPILOT function.
Discover quick data insights and perform advanced analysis with Python.
Learning objectives
Perform common Excel tasks (including sorting, filtering, and formatting) with chat prompts.
Get answers about your data using natural language queries.
Create charts, PivotCharts, and PivotTables using Copilot.
Clean messy data with the COPILOT function.
Discover quick data insights and perform advanced analysis with Python.
Concepts
Introduction
- Increase productivity with Copilot in Excel
- How to use and navigate Copilot in Excel
Copilot in Excel
- Write and explain Excel formulas
- Results will vary
- Highlight data automatically with conditional formatting
- Summary reports with charts and pivot tables
- Quick data insights and advanced analysis
- Clean data with the COPILOT function
- Agent Mode - The future of copilot in Excel