Excel Assignment

Excel Assignment




  • Task:

  • With the following excel file sales provided on the CIS8008 S1 2012 course study desk produce the four following reports with appropriate accompanying graphs based on a pivot table for each report and briefly comment on each report in about 125 words in terms of what trends and patterns are apparent in each report.
    The sales.xlsx file contains the following dimensions and information:
    1. Region
    2. Product
    3. Customers
    4. Salesperson
    5. Sales by month
    A) Create a report and accompanying graph using a pivot table that lists product by region in order of the top selling product for the year 2008 and comment on key trends and patterns in this report (125 words approx)

  • 12
    B) Create a report and accompanying graph using a pivot table that lists by region in order of the top performing sales person for the year 2009 and comment on key trends and patterns in this report (125 words approx)
    C) Create a report and accompanying graph using a pivot table that lists by product in the order of the top customer for years 2008 and 2009 and comment on key trends and patterns in this report (125 words approx)
    D) Create a report and accompanying graph using a pivot table that lists the top five selling products by region and by sales person and comment on key trends and patterns in this report (125 words approx)
    Your assignment 2 report must be structured as follows, which is similar to the report
    structure detailed in Summers & Smith 2010:
    1. Cover page for assignment 2 report
    2. Introduction (250 words)
    3. Body of report – main sections and subsections for assignment 2 task and sub tasks so Task 1 will be a main heading with appropriate sub headings etc….for each sub task etc..
    4. Conclusion (250 words)
    5. List of References

  • Download Data file : GBI-sales

  • Solution : Please click here

  • If you need assignment help in other subjects as well then visit http://www.assignmenthelpsite.com/

  • For Law assignment help visit : http://www.lawassignmenthelp.com/

  • Get Assignment help for this assignment at hndassignmenthelp@gmail.com  

  •  


Comments