« Community | Home | Creativity »

Archive for the Computer Tips Category

11 Tips for Creating Tables in Word

Posted on Tuesday, October 04, 2005 at 8:59 AM by Ian McKenzie
Microsoft Word tables may be the unsung hero of the document formatting world. Simple and straightforward or slick and sophisticated, Word tables let you arrange your thoughts and data in ways that make sense to the people you're trying to reach.

A table's function is to convey—in as few words as possible—the important points your readers are looking for. The key objectives of your proposal will look great in a table; your entire Web page can be built in a table; your sales projections for 2003 can be prettied up; and your primary research factors can be introduced in a table.

Use these 11 tips—ranging from simple to sophisticated—to help get started showing off your data in a new, tabular way. [Katherine Murray]

MS PowerPoint Tips

Posted on Thursday, September 29, 2005 at 4:16 PM by Ian McKenzie

at WorldStart.com

Some titles:

  1. First - Last - First - Last
    A few key strokes can save time when navigating a Power Point presentation
  2. PowerPoint Peek-A-Boo
    Learn how to hide slides that you don’t want to display in a presentation.
  3. Agenda Slides In MS PowerPoint
    Have you ever found yourself creating an agenda slide for a presentation you’ve just completed? Want to save a lot of time?
  4. Spiffy PowerPoint Handouts
    Have you ever given a presentation in MS PowerPoint and found yourself wishing that you had an easy way to put together a handout for your audience to follow? Make beautiful handouts of your own.

read them all

Categories: , ,

Computer links from Lifehacker

Posted on Tuesday, September 27, 2005 at 2:29 PM by Ian McKenzie

Creating PDF's

Posted on Thursday, September 22, 2005 at 11:20 AM by Ian McKenzie

Adobe's pdf format has become the standard for exchanging documents, both on and off the web. However, Adobe's software for creating pdf's can be pricey for some users. There are a number of free alternatives out there and in this week's Office Letter lists user-suggested free software for creating pdf's.

Powerpoint Tips

Posted on Tuesday, September 20, 2005 at 11:27 AM by Ian McKenzie

Loose Links

Posted on Saturday, September 03, 2005 at 5:38 PM by Ian McKenzie

Loose Links

Posted on Friday, September 02, 2005 at 11:37 AM by Ian McKenzie

Sizing rows and columns in Word

Posted on Tuesday, August 30, 2005 at 8:35 AM by Ian McKenzie

If you work with tables, here are some column-sizing tricks that you should know:

  • Ctrl + drag a column's right border to resize the column and proportionately resize all columns to the right
  • Shift + drag a column's right border to resize that column only. All columns to the right stay the same size.
  • Ctrl + Shift + drag a column's right border to resize the column and resize all column's to the right to be the same size.
  • Alt + drag a column's right border to size the column without snapping to the ruler increments. This trick also shows column widths on the ruler. If the ruler is not displayed, select View/Ruler.

You can also use the Alt key in combination with any of the first three Ctrl and Shift tricks. Press Alt with Ctrl or Shift or Ctrl + Shift and you'll resize the columns without snapping to the ruler increments. And if that's not enough, right-click the table, then select Table Properties. There are plenty of options in there to keep you busy.

Selecting

You need to know how to select 3 things in a table: columns, rows and the table. Two of those (columns and the table) have shortcuts.

Three shortcuts for selecting columns and tables:

  • To select a column, Alt + click any cell in the column or press Alt + Shift + Page Down.
  • To select several contiguous columns, Alt + click one column, then drag.
  • To select a table, Alt + double-click any cell in the table or press Alt + 5 on the keypad with the Num Lock turned off. (Weird shortcut but I use it.)

Learn these and you'll never go back to clicking the down arrow at the top of a column or selecting Table/Select again.

To select row, use one of the following:

  • Click in the margin to the left of the row. (The pointer should turn into an arrow pointing right.)
  • Press Alt + Shift + End.
  • Click in the first cell of the row, then drag across to the last cell.
  • Click in the first cell of the row, then hold Shift while pressing End, End, End until the entire row is selected.

