TaskbyTask.Practical AI guides for work

Practical AI guides

Spreadsheets & data.

Spreadsheets, CSVs, formulas and dashboards with answers you can check.

27 articles
Transferable AI skills

Ask AI to build a small offline dashboard from a CSV

Turn a monthly CSV export into a one-file dashboard colleagues can filter without a spreadsheet, then check its row count and totals against the file.

Spreadsheets & data7 min read + practice9 October 2026
Transferable AI skills

Ask AI who's free from a rota without inventing cover

Ask AI who is available from a spreadsheet rota, keep blank cells as unknown, and check overlaps and end times before you rely on the answer.

Spreadsheets & data6 min read + practice9 October 2026
Transferable AI skills

Give AI a data dictionary before it combines your files

Before ChatGPT, Claude, Copilot or Gemini joins two files, confirm what the key columns mean, then check the row count so a duplicate doesn't double your total.

Spreadsheets & data6 min read + practice9 October 2026
ChatGPT or Claude, with Excel or Google Sheets

Make AI account for overlapping segments in a chart

Tell AI which groups overlap, keep the real denominator and catch the pie chart that counts the same people twice.

Spreadsheets & data7 min read + practice9 October 2026
Power BI Copilot or Tableau Pulse

Ask a BI question and check what the answer measured

Ask Power BI Copilot or Tableau Pulse one question, then check the measure, filters and dates it used before you quote the number.

Spreadsheets & data14 min read + practice7 October 2026
Transferable AI skills

Turn a dashboard into a short decision note

Draft a six-sentence note from checked dashboard figures, keeping causes, requests and completed actions separate.

Spreadsheets & data15 min read + practice7 October 2026
Transferable AI skills

Turn an audit request list into a checked tracker

Split the auditor's request list into one row per deliverable, add owners and a definition of done yourself, and send the unclear items back as questions before anyone starts searching.

Spreadsheets & data13 min read + practice7 October 2026
Gemini in Google Sheets

Use Gemini in Sheets to build and check a small table

Ask Gemini in Google Sheets for a total that says Incomplete while a value is missing, then check the formula still works when the table grows.

Spreadsheets & data12 min read + practice7 October 2026
Transferable AI skills

Write a metric definition your team can check

Use AI to list every decision two rival numbers disagree on, have the owner settle each one, then try to break the one-page definition before you publish it.

Spreadsheets & data15 min read + practice7 October 2026
ChatGPT

Find the useful themes in survey comments

Upload survey comments, ask ChatGPT for themes with counts and examples, then check the comments and the denominator behind each finding.

Spreadsheets & data14 min read + practice4 October 2026
ChatGPT

Get ChatGPT to write your spreadsheet formula

Describe the calculation in ordinary words, put the candidate formula in a copy of your sheet and test it on rows whose answers you already know.

Spreadsheets & data13 min read + practice4 October 2026
ChatGPT

Use ChatGPT to compare supplier quotes

Upload the quotes, say what you need and get a like-for-like comparison that accounts for pack minimums, missing costs and delivery dates.

Spreadsheets & data12 min read + practice4 October 2026

Optional analytics

With your permission, Google Analytics uses cookies to measure visits and which guides people read. It stays off until you accept. Use Analytics choices in the footer to change your choice. Rejecting after accepting refreshes this page. Privacy details.