Using Excel Templates When Organizing Your Personal and Business Matters
Using Excel Templates When Organizing Your Personal and Business Matters
By Tywan Miller
Templates are spreadsheets that are pre-formatted with text, colors, and/or formulas. They can be used to save you time and effort. Sometimes you are using a workbook as a template and don’t even realize it. By this I mean you have a spreadsheet that you use daily, weekly or monthly. You may have to modify a few cells but the remainder of the spreadsheet is exactly the way you want it. It may be tedious to modify the cells but it is easier than recreating it from scratch. Guess what, you have the basis of a template!
If you wanted to make this spreadsheet into template, you would need to take two more steps. The first step would involve modifying the spreadsheet to display only the data that remains the same. If you are constantly changing certain cells, you would leave these cells formatted but blank. The last step involves saving this spreadsheet as a template. Once this is done, you would always have access to a clean spreadsheet that is formatted the way you want and ready for your modifications.
Microsoft has hundreds of free templates available on their website http://office.microsoft.com/en-us/templates. You can also download templates that are already loaded in your version of Excel. They are typically located under the File/New or Office Button/New option. When downloading these business and personal templates, be sure to monitor the version of Office that the template applies to. They have templates available for all of the versions of the Office Suites.
Tywan Miller is a MOS instructor. She has trained and supported thousands of students across the US using the Microsoft Office Suite. She still does support from time to time. Visit my site http://www.myexceltemplates.com and harness power of utilizing excel templates in your daily business and personal life!
Article Source: http://EzineArticles.com/?expert=Tywan_Miller
http://EzineArticles.com/?Using-Excel-Templates-When-Organizing-Your-Personal-and-Business-Matters&id=2900008