Using templates in MS Office

Posted on Tuesday, August 23, 2005 at 8:57 AM by Ian McKenzie

Stephanie Krieger's article, "Design Your Look: 5 More Ways to Customize the Way You Work," gives some tips on creating your own templates in MS Office products.

  1. Create Templates in Word
  2. Create Design Templates and Customize Masters in PowerPoint
  3. Create Templates and Set Up Styles in Excel
  4. Create Your Own Stationary in OneNote
  5. Get Customizable Templates at Office Online
Tags: , , , , ,

Back up your data

Posted on Tuesday, August 16, 2005 at 10:08 PM by Ian McKenzie

A few years ago I was involved in a fund-raising project. We were selling a cold-cut and salad lunch that would be delivered to the buyer before noon on a particular Saturday. Being the geek on the committee, I was tapped to created a database that would produce the delivery schedules for the volunteer drivers. On the Friday evening before delivery day, I booted up to add the final addresses and print the delivery routes for the almost 2,000 dinners we had sold. Imagine my dismay on discovering that several weeks of data entry had "disappeared" from the hard drive and this geek had not kept a backup! It took four of us all night to reenter the data in time for the morning deliveries.

I learned an important lesson that night, data can and will fail at the most inopportune times. Backing up data is important. There are some steps you can take to make the backup process a little more secure and a little easier.

  1. Take advantage of the corporate network. In most cases, if you are working with a company network (LAN), there will be an automated backup schedule in place. Keep necessary files on the network. That way, if something becomes corrupted on your computer or it fails altogether, your files can be recovered from the LAN backup.
  2. Use a "belt and suspenders" approach to file backup. If your company/career-changing presentation is on the server and it fails, you had better have a backup backup plan. Don't rely solely on your network. The network can crash, the person responsible for changing the media might forget and so on and so on. Use local drives to create a second copy: CD ROM USB drives, etc.
  3. Schedule your backup. Take advantage of the automated scheduling and synchronization functions of you computer's OS. Use these, or third-party utilities to move your data someplace safe.

This only scratches the surface of options available to protect your data. With only a few simple steps, you can avoid a major data loss.

Ergonomics: Safe Computer Use Tips

Posted on Tuesday, August 09, 2005 at 10:30 AM by Ian McKenzie

As we use computers for longer hours every day, we may notice increasing aches and pains in some parts of our bodies. These musculoskeletal problems can happen in anyone who uses a computer for long hours. The problems can range from minor muscle aches that last less than a few hours to persistent tendon problems that can last for years. The more severe problems can lead people to leave a job they like or stop doing sports activities they enjoy, like tennis or bicycle riding. So we should do what we can to prevent the minor aches of work from progressing to disabling conditions.

The most common body areas to watch for are the hands, wrists, elbows, shoulders and neck. The problems may vary from aches to pain, burning, numbness or tingling. These symptoms may be felt during typing or mouse use or at other times when no work is being done, including during the night when the symptoms might wake you up. If you experience these symptoms, or other persistent or recurring pain that you think may be related to using a computer, you should see a qualified physician. The earlier a problem is properly diagnosed and treated, the less chance there is that it will progress to a disabling condition. Now, having said that, you should know that most often these problems are not serious and will go away with a little attention to the way you work.

Point 1. When working on the computer for long hours, pay attention to tension, discomfort or pain you feel and take immediate action to relieve it.

Point 2. Make sure you stand up and walk away from your computer on a regular basis. Just walk around for a few minutes, stretch, and relax. This should be done at least every hour. Use a timer and get away from your computer every 20 to 30 minutes.

The greatest risk for these problems occurs when people use computers intensely for long hours and work in poor postures. Ergonomics is the study of understanding the limitations of the human body in order to design productive and comfortable workplaces, tools and work tasks.

