February 24, 2011

Microsoft Word 2007 - How to Add Horizontal Lines Quickly

Here are some quick ways to add different types of horizontal lines into your Word document. 

If you want to add a simple straight line, type three dashes (—) and press Enter on the keyboard.

Type three asterisks (***) and press Enter for a dotted line.

Type three underscores ( ___ ) and press Enter to get a thicker line.
Type three equal signs (===) and hit Enter to get a double line.
Three hash signs ( ### ) and press Enter to get a bold line surround by two thin lines.
Typing in three tildes ( ~~~ ) and press Enter to get a jagged line.

February 22, 2011

Microsoft Excel 2007 - Add Rounded Borders to Charts

Did you know that you can add rounded borders to your charts?

1. Right click on the chart

2. Select format chart option

3. In the dialog, check the “rounded borders”

This is just an quick and easy way to really customize your excel charts. Try it!

February 16, 2011

Microsoft PowerPoint 2007 – Useful PowerPoint Shortcuts

Below are some useful shortcuts you can use in PowerPoint.

Ctrl+B = Bold

Ctrl+I = Italic

Ctrl+U = Underline

Ctrl+L = Left justify the text

Ctrl+M = Insert New Slide

F5 = Begin the Slideshow

Ctrl+N = Open a new document

Ctrl+O = Open an existing document

Ctrl+S = Save a document.

Ctrl+A = Select All (used for cutting and pasting)

Ctrl+P = Print a document.

Ctrl+Z = Undo the last thing you did (if you typed something or deleted something, it will Undo it).

Ctrl+F = Will bring up a pop up window to help you find a word on the page. Simply type the word you are looking for and click Find Next

February 15, 2011

Save Time with Computer Shortcuts in Microsoft Office Programs

If you’re like most people, you’re always looking for ways to save time, even when using Microsoft Office software. Keyboard shortcuts could be your new best friend when it comes to time management.

Not everyone uses shortcut keys to save time, but some people find them easier to use than a mouse, especially when spending long stretches of time at the computer.

Ready-made Microsoft Office tools
If the thought of memorizing key combinations makes you wince, you can still save time and effort while working in all Office programs by using these built-in tools.

To continue reading this article, and find all the ways to save time, click here to go to Mircrosoft at Home website. 

February 10, 2011

Microsoft Word 2007 - How to Select Text Vertically?

Here is a really neat trick I just learned. Try it!

•  Point the mouse to the beginning of the text you want to select.

•  Hold down the Alt key.

•  Drag the mouse pointer downwards around the required area.

•  Select your type of format, bold, underline, italics, color, font, etc.

February 8, 2011

Microsoft Excel 2007 – Freeze Rows and Columns

When working with very large spreadsheets headings located at the top and down the left side of the worksheet often disappear if you scroll too far to the right or down. Without the headings, it's hard to keep track of which column or row of data you are looking at.

To avoid this problem Excel lets you "freeze" or lock specific columns or rows of the spreadsheet so that they remain visible at all times.

Freeze the Top Row

1. Click on the View tab.

2. Click on Freeze Panes from the ribbon to open the features drop
    down list.

3. Click on Freeze Top Row option in the list.

Scroll down through the worksheet. If you scroll far enough, the rows below row 1 will begin disappearing while row 1 will stay on the screen.

Freeze the First Column

1. Click on the View tab.

2. Click on Freeze Panes from the ribbon to open the features
    drop down list.

3. Click on Freeze First Column option in the list.

Scroll to the right in the worksheet. If you scroll far enough, the columns to the right of column A will begin disappearing while column A will stay on the screen.

To Unfreeze Columns and Rows

1. Click on the View tab.

2. Click on Freeze Panes from the ribbon to open the features
    drop down list.

3. Click on Unfreeze Panes option in the list.

New and Improved Web Site for ScottsdaleDesigner.com

Vicki Bergelt had a good web site but wasn't getting the search engine attention or traffic she wanted.  Your Computer Lady built a new site in WordPress. We retained the great design but made the site more consistent. We put Vicki's blog right on the site instead of it being a separate site. This pulls all of her traffic to one place which will in turn generate more traffic.

One powerful feature of the ScottsdaleDesigner site is the Glimpse page which includes a great photo gallery. Vicki's work as an interior designer is very visual. So the site had to show off her designs. The photo gallery we used allows us to show a lot of oversized thumbnails which open into full size photos. It's good software that Vicki can update on her own.

In fact, 90% of the site can be edited by Vicki at any time she wants. Structural or navigational work still needs to be done by a programmer. This is a big advantage of WordPress sites. The site owner or a non-HTML person can edit the site. It gives you the ability to keep the site fresh with new and changing content while keeping your programmer costs down.

Finally, we incorporated links to LinkedIn, Facebook and Twitter to encourage visitors to share the tips and information they learn from Vicki's site.

Check out Scottsdale Designer and the blog DesignGirlAZ

February 3, 2011

Microsoft PowerPoint 2007 – Make Your Text Stand Out

Looking for another way to make certain text stand out in a Microsoft PowerPoint 2007 presentation? With a few clicks you can make format your text to shadow, reflection, glow, bevel, 3D and transform.

1. Highlight the text that you want to stand out.

2. Click the "Format" tab in the Ribbon.

3. Click on the "Text Effects" pull-down.

This will help make some of your text “stand out” in your presentation.

February 1, 2011

10 Tips to Help Improve your Wireless Network

If the Windows operating system ever notifies you about a weak Wi-Fi signal, it probably means that your connection isn't as fast or as reliable as it could be. Worse, you might lose your connection entirely in some parts of your home. If you want to boost the signal for your wireless network (WLAN), try some of these tips for extending your wireless range and improving your wireless network speed and performance.

To read the 10 Tips, click here to go to Microsoft at Home.