Get instant live Excel expert help to learn how to create and adjust tables in Excel?

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

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I have a table with transactions. The transactions are by dates, the Month of July, 2016. I need to sum the total for each day and make a new list with just the day totals.
Solved by O. J. in 25 mins
I have a sheet with transaction for a month. Each month I get a new transaction sheet. I need a pivot table to calculate the total transactions for each day. However, before that, I need VBA/Macros to add in the date next to the qty sold, it is currently placed next to the receipt#.
Solved by C. Q. in 24 mins
I need a pivot table sample data
Solved by Z. W. in 22 mins
I need to figure out how this pivot table was created so that I can apply it to other sheets
Solved by B. Y. in 21 mins
in a table, one request number has one row for each phase i.e start,1, 2,3,4 and lastly complete. I want to use if function to check if for a unique request no., "complete" phase exists. If yes, then format all rows with the same request no in green
Solved by Z. E. in 17 mins
I need a macro for analysing a table with with value and colour to change another segment to the same colour resembled on the table
Solved by V. U. in 27 mins
I'd like to setup a pivot table to show information from column C, D and I
Solved by S. H. in 26 mins
need to figure out how to calculate time on how much time was in total used to for the companies in pivit table or not
Solved by K. J. in 18 mins
Write an HLOOKUP function that will output the correct Net Profit for whichever date is selected in cell H11. Table array is C5:H8 Expert_777
Solved by D. H. in 24 mins
I'm having problems with my pivot chart. The times are not in chronological order and the days of the week are in a different order than what I need. Also, the I need different charts from different sections of the table and whenever I try to change the section, my charts switch also.
Solved by G. D. in 17 mins