AI Expert
Topic

Spreadsheets & Data Work

Clean tables, analyze data, create charts, measure workflows, and structure outputs.

11 stories (4 articles · 7 videos)

Start here

A few good first pieces before you browse the full feed.

8 min read
Article

AI for spreadsheets: cleaning, analyzing, and charting data

A practical guide to using AI to handle spreadsheets — cleaning messy data, writing formulas, building pivot tables, and turning rows of numbers into clear answers. Works in Excel, Google Sheets, or via ChatGPT directly.

Turn the workflow into a small practical experiment with a clear quality check.

Beginner
10 min read
Article

Evals for non-engineers: know if your AI workflow is getting better or worse

Evals — systematic measurement of AI output quality — are usually treated as an engineering concern. But every team running AI workflows needs them, and the basics are accessible without code. The how-to.

Measure whether an AI workflow is improving by using examples, rubrics, and regression checks.

Intermediate

More in this topic

59 minutes
Video

From Hype to Habit: How Tech Companies Are Scaling AI Beyond the Experimental

Propeller Consulting. Discusses governance, operating discipline, workforce adoption and ROI measurement as connected parts of scaling AI beyond experiments. That fits the article's maturity model because adoption is treated as changed work with owners and metrics, not as tool usage or workshop attendance.
Advanced
9 min read
Article

AI ROI and maturity: how to measure adoption that actually works

AI adoption should not be measured by how many people tried ChatGPT. A practical framework for measuring workflow ROI, quality, risk, maturity, and scale-readiness.

Measure AI adoption using workflow ROI, quality, risk controls, and maturity levels instead of tool usage vanity metrics.

Advanced
13 min read
Article

Structured outputs and function calling: the production patterns

Structured outputs and function calling are the bridge from 'LLM that generates text' to 'system that does work'. In production, the patterns that matter are about schemas, error handling, idempotency, and graceful degradation — not just JSON mode.

Evaluate the implementation pattern, failure modes, and guardrails before building.

Advanced
41 minutes
Video

OpenAI DevDay 2024 | Structured outputs for reliable applications

OpenAI. Walks through `strict: true`, the difference from old JSON mode, refusal handling, and how function calling and response-format schemas compose. Useful precisely because it describes the contract the API gives you, which is what the article's production patterns are built on top of.
Advanced
18 minutes
Video

Pydantic is all you need: Jason Liu

AI Engineer. The talk that crystallised the modern "define a Pydantic model, hand it to the LLM, let validation do the rest" pattern, with concrete examples of nested objects, validators that catch hallucinated URLs, and Chain-of-Thought as a typed field. Watch it before re-reading the article's section on validators and you will recognise where its retry and refusal rules come from.
Advanced
3 minutes
Video

Evaluate prompts in the Anthropic Console

Anthropic. A three-minute Anthropic walkthrough of running a real eval inside the Workbench — auto-generating realistic test cases, grading outputs, tweaking the prompt, and re-running the same suite side-by-side. The view count sits below the usual bar, but for "how do I actually do this without writing code" this is the cleanest official demo and slots neatly under the more strategic Husain/Shankar conversation.
Intermediate
107 minutes
Video

Why AI evals are the hottest new skill for product builders | Hamel Husain & Shreya Shankar

Lenny's Podcast. Hamel Husain and Shreya Shankar walk through the entire eval workflow on a real property-management AI assistant — looking at traces, open and axial coding of errors, deciding when to stop, building an LLM-as-judge, and validating it against human judgment. This is the rare long-form conversation that is genuinely aimed at PMs and team leads rather than ML engineers, and it covers the same "30 minutes a week after setup" rhythm the article recommends.
Intermediate
18 minutes
Video

How to Improve Your Excel Skills with ChatGPT

Leila Gharani. Older (early 2023) but still the cleanest worked example of pasting a real Excel question into ChatGPT, getting a SUMPRODUCT-or-conditional-formatting answer back, and then iterating with the model when the first formula doesn't quite fit. The model has improved a lot; the prompting workflow she shows is the same one you'll use today.
Beginner
12 minutes
Video

Excel's New AI Function is Absolutely Insane (Copilot Function)

Leila Gharani. Live demo of the new `=COPILOT()` function on the kinds of messy real data the article describes — shift handover notes turned into a structured action table, free-text reviews tagged for sentiment, and inconsistent job titles normalized against a master list. Also calls out the limits clearly: don't use it for anything that has to be exact, freeze results as values when you're done.
Beginner