“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

HR Metrics: Excel Activity 7
DUE:
This activity is due by June 4th at 11:59pm.
Issue:
Our employee database has been partially corrupted and we need to fix the raw data and provide our VP with answers to a few of her questions. As seen in the screen shot below, all the calculations between Columns K to R have been erased along with employee data below row 10.
Requirements:
The file has 6 tabs that you will need to use.
First you need to complete the Raw Data tab with all the necessary calculations. For some of the columns you will need to link data contained in the Reference Tables tab. This prep work is required to answer the questions in the final tab, “Questions & Answers”.
Use first 10 rows of the Raw Data tab to work out your formulas and double check to make sure you are doing them correctly (try replacing them to see if you get the same results that are already there). Once you are confident they are correct, copy the formulas down to complete this tab.
Then use the pivot tables to answer each question found in the Questions & Answers tab. Make sure you use the Q.1 Pivot tab to complete and show your work to answer Question 1 in the Questions & Answers tab. Use the Q.2 Pivot for Question 2 and Q.3 Pivot for Question 3.
Once done, save the completed file and upload it to the Assignment folder named, “Excel Activity 7”.
Marks: Completing the Raw Data tab=1 mark; Showing work in all 3 Pivot tabs=3 marks; Answered Questions tab=1 mark (0.25 marks each).
Key Concepts:
You will need to incorporate the following functions: =VLOOKUP(), =INDEX(), =MATCH()
You will also need to group data in the Pivot Table and remember how to calculate averages.

Solved by X. D. in 15 mins

I need help with pulling these two sheets into 1 using the store number as a point of reference and then doing 3 pivot tables

Solved by K. U. in 21 mins

I need to get 4 different pivot tables created off this sheet

Solved by B. F. in 20 mins

I'm new to pivot tables and just the basics are stumping me. just getting 3 columns it doesn't go where I want to.

Solved by T. B. in 20 mins

How do you do pivot tables in Google Sheets?

Solved by A. F. in 13 mins

Hi, I have a problem trying to summarise the data from a spread sheet I have created. The summery I require is to filter the 'divisions' while being to count the number of 'Yes', 'No' and 'N/A' answers to a given questions Q1, Q2, Q3 etc. I seem to be unable to do this using pivot tables as there is too my variables, is there another way of summarising the data?

Solved by T. B. in 13 mins

I have been using pivot tables in excel and my spreadsheet consists of hundreds of inputs. My current issue is that after adjusting my inputs on the pivot table, I am trying to find the average(s) of all of this data, and some of the entries are showing as duplicates and not averaging together.

Solved by C. W. in 19 mins

Need to update several pivot tables in a worksheet after the data is updated (data is a OBDC query)

Solved by T. B. in 28 mins

Need to modify pivot tables to show proper counts for sales items.

Solved by D. U. in 26 mins

I have been working with Pivot Tables for this data, but I feel that a macro may be better at this point.
Essentially, I have exported an survey that has been attached to an event session. There are three questions for each session and each question has 5 answers to choose from. I would like each question to show a graph like this:
Question: I feel confident that I can apply what I learned.
Session Item: RED
Count of each option:
Definitely Yes!: 4
Definitely No: 2
Sure: 18
No: 0

Solved by O. J. in 14 mins