Get instant live Excel expert help with Pivot Tables
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
how do i correctly use vlookup and pivot tables for my aat level 3 exam
Solved by B. Y. in 30 mins
how to build a pivot table in excel? I'm trying to build out a pivot table with existing data. I need to organize the data and need help with that.
Solved by G. A. in 23 mins
I'm trying to work on sumif in excel and pivot tables.
Solved by T. J. in 16 mins
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 have a pivot table with the names of all of my vendors and the YTD sum of checks paid out. In a second spreadsheet, I have a list of vendors with their addresses.
I need to be able to match the Vendor names to their addresses without having to do it manually, one by one.
Solved by K. J. in 15 mins
Hello, I'm trying to get my pivot table grand totals to be averages instead of totals. Is this possible in Excel 2016?
Solved by F. F. in 28 mins
How do I sort a pivot table by the amount in the first numeric column?
Solved by A. E. in 19 mins
need help doing a v look up and creating a pivot table excel
Solved by E. S. in 12 mins
I have a start date and end date in 2 columns, I would like to create a Pivot Table that will show all months between the start date and end date with corresponding data.
For example - start date 7/5/17 and end date 16/8/17, I would like to see a Pivot Table that has count as per below:
May 1
June 1
July 1
August 1
Solved by I. J. in 18 mins
I need to get josephs help if available if not i need to do a vlook up and a pivot table
Solved by A. J. in 26 mins