Create a new worksheet and sort the pivot table

Assignment Help Business Management
Reference no: EM13992772

In project, you will determine what core courses that are required to complete your degree in Information Systems Management. You are trying to determine which classes will be offered and how much longer it will take you to complete your degree.

Once you complete your pivot table and chart, you will now be able to visually see what courses are available and which semester offers the most courses that you will need to successfully graduate.

To complete the assignment, perform the following tasks:

Open this Excel workbook and save the worksheet as "FirstInital_LastName_PivotIPA04_.xlsx."Highlight the entire data set, and insert a pivot table.

For more information on how to create a pivot table, click here.

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.Insert a Column chart and expand your chart. Select Chart Layout 3, and also change your chart design style

2. Add a title "Course Availability" for your table. Save the worksheet as "Course Availability," and save your document as "FirstInitial_LastName_PivotIPA04_solution.

"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.

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.

Change your chart type to columns and choose a style from the design tab. Insert the name "Course Overview" as your title.

Adjust your new chart by expanding it from cells A22 to G48.

Rename the worksheet to "Course Overview."

Submit your Excel spreadsheet.

Attachment:- U4IP.xlsx

Verified Expert

The solution uses the concept of Pivot Table. The tool Pivot table of excel has been utilized to determine what core courses that are required to complete the degree in Information Systems Management. Further the time required for there complete has been determined.

Reference no: EM13992772

Explain the advantages of utilizing the research firms

Explain the advantages of utilizing these research firms. Discuss why a company might decide to save the money and utilize its in-house team as opposed to one of these firms.

Face in a non-project-based organization

Describe two challenges a project manager might face in a non-project-based organization. As a project manager in a non-project-based organization, how would you overcome th

What are different expatriate compensation method recognized

What are the different expatriate compensation methods you recognized in the text? What are the advantages and disadvantages of these different expatriate compensation metho

What kind of monetary policy

If you were the Chairperson of the Federal Reserve, what kind of Monetary Policy (Increase or decrease Money Supply) would you advocate? Why? How will this policy impact GDP

Specify the nature and type of products or services of apple

Specify the nature, structure, and types of products or services of Apple, and identify two key factors in the organization's external environment that can affect its succes

Positive and negative aspects of workplace conflict

What are the positive and negative aspects of workplace conflict? Share examples from your professional experience to illustrate your answers. What are some differences in c

Illustrate what is her recognized gain or loss

Abner provides his daughter, Melissa, stock (basis of $52,000; fair market value of $42,000). No gift tax is paid. If Melissa subsequently sells the stock for $54,000, illus

What is the marginal product of capital in situation

Assume that a country's production function is Y = AK0.3L0.7. The ratio of capital to output is 3, the growth rate of output is 3 percent, and the depreciation rate is 4 per

Reviews

Write a Review

 
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd