Copilot in Excel Tutorial: Prompts for Data Analysis, Formulas, and Reports

Kingy AI Microsoft Copilot Tutorial

Copilot in Excel Tutorial: Analyze Data, Build Formulas, and Create Better Reports

A practical guide for using Copilot in Excel without turning your workbook into a guessing game. Learn how to prepare data, ask better questions, inspect formulas, summarize trends, and verify outputs.

Start the Excel path in the Copilot course
Open the Copilot Prompt Library
Download 100 Copilot prompts

Feature availability note: Microsoft Copilot feature availability can depend on license, account type, region, tenant settings, app version, admin settings, and rollout status. Verify features in your own Microsoft environment before promising a workflow to a team or client.

What this is Use cases Workflow Prompts Related Kingy AI resources FAQ

What this guide is for

Copilot in Excel works best when your workbook is clean, saved where Copilot can access it, and organized as structured data with clear headers. Your prompts should say what you want to analyze, which table or columns matter, what output format you need, and how you will verify the answer. Treat every number, formula, and chart recommendation as a draft until checked.

Availability context: Microsoft Support notes that Copilot in Excel experiences can depend on eligible subscriptions and that Copilot in Excel works with supported workbook types saved to OneDrive or SharePoint with AutoSave on. Some newer Excel capabilities may also be limited by program, platform, license, or rollout status.

How this fits into the Microsoft Copilot hub: This Excel page is a focused companion to the full course. Keep the prompt library nearby for extra data and verification prompts, use the business guide when spreadsheet work becomes a team process, and use the meetings and email page when reports come from meeting follow-up.

Practical use cases

Data readiness checks

Find missing values, duplicate rows, inconsistent labels, unclear headers, and fields that should be split or standardized.

Formula help

Ask for formula options, explanations, edge cases, and safer ways to calculate metrics.

Trend summaries

Summarize revenue, pipeline, support, campaign, or operations data into plain-English insights.

Pivot and chart planning

Ask which pivot tables, segments, or visuals would best answer a business question.

Finance reviews

Check budget variance, forecast assumptions, outliers, and questions to ask before presenting the workbook.

Executive reporting

Turn analysis into a short briefing with caveats, charts to include, and claims to verify.

A safer Excel Copilot workflow

Prepare the workbook

Use supported file types, save to OneDrive or SharePoint, turn on AutoSave, and format data as clear tables where possible.
Ask a narrow question

Reference the table, columns, date range, metric, segment, and output format you want.
Request explanation

Ask Copilot to explain formulas, assumptions, and why it chose a chart or summary.
Verify the math

Spot-check totals, formulas, outliers, filters, and any generated narrative before sharing.
Convert to business output

Turn the verified analysis into an email, Word brief, PowerPoint outline, or dashboard plan.

Copy/paste prompt examples

Use these as starting points. Replace bracketed or implied context with your real source material, audience, constraints, and review process.

Beginner
Works best with: Excel

Excel data readiness audit

Best for: cleaning a workbook before analysis

Inspect this workbook or table for issues that could weaken analysis. Check for missing headers, blank rows, inconsistent labels, duplicate records, odd date formats, non-numeric values in numeric columns, and columns that need clearer names. Return a table with issue, location, why it matters, suggested fix, and whether the fix should be reviewed by a human.

How to customize: Name the sheet, table, and columns that matter most. Add any business rules for valid dates, regions, products, or statuses.

Feature/license note: Copilot in Excel may require supported file types and files saved to OneDrive or SharePoint with AutoSave enabled, depending on the experience.

Beginner
Works best with: Excel

Formula explanation and safer alternative

Best for: understanding or improving a formula

Explain this formula in plain English. Then identify possible edge cases, such as blanks, text values, divide-by-zero errors, hidden filters, or mismatched date ranges. Suggest a safer version if needed and explain exactly how to test it.

How to customize: Paste the formula or select the cell, then name what the calculation is supposed to represent.