My Skill Lab
AccountingBeginner

Excel for Accountants

Reconciliations, schedules, lookups and month-end templates.

Taught by Pooja Adhikari · Chartered Accountant

What you'll learn

  • Structure ledgers and schedules as Excel tables with consistent formats, freeze panes and keyboard shortcuts
  • Summarise transactions by account, period and cost centre using SUMIFS, COUNTIFS and AVERAGEIFS
  • Match records between two lists with XLOOKUP and INDEX/MATCH and isolate unmatched items
  • Build a reusable bank reconciliation template that proves the book balance to the statement
  • Prepare depreciation, prepayment and accrual schedules with date functions that roll forward each month
  • Analyse a general ledger with PivotTables and Power Query and add check cells that flag errors automatically

About this course

Excel is still the tool every accountant opens first, and the difference between a fast, reliable month-end and a late one is usually a handful of functions used well. This beginner course is for bookkeepers, accounting students, trainee accountants and finance administrators who want practical Excel skills built around real accounting work rather than generic spreadsheet tips. You will structure ledgers as tables, summarise them with SUMIFS and COUNTIFS, match data between lists with XLOOKUP and INDEX/MATCH, build a bank reconciliation template, prepare depreciation, prepayment and accrual schedules, analyse a general ledger with PivotTables and Power Query, and add check cells that catch errors before your reviewer does. Everything works in Microsoft 365 and Excel 2021 or later. You should know basic debits and credits; no prior Excel formulas are assumed.

Course content

6 lessons
  1. 1Excel Habits That Keep Accountants Out of TroubleTables, number formats, freeze panes and the shortcuts that make ledger work fast and safe.Preview
  2. 2SUMIFS, COUNTIFS and Summarising a LedgerTotal a ledger by account, period and cost centre with conditional aggregation instead of sorting and subtotalling.
  3. 3XLOOKUP, INDEX/MATCH and Matching Two ListsPull data from one list into another and find what is in one list but not the other.
  4. 4Building a Bank Reconciliation TemplateA reusable workbook that matches the cash book to the statement and explains every difference.
  5. 5Depreciation, Prepayment and Accrual SchedulesDate-driven schedules that calculate each month's charge and roll forward without rebuilding.
  6. 6PivotTables, Power Query and Month-End ChecksAnalyse a general ledger in seconds, automate the import, and add checks that catch errors before review.