Learning outcomes
- Explain how to describe a data question and required checks.
- Complete the guided activity safely.
- Check that you can confirm the result against source rows.
Files, Images and Data
Working with Spreadsheets
Learn to describe a data question and required checks and confirm the result against source rows in this beginner-friendly ChatGPT lesson.
Before you begin
Use non-sensitive sample files. Confirm you have permission to upload, analyse, transform or share every file and image.
Step-by-step instructions
- Open a chat where file or image upload is available on your account and confirm you are using the intended account or workspace.
- Analyse a fictional CSV for totals and missing values.
- Pause and check privacy, permissions, source material, feature availability and any instruction that affects the task.
- Review the result carefully and confirm that you can confirm the result against source rows.
- Save only the useful, verified output and record one improvement for your next prompt.
Ian's practical tip: Start with fictional or non-sensitive information. Treat the first response as a draft, then verify facts, sources, calculations and permissions before using it.
Practical activity
Analyse a fictional CSV for totals and missing values. Your expected result is to confirm the result against source rows.