All Courses

Every trick.
15 minutes.

4 courses · taught by former Big 4 accountants · no subscriptions, pay once

FormulasNamed RangesDynamic ArraysVBAMacrosMonth-EndPower QueryETLData ShapingLookupsXLOOKUPINDEX/MATCH
FormulasNamed RangesDynamic Arrays

Dynamic Named Ranges with OFFSET

Build self-expanding ranges that automatically capture new data — no more manually adjusting chart sources or pivot ranges every month.

S

Sarah K.

ex-Deloitte

15 min
$29
Buy Now
VBAMacrosMonth-End

Automating Month-End Close with VBA

Write a macro that copies, formats, and timestamps your close checklist — so the 3-day sprint becomes a 3-hour sprint.

J

James R.

ex-PwC

15 min
$49
Buy Now
Power QueryETLData Shaping

Power Query: Unpivot Like a Pro

Turn awkward crosstab exports from your ERP into clean, analysis-ready tables — without touching a formula or writing SQL.

A

Amy T.

ex-KPMG

15 min
$29
Buy Now
LookupsXLOOKUPINDEX/MATCH

Error-Proof VLOOKUP Replacements

Retire fragile VLOOKUP and embrace INDEX/MATCH and XLOOKUP — lookups that won't break when columns shift.

D

David M.

ex-EY

15 min
$19
Buy Now

All courses include lifetime access · Instant delivery · No subscription required

Secure checkout via Stripe