Workshops: Prompt Engineering
AI for Finance: Prompt Engineering for Finance Teams
This training shows finance and controlling teams how to use AI for analysis, report commentary and spreadsheet work without losing traceability. You will learn where language models can calculate, where they cannot, and how to keep every figure verifiable.
Who is this workshop for?
- Controllers and management accountants
- Accounting and bookkeeping teams
- FP&A, treasury and investor relations
- CFOs and finance leads in mid-sized companies
- Procurement and cost accounting
What you will take away
- You have variance analyses and management commentary drafted from your figures and review them purposefully.
- You build Excel formulas, pivot logic and macros with AI support and understand the result.
- You know when an AI calculates with code execution and when it is merely guessing.
- You summarise contracts, policies and audit reports in a structured way.
- You know the rules for financial data, inside information and business licences.
Agenda
Module 1
Numbers and language models
- Why language models can miscalculate
- Data analysis with code execution in ChatGPT, Claude and Copilot
- Documenting results reproducibly
Module 2
Excel and data preparation
- Generating formulas, conditional logic and pivot analyses
- Copilot in Excel in practice
- Exercise: clean and analyse raw data
Module 3
Reports and commentary
- Variance analyses and monthly commentary
- Management summaries at different depths
Module 4
Documents and research
- Analysing contracts, policies and annual reports
- Researching benchmarks with source checks
Module 5
Control and compliance
- Four-eyes principle for AI output
- Confidential financial data, GDPR and inside information
Why finance needs special prompts
A language model writing freely can swap a number or state a plausible but wrong total. In finance that is unacceptable. The answer is a way of working in which the AI runs calculations as code, shows its working and reconciles results against source data.
We show how to build this into your prompts and how a short verification step becomes routine.
The biggest lever is often not the analysis itself but the communication: explaining variances clearly, tailoring KPIs to different audiences and anticipating questions from management. Here AI saves real time during month-end close, while the professional judgement stays with finance.
Tools for finance teams
We compare the data analysis features of ChatGPT, Claude and Google Gemini with Microsoft 365 Copilot in Excel, complemented by Mistral Le Chat and Perplexity for research.
- Code execution for calculations and charts
- Copilot directly in Excel and PowerPoint
- Document analysis for contracts and reports
Confidentiality of financial data
Unaudited figures, plans and company data are highly sensitive, and listed companies must also observe insider rules. We clarify which data belongs only in approved business environments and which internal rules make sense.
Frequently asked questions
Can I rely on AI calculations?
Only to a degree. When the tool executes code and you check the working, results are far more reliable than pure text answers. A plausibility check is always needed.
Do we need Microsoft 365 Copilot for the training?
No. Copilot in Excel is a focus if you use it; otherwise we work with ChatGPT, Claude or Gemini and their analysis features.
Can the training be tailored to our month-end close?
Yes. Using anonymised sample data from your reporting, we build exercises that fit straight into your closing and reporting process.
Workshop
Get in touch
Want to speed up reporting with AI without losing control?
Tell us a little about your team – we will get back to you within 24 hours with a proposal for content, format and dates.
Prefer to talk?
More workshops
- Workshops: Prompt EngineeringAI for Leaders: Prompt Engineering Workshop for Managers
- Workshops: Prompt EngineeringPrompt Engineering for Teachers, Trainers & Universities
- Workshops: Prompt EngineeringPrompt Engineering for Developers: System Prompts, APIs, Evals
- Workshops: Agentic CodingWorkshop: Turn Your Website into iOS & Android Apps
