Stop Guessing Prices! Build an Automated Excel Inventory Sheet 🔥
Emmy The Analyst
0:00 / 0:00
Stop Guessing Prices! Build an Automated Excel Inventory Sheet 🔥
45 просмотров · 10 месяцев назад
Emmy The Analyst
171 подписчик
45 просмотров · 10 месяцев назад
In this tutorial, you’ll learn how to create a Stationery Order Sheet in Excel — step by step! Perfect for beginners, this video covers essential Excel skills used in real business tasks.
You’ll learn how to:
✅ Multiply quantities and unit prices to get Total Cost
✅ Apply VAT (7.5%) using formulas
✅ Add Discounts (10%) to calculate final totals
✅ Use Relative and Absolute Cell References
✅ Apply AutoFill to save time
✅ Use the SUM function for totals
✅ Format your sheet with borders, colors, and alignment for a professional look