Upload has all the information you need.Excel PivotTables Assignment (10 Points) An Excel

Upload has all the information you need.

Excel PivotTables Assignment (10 Points)


An Excel PivotTable is used to present Excel information in a table format. The idea is that you can click drop down lists and change the data that is being displayed (hence, you may “pivot” information into and out of the table). For example, in a teacher’s grade book, you may choose just one student from a drop-down list of students, and then display only the one student’s scores.

In this assignment, you watch two videos, and then complete a short PivotTable exercise. Place your completed PivotTable exercise file in this week’s D2L Assignment dropbox.

1st Video:
Pivot
Table Excel
Tutorial by Kevin Stratford

The first video shows how PivotTables may be used to display a company’s inventory. Do not try to memorize the specific steps being demonstrated, just focus on how the presenter “pivots” information into and out of the PivotTable depending upon the information he wants to display.

Click this link to view the first 13.5-minute YouTube video:

2nd Video and Assignment:
Excel 2016– Intro to
Pivot
Tables by GCF Global

Although the video is based on the 2016 version of Excel, the same steps are followed when using the current version of Excel.

Display the GCF Global

Excel 2016 – Intro to PivotTables
web page by clicking on the link below (or access the link directly from your browser).

https://edu.gcfglobal.org/en/excel2016/intro-to-pivottables/1/. If needed, choose your desired cookie option, then complete the steps listed below.

1. Read the introductory paragraphs and watch the video.

2. Near the top of the Web page, click the practice workbook link to download the practice workbook.

3. Save the file as

Lastname_Firstname_PIVOTTABLES.xlsx.

4. Read the
Using PivotTables to answer questions paragraphs to review an introduction to PivotTables.

5. Read and complete the seven steps in the
To create a PivotTable: section:

a. After you complete step 7 in this section, your PivotTable should look like the one shown in step 7 on the Web page.

b. For our purposes, you do not need to change the number format to Currency.

6. Read and complete the steps in the
Pivoting data section.

a. When you add the
Month field to the COLUMNS setting, your PivotTable should look like the one in step 2 of this section.

7. Read and complete the steps in the
To change a row or column: section.

a. Complete steps 1 and 2 in this section. When you complete these steps, your PivotTable should look like the one in step 3 of this section (the same PivotTable is shown below).

· You will have completed the assignment when your PivotTable looks like the illustration below:

b. Students do not need to complete the steps in the
Challenge! section at the bottom of the web page.

8. Save your completed
Lastname_Firstname_PIVOTTABLES.xlsx file

9. Upload your file into this week’s D2L Assignment dropbox.



Excel PivotTables Assignment Page 8 of 8

image1.png

image2.png

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Prompt: One of the issues under consideration in your draft

 Prompt: One of the issues under consideration in your draft is analytics methods. Either descriptive, inferential, or predictive, provide a summary and the data requirements. Note that after the report, you may incorporate recommendation received from your professor.Instructions: Label your Word document as follows: yourlastname.doc (ex: Johnson.docx) not bullet format

Conduct a discrete and respectful community

Assignment Overview In this assignment, you will conduct a discrete and respectful community observation of an Alcoholics Anonymous meeting. Locate and attend a local Alcoholics Anonymous meeting in your area. Explain to the meeting leader that you are a nursing student studying community resources. Write a two page summary of

MAN4240CBE Section 01CBE Organizational Behavior Analysis (11 Weeks) – CBE

CompetencyDetermine the value of organizational behavior. ScenarioIndividual behaviors in the workplace impact an organization, and leadership should understand its impact on an organization as a foundation for creating strategies in effectively leading. In this scenario, a technology company has been struggling with sales recently, and leadership believes developing new, in-demand

Review the Resources and reflect

New technology—and the application of existing technology—only appears in healthcare settings after careful and significant research. The stakes are high, and new clinical systems need to offer evidence of positive impact on outcomes or efficiencies.Nurse informaticists and healthcare leaders formulate clinical system strategies. As these strategies are often based on

Pediatric Denver II Assessment Assignment Complete Denver II assessment on

   Pediatric Denver II Assessment Assignment Complete Denver II assessment on a child between the ages of 0-6.  Fill out the worksheet and document finding. Take the child’s height, weight, head circumference (if under 3 years of age), and vital signs. Write 250-500 words summarizing your assessment findings and the

New International Vision Bible

Discussion Question #1 Whatever you been diagnosed with that may lead to a surgical procedure (ex, appendix removed, or a quadruple bypass), any surgical procedure is a serious matter. The last thing anyone wants to hear following a surgery is that an error occurred.  But does that automatically mean your surgeon committed medical

M8 Question and Answer Measuring the Economy What does GDP

  M8 Question and Answer Measuring the Economy What does GDP attempt to measure?  Briefly differentiate between nominal and real GDP. Why is real GDP a more accurate measure of economic growth compared to nominal GDP?  What are two weaknesses of GDP?  GDP can be expressed as the sum of

Introduction Effective teams require effective team members with key traits

   Introduction Effective teams require effective team members with key traits and characteristics. The leader of an effective team must be able to define team roles, describe role responsibilities, choose tasks for each role, and seek out team members with the skills to complete these tasks. This assignment gives you

Please answer all question Reflect on the current roles of

  Please answer all question Reflect on the current roles of advanced practice nurses in healthcare as the care providers at the front line of disease management and health promotion in primary care and many other specialty settings.  What do you think are some effective tactics for APN strategic positioning regarding pay

  Write a 500-750-word essay on the influence patient education has

  Write a 500-750-word essay on the influence patient education has in health care using the experiences of a patient. Interview a friend or family member about that person’s experiences with the health care system. You may develop your own list of questions. Suggested interview questions: Did a patient education

A. Assignment Guidelines DIRECTIONS: Write a composition (at least 100

A. Assignment Guidelines DIRECTIONS: Write a composition (at least 100 words) in Spanish that incorporates each of the following: Use a form of salutation (start with “hello” in your favorite form in Spanish). Introduce yourself (give your name). State how you feel using the verb estar plus an adjective or

Individual Assignment #1 Scenario: Imagine you are an international business

Individual Assignment #1 Scenario: Imagine you are an international business researcher. You have been hired by a Canadian business which is considering expanding internationally. They have narrowed the choice down to a few key markets and have asked that you provide some insight as to which market they should choose