Periodically, you will run into situations where the data you are working with needs to be rearranged in such a manner that the columns of data need to be the rows and the rows need to be the columns. Calc refers to this as Transposing the data. This is quite useful when the main focus of the data has changed from one aspect (the columns) to another (the rows).
Inputing a list of employees, their email address, phone number, etc. can be a lengthy task to do by hand if you are dealing with a large number of people. If all of them are currently members of your domain and you are using Exchange as your mail server then you can compile this list off of the Global Address List in minutes versus hours. Here’s how:
Page numbers can be an important aspect of a large report, especially if you will be utilizing a Table of Contents or Index for your report. It is also useful to the reader if they need to reference the document or refer someone else to information within the report. To add page numbers to your document, follow these steps:
In large spreadsheets, it is quite useful to include the columns and/or row headings on each page so that the user of the document can easily find the data they are looking for without having to refer to the first page to locate the proper headings.
Whether you refer to them as flash drives, USB drives, or pen drives, these portable storage devices can be both a blessing and a curse. More and more administrators are being tasked with preventing users from being able to copy important documents onto these drives to prevent loss of important data. To prevent a user from writing to USB drives attached to a computer running Vista, follow these steps:
By default, Outlook shows the Inbox when the application is launched. You may want to have it open up to your Calendar or Tasks (or possibly Contacts, Notes, Journal, or other folder). You can change the default opening folder and have the information you need when you open Outlook by following these steps:
If you are running Vista Ultimate on a domain, you will notice that Parental Controls is disabled by default. In order to utilize Parental Controls so you can limit access to the web, set hours that the account can access the computer, what games can be played and what applications can be run, you will need to enable this functionality. Parental Controls can only be applied to standard users, not administrators. To enable this Parental Controls on a domain computer, follow these steps:
Blank rows can be beneficial when it comes to making your spreadsheet easier to read, however if you are going to pull the data into another application (such as Access), the blank rows can cause you some problems. You could go through the painful task of selecting and removing these rows individually, but if you are working with a large spreadsheet, it could take forever to accomplish this. Instead, utilize Go To Special and let Excel do the work for you. Here’s how:
By default, PowerPoint ends your presentation with a black slide. If you would rather it end with your final slide, follow these steps and be rid of the black slide.
Don’t you hate it when you are printing out a large spreadsheet document and ed up having to sort through it to remove the empty pages? You can suppress the output of empty pages and avoid this unnecessary task by following these steps:
Free up room on your Task Bar by minimizing your Outlook to the System Tray.
At some point after installing OpenOffice.org, you may need to change the association of documents created by one (or all) of the Microsoft Office applications. This may be to open them in OpenOffice.org or in Microsoft Office, or some combination of the two.
1...483484485...501Page 484 of 501 error: Content is protected !!
