This course teaches the Excel skills that matter in a film or TV production office, with AI tools such as Copilot and ChatGPT as your assistants. Learn to clean exports, use Power Query, write lookups and SUMIFS, build cost report summaries and trackers, and automate a weekly report.
WHO IT'S FOR
• Production accountants and assistant accountants
• Production coordinators and office teams
• Production managers and line producers
• Anyone whose job lives in spreadsheets
WHAT YOU'LL LEARN
• How to find and fix the six common kinds of messy data
• How to import and clean weekly exports with Power Query
• How to brief AI to write lookups, totals and filters, and test the result
• How to build cost report summaries that tie to the penny
• How to build crew, PO and petty cash trackers that flag problems
• How to automate a one-page weekly summary
WHAT'S INCLUDED
• 8 video modules (about 75 minutes)
• 5 hands-on exercises with worked answers
• Ledger Practice, Cost Report Builder and Production Trackers workbooks
• 20-formula cheat sheet and an Excel + AI prompt card
• Module summaries, knowledge checks and a final scenario test
• Certificate of completion
Course curriculum
-
-
Course Guide
-
Download: Scenario Workbook
-
-
-
Excel in a Production Office
-
Knowledge Check
-
-
-
Clean Data First
-
Download: Firezone Ledger Practice
-
Download: Excel + A.I Prompt Card
-
Knowledge Check
-
-
-
Power Query for Imports
-
Knowledge Check
-
-
-
Formulas A.I Can Write For You
-
Download: Formula Cheatsheet
-
Knowledge Check
-
-
-
Summaries Without Pivots
-
Download: Firezone Cost Report Builder
-
Knowledge Check
-
About this course
- £49.00
- 26 lessons
- 1 hour of video content
FAQ
-
Do I need Copilot?
No. Every exercise works in any spreadsheet app; the course shows where Copilot, agent mode or chat AI speed things up.
-
Is it for beginners?
You should be comfortable entering a formula. Everything else is taught step by step.
-
Which version of Excel?
Address common questions ahead of time to save yourself an email.
-
Can ChatGPT or Copilot write Excel formulas?
Yes, and they're good at it, but they can be wrong. The course shows how to brief AI clearly, then test every formula against numbers you already know before you rely on it.
-
What is Power Query in Excel?
Power Query is a tool built into Excel that imports and cleans data, such as weekly exports from accounting or payroll systems. You set up the steps once and refresh them each week, instead of tidying the data by hand.
-
Which Excel formulas do production accountants use most?
SUMIFS, XLOOKUP, FILTER and UNIQUE do most of the work: totalling costs by account, matching POs to invoices and pulling lists out of a ledger. The course includes a 20-formula cheat sheet.