100% Free · Self-paced · Path Rewritten Accounting Academy

Excel for Accountants

A hands-on Excel path focused on accounting data: formulas, clean datasets, lookups, PivotTables, reconciliations, Power Query and a professional accounting workbook capstone.

12 modulesBeginner to Intermediate

Who this program is for

Accounting students, AP/AR professionals, bookkeepers, Staff Accountants and career changers who need practical Excel fluency.

Prerequisites

Basic computer skills. Desktop Excel is recommended for the Power Query module.

What you will learn

  • Build reliable formulas and criteria-based summaries.
  • Use lookups to map accounting data and troubleshoot errors.
  • Create PivotTables and accountant-ready workpapers.
  • Use Power Query for repeatable cleanup and consolidation.
  • Build a reusable monthly accounting analysis workbook.

Course outline

The full instruction, workbooks, practice labs, and knowledge checks are available free through the Path Rewritten learning portal.

  1. Module 1: Workbook Setup, Clean Data & Tables
  2. Module 2: Cell References & Core Math Functions
  3. Module 3: IF Logic, Error Handling & Decision Rules
  4. Module 4: SUMIFS, COUNTIFS & Accountant Summaries
  5. Module 5: Text, Dates & Imported Accounting Data
  6. Module 6: Tables, Filters, Conditional Formatting & Data Validation
  7. Module 7: VLOOKUP & XLOOKUP
  8. Module 8: INDEX-MATCH, Formula Auditing & Debugging
  9. Module 9: PivotTables, PivotCharts & Slicers
  10. Module 10: Reconciliations, Rollforwards & Variance Analysis in Excel
  11. Module 11: Power Query for Repeatable Accounting Work
  12. Module 12: Excel for Accountants Capstone
Independent self-paced learning, not an accredited degree or professional license. Some optional third-party resources may have different access terms.
Enroll for Free →All Programs