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…
The skinny
The skinny isn't ready yet — notes appear once the transcript is processed.