Legal & Compliance
Legal and compliance work is full of small calculations with large consequences: a deadline counted one day short, an interest figure on the wrong basis, a risk score nobody can explain. These courses teach clear, checkable spreadsheet methods for those tasks, using illustrative rules so the mechanics stay in focus.
The 6 courses cover deadline and limitation-period calendars, time recording and client trust ledgers, damages, statutory interest and settlement value, compliance risk scoring with heat maps, and KYC risk rating with transaction-monitoring rules. They are written for paralegals, legal operations staff, compliance analysts and lawyers who manage their own numbers.
Legal & ComplianceCompute filing deadlines and limitation dates the way docketing teams do: calendar vs court days, holiday tables, next-court-day roll-forward, extra days for postal service, EDATE limitation periods, tolling, a traffic-light docket and a month calendar, with every cell checked as you go.
Legal & ComplianceBill time at a fictional law firm the careful way: tenth-of-an-hour rounding, task-code cross-tabs, realisation and write-offs, five fee arrangements, banded contingency fees, matter budgets, per-client trust ledgers and a three-way reconciliation, with every cell checked as you go.
Legal & ComplianceQuantify a fictional commercial claim from start to finish: lost profits and mitigation, statutory interest with changing rates, day-count conventions, late-payment interest, future losses in present value, risk-weighted case value and a structured settlement, with every cell checked as you go.
Legal & ComplianceBuild an obligations register with due dates, score risks before and after controls, map them on a 5×5 heat map, check them against risk appetite, run privacy deadlines and a breach clock, age open issues and report key risk indicators to the board – 8 hands-on labs at one fictional distributor, with every cell checked as you go.
Legal & ComplianceScore customers with weighted risk factors, set tiers, due diligence and review dates, run large-cash and structuring rules on transactions, screen names against a fictional watchlist, measure alert outcomes, tune thresholds and staff the case backlog – 8 hands-on labs at one fictional bank, with every cell checked as you go.
Legal & ComplianceEstimate and control a document review: volumes from gigabytes, culling funnels, reviewer staffing, sampling for recall and cost per document, with every cell checked as you go.
No. The courses teach calculation methods with fictional cases and simplified rules. Real deadlines and claims must be checked against the applicable law.
None in particular. Rules are illustrative and labelled as such, so the methods can be adapted to the jurisdiction you work in.
Each course is a single purchase of $9.99. That covers every lesson and lab, the final exam and the certificate, with no subscription and nothing that renews.
Start with the recommended course and build your first result in the lab today.
