By Senior Instructor on
12/26/2008 9:37 AM
Do you want to quickly aggregate web content that interests you? Target articles with RSS (really simple syndication) feeds to stay on top of newly updated content without becoming overwhelmed with information.
Using a feed reader, you can easily navigate the familiar file tree structure to see the articles that most interest you. ...
Read More »
|
By Senior Instructor on
12/26/2008 9:33 AM
You know you want to hold a meeting exactly one week from today. You may type in the text “next week” in the "Start time" field and Outlook will automatically find the date one week out from the current date. You may also use the text “next month,” “next Friday,” etc to find additional dates.
|
By Senior Instructor on
10/20/2008 3:01 PM
Have you ever wanted to look at multiple, maybe non-consecutive dates in your Outlook calendar? You can access multiple dates side-by-side by clicking on the first date you want to see in the Date Navigator in the Navigation Pane in the upper left corner, and holding the Ctrl key + click on the other dates you want to see. The dates will appear in the Calendar window as separate days.
|
By Senior Instructor on
10/20/2008 3:00 PM
You’re working through your Inbox, and suddenly you need to look at your calendar or add a task list item. Often people click in the navigation pane to switch to the appropriate area. You can right click on any of the navigation buttons and right click on “Open in New Window” to keep each pane open on its own. You can select Alt-Tab to switch between windows.
|
By Senior Instructor on
8/18/2008 11:03 AM
Have you ever wanted to use text as a placeholder in a document to later replace it with a graphic you created? Here’s an easy way:
1) After you’ve completed it, place the graphic somewhere in your document (location is not important, as you will cut it from the document to place it on your clipboard).
Read More »
|
By Senior Instructor on
7/31/2008 6:43 AM
To have Excel move you to the cell to the right of the one you are working on, rather than the one below it, try this. Go to the Tools menu, and select Options. Hit the edit tab in the box. Below the "Move selection after Enter", go through the pull-down menu right by "Direction". Change this to "Right". Hit OK, and now you can perform data entry along rows instead of columns.
|
By Senior Instructor on
7/9/2008 12:51 PM
They are not words, but when spellchecking a document in Excel, uppercase acronyms often appear to be misspellings. To fix this minor problem without adding numerous words to your dictionary, you can simply click Tools, and select Options. When the menu appears, hit the tab marked "Spelling". Check the box next to "Ignore words in UPPERCASE", and hit OK.
|
By Senior Instructor on
7/9/2008 12:46 PM
Have you started a spreadsheet and then decided you wished your columns were where your rows were, and your rows were where your columns were? There is a much easier way to do just that, and WITHOUT retyping all the data you spent time recording. Simply select all of the cells you'd like to change (click on the upper left-most corner, then hold shift and click the lower right-most cell), and copy them (either through the edit menu, or by holding Ctrl+C). Click a new place on your spreadsheet and right click. Select Paste Special. A menu will come up, and by checking the box next to "Transpose" in that menu, Excel will paste in a rearranged chart for you!
|
By Senior Instructor on
6/5/2008 3:18 PM
When working with a large worksheet, losing sight of your headings can make it difficult to navigate your document. Luckily, Excel 2003 provides a helpful tool to solve this problem. To freeze your headings so they can be seen while you work on any other row in your worksheet, simply click on the row that is below your headings and select Window at the top menu, then Freeze Panes. You can also click the rows after the second one instead to freeze several of the first rows at once!
|
By Senior Instructor on
6/5/2008 3:15 PM
Sometimes the amount of data that needs to fit in a cell seems to be just too much. If you need more space, try this tip! Type up all the data you want to be in that cell, hit Enter, and click that cell once more. Select Format, then Cells, then Alignment. Select Wrap Text. Hit OK. Everything fits!
|