August 30, 2011

Microsoft Office - Turn on the Clipboard Pane

Did you know that you can turn on the clipboard pane in Microsoft 2007 Word, Excel and PowerPoint?  

We all know about the CTRL+C, CTRL+V trick, but did you know that you can turn on the clipboard feature in a full panel view and use it to speed up the copy, paste activity?  It is a great time saving tool to use when you are copying and pasting between programs.

To turn on the clipboard pane, click on the arrow on the Paste, Copy box on the Home Ribbon. 

August 25, 2011

HubSpot's Introduction to Search Engine Optimization

PLEASE read this booklet! It truly breaks my heart to see companies building web sites that do them absolutely no good. Sure that FLASH is cool. The programmer had a great time creating it. Yes, that design is hip, modern, ...  free.  But what is the web site doing for you?  The attached booklet is from one of the leading online firms who specialize in SEO. (YCL does the basics but SEO is an art form so we refer clients to specialists when needed.) Their simple, clear explanation of SEO and how it works is well worth your time. You will look at your web site with new eyes!

HubSpot's Introduction to Search Engine Optimization

How to Customize Views In Outlook

( versions 2003 & 2007)

One of the advantages of using Outlook is that you can customize any View of the various modules to fit the way you work.  In Mail, Contacts and Tasks, most of your Views are in columns. Remember that each View can be customized. For example, in Mail, I can customize the View for a client folder, the Inbox folder, the Sent Items folder or even the Deleted Items folder. (Though why you should need to view Deleted Items is beyond my comprehension. They’re trash! If you are using Deleted Items as a storage folder, we need to talk.) Here are the steps to customize the View. I’m going to use a Mail folder in this example but the process is the same in Contacts or Tasks.

In the Mail module,
  1. Select the folder you want to customize. I’m going to customize Sent Items.
  2. Go to View on the menubar > Arrange By > Custom
  3. Click on the Fields button in the Customize View window. 
  4. Select available fields from: Use the drop-down menu to choose the type of fields you want to choose from. The default is “Frequently used fields” which may be just what you need. 
  5. Available fields:  This is a list of all of the fields available to use. So if I chose “All Mail fields” in the step above, I would see all of the mail fields in Outlook.
  6. Click the field you want to include in your view. I’m going to select the “To” field since I want to see who I sent the email to.
  7. Click the Add button in the center of the window to add the field to the Show these fields in this order: list on the right side of the window.  This adds the “To” field to the bottom of the list.
  8. Select the new field (the “To” field) then use the Move Up or Move Down buttons to place the field in the order you want. I would like to see the “Sent date” then the “To” field then the “Subject” field in my custom view.
  9. Select and use the Up and Down buttons to arrange all of the fields as you want them.
  10. Click the OK button in the bottom right corner of the window.
  11. Click the OK button in the bottom right corner of the Customize View window.
Now when I look at my Sent Items folder, I see the fields I need in the order that I want them.

Note that you can click on any field heading to sort the data by that field. In other words, I can click on the “Sent” heading to sort all of the emails by the sent date. Or I could click on the To heading to sort all of the emails by the email address I sent the message to.

Microsoft PowerPoint 2007 - Adding Hyperlinks


Microsoft PowerPoint 2007 allows you to add hyperlinks to your slides. All you need to do is to click on the "Insert Tab" and add the hyperlink.

When you are in Slide Show mode, you can now click on the link to test it.

August 22, 2011

6 Useful Windows tricks

What a great article I found on Microsoft Office at Home website.  It is definitely worth reading. 

You know that feeling you get when your friends or family see you do something on your computer that they've never seen before? If you’ve had this experience, you know that “world's coolest power-user” feeling. But if you haven’t, start here. Knowledge is power! 

Read these six tips for Windows 7, Windows Vista, and Windows XP that will keep you schoolin' your friends and family.

Click here to read the article. 

August 19, 2011

Increase Text Size on Web Pages Quickly

Have you ever had trouble reading text on web pages?  Did you know you can increase or decrease the size of text?   Well you can. 

To increase and/or decrease the text size on a web page, hold down your control button on your keyboard and use your mouse scroller at the same time.  What watch happens to the size.

Amazing!

August 18, 2011

Should You Let Your Employees Work from Home?

Humorous but profound schematic to determine if you should let employees work from home.

Mindflash infographic

Your Computer Lady is a big proponent of working from home. I've done it (most days successfully) for 15+ years. Many of our clients work from their home. With today's technology and a little bit of training, many employees can work from home and be more productive. It does take some adjustment on the part of the employer and the employee.

The employer has to be flexible and cooperative with the employee. There's no need to get upset when the phone isn't answered at 2:30 pm if you know the employee has car pool duty at 2:30 each afternoon. Plan around that.

The employee has to be self-disciplined to stay on target and focused on the details to maintain quality and the appropriate quantity of work.

One key for success is computer skills training. When you are on your own, you need to know how to do your tasks efficiently and effectively. You don't have a co-worker to call over to your desk for tech support. There isn't an IT person to call. So the work-from-home employee has to take charge of their own training and be sure they stay up to date.

There are plenty of tools:
  • Online classes like our Wednesday Call Solutions.
  • Reference books like the Dummies series.
  • Library or community college classes.
  • In house training. It's an opportunity to gather everyone in one spot for some office bonding as well as updating skills.
But overall, it's a great way to work where the advantages outweigh the disadvantages.

August 17, 2011

Microsoft Word 2007 - Inserting a Screenshot in Your Document

In Microsoft you have the ability to capture screenshots. That means you can capture images from you screen and insert them directly into your Word document. This is particularly useful if you're creating technical documentation.

To capture and insert a screenshot in your document, follow these easy steps:

  1. Click Shift+Print Screen.
  2. Position your cursor where you would like to insert the screenshot
  3. Click Control+V to paste the image

August 11, 2011

Microsoft Office- Pin Recent Presentations, Spreadsheets and Word Documents

Have you noticed that the most recent files are always listed in the Microsoft Office button?  However, they get over written every time you open another one. So if you want to make a file show up permanently in the recent menu, click on the pin button next to file name when you click the Microsoft Office Button.

I use this and it really saves me a lot of time.  Try it!

August 9, 2011

File Organization Tips: 9 Ideas for Managing Files and Folders

The tips in this article can help you master file management by supplying some tips to help you better manage and organize computer files. After you’ve decided on a strategy for organizing and managing files and folders, we bet you’ll see improved time management skills and increased productivity.

Click here to go to Microsoft at Work to continue reading this article.  

August 4, 2011

Word 2010 Keyboard Shortcuts

No matter how often you use Office applications, no one knows ALL of the keyboard shortcuts  Click here to look at these keyboard shortcuts for Word 2010.

August 3, 2011

Keyboard Shortcuts For Excel 2010

This article describes what Key Tips are and how you can use them to access the ribbon. It also lists CTRL combination shortcut keys, function keys, and some other common shortcut keys for Microsoft Excel 2010.

To read the full article, click here.  

August 1, 2011

New Sections for Your LinkedIn Profile

Thanks, Peter Newton with Romanoski Co Inc, for the heads up on some new profile sections LinkedIn has made available. You can now add Honors and Awards, Projects, Publications, Languages and 5-6 other new sections to your profile. This is a great way to build your expertise.

In LinkedIn, go to Edit Profile. You see a link to the new sections just above the Summary section. Click the link then select the section you want to add. The individual sections have fields to help you as well as a description field to expand on the entry. Be sure to use your keywords!