This involves analysis of sales from a past point e.g 1984 to date. this enables a firm or an enterprise to ,with ease make strategic decision like budget making, company financial/ sales/ marketing/production targets, company projections. Sales Analysis is also a data source for all other department in a firm/ company. this is because it summarizes periodic volume sales. With Sales analysis using Excel, one is able to determine 1. Performance of the sales team, 2. Company/firms's market share, 3. Periodic data comparison, e.g week 12 of 2017 and week 12 of 2018. 4. Graphical presentation,pivot table and automated fomulas 5. Automated Dashboard what i will do for you I will : 1. Reformat your sales data and tabulate 2. Create periodic performance gauge (weekly, monthly, quarterly or yearly) 3. Create an automated trend analysis which enables one determine performance. this is done by comparison of previous week, month, year with the current. and also against set targets. 4. market-share - this mainly shows how the company's position in the market. That is , this helps to compile detailed report of the completion's
What the Seller needs to start the work
1. Detailed sales report
2. Specific key areas for the report
3. company's projections and Budget a location.