| Banner/BannerWeb |
A a faster way to look up past purchases
Do you need to look up a purchase, but don’t know the PO number?
Go to Bannerweb and click on the finance section.
Click view document and click document number (leave the box blank)
This brings you to a search page where you can search for ever purchase made in the past month, year, of forever.
Submitted by Joanne Hathaway. |
| E-mail |
To send a message to someone without other recipients of the message knowing, use the Bcc line in the message. Bcc stands for blind carbon copy. If you add someone's name to the Bcc line, a copy of the message is sent to that person, but his or her name is not visible to other recipients. |
Want to permanently delete an email message without sending it to the trash first? This tip is great for junk mail, so it stops wasting space in your deleted mail.
In WebMail, check the box next to a message you want to delete, and from the Action menu choose Expunge.
In Outlook Express or Thunderbird on Windows, you can permanently delete a message by holding the Shift key while deleting a message. |
Mozilla Thunderbird has a few features other email programs do not. These include integrated calendar, accessing multiple accounts in one screen, and a live-address book that allows easy searching for other users. If these features would help you work better, the Help Desk can switch both Mac and PC users to this software. |
| Internet Browsers |
Find the date of the website you are viewing was last updated.
Determine the exact date and time when a website was last updated or modified by inserting the below string into the address bar.
javascript:alert(document.lastModified) |
In Internet Explorer or Firefox you can use the print button on the toolbar to print the page you are viewing. However this will not allow you to choose any print options and will print with your normal defaults. To chose your print options use the Print option from the top menus. |
Deleting Auto-Fill Entries in Firefox
If you are using the Firefox browser, you follow the same steps except that you hold down shift while pressing delete in the third step. And that's it - it's that easy to remove unwanted entries from your auto-fill options. |
Removing Auto-Fill Options in Internet Explorer
In the Internet Explorer browser, all you need to do is:
Double-click in the text field so the drop-down box of auto-fill options appears.
Hold your mouse over the option that you want to remove from auto-fill so that it's highlighted. Don't click on it.
Press your delete key. The option should be deleted from your auto-fill. |
Keep the clutter down. Instead of having multiple browser windows open, you can now have multiple tabs inside one window. In Mozilla Firefox, simply click on File - New Tab, or use the keyboard shortcut Ctrl + T. |
| Multimedia |
Find yourself switching between Full Screen and Window mode in a program like Windows Media Player? The ESC key can usually be used to turn off Full Screen Mode. The shortcut Alt + Enter also will toggle Full Screen mode on and off. |
| Operating Systems |
If you want to select multiple files that are together, click the first file, then hold Shift, and click the last file. All files in between will be selected as well.
If you want to select multiple files that are spread out in one folder, hold Ctrl as you single click on each file. |
Using Windows, you can put your most often used programs in the top of the start menu so they are easily accessible. Open the start menu and find the program you'd like to access, right click that link and choose Pin To Start Menu.
If you want to remove a pinned program, right click on it and choose Remove from Start Menu |
| Productivity Suites |
If you hold down the Shift key while selecting the File menu in Word (or in Outlook when composing a message), the menu options change. You get handy options to Save All and Close All open files. In Excel, you get a Close All but not a Save All option. |
In Excel, pressing Ctrl and then the ' key will copy the contents of the cell above the current cell. |
A spectacular yet underused feature is Word's ability to display two different parts of a document at the same time. To do this, you can either select the Split option from the Window menu to display a dividing line in the current window. |
In Excel you can press Alt-Enter to start a new line within a cell. |
Do you want to keep the column headings visible on each page when printing Excel?
1. Go to the page layout tab and select Print Titles.
2. Under rows to repeat at top Select the row containing your column headings. |
Introducing the Mini-Toolbar.
Did you know that you can use the mini-toolbar in Microsoft Outlook, Word, Excel, PowerPoint, and Access 2007 to quickly format text? Select the text you want to change, and the mini-toolbar appears. When you've finished, the mini-toolbar goes away. |
If you often copy and paste by going to the menu, and clicking through Edit - Copy, Edit - Paste then you'll find it much faster to use keyboard shortcuts
To Copy, highlight what you'd like to copy, hold the Ctrl key, and press c. Release both buttons.
To Paste, put the cursor where you would like to paste, hold the Ctrl key, and press v. Release both buttons. |
In Microsoft Word, you can hit Ctrl+s to save your work at any time. |
You've probably noticed that Word completes certain phrases, such as "Best Wishes," before you've finished typing. You can customize this list so that Word completes only the phrases you define. Select AutoCorrect Options from the Tools menu, then go to the AutoText tab. Delete any items you don't want to keep, then add names and phrases that you type often, such as your name, company, or address |
Keyboard shortcuts in Word.
To move to the previous or next word, press Ctrl+Left Arrow or Ctrl+Right Arrow. To go to the beginning or end of a document, press Ctrl+Home or Ctrl+End. |
The AutoCorrect feature in Office can automatically place symbols in your documents. Here are some of our favorites. (c) will do this: © (r) will do this: ® (tm) will do this: TM |
Creating an Excel Chart in a Few Easy Steps
1. Using your keyboard select the data you want to plot.
2. Press F11 and Excel will automatically create a chart for you. |
In Microsoft Word, you can easily change the font and presentation of your text by highlighting the text you want, right clicking, and then selecting "Font." |
Change the case of text in Microsoft Word
1. Select the text you want to change and press SHIFT+F3.
2. Each time you click F3 the text case switches between Title Case, UPPERCASE, and lowercase. |
Format on the fly with keyboard shortcuts.
Select text and hit Ctrl-B to bold, Ctrl-U to underline, Ctrl-I to italicise, Ctrl-[ and Ctrl-] to change font size, or Ctrl-Shift-A to toggle between CAPS and lowercase. |
| Shortcuts |
It is possible to take a picture of your computer screen and insert that picture into Word, PowerPoint, Excel or any other program that accepts image files. *be careful what you capture and email to people. Email is not a secure way to transfer confidential information.*
Windows
Hitting the print Screen button will take a picture of your entire desktop
Hitting ALT Print Screen captures just the active window you are work in.
Try hitting print screen, opening Word and hit the past button.
Check out the help sheet on capturing
Mac
Shift-Command-3 Capture the screen to a file
Shift-Control-Command-3 Capture the screen to the Clipboard
Shift-Command-4 Capture a selection to a file
Shift-Control-Command-4 Capture a selection to the Clipboard |
Windows 7, To open multiple sessions of a program, like Word, hold down the shift key and click the program on your task bar. |
Can't find a file? Windows
(Windows – F) Press and hold the Windows key and hit f on the keyboard to bring up the search box. Here you can search by title or words contained in the body of a document. The Windows key located by the left alt key.
Mac
Option-Command-F Press and hold all three buttons until the search box comes up to navigate to the search field in an already-open Spotlight window. Here you can search by title or words contained in the body of a document. The Option and Command buttons are located to the left of the space bar. |