1 min to read

Excel Sales Tracker

A prompt to accelerate your excel

Featured image

Prompt

Create a sales tracker using an Excel spreadsheet to keep track of all sales, customers, and revenue for a small business.

Example answer

  • Create a spreadsheet with the following columns: Date, Customer Name, Items Sold, Quantity, Unit Cost, Total Cost, Revenue
  • Enter all sales data into the appropriate columns.
  • Add formulas to calculate Total Cost and Revenue (Total Cost = Quantity x Unit Cost; Revenue = Quantity x Unit Cost - Total Cost)
  • Create charts/graphs to display customer-based revenue and overall revenue.
  • Create a summary table that includes total revenue for each customer and an overall total.