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!”
Here are some problems that our users have asked and received explanations on
On the tables that has a completion date, I would like to add a start date row above it and get the start date from Ticket Input sheet
Solved by D. U. in 23 mins
have a problem with pivot tables and bar chart in my project, I think I have done the pivot tables correctly along with the bar chart completed my worksheet
Solved by Z. Q. in 18 mins
I'm making an order form in excel using indirect tables is there a way to look up prices depending on what tables I choose
e.g. fruit > banana > show price also
Solved by S. Q. in 27 mins
I have data in excel. 5 tables of temp (Column B - 1st data set) and corresponding time (Column D - 1st data set)
I am getting a value from a software when this data is fed in the system - A temp (B4) and a time (C4).
I need to find a equation/formula which will replicate this is excel.
Solved by X. W. in 17 mins
I am building a KPI dashboard and I need to calculate the weekly, monthly, quarterly sales based on data that refreshes every one minute.
I have tables and pivot tables for my data. But I am unable to conditional format the data to get the required numbers.
Please help me
Solved by T. J. in 12 mins
I have a large set of files (two folders with 104 and 156 .txt files each) The text files are tables of 4 columns by some 11000 or 16000 rows. The files are named so that columns 2 and 3 are obsolete if the 4th row's data can be tied to the filename by having the latter imported as a header. The 1st column is a date range that does not vary between any of the 260 files. Can I (somehow) import the 4th column of these txt files in a timely fashion to a singe worksheet with each column showing the file name followed by the 16000 rows of data?
Solved by F. H. in 21 mins
Need help with pivot tables in doing columns and rows
Solved by X. J. in 11 mins
I need to great a report with Pivot tables and charts to track project counts, milestones, and completions. I am not good with this kind of stuff.
Solved by K. D. in 11 mins
I need some pivot tables for my project that I can also convert to charts
Solved by T. S. in 27 mins
I need to create metrics from a spreadsheet, some sort of dashboard perhaps using Pivot tables or Chart. I have a file but would like help, because it's data that's work related.
Solved by I. F. in 30 mins