Find it on Unjargoned

1. IntermediateAI at work3 min read

   AI for spreadsheets: formulas, tidy data and quick analysis

   Get formulas written and explained, fix errors, tidy messy data and analyse a whole file in minutes. Then check the results, because a wrong number looks just like a right one.

2. AdvancedAI at work3 min read

   Analyse data with AI’s code tools, and check the working

   Let an assistant write and run code on your spreadsheet, then check its working. A workflow for analysis you can trust, and rerun next month.

1. BeginnerSpreadsheets and dataFree

   Write a spreadsheet formula

   Turns what you want a cell to work out into a formula, with an explanation.

2. AdvancedCoding and automationPROPro prompt

   Automate a spreadsheet with a script

   Writes a spreadsheet script, with clear steps to add it and run it safely.

3. IntermediateSpreadsheets and dataFree

   Find what your survey results are saying

   Spots the patterns in survey results and suggests what to look into next.

4. AdvancedSpreadsheets and dataFree

   Analyse a dataset with an assistant that runs code

   Gets an assistant that can run code to explore your data and show its working.

5. BeginnerSpreadsheets and dataPROPro prompt

   Explain a formula someone else wrote

   Breaks down a confusing formula so you can trust it, or fix it.

See all 9 prompts