Excel, data and checking numbers

When you finish, you can use Copilot to explain and build spreadsheet work while checking the math yourself.

What spreadsheet help looks like

Where Copilot is available in Excel, it can suggest formulas, explain what a formula does, highlight patterns, make a simple chart or summarize a table. Your data usually needs to be organized, for example as a table with clear column headings. Features change with version and license.

Clean data helps. Give each column a plain heading. Avoid merged cells and mixed types in one column. Then ask a specific question: "Which month had the highest total and by how much?"

Ask for explanations, not just answers

Weak: "Fix my sheet." Strong: "Column B has dates and column C has amounts. Show me a formula that totals amounts for each month, and explain it in plain words so I can check it." You learn something, and you can spot a wrong formula.

Worked example: a shop owner in Ghana asks, "Which three products had falling sales over the last four months?" Copilot lists them. She checks the figures against her sales table for those products and finds they match. Then she asks what might explain it and uses her own knowledge to judge.

Check the numbers

AI can pick the wrong range, misread a header or round in an unexpected way. Test totals on a small sample that you can add by hand. Look at the first and last rows. Ask Copilot to show which cells it used.

Keep a copy of the original data before you change anything. If a calculation affects money, grades, health or legal results, have a second person review it and follow your organization's rules.

Privacy in spreadsheets

Spreadsheets often hold personal data: names, salaries, addresses and case numbers. Use only the tool your organization has approved for that data. Remove or mask identifying columns when you can.

In regulated fields such as health, finance, education or government, never put patient, client, student or citizen identifying information into a consumer AI tool unless your employer has approved that tool for that data. Follow policy and your regulator's rules.

Practice now

Make a small table of ten rows with made-up data. Ask Copilot, or any assistant, for a formula and an explanation. Test it by hand.
Take a sheet you use and list which columns contain personal data. Decide which tool is allowed for it.

Use any AI assistant you have. Do not paste private, client or patient information into it.

Check yourself

1. Which request is better?

2. How should you test a new formula?

3. What should you do with personal data in a sheet?

Ask the AI tutor

Ask anything about this lesson, in any language. The tutor is an AI: it can be wrong, and it never needs your personal details.

Next lesson: Work data protections and admin controls

AI-drafted. Checked by an automated validator and a separate AI reviewer; a person has not read every lesson. Translations and tutor answers are AI-made. Found a mistake? Tell us. AI can be wrong. General information only, not professional advice. Not affiliated with any AI company named. Current University is not accredited.