RootWright

Excel for Small Business: Automate Your Books and Build a Cash-Flow Tracker

Excel for Small Business: Automate Your Books and Build a Cash-Flow Tracker

Replace your manual ledgers with Excel: record transactions, automate totals with formulas and lookups, summarise with pivot tables, and finish by building a working monthly cash-flow sheet.

Rafi Ahmed Category One Intermediate 5.0 out of 5, 1 review 22 lessons

About This Course

If you run a small business and track money by hand, this course turns Excel into your bookkeeping and forecasting engine. You’ll set up a clean, structured transaction register, then let formulas do the adding, matching and reporting for you.

Along the way you’ll learn the Excel features that matter most for business: essential formulas, VLOOKUP and XLOOKUP for matching invoices and customers, pivot tables for instant summaries, and charts that make trends obvious at a glance.

By the end you’ll build a complete monthly cash-flow sheet — opening balance, inflows, outflows and closing balance — that updates itself as you log transactions. No accounting background needed; just a spreadsheet and your own numbers.

Curriculum

5 topics · 22 lessons

Setting Up a Business Workbook That Works 4 lessons
  • Why Excel Beats Your Paper LedgerText
  • Building a Clean Transaction RegisterText
  • Excel Tables, Data Validation and Dates Done RightText
  • Check Your Workbook SetupQuiz
Formulas That Do the Bookkeeping For You 4 lessons
  • SUM, SUMIF and Counting What MattersText
  • Monthly Totals with SUMIFS and Date RangesText
  • Auto-Updating Running BalanceText
  • Formulas Check: Does Your Register Balance?Quiz
Lookups: Match Customers, Invoices and Prices Automatically 5 lessons
  • Build Reference Sheets for Customers and PricesText
  • VLOOKUP: From ID to Name and Price in One StepText
  • XLOOKUP: The Modern, Error-Proof WayText
  • Flag Who Still Owes You MoneyText
  • Knowledge checkQuiz
Pivot Tables: Instant Business Reports 4 lessons
  • Your First Pivot Table: Expenses by CategoryText
  • Slicing by Month and CustomerText
  • Profit Pivot: Income vs Expenses Side by SideText
  • Pivot Tables Check-UpQuiz
Build Your Monthly Cash-Flow Sheet 5 lessons
  • Charts That Show Where the Money GoesText
  • Assembling the Cash-Flow SheetText
  • Forecast Next Month and Spot a Cash GapText
  • Assignment: Submit Your Working Cash-Flow WorkbookAssignment
  • Knowledge checkQuiz

Get this course in a bundle

Student reviews

5.0 5.0 out of 5 1 review
  • nasir 5.0 out of 5

    A great course for anyone wants to learn excel!

    I enrolled into this course to get more idea on excel how it work and so far I am finding it very helpful.