← Back to the Copilot Adoption Hub

Author: Lukáš Barda · Updated November 2, 2026

Scenarios and prompts from the Copilot in Excel webinar. This isn’t about advanced Excel – we’ll show how to get answers from ordinary spreadsheets in plain language. Copy the prompts and try them on your own data.

Before you start – 3 rules for making Copilot in Excel work:
  • the data must be formatted as a table (Home → Format as Table),
  • the file must be saved on OneDrive or in SharePoint,
  • always check the results – Copilot can make mistakes.

Tip: After pasting, rewrite the text in [square brackets] to fit your file – e.g. with the name of your table or column.

1

Feedback and comments

You have a Microsoft Forms export with 60 responses. Nobody wants to read 60 comments – you need to know quickly what people praise and what they’d improve.

Prompt 1

Analyze the table [table name]. Summarize the main themes of the comments, the strengths and the most common requests for improvement. Don’t make up information that isn’t in the data.

Prompt 2

Sort the comments into meaningful categories and compare the average rating by [column, e.g. channel or department]. Prepare a brief summary for management in five points.

Prompt 3

Prepare a 5-point executive summary. For each point, state which data you’re basing it on.

„I don’t have to read dozens of comments. I have an overview in a minute.“

2

Costs and trends

You get a monthly cost report and need to understand where the money goes, what’s growing and what’s a problem.

Prompt 1

Analyze the table [table name]. Find: – the biggest deviations from the plan, – categories with rising costs, – unusual months. Back up your conclusions with specific values.

Prompt 2

Create a chart suitable for management. Highlight where planned costs were exceeded.

Prompt 3

What questions might management ask me when I present this data?

Copilot doesn’t just summarize the data – it also prepares you for the questions that will come up in the meeting.

3

Checking mandatory training

You need to find out how departments are doing with mandatory training and who should get a reminder. We’re not evaluating employees – we’re checking the administrative status of the training.

Prompt 1

Prepare a summary of training completion by department and type of training.

Prompt 2

Find overdue training. Create an overview of the reminders needed.

Prompt 3

Check the data quality. Find: – missing values, – illogical entries, – potential problems.

„Copilot isn’t just number analysis. It can also check data quality.“

4

Formulas and automation

Every month you get the same export, and over and over you calculate, format and look for problems in it. Copilot explains the formulas and suggests how to automate the work.

Prompt 1

Explain the formulas in the columns: – [column name] – [column name] – [column name] As if I were a beginner.

Prompt 2

Which formulas can be simplified? Explain why.

Prompt 3

Every month I get the same export. Suggest a way to automate: – the calculations, – the formatting, – highlighting [what you want to watch, e.g. low margins].

Prompt 4

Prepare a draft Office Script. First explain the assumptions and the checking steps.

You don’t have to do repeated monthly edits by hand – Copilot suggests an Office Script that does them for you.

Bonus: What else to ask?

Not sure how to continue? Let Copilot advise you:

Prompt

What other questions could be explored with this data?

Frequently asked questions

What do I need for Copilot in Excel to work?

The data must be formatted as a table (Home → Format as Table) and the file must be saved on OneDrive or in SharePoint. Always check the results – Copilot can make mistakes.

Do I need to know formulas to use Copilot in Excel?

No. You ask about the data in plain language, for example „find the biggest deviations from the plan“. Copilot can also explain formulas to you or suggest how to simplify them.

Can Copilot in Excel create a chart?

Yes. Just write who the chart is for and what it should highlight – for example „Create a chart suitable for management and highlight where planned costs were exceeded“.

Can Copilot automate repeated edits in Excel?

It can suggest an automation approach and prepare a draft Office Script that does the calculations, formatting or highlighting for you. Ask it to explain the assumptions and checking steps first.

Lukáš Barda – AI and Microsoft Copilot trainer. He helps companies and their teams bring AI into everyday work in a practical, clear way, without unnecessary jargon. AI and Copilot training