Figuring out how to properly set up your workstation, chair, monitor, keyboard and mouse can be a complicated task because when you adjust one thing, like the height of the chair, it can effect something else, like your wrist angle. The goal should be to adjust everything so that your body is in a comfortable posture that you would not mind being in for hours. You would not drive a car without adjusting the seat and mirror. Likewise, you should not drive the computer without adjusting it to your body. Here is an overview of how to adjust your workstation:

Point 3. Adjust you chair so your feet and back are firmly supported by the floor and seat back. You should lean back in your chair a little. Arm rests can be a nuisance; they can press on the elbow or prevent you from pulling your chair forward.

Point 4. Position the monitor so the top is about at the level of your eyes and it is straight in front of you. It should be about an arm length away. If it is difficult to see the small characters check the glare, monitor resolution, or your eyes. You may need glasses (bifocals can be a problem). You should not have to lean forward to see your work. If you are frequently reading from books or papers when using the computer, use a sturdy document holder set next to the monitor.

Point 5. The keyboard should usually be at a low height, near the height of your elbows and the mouse or trackball should be right next to the keyboard. They can be higher if you have a padded surface to rest your forearms on. I am not a big fan of wrist rests; the wrist is a sensitive part of the body and it should not be constantly resting on something. Having to continuously reach for the keyboard or mouse may lead to shoulder pain. If you have to reach for the keyboard or mouse (for example with a high desk surface), rest your arms in the middle area of the forearms. Generally the keyboard should be flat so that the wrists are relatively straight.

Point 6. Try a different keyboard, mice and trackball -- there are many alternative designs on the market and it is up to you to find the one that works best for you. Some people find using the mouse uncomfortable. They can try using the mouse with their other hand or try switching to a trackball.

Finally, the stresses of work can make aches and pains worse. Ideally, you should try to set up your work so you can control the pace and flow of your work, so that you can take a break when you need to and not feel like you have to work through your coffee break or lunch breaks. As mentioned, get away from the computer for a few minutes regularly.

It's Your Body

Long hours on the computer can be rewarding, even fun, but they can also lead to aches and pains in your neck, shoulders, arms and hands. If you ignore these aches and continue working with improper work habits you may develop painful and disabling injuries.

You may have heard of some of these musculoskeletal problems: tendinitis, carpal tunnel syndrome, and other health problems referred to as repetitive strain injuries (RSI) or cumulative trauma disorders.

Why some people develop these problems and others do not may be due to things like our age, physical conditioning, medical conditions (e.g., pregnancy, diabetes), hobbies (e.g., musical instrument use, weight lifting), and our ability to relax and get along with co-workers and supervisors.

But they also can be brought on by long uninterrupted hours at the computer, especially under stressful work conditions, using improper work habits and improper postures. Although setting up your computer may seem intuitive and as simple as pulling up a chair and reaching for the mouse, it takes deliberate effort to use your computer properly.

originally posted: February 11, 2003

MS Word Tips

Posted on Saturday, July 30, 2005 at 3:36 PM by Ian McKenzie

You can quickly create a new folder inside the current folder for one of your Word documents without leaving the program. For example, if you produce a Word document in a certain folder, but you prefer to save it in a new folder, choose File, Save As. When the Save As dialog box opens, click the Create New Folder button in the Save As toolbar (it is the fifth button from the right).

Name your new folder and click OK. Now you can name your file and click Save to save it in the new folder.

When you want to find a specific word in a Word document, you can press Ctrl-F to open the Find And Replace dialog box. Then you type your word and click Find Next.

If you would like to locate all occurrences of the same word without having to leave the Find And Replace dialog box open, you can just click the double down arrow at the bottom of the scroll bar. This takes you down the page to the next occurrence of the word you entered in the dialog box. You can repeat this until you have located all occurrences.

If you want to search from the current point upward, click the double up arrow.

There is an easy way to make a document fit on a single page, for those times when you’ve edited the text as well as you could and even reduced the font, but the document is still too long.

Word has a Shrink To Fit option. Run Word and load your document. Now choose File, Print Preview. When the Print Preview window opens, click the Shrink To Fit button in the toolbar (its icon is two pages with an arrow pointing at a single page).

