Our Services

Get 15% Discount on your First Order

[rank_math_breadcrumb]

Education Excel PivotTables Assignment

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

Cultural

  To start understanding organizational behavior inside your company or institution, you first need to see the connections between the various parts of the organization including the people and teams. This activity will help you organize this information, so you can delve deeper into your organizational culture for the summative

Education edu 522 week 8 assignment

 upload two lessons to the Canvas learning management system. Your goal is to create an interactive and engaging learning environment for students by providing well-structured lessons with additional resources and opportunities for interaction and discussion.    Use the how-to document linked above and the foundational concepts you developed in the

Culturally Responsive Instruction

All information is in attachments. Please follow closely.  5/20/24, 11:13 AM Page 1 of 3about:srcdoc Culturally Responsive Instruction – Rubric Total 255 points Criterion 1. Unsatisfactory 2. Less Than Satisfactory 3. Satisfactory 4. Good 5. Excellent Explanation of How You Will Integrate Culturally Responsive Instruction Into Your Teaching Practice An

EDU 522 week 8 discussion

As eLearning continues to grow, it becomes increasingly important to determine whether classes or training are effective. How can we determine if eLearning classes are meeting their goals and have a positive return on investment (ROI)? Describe how you would develop an analytical approach to assess the class you are

Discussion

Provide a response to each post below: Each response must be at 150 words. 1. Action research is a methodology that places a strong emphasis on working together to identify issues, create solutions, and carry out changes with participants (What Is Action Research, 2024). This image illustrates the iterative process

week 3 discussion

Prepare: Prior to beginning work on this discussion forum: Read:  In Laubacher et al.’s (2023) An Introduction to Social Science: Individuals, Society, and Culture Chapter 5: Sociology Chapter 6: Anthropology and Human Geography Chapter 7: Psychology and the Behavioral Sciences

week 3 discussion

Prepare: Prior to beginning work on this discussion forum: Read:  In Laubacher et al.’s (2023) An Introduction to Social Science: Individuals, Society, and Culture Chapter 5: Sociology Chapter 6: Anthropology and Human Geography Chapter 7: Psychology and the Behavioral Sciences

Education Bibliography Assignment

ANNOTATED BIBLIOGRAPHY ASSIGNMENT INSTRUCTIONS OVERVIEW For this assignment, you will create an annotated list of at least 10 resources (both Christian and secular) that you plan to use for your Research Paper Assignment later in the course. The resources must have been published within the last five years. These sources

quay

please see attachment This assignment has two parts: 1. Identify and discuss the quality management objectives in a healthcare organization, including at least four (4) definitions of introductory quality management terms. 2. Identify and discuss how to apply systems thinking strategies to healthcare quality control and management processes. This is

angie

please see attachment please review the following list of potential problem/situations and choose one for your final assignment, Strategic HR Plan. You can write your paper as if you were employed at a Fortune 500 company, a current organization that is in the news, or a past or present employer.

anna

please see atachment a) demonstrates proficiency in setting up an ethnographic research project; b) describes a strategic site for ethnographic research; and c) conducts ethnographic research (via observation only) and presents some preliminary findings. Your paper should utilize sound critical thought, refer to course materials, and be written in APA-format

Research Outline

RESEARCH PAPER OUTLINE ASSIGNMENT INSTRUCTIONS OVERVIEW For this assignment, you will create a short, working, informal outline of how you plan to formulate your Research Paper Assignment. The outline should be a working outline meaning that it is a beginning point for your research paper. INSTRUCTIONS Access Jerry Falwell Library

quita week 2

please see attachment This assignment addresses course learning objective 1 – Identify the various segments of the hospitality industry, along with institutional learning objectives related to information literacy. For this assignment, you will be preparing an annotated bibliography that lists four different academic sources from the Trefry online library. The

Education Problem-Based Assignment

ASSIGNMENT Textbook: Stringer, E. T., & Aragón, O. A. (2020).  Action research (5th ed.). SAGE Publications, Inc. ISBN: 9781544355948. Read chapters 3, 4, & 5 Look, Think, Act Essay Write a 2000- word essay addressing each of the following points/questions. Be sure to completely answer all the questions for each bullet point. Separate

Athletics and the Law

After reading the attachment.  Name your firm and create a brief introduction to it which would appear in the About Us section of your company website. Create a SWOT analysis of the Dolphins’ athletic department. Prepare an assessment for presentation to the board of directors that covers the following laws:

respond to discussion 2MR

Jennifer Cohen Module 2 Respond to each one Situation             Many years ago, I had a group of students who were predicted to fail, and they needed intervention. They were group of first graders that were on a beginning kindergarten level. The whole group was the lowest of the first-grade classes.

Discussion Question

TEXTBOOK: Stringer, E. T., & Aragón, O. A. (2020). Action research (5th ed.). SAGE Publications, Inc. ISBN: 9781544355948. Read chapters 3, 4, & 5. Discussion Question: Must be at least 250 words. Review various visuals describing the Action Research models and select one that best exhibits your own understanding of the AR process.