skinny.

Latest / ModeLoop: Financial Modelling in Excel

P3E3: Prompting for Modellers - How to Ask AI for Excel Formulas That Actually Work

AI prompts for Excel formulas only work when the AI knows your model: the layout, the sign convention, the timing and the Excel version. This lecture gives you a five-part prompt that turns Claude, ChatGPT or Copilot into a fast junior analyst on project finance, M&A and FP&A models.

In this episode:

Why vague prompts fail: invented cell references, sign conventions, timing, Excel version, edge cases

The five-part modeller's prompt: context, layout, conventions, constraints and a test case

Before and after: a senior debt interest formula with Actual/365 and an operations flag

What AI usually…

Log in to save or queue this episode.

The skinny

The skinny isn't ready yet — notes appear once the transcript is processed.