Microsoft Excel is a powerful tool for creating first rate reports. The step by step instructions below walk you through importing a file into MS Excel and then reformatting the output.
Upon completion of this 1-on-1 training, you will be able to:
The Text Import Wizard is very helpful when loading a text file (usually with extension *.txt) into Excel. The wizard will walk you through the process in a step by step fashion.
By saving the file now, you will keep all of your hard work importing the file. In addition, you will be saving it as an Excel spreadsheet which will also keep the formatting that has been achieved.
The Text Import Wizard will do what it can to format the report for you. Inevitably, however, there will be some work left for you to complete.
Numbers with the negative sign after the number, by default come into Excel as text strings rather than as actual numbers. This can be changed by following the steps below.
There are times when separating a report into specific pages is helpful. To do this,
It is possible to review your report without sending it to the printer and looking at the paper. Instead, you can view the report within MS Excel as it will look when printed. Use the following steps for this purpose.
Now that you have imported your text file, reformatted the output, and reviewed your report within Excel, you are ready to print your report. Remember to save one last time before you leave Excel.