Sunday, September 26, 2010

Week 5: Clear

After working with excel during my internship this past summer, I know firsthand that it is important to know how to work with Excel.  Knowing how to use Excel is a great asset and important in every field.  Out of the different sections reviewed in class, I have to say I have a special appreciation for the printing section.  This summer, I spent a considerable amount of time formatting spreadsheets before printing. 
In class we went over the steps it takes to automatically scale a spreadsheet to fit within a certain number of pages, either wide or long.  You simply go into the page setup, click on the page tab and fill in the number of desired pages you would like it to fit into, wide and/or long.
Not only is it important to fit within a certain width or length, but it is nice for the data to have appropriate spacing within the columns.  Thus, another skill that goes along with the printing set up is the width of the columns.  Often times the spreadsheet may have plenty of room in landscape mode (click here for directions to setup page orientation) for the columns; however, it may not look the nicest.  Sometimes the information is squished into tiny columns when it does not need to be.  This is when you can go back to the spreadsheet and double click the right side of the column.  Excel automatically adjusts the width to the needed width to display the data.  This was always an important trick when I was getting ready to print spreadsheets.  It makes the data look more presentable. 
Thus, not only is it important to know how to put together a great spreadsheet, but it is also important to know how to format it for printing in the best possible way.

No comments:

Post a Comment