Inventory and Sales Management in Excel
A file to track items, movements, balances and sales, with reports and reorder alerts.
Course contents
- 1The item card
- 2Receipts and issues
- 3Stock balances and reorder levels
- 4Sales invoices
- 5Sales and profit reports
What you gain from the course
You can track stock and sales from one file and see what to reorder and what makes money.
Other courses in the same track
Practical applications
Building a Complete Accounting System in Excel
Building a system that starts with the chart of accounts and journal and ends with the trial balance and financial statements.
30 training hours
Payroll and Attendance Sheets in Excel
Designing an attendance file and a payroll sheet that calculates entitlements and deductions.
18 training hours