Treasury runs on a number that has to be right before nine in the morning. This course teaches you to produce it — and to defend it — using Microsoft 365 Copilot in Excel.

You'll consolidate prior-day statements from several banks, arriving in different formats and currencies, into a single daily cash-position schedule where balance type, value date, and FX rate source are stated rather than assumed. You'll build a thirteen-week direct-method cash-flow model whose collections, payment-timing, and FX drivers sit in toggles a reviewer can move, so liquidity headroom responds visibly rather than being asserted. And you'll interrogate a projection before acting on it — separating a timing gap that closes itself from a structural one that doesn't, then recommending a lever with its cost, lead time, and approval path attached. Practice is hands-on throughout: a three-bank consolidation you defend line by line, a sensitivity model you build and submit for feedback, and a shortfall conversation with a treasurer who wants to know what the draw will cost and whether your week-eight number can be trusted at all. Designed for treasury analysts, cash managers, and finance professionals with working Excel skills who want to compress the mechanical work of liquidity management without losing the traceability the work depends on. By the end of this course, learners will be able to: - Apply Copilot prompts to consolidate multi-bank balance reports into a unified daily cash-position schedule. - Create dynamic short-term cash-flow sensitivity models in Copilot that adjust for variables such as collections delays, payment timing, and FX movements. - Evaluate Copilot-generated liquidity projections to identify impending working-capital constraints and recommend actionable levers (e.g., revolver draw, payment deferral). • Working familiarity with Excel: tables, named ranges, absolute and relative references, basic charting. No macro or Power Query experience assumed. • Access to Microsoft 365 Copilot in Excel, or the ability to follow demonstrations without a licence. All course datasets are supplied. • Practical exposure to a treasury, cash management, or finance operations role — enough to know what a bank statement, an AR ageing, and a payment run are. • No prior forecasting-model build required. Direct-method cash forecasting is taught from first principles.