assignment 4852537 2

Hire our professional essay experts at Gradehunters.net who are available online 24/7 for an essay paper written to a high standard at an affordable cost.


Order a Similar Paper Order a Different Paper

To complete the assignment, perform the following tasks:

  1. Open this Excel workbook and save the worksheet as “FirstInital_LastName_PivotIPA04_.xlsx.”
  2. Highlight the entire data set, and insert a pivot table.
    • For more information on how to create a pivot table, click here.
  3. Create a new worksheet, and sort the pivot table as follows:
    • Move Student level to the Column level.
    • Move the Year will move to Values, changing your values to count instead of sum.
    • Move the Course to Row Label.
  4. Insert a Column chart and expand your chart. Select Chart Layout 3, and also change your chart design style 2.
  5. Add a title “Course Availability” for your table.
  6. Save the worksheet as “Course Availability,” and save your document as “FirstInitial_LastName_PivotIPA04_solution.”
  7. Return to the Data sheet, highlight all the data, and click on Insert a pivot chart.
    • For more information on how to create a pivot chart, click here.
  8. Create a new worksheet, and sort the pivot chart as follows:
    • Filter the Year.
    • Move Courses to Axis Fields.
    • Move the Count of Student to Value.
  9. Change your chart type to columns and choose a style from the design tab. Insert the name “Course Overview” as your title.
  10. Adjust your new chart by expanding it from cells A22 to G48.
  11. Rename the worksheet to “Course Overview.” Submit your Excel spreadsheet.

Reference

Microsoft. (n.d.). Create or delete a PivotTable or PivotChart report. Retrieved from http://office.microsoft.com/en-us/excel-help/create-or-delete-a-pivottable-or-pivotchart-report-HP010342375.aspx?CTT=1#_Toc254687657

"Is this question part of your assignment? We can help"

ORDER NOW
Writerbay.net

Everyone needs a little help with academic work from time to time. Hire the best essay writing professionals working for us today!

Get a 15% discount for your first order


Order a Similar Paper Order a Different Paper