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.
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
Curriculum
50 lessons · 1340 minutes total
- 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
Student reviews
New (0)No reviews yet — be the first to share your experience.
Related courses
- 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