I am working with a listing of 10 and for each I have 6 columns – last name, first name, SS#, Salary, Date of Hire, Department.
I want to create reports from this list. I can teach the kids how to sort and how to filter.
I would like to know if there is a way I can have it print the last name, the first name and just the Salary. (This harkens back to the days of a simple database and reports in which I could choose which columns to be in the report).
Is there a way to do this in excel