Create a table with headers

Assignment Help Database Management System

Reference no: EM13761135

Set up Lookup Table

1. In the lookup workbook, create a table: with headers: Region, Metro, University, Employment, Enrollments

2. Build the table using direct sourcing from the appropriate tables to create this chart:

East	Atlanta-Sandy Springs-Marietta, GA	University of Central Florida [note 2]	2.1	59,770
Central	Chicago-Joliet-Naperville, IL-IN-WI	Ohio State University	0.9	57,466
West	Dallas-Fort Worth-Arlington, TX	University of Texas at Austin	3.3	51,145

3. Insert this as a formal table named LookupTable1

Set up Analysis Table

1. In the workbook Transforms-1, create headers:

OrderDate

Location

Employment

University

Enrollments

Rep

Item

Units

Cost

Total

2. Location: Use VLOOKUP to associate Source-Sales region with lookup table Metro

3. Employment: Use VLOOKUP to associate Source-Sales region with lookup table Employment

4. University: Use VLOOKUP to associate Source-Sales region with lookup table university

5. Enrollments: Use VLOOKUP to associate Source-Sales region with lookup table enrollments

6. For columns OrderDate, Rep, Item, Units, Cost: Do a direct association with these values from the Source-Sales

7. For column Total: Create a simple formula Units * Cost

Create Pivot Tables and Charts

1. Create a pivot table and associated bar chart to show total sales per rep by Metro area. Label this workbook "Report-1"

2. Create a pivot table and associated bar chart to show total sales per rep by University. Label this workbook "Report-2"

3. Create a pivot table and associated bar chart to show total sales per employment number by University. Label this workbook "Report-3"

4. Create a copy of the Transforms table in a new workbook labeled "Transforms-2" and set up filters. Hide date, rep, item, units, costs columns. Create a pivot table and chart to show total sales per Metro area. Label this workbook "Report-4"

Attachment:- dowmloads.rar

Reference no: EM13761135

Questions Cloud

Discuss the importance of disaster recovery : Discuss the importance of disaster recovery and/or business continuity planning with respect to maintaining the confidentiality, integrity, and availability of information and information systems

What are the two explanations of hayys origin : What is the point Ibn Tuffayl is trying to make with the blind child allegory (p. 97)? What is he trying to show or suggest? What are the two explanations of Hayy's origin? What is the difference between them?

Table for each employee and total the columns : 1. Prepare a table with the following column headings: Employee, Cumulative Pay, Pay subject to FICA Social Security Taxes, Pay subject to FICA Medicare Taxes, Pay subject to FUTA taxes, Pay subject to SUTA taxes. Compute the amounts in this table fo..

Describe the specific steps that your firm would : Define a business idea, preferably one that you create, that might work as a start-up firm in the United States. Your proposed firm should provide a particular product or service mainly to customers located outside the United States.

Create a table with headers : In the lookup workbook, create a table: with headers: Region, Metro, University, Employment, Enrollments 2. Build the table using direct sourcing from the appropriate tables to create this chart:

Applying theory to a practice problem : It is important to understand how borrowed theory can help you in your everyday environment as a nurse.

Paper about cyber security and identify assess and propose : Please refer to the latest document about cyber security and identify assess and propose: Risk related indicators and governance solutions, vulnerability assessment for cyber security

Financial systems-financial management : From the second case study and e-Activity, determine the importance of bankers having good working relationships with their clients. Support your response with two (2) examples that illustrate such importance.

How person you have indicated fulfills emersons description : Write an essay in which you discuss how the person you discuss and how the person you have indicated fulfills Emerson's description of a friend.

User Account

All Pages