Create pivot table in new worksheet showing neighborhoods

Reference no: EM132239417

Assignment -

1. Structured Tables - Convert Chicago energy to and Excel table, and name it ChiEnergy filter to just blank building types Copy and paste values (visible values only) to a new worksheet, make that into a table, and name it ChiEnergyAgg Calculate KWH and BTU per capita and rank in descending order in two columns.

2. Pivot Tables - Use the ChiEnergy table created above (not ChiEnergyAgg) and create a pivot table in a new worksheet showing top 20 neighborhoods in residential population that displays the sum of occupied residential units, total KWH consumed in 2010 by residential units, total BTU consumed in 2010 by residential units, and population of residential buildings.

Note: Submit one workbook with multiple worksheets. There should be 3 worksheets.

Attachment:- Assignment Files.rar

Reference no: EM132239417

Questions Cloud

Professional environment gain from this external source : What benefits would your work or professional environment gain from this external source?

Example of how it applies in planning program : Define each of the following and give an example of how it applies in a planning program.

Human resources departments face with career management : Identify and discuss the issues Human Resources departments face with career management.

Important to strategic planning and the project manager : Why is the implementation of projects important to strategic planning and the project manager?

Create pivot table in new worksheet showing neighborhoods : Create a pivot table in a new worksheet showing top 20 neighborhoods in residential population that displays the sum of occupied residential units

How contracts were formed and terms of contracts : Describe how (or if) the contracts were formed and the terms of the contracts.

How the knowledge have been applied in a practical manner : Provide a reflection of at least 500 words (or 2 pages double spaced) of how the knowledge, skills, or theories of the course "Telecommunication and network.

Abstract for health and safety quality management system : Provide an abstract for a health and safety quality management system with issues covering quality assurance, preventing customer dissatisfaction,

Develop a network design to meet the requirements : Your job is to develop a network design to meet the requirements above. You should submit a network drawing listing the network's topology including.

User Account

All Pages