This video explains one approach to organizing and presenting data in Excel. For this example we use sales data recorded at a small bike shop. 

In this video, we use the Excel function Solver to solve a short-term production problem.