My learningമലയാളം പതിപ്പ് (കരട്)
10 minutesGuided projectFree practice

Analyse Excel data with AI

Reconcile fictional sales totals and monthly percentage changes.

What you will be able to do

  • Calculate total, average and percentage changes independently.

Suggested preparation: No previous AI experience required.

Try the task

  1. Import the CSV into Excel. Ask AI for calculations, then verify with SUM, AVERAGE and (new-old)/old. A chart does not explain why sales changed.
  2. Use fictional or permitted inputs. Identify missing information before asking AI to help.
  3. Attempt the task yourself, then use the prompt to compare methods. Keep the source with your working.
  4. Check the result against the worked answer and complete the checkpoint. Correct an error before saving completion.

Fictional practice data

Month,Sales,Cost
January,100000,60000
February,120000,75000
March,90000,55000
Download sample CSVDownload working template

Try this prompt

Analyse this fictional sales CSV. Show total, average and monthly percentage changes with formulas. Suggest one supported observation; do not infer causes.
Refine it in the prompt lab →Ask for a hint →

Your working notes

Check your result

Use only the supplied facts. This checkpoint validates these specific calculations or decisions; it does not certify professional competence.

Worked answer and review criteria

Total ₹310000; average ₹103333.33; February +20%; March −25%. Excel: SUM(B2:B4), AVERAGE(B2:B4), (B3-B2)/B2.

  • Every amount reconciles to the supplied data.
  • Missing facts and unsupported conclusions are identified.
  • The result can be independently reproduced.

Try the checkpoint yourself before relying on this answer.

What to do next

Read the full practical guide →

Understand what AI can and cannot do →

View your learning path →

30-day daily practice plan → · Long-term AI mastery reference →