Solve an Excel problem, please!

  • Estado Completado
  • Presupuesto $10 - $30 CAD
  • Total de ofertas 16

Descripción del proyecto

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

Instructions:

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.

Obtén cotizaciones gratis para un proyecto como este
Completado por:
Habilidades necesarias

¿Buscas ganar algo de dinero?

  • Fija tu plazo y presupuesto
  • Describe tu propuesta
  • Recibes pagos por tu trabajo

Contrata Freelancers que también oferten en este proyecto

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