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

hello Madam /sir i got little confusion about pivot table tools once i select pivot table column option tool will be displayed but there formula column hide in my excel how can i get ?

Solved by E. D. in 24 mins

I create pivot tables/charts from data extracted into excel. Each month I have to update the charts - so I extract the data from the software, cut & paste into the file to update the data source for the charts. But - it seems I have to select the data source and highlight the records to be included for each chart, each time I update! I tried to produce a 'dynamic pivot table' without success. Other answers have been when selected the data source select a much large area so you capture the new data pasted into it.... sorry not easy to explain!

Solved by S. U. in 19 mins

How to create power pivot tables? I'm working as a document controller in a big company. I need your support with the all excel expert. I know you are the best team which helps employees and students. Thank you and godbless excel expert!

Solved by Z. S. in 20 mins

I created the pivot table with certain data excel. i want to add more data to the excel file and automatically the pivot table should get updated. is it possible?

Solved by D. E. in 29 mins

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. 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. You must use the built-in calculations in the pivot tables for your answers and not manually perform calculations (e.g. averages) afterwards on the pivot table data

Solved by V. D. in 26 mins

Have an existing pivot table that lists columns of data but also need users to be able to enter comments next to each row of data in this pivot table. What I need to do is add a text column within the pivot table that users can enter comments directly. This text column also needs to be able to sort with the excisitng pivot table.

Solved by D. S. in 23 mins

Have an existing pivot table that lists columns of data but also need users to be able to enter comments next to each row of data in this pivot table. What I need to do is add a text column within the pivot table

Solved by A. D. in 30 mins

In Pivot table, how to put 2 columns one by one if the first row label has more than 1 value in the 2nd column?

Solved by X. J. in 17 mins

how to make a pivot table? I need to make several ranges of numbers into groups.

Solved by K. S. in 24 mins

How to do a pivot table? I cant get to the right data source of my pivot table

Solved by X. W. in 19 mins