WEEK 01
Matching Fundamentals
Prep: Logical Functions and Lookup Functions
- Recon mindset; single-criteria matching with VLOOKUP or XLOOKUP and IFERROR flagging.
- INDEX + MATCH for multi-criteria lookups and an introduction to two-way matching.
Applied Excel Series | Course 01
Reconciliation with Excel Masterclass
A six-week live program for professionals who reconcile every day. Move from manual matching to a faster, repeatable Excel workflow for bank, vendor, and intercompany reconciliations.
12 live sessions 6 weeks 10 seats per cohort
Taught by Ayodele LawalMeet your instructorReconciliation preview
Find the difference
DescriptionBankBooks
Opening balance1,204,5001,204,500
Vendor payment · 044286,00086,000
Wire transfer · 0451154,200—!
Bank charges2,1502,150
Closing balance1,362,5501,208,350!
One outstanding item flagged. The course teaches you to build this workflow yourself.
Sound familiar?
The reconciliation grind can be replaced with a process.
This course is built around the real work of closing the books, not generic spreadsheet exercises.
01
Every month-end
Hours spent moving between spreadsheets, scanning rows by eye to find the transaction that does not match.
02
Every new dataset
Rebuilding the same lookup formulas because this month's export has different columns or inconsistent data.
03
Every audit
No clear trail from opening balance to closing balance, just a final number and a long list of questions.
Your outcomes
A workflow you can use again next month.
Build practical skills on realistic reconciliation data, then take away tools and methods you can apply to your own work.
- Match transactions across two datasets with a repeatable method.
- Clean inconsistent exports and handle duplicates with confidence.
- Build refreshable Power Query workflows for recurring reconciliations.
- Explain unmatched items with a clear, auditable trail.
Ready to get started?
Build a reconciliation workflow you can use every month.
Enrol in the Masterclass, or chat with us if you have questions first.
Six-week curriculum
From matching basics to full case studies.
Two live two-hour Zoom sessions each weekend: one on Saturday and one on Sunday. Prep videos are assigned where available; other topics are taught live.
WEEK 02
Data Cleaning
Prep: Data Management and Text Functions
- Clean live bank and ledger exports with TRIM, SUBSTITUTE, text-to-columns, and duplicate checks.
- Practice, Test 1 review, and time for cleanup questions.
WEEK 03
SUMIFS & COUNTIFS
Prep: Taught live; no prep video
- Build SUMIFS and COUNTIFS from the ground up around real reconciliation scenarios.
- Create a two-way match workflow for matched, unmatched, and duplicate records; Test 2 assigned.
WEEK 04
Power Query
Prep: Taught live; no prep video
- Import, clean, and correct data types in messy exports with Power Query.
- Merge and append queries; build a reusable monthly reconciliation template; Test 3 assigned.
WEEK 05
SUMPRODUCT & Case Study One
Prep: Date & Time Functions, Conditional Formatting, and Pivot Tables
- Use SUMPRODUCT for multi-criteria matches and near-matches such as timing differences.
- Complete an end-to-end bank reconciliation from opening balance through outstanding items.
WEEK 06
Case Study Two, Dashboard & Wrap-Up
Prep: Taught live; no prep video
- Work through an intercompany or vendor statement reconciliation with a different data structure.
- Build a reconciliation summary dashboard, complete the final assessment, and earn your certificate.
The format
Small cohort. Live practice. Useful feedback.
6 weeks
Live cohort program
12
Two-hour Zoom sessions
10 max
Enrollees per cohort
Weekly
Tests and practice
9 videos
Pre-recorded prep videos for self-paced training
Your instructor
Ayodele Lawal
For over 20 years, Ayodele has applied Microsoft Excel to practical problems in the finance industry, including the reconciliations professionals face every day. This course comes directly from that experience: real reconciliation structures, not generic spreadsheet theory.
Enrollment
Excel Reconciliation MasterClass
- 12 live Zoom sessions across six weeks
- Weekly tests and three assessed practice tests
- Two full end-to-end case studies
- Reusable Power Query template and certificate
- 9 prerecorded prep videos
Ten seats per cohort. Reconcile with confidence by the end of week six.