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

I have a list of dates in a table on a worksheet(main worksheet) and this corresponds to worksheets(names by their date) which contain a lot of data which is then input into the main worksheet for an overview of all the data. Every time a new worksheet is created with a new date this needs to be put into the main table. The problem is that in each column in this main table the date in the formula must be changed from the previous date to the new current one manually. Is there any way to change this or speed the process up?

hi, I have a table of numbers 4,3,2 7,9,9 5,3,1 9,8,3 In the first column, 4, 5, and 9 are the highest values in their row. How do I calculate the sum of the max numbers in the column, and also maximum columns in excel? In this case, the sum is 4+5+9.

I have a large pivot table of customers, I need to sum when there are new customers and in reverse, when customers leave. Not sure if this can be done through pivot table. I just can't figure out the best way to do this with a sumif formula

I need to store the values in the table on the first page into an array. I then need to multiply each value by 2 and store each value in a table on the second sheet. I dont know how to place the table on the second sheet without referencing a cell on the second sheet but by following the same cell locations as on the first sheet

I want to split one column of data into data table contain fields of (university name, faculty name and program name)

I need to extract universities and faculties in differfent columns to get fully data table with 3 fields university name, faculty name and program name

I have a table which lists the schedule of classes for a school. The table is broken down into one hour time slots (columns) and subjects per days of the week (rows). In each time slot per subject is a class number. Each class takes one subject per day. My goal is to say to Excel: "Look in this range and tell me which subjects class X is taking"

Without using an index match formula could you please extract all the sodium results for each patient and make a table of them

I am trying to create a sensitivity table for IRR that takes years as one of my points of comparison however my resulted table does not change with different years of comparison.

I am trying to get my matrix table to have a set of constants (equipment) in 1 column while the next column needs to have a drop down menu that will show if the control unit is compatible with the equipment that is list in the constant column