Billing System in Excel: Build an Invoice System Step by Step (No VBA)
Typing every invoice by hand costs time, and one wrong price costs money. In this tutorial you build a complete billing system in Excel with formulas only - no VBA,
Blogs
Stationery Stores Dashboard in Excel
Stationery Stores Dashboard in Excel is a five-page workbook that shows where a stationery business makes its sales and profit across stores, product categories and customer segments. The overview of
General Store Billing Management System in Excel VBA
The General Store Billing Management System is a macro-enabled Excel workbook that runs a general store from one file: counter billing, customer charge accounts, supplier purchases, stock, expenses and profit.
Sporting Goods Dashboard in Power BI
Running a sporting goods store means watching many moving parts at once: bikes and fitness equipment that sell at high prices, footwear and apparel that sell in volume, online orders
Power BI Dashboard Design: Make Your Report Look Like an App (5 Moves)
Your Power BI dashboard design can be correct and still nobody opens it. In this tutorial we take a plain Trailhead Outfitters sales report - $1.98M in sales for January
Customer Payment Reminder Tool in Excel VBA
The Customer Payment Reminder Tool in Excel VBA reads your open invoices, groups them by customer and creates one statement email per customer in Microsoft Outlook. It escalates across 4
How to Make a Production Tracker in Excel (Free Template)
This tutorial shows you how to build a production tracker Excel workbook from a blank file in 32 steps: a shift-wise Production Log, 5 KPI cards (Target Qty, Actual Qty,
Cash Flow Analysis Pack
A business can show a healthy profit and still run out of cash. The Cash Flow Analysis Pack shows where the money goes and when the bank balance will dip,
Plant Production Planning and Control Management System in Excel VBA
The Plant Production Planning and Control Management System is a macro-enabled Excel workbook that runs a manufacturing plant from one file: 22 worksheets, 13 VBA entry forms, 5 pivot dashboards,
Excel Form Controls: Combo Box, Spin Button and Option Buttons (3 Real Business Examples)
Excel form controls turn a static sheet into an interactive tool that anyone can use with a click. In this tutorial we solve three real business problems with the three