Create pivot table in new worksheet called data analysis

Assignment Help Operation Management

Reference no: EM13857024

Need a little help on each of these steps. If anyone can give somewhat of a step by step analysis it would be appreciated.

1. Create a pivot table in a new worksheet called “Data Analysis”

2. Make the background the same Tan color (there is a trick to this that involves a new worksheet and come cutting and pasting)

3. Change the view of the Pivot table to be “Classic Pivot Table layout...”

4. Provide a count of documents by Critical Operating Process for each of the roles. Please note that the totals at the bottom match the totals you calculated in the data table using the Counta formula

5. Change the columns headings for the data columns to run up at a 45 deg angle, delete the words “Count of” and add the “(Tot)” at the end of each one.

6. Notice the “Document” Row in the picture below. Add that row as pictured below but hide the information to keep the table only showing totals by Critical Operating Process Name. Notice what happens to formatting of your background when adding rows and then hiding or removing them.

7. Remove the Document field from the Pivot chart and fix the background color. Create a Pivot chart from the pivot. Choose a 3D stacked bar chart. The corresponding chart will show which role has how much involvement with each Critical operating process. Using this chart it is easy to see which COP’s are not relevant to the AP Market Manager. This chart also shows that the Operations Manager is very involved with all of these processes.

Reference no: EM13857024

Questions Cloud

Create a document to compare data : Create a document to compare data between 2013 and 2014 through two pie charts, a grouped bar chart and a table

Identify organizations and negotiate terms of agreement : Develop and demonstrate skills to prepare a project proposal, project specification, identify appropriate organization(s) and negotiate terms of agreement

Research a u.s.-based company that manufactures product : Research a U.S.-based company that manufactures technology products

Calculate the diameter of a medium carbon steel pin : Calculate the diameter of a medium carbon steel pin in double shear subjected to a suddenly applied shearing force of 150,000N

Create pivot table in new worksheet called data analysis : Create a pivot table in a new worksheet called “Data Analysis”. Make the background the same Tan color (there is a trick to this that involves a new worksheet and come cutting and pasting) Change the view of the Pivot table to be “Classic Pivot Table..

Calculate the vorticity component in the circumferential : Consider fully developed axisymmetric Poiseuille flow-flow in a round pipe of radius R (diameter D = 2R),with a forced pressure gradient dP/dx driving the flow

Purchased by both private and public organizations : Using examples that are purchased by both private and public organizations (like uniforms, trucks, and budget-tracking software), weigh the advantages and disadvantages of doing business with the federal government,

Describe the switching costs : Describe the switching costs that a company would incur if it began to phase out its current suppliers and pick new suppliers. How would you suggest this company reduce its switching costs?

Cost of goods sold was by a company : cost of goods sold was by a company

User Account

All Pages