Excel spreadsheet | Mathematics homework help


trying to indicate which classes conciliate be offered and how considerefficient longer it conciliate assume you to full your amount. Once you full your pivot tefficient and chart, you conciliate now be efficient to visually see what courses are availefficient and which semester offers the most courses that you conciliate insufficiency to successfully furrow.

To full the assignment, discharge the subjoined tasks:

  1. Open this Excel workbook and prevent the workequivocation as "FirstInital_LastName_PivotIPA04_.xlsx."
  2. Highlight the whole axioms set, and infuse a pivot consideration.
    • For over instruction on how to invent a pivot consideration, click here.
  3. Create a new worksheet, and quality the pivot tefficient as follows:
    • Move Student flatten to the Column flatten.
    • Move the Year conciliate propel to Values, changing your values to estimate instead of sum.
    • Move the Course to Row Label.
  4. Insert a Column chart and extend your chart. Select Chart Layout 3, and to-boot veer your chart scheme designate 2.
  5. Add a inscription “Course Availability” for your consideration.
  6. Save the workequivocation as “Course Availability,” and prevent your instrument as "FirstInitial_LastName_PivotIPA04_solution."
  7. Return to the Axioms equivocation, highlight all the axioms, and click on Infuse a pivot chart.
    • For over instruction on how to invent a pivot chart, click here.
  8. Create a new worksheet, and quality the pivot chart as follows:
    • Filter the Year.
    • Move Courses to Axis Fields.
    • Move the Estimate of Student to Value.
  9. Change your chart fashion to columns and select a designate from the scheme tab. Infuse the designate “Course Overview” as your inscription.
  10. Adjust your new chart by extending it from cells A22 to G48.
  11. Redesignate the workequivocation to “Course Overview.” Submit your Excel spreadsheet.