Get instant live Excel expert help to learn how to use Large function?

I have a large data set with names that needed to be sorted in alphabetical order by last name. sadly, the cells are written as "first name Last name" with a space in between them. There is also corresponding data to the names in the columns next to you it that to stay with the last names.

I have a large Excel spreadsheet - when trying to freeze the columns I did something else and I can't undo it - it's hiding Rows 2-17, but it hasn't been done with the hide function - it's a little pulldown on the lines between the cells - help!

Change format to a monthly basis rather than a large continuous file

I set up a worksheet with large second column for narrative then 4 little column - have types in lots of narrative - now want to print it and it only recognized the first column. Tried to copy and transfer to word and same thing. Help!!

I have a large data set from I need specific information transposed to a different sheet if it contains specific criteria.

I need help adding up a large number of cells at once

I have a very large spreadsheet that spans the entire year. I would like to have this spreadsheet modified to cover 4 month increments. JAN-APR, MAY-AUG, SEPT-DEC. I just do not know how to manipulate the formulas to do this

I have a very large spreadsheet that spans the entire year. I would like to have this spreadsheet split in 2. Because it is so large the calculations are slow in google sheets. Can you make one copy of it from Jan-Jun and make another file Jul-Dec. I would like a column added to the Jul-Dec spreadsheet with June's totals

I have a large file with numerous tabs of pivot tables. Recently when you filter or manipulate the table some cells turn to black fill instead of keeping formatting. How do I fix this?

assignment for using business data. You are the new Director of Operations for Transport for London's (TfL's) 'Santander' Bike Hire Scheme. The docking machines all over London secure bikes that have been returned to the docks by customers, but they are then not in the optimum place at the start of each day for the customers to hire them again. So every night, TfL re-distributes bikes back to the docks where they are needed. The number of bikes hired each day is automatically recorded on each day and you have the data for each day's hires between July 2014 and August 2010. In addition, daily temperature data has been included for each day of the recorded sample. Your job involves analyse this large dataset to address the following taks. You will consider this large dataset that you have been provided with as a population.