Solve an Excel problem, please!

  • ステータス 完了済み
  • 予算 $10 - $30 CAD
  • Total Bids 16


I have 4 questions for a test on Excel that I need completed right away!


The Vice-President, HR has asked you to do the following:

1) Create a pivot table chart summarizing the number of 2015 ratings by job level and by 2015 ratings on a separate worksheet.

2) Create an employee listing report on a separate worksheet including the following data: employee number, job level, job code, job title, Performance Rating 2014 and Performance Rating 2015. Sort the list by job level in descending order and 2015 rating in ascending order. Ensure this report is in printable format.

3) Create a graph showing year over year ratings (as %) for 2014 and 2015 as compared to the rating guidelines. Include a data table with the graph which shows the percentages below.

4) Create a powerpoint slide that includes the graph of performance ratings and identify trends in the data. Please also note any assumptions used in the preparation of the data.

Files needed to solve are attached.


Looking to make some money?

  • 予算と期限を設定してください
  • Outline your proposal
  • 仕事の報酬を受け取りましょう


    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online