Free testing period: everything is free while we test. Try it out and tell us what you think.
Accounting Practicals

Excel for Accountants: Zero to Hero (Practical Workshop)

From your first cell to everyday jobs, budgets, reconciliations and pivot reports - hands-on, step by step.

New (0 ratings) 2 students Beginner English

Created by JMatrix Learn

About this course

A practical, follow-along workshop for accountants and accounting students who have never used Excel, or who use it but do not trust it. Every lesson is a hands-on exercise: you type small sample data, build the formula yourself, and compare your answer with the result stated in the lesson. You build the sheets people really use at work: a shop cash book, a stock tracker, a staff pay sheet, a school fees tracker, a budget with variances, a bank reconciliation, an aged-debtors report and a pivot report with charts. Advanced finance topics are left out on purpose; they have their own separate course for people who are already comfortable with Excel.

What you'll learn

Navigate Excel confidently with keyboard shortcuts and keep clean, professional workbooks
Write correct formulas using relative and absolute references, and use SUMIFS, IF, text and date functions
Look up data with VLOOKUP, XLOOKUP and INDEX+MATCH and know which to choose
Build PivotTables and charts that summarise thousands of rows in seconds
Keep a shop cash book and stock sheet, a staff pay sheet with overtime and deductions, and a school or club fees tracker
Clean messy bank and ledger exports using formulas and Power Query
Build a budget, a bank reconciliation and an aged-debtors report, each with a check that proves it is right
Audit, protect and document workbooks, and use AI assistants (like Copilot) safely

Curriculum

  • The Excel Screen: Workbook, Sheet and Cell Preview 25 min
  • Moving Fast: Navigation and Essential Shortcuts 25 min
  • File Hygiene: Habits That Prevent Costly Errors 25 min
  • Practical Lab - Set Up a Clean Petty Cash Workbook 30 min
  • Module 1: Getting Around Excel & Good Habits — Quiz 10 min
  • Build and submit your own Petty Cash workbook

  • Entering Data and Number Formats 25 min
  • Your First Formulas: Operators, Order and Basic Functions 25 min
  • Relative, Absolute and Mixed References 30 min
  • Practical Lab - Build a VAT Invoice 30 min
  • Module 2: Entering Data, Number Formats & Core Formulas — Quiz 10 min
  • VAT invoice with a single rate input

  • Decisions with IF, IFS, AND and OR 30 min
  • Totals with Conditions: SUMIFS, COUNTIFS and AVERAGEIFS 30 min
  • Rounding, Text and Date Functions 30 min
  • Practical Lab - Analyse a Sales Ledger 35 min
  • Module 3: Functions Every Accountant Needs — Quiz 10 min
  • Regional sales analysis workbook

  • VLOOKUP: Exact and Approximate Match 30 min
  • XLOOKUP: The Modern Replacement (Excel 365 and 2021) 30 min
  • INDEX + MATCH and How to Choose 30 min
  • Practical Lab - Price Orders and Calculate Commission 35 min
  • Module 4: Lookups - VLOOKUP, XLOOKUP and INDEX+MATCH — Quiz 10 min
  • Order pricing and commission workbook

  • Excel Tables, Sorting and Filtering 30 min
  • Data Validation: Stopping Bad Data at the Door 25 min
  • Conditional Formatting: Let the Data Highlight Itself 25 min
  • Practical Lab - Build a Controlled Expense Tracker 35 min
  • Module 5: Tables, Sorting, Filtering, Data Validation & Conditional Formatting — Quiz 10 min
  • Controlled expense tracker

  • PivotTables: Summarise Thousands of Rows in Seconds 30 min
  • Charts That Tell the Truth 25 min
  • Practical Lab - Monthly Sales and Margin Report 35 min
  • Module 6: PivotTables & Charts — Quiz 10 min
  • One-page pivot report

  • A Shop's Daily Cash Book 35 min
  • A Stock Tracker: In, Out, Balance and Reorder Alerts 35 min
  • Practical Lab - Run a Small Shop for a Month 40 min
  • Module 7: Everyday Jobs I - Shop Cash Book & Stock Control — Quiz 10 min
  • My shop's cash book and stock sheet

  • Staff Pay and Attendance: Salary, Overtime and Deductions 40 min
  • A School or Club Fees Tracker: Who Has Paid, Who Owes 40 min
  • Practical Lab - A Payslip and a Fees Statement 40 min
  • Module 8: Everyday Jobs II - Staff Pay & School Fees Tracker — Quiz 10 min
  • Pay sheet and fees tracker for my own setting

  • Cleaning Data with Formulas and Built-in Tools 30 min
  • Power Query: Clean Once, Refresh Forever 30 min
  • Practical Lab - Clean and Reconcile a Messy Bank Export 35 min
  • Module 9: Cleaning Data & Power Query Basics — Quiz 10 min
  • Clean a messy export two ways

  • A Budget vs Actual Report with Variances 30 min
  • Bank Reconciliation and Aged Debtors 30 min
  • Practical Lab - The Month-End Pack 45 min
  • Module 10: Building Real Workbooks - Budget, Reconciliation & Debtors — Quiz 10 min
  • Month-end pack with proof checks

  • Auditing Formulas and Understanding Error Values 30 min
  • Named Ranges and Protecting Your Work 30 min
  • Macros, Automation and Using AI Safely with Excel 30 min
  • Practical Lab - Audit and Fix a Broken Workbook 40 min
  • Module 11: Auditing, Protecting & Automating Your Workbooks — Quiz 10 min
  • Audit, fix and protect a broken workbook

Requirements

  • A computer with Microsoft Excel (365, 2021, 2019 or 2016 - the lessons say where versions differ)
  • No Excel experience needed - we start from the screen layout
  • Basic accounting vocabulary (debit, credit, budget, depreciation) is helpful but explained as we go
  • A notebook for jotting shortcuts and a willingness to type every example yourself
Also available in a bundle
Practical Accounting Skills
View bundle

Student reviews

New (0)

Related courses

Accounting Practicals
FREE
Live classes for this course Ask the tutor for a live class
  • Full lifetime access
  • Access on mobile and desktop
  • Learn by doing: written lessons, quizzes and hands-on practice (video lessons coming soon)
  • Instructor Q&A on every lesson
Feedback