This method works very well, as long as you don’t have too much extra text. If you don’t like the looks of the change, press Ctrl-Z to undo it.

When you want to work with an important Word document and you don’t want to take any chances with it at all, you can simply open a copy and work with the copy. This leaves your original document intact

To do this, open Word and choose File, Open. When the Open dialog box appears, right-click the file you want to open and choose Open As Copy. Word opens a copy of the file. You will notice in the Word title bar that the file is named Copy Of Myfile.doc (where Myfile.doc is the name of your document).

Powerpoint 2000 tips

Posted on Tuesday, July 26, 2005 at 9:07 AM by Ian McKenzie

Microsoft PowerPoint® 2000 tips and tricks were submitted by Office users.

Quick-Start Your PowerPoint Slide Show

From Bradleigh Young, United Kingdom

Want a quick and easy way to launch a PowerPoint presentation? Save it as a PowerPoint slide show file, and when you double-click it, it opens right up in slide show view. No need to fumble around inside PowerPoint when you just want to give a presentation, not create one.

To save your presentation as a slide show file:

1. Open the presentation you want to save as a slide show.

2. On the File menu, click Save As.

3. In the Save as type list, click PowerPoint Show. Your slide show file will be saved with a .pps file extension.

When you open this file from your desktop, it will automatically start your presentation in slide show view. When you’re done, PowerPoint automatically closes and you return to the desktop. If you want to edit the slide show file, you can always open it from PowerPoint by clicking Open on the File menu.

More Ways To Quickly Start A PowerPoint Slide Show

In response to Bradleigh Young’s tip (above), several others wrote in with even more ways to quickly start a PowerPoint slide show.

From Sandy Bennett, Phoenix, Arizona

In Microsoft Windows® Explorer, simply right-click any PowerPoint presentation and then click Show to start the show.

Right-click your PowerPoint presentation to start the show

From Giovanna Martini, Waterfront, South Africa

A quick and easy way to turn a PowerPoint presentation into a slide show file is to simply rename the file extension from .ppt to .pps in Windows Explorer. Now you can launch it in one click!

Tweak the Layout of PowerPoint Slides

From Jeff Branzburg, New York, New York

When I need to fine-tune the placement of a graphic or text box on a PowerPoint slide, I use the arrow keys. Here’s how you do it:

First select the graphic, then simply press the UP, DOWN, LEFT, or RIGHT arrow keys to move the graphic in the desired direction.

Tweak the Placement of a Graphic in PowerPoint, Part Two

From Evelyn Moriarty, Blackwood, New Jersey

Here’s a way to move things in even smaller increments:

1. Select the graphic or text box.

2. Press and hold down the CTRL key.

3. Use the arrow keys to move graphic or text up, down, right, or left.

You will notice that you have more precise control over how far the image moves.

Take a Break During a PowerPoint Slide Show

From Joanne Briggs, Sunnyvale, California

Here’s an easy yet very useful tip for those who give presentations using PowerPoint slide shows.

When you want to stop for a break in your presentation without losing your place in the slide show, just press the lowercase B key or press the PERIOD (.). This will make the screen go black, and if it is a self-running presentation, it will pause. When you are ready to resume the show, press either key again, and you will start right where you left off.

Ten Favorite PowerPoint Shortcuts

From Tiago de Moraes, Fairborn, Ohio

Here are some easy ways to make your PowerPoint slide show go smoothly:

TO PRESS

Advance to the next slide

N, ENTER, PAGE DOWN, RIGHT ARROW, DOWN ARROW, or the SPACEBAR (or click the mouse)

Return to the previous slide P, PAGE UP, LEFT ARROW, UP ARROW, or BACKSPACE

End a slide show

ESC or HYPHEN

Stop or restart an automatic slide show

S or PLUS SIGN

Go to slide

+ENTER

Display a black screen, or return to the slide show from a black screen

B or PERIOD

