Productivity and Collaboration Tools: Sales Data Analysis Report

This report provides an analysis of sales data related to productivity and collaboration tools, focusing on quantities sold per person, district, and product. The analysis identifies key performance indicators such as the best and worst-performing salespeople and districts, as well as the products with the highest and lowest sales volumes and profit margins. The report highlights the importance of data sorting and presentation in Excel for effective understanding and evaluation of sales information, emphasizing the use of Excel functions for data manipulation and chart creation to visualize sales performance across different categories.

Productivity and Collaboration Tools for
Learning and Work

Quantities Sold per Person
 From the chart, it can be analysed that Alison
Smith has sold 40 quantities which is minimum
in the quantities sold.
 The maximum quantities of all the products
which has been sold is by Hadyn Jones with 660
quantities.
 The sale quantity by Frederick Walters is 500 in
number.

Quantities Sold per district
 The quantities of the different products that
has been sold is evaluated in the structured
manner.
 The highest quantities sold is from the
Liverpool city which is approx. 700 units
of all the products from A to E.
 The lowest quantities are being sold in
Cardiff district which is around 120 units.

Quantities Sold per product
 The product is being classified in five
different categories such as A, B, C, D
and E respectively and the table shows
the sales made thereof on the basis of
various products.
 The higher sales volume is of product C
which is 1036 units and lowest one is of
product B which is 340 units.

Worst and Maximum Profit
 The maximum profit is incurred for the
product C of 3600, which is more than all
the product.
 The minimum profit incurred is by
product A which is only 800.

Worst and Best performing salesperson
 The worst performing salesperson
is Alison Smith with only 40
quantities sold.
 Also, considering the other
salesperson, the maximum
quantity of product is sold by
Hadyn Jones.

Worst and Best performing district
 The worst performing district in terms
of the quantities sold is for the district
Cardiff with only 120 products sold.
 And the best performing district in
sales of all the products is Liverpool
with 700 quantities sold.

Summary
From the overall tasks performed it can be analysed that sorting the data
and then the presentation of that data is very crucial. It helps in better
understanding of the information that is to be evaluated and filtered. It is
very important for the analyzer to know the importance of the functions
that are used in Excel. In the above presentation, the charts are prepared by
utilizing the formula bars of excel for sorting the data of the quantities sold
per salesperson, district and product.