My skill level with Excel is beyond basic, but not sure it's Intermediate. I am looking for either free on-line tutorials or books I can use to learn how to do things in Excel that are beyond the basics.

I copy a CSV report to an Excel worksheet, I have additional worksheets that use different columns of the data to either display or provide a metric of some kind.

I have a worksheet where I display a count of different combinations of cells in 3 columns (row A:row, B:row, and C:row) based on the data from the CSV worksheet. An example is Column A would have Accounts, B would have Network, and C would have New. When the raw data has a row with all three values, it is counted. Not all combinations end up with a count >0. Right now, I just have a list of the combinations and the count, including the combinations where the count =0. I'd like to find a way to display only those combinations that have a count>0. So how ever I display it (chart, table, whatever) it would expand and contract as the raw data changes.

I have another formula which is suppose to give the average time based on the different of 2 date/time entries. I know how to concatenate cells or separate cells (one time in CSV has one cell is date, other is time; the other date/time is all in one cell). I can't find the answer to how to best find the difference - date/time in a single cell or separated. One this was first set up, only date was used, so it was fairly straight forward, and I used the functions that excluded weekends and holidays. Now I also need to exclude non-service hours.

The number of rows of data from the CSV vary, and of course are unformatted but do have a column title. I want to copy select data to worksheets with formating. I know how to copy an entire column; using A$, but how do I exclude row 1 (heading row).

I don't want to use VBA or macros, this is for a template and I want it's use to be as simple as copying the CSV data to the Workbook and all the sheets using that data are automatically populated. Suggestions for solutions would be appreciated, but a resource (such as a book or online tutorial) that I could use for this and any future needs would be great.