Display a white screen, or return to the slide show from a white screen

W or COMMA

Hide the pointer

CTRL+H

Redisplay hidden pointer and/or change the pointer to an arrow

CTRL+A

Return to the first slide Both mouse buttons for 2 seconds

Apply Transition Effects to Multiple PowerPoint Slides

From Bev Davis, Lake Oswego, Oregon

Here’s a shortcut that enables you to apply the same transition effect to multiple slides at once:

1. On the View menu, click Slide Sorter.

2. Select the slides you want to apply the transition effects to by clicking one slide, and then holding down the CTRL key while you click each additional slide.

3. On the Slide Show menu, click Slide Transition.

4. In the Effect box, click the transition you want, and then select any other options you want.

5. Click Apply.

Now your slide show has a consistent, seamless look.

Creating a Summary Slide in PowerPoint

From Rick Borzymowski, Ann Arbor, Michigan

You’ve just created a quick PowerPoint presentation, but you haven’t added an introduction, agenda, or conclusion. PowerPoint provides a quick method of adding a Summary Slide to your existing presentation. This slide can be renamed Introduction or Agenda, or you can copy it to the end of your presentation and rename it Conclusion or Review.

To create a summary slide from the titles of other slides:

1. Open the completed presentation you want to add a summary slide to.

2. On the View menu, click Slide Sorter.

3. In slide sorter view, select the slides with the titles you want to use. To select multiple slides, hold down CTRL and click the slides you want. (Be sure to select the slides that will best summarize your presentation.)

4. On the Slide Sorter toolbar, click Summary Slide. A new slide, titled “Summary Slide,” with bulleted titles from the selected slides, appears in front of the first selected slide.

5. Double-click the new slide to edit it. You can change the title, edit existing bullets, or add new ones.

Display Shortcuts During a Slide Show

From Iman, Jakarta, Indonesia

If you need quick access to keyboard shortcuts during your PowerPoint slide show, press F1 (or SHIFT+?) and Slide Show Help will display automatically.

Slide Show Help menu in Microsoft PowerPoint®

Keep Track of Action Items During a Slide Show

From Jennifer Phinney, Falmouth, Maine

When giving a presentation, have you ever needed to make a list of ideas, comments, suggestions, or action items? Instead of using a flip chart, use PowerPoint. Here’s how:

1. In Slide Show view, right-click anywhere in the slide, and then, on the shortcut menu, click Meeting Minder.

2. Click the Action Items tab.

3. Type your information into the Description, Assigned To, and Due Date boxes, and then click Add.

4. Repeat step 3 if you want to add more action items, and then click OK.

Your items appear on a new slide at the end of your slide show. You can use this slide as a way to review the ideas or suggestions that came up during the slide show or as a reminder of the action items that need to be addressed.

Meeting Minder dialog box with assigned action items

Editor’s Note: You can export your action item list to Word or Outlook. Here’s how:

1. On the Tools menu in PowerPoint, click Meeting Minder.

2. In the Meeting Minder dialog box, click Export.

3. To create a new Word document that contains your list of ideas or action items, select the Send meeting minutes and action items to Microsoft Word check box.

4. To place them on your task list in Outlook (and assign each task to the appropriate person later), select the Post action items to Microsoft Outlook check box.

5. Then, click Export Now.

Konfabulator is now free

Posted on Monday, July 25, 2005 at 9:59 AM by Ian McKenzie

Yahoo has acquired Konfabulator and made it a free download. I played with this program before, but never felt it warranted parting with hard-earned money. I no longer have to. It’s free and it’s installed. ;)

Lotus Notes Tip

Posted on Tuesday, July 19, 2005 at 11:29 AM by Ian McKenzie

You can create numbered lists within lists. To do this, enter the sublist with the first list, then select it and press F8. This indents and numbers the sublist within the main list. You can also do this on the fly by pressing F8 at the line you with to indent. Pressing Shift+F8 will return you to the previous level.

Tags: ,

« Community | Top | Creativity »