Microsoft Excel is a powerful information management tool. The step by step instructions below walk you through manipulating columns and rows, sorting, filtering, and printing the output.
Upon completion of this 1-on-1 training, you will be able to:
What are you starting with? Before you know what to do with a spreadsheet, you need to know what you have as a starting point. To determine this, do the following:
What do you want in the end? Now that you know what you have, you need to decide what goals you have for the spreadsheet. For example, you might have the following goals:
How do you get from here to there? You know what you have. You know what you want. Now you “just” need to manipulate the spreadsheet to get the desired results. The remaining steps will guide you through that process.
By saving the file now, you will keep an original version of the data in case you need to start over. Also, the file would be available if you want to start with the same data, but want a different report in the end.
The spreadsheet that you are starting with may have more columns than you want displayed on your report. It could be important information, just information that is not necessary for this report.
Spreadsheets can be sorted by any column, ascending or descending. If the entire spreadsheet is to be sorted, all of the cells must first be selected. Otherwise, the highlighted data will be sorted and the non-highlighted data will remain as it was which might not be what you want. To sort the entire spreadsheet,
There are various ways in which to alter which rows of data are displayed. Each method has a different purpose.
Once you have all of the data that you want displayed, and none of the data that you do not want displayed, you are ready to format your report for printing.