Microsoft Word 2007 - Print Out Short Cuts

There are so many commands and shortcut keys in Word 2007 that nobody can be expected to remember them all. Fortunately, you can print a list of Word's shortcut keys. This will help you when you're struggling to find a command.

To print Word 2007's shortcut keys, follow these easy steps:

1. Click Ctrl+P to open the Print dialog box

2. Find the drop-down box labeled Print what

3. Select Key Assignments

4. Click OK to print your list of shortcut keys.

Using Pinterest for Vision Boards / Business Plans

Here is a unique idea. This could be very powerful for those of you who are “visual” people. Or those of you who lead visual people.

 How to Create a Vision Board for Business Ideas on Pinterest by Nadia Goodman for “Entrepreneur”

13 Killer Excel 2007 Shortcuts

Here are some great Excel 2007 shortcuts published by PCMagazine.com

• Apply the outline border to the selected cells - Ctrl-Shift-&
• Apply the Date format with the day, month, and year - Ctrl-Shift-#
• Apply the Time format with the hour and minute, and AM or PM - Ctrl-Shift-@
• Enter the current time - Ctrl-Shift-:
• Enter the current date - Ctrl-;
• Hide the selected rows - Ctrl-9
• Hide the selected columns - Ctrl-0
• Alternate between displaying cell values and displaying formulas in the worksheet - Ctrl-`
• Display the Find and Replace dialog box, with the Replace tab selected - Ctrl-H
• Display the Insert Hyperlink dialog box for new hyperlink - Ctrl-K
• Display the Print Preview window - Ctrl-F2
• Switch to the next workbook window - Ctrl-F6
• Display the Macro dialog box to create, run, edit, or delete a macro - Alt-F8

Tips from Real Business Owners: Software and Hardware to Get the Job Done

We work outside the office more and more often these days. As Scott Schaefer of the B-Town Blog says in the video, "The modern workplace is essentially wherever you can get the Internet."

Read full article at Microsoft at Work.

Keep Your Eyes Healthy in the Digital Age

Whether it’s for work or play, people spend hours a day reading on e-readers, texting on smartphones, typing on laptops or playing on tablets. Technology has become so prevalent that we find ourselves sitting in front of some kind of screen every day. So what does this mean for your eye health?

There is no significant evidence indicating that frequent technology use causes any permanent vision damage. However, staring at a bright screen for hours on end can definitely lead to a number of smaller-scale problems over time.

Continue reading article by Dr. Roger Ethington, O.D. at GreenLiving.com

Get More From the Notes You Take Every Day and Everywhere

If you’re like most people, your notes can be essential parts of virtually any kind of project. You may take notes for brainstorming, planning, research, or reference. Essentially, your notes represent your ideas. But do you still take notes on a legal pad or type them as a simple text file?

Read full article at Microsoft at Work.

Microsoft Excel 2007 - Avoiding Hyperlinks

You may have probably noticed that when you type an email address or URL, Excel automatically converts the text into a clickable hyperlink. But what if you don't want to create a hyperlink?

By putting an apostrophe (') before the email or ULR, Excel will not create a clickable hyperlink.  For example, type 'www.yourcomputerlady.com. 

Try it!

Color will Make or Break your Next Email Campaign. Sound too Bold to be True?

When your email message is opened, you have a split second to make a good impression. Long before any of your words are absorbed, your reader sees the appearance of your email.

And color is the first thing that makes an impression. Will the impression be that your business is polished, professional, and trustworthy?

Or will the impression be that your business is scattered, disorganized, and hard to communicate with?

Read full article at Constant Contact.

10 Tips for More Effective PowerPoint Presentations

“Oh no! Not another boring PowerPoint presentation! My eyes, my eyes…!!!”

How much does it suck to be in the audience for yet another drawn-out, boring, lifeless slideshow? Worse yet, how much does it such to be the one giving it?

The truth is, bad PowerPoint happens to good people, and quite often the person giving the presentation is just as much a victim as the poor sods listening to her or him.

Here are ten tips to help you add a little zing! to your next presentation. They are, of course, far from comprehensive, but they’re a start. Feel free to share your own tips in the comments.

Read full article by Dustin Wax.

Microsoft Word - CAPS LOCK Answer

Have you ever had the CAPS lock key activated by accident?  You could retype the text, but that is time consuming. Fortunately, there is an easier way to change the font case in Word 2007.  Follow these steps:

1. Select the text you’d like to change
2. Click the Change Case button in the Font section of the Home ribbon.  You can select any of these:

• Sentence case   
• Lower case
• Upper case
• Capitalize each word
• Toggle case

Pictures, Links Most Likely To Be Shared, Say Social Media Buffs

When it comes to sharing content on social media, pictures and links get the nod over quotes and videos, according to survey results from SocialToaster. The company surveyed its “Super Fans,” a collection of social media experts and professionals, finding 90% agreeing that pictures were most likely to be shared, and 68% saying the same about links. Quotes (51%) and videos came in next (47%), with studies and statistics (20%) far behind.

Read full article.

Microsoft Excel - Shade Alternate Rows

Have you ever wanted to apply shading to a specific range of cells or your entire worksheet?  Follow these steps.  

1. On the worksheet, do one of the following:
• To apply the shading to a specific range of cells, select the cells you want to format.
• To apply the shading to the entire worksheet, click the Select All button.
2. On the Home tab, in the Styles group, click the arrow next to Conditional Formatting, and then click New Rule.
3. In the New Formatting Rule dialog box, under Select a Rule Type, click Use a formula to determine which cells to format.
4. In the Format values where this formula is true box, enter =MOD(ROW(),2)=0.
5. Click Format. 
6. In the Format Cells dialog box, click the Fill tab.  Select the background or pattern color that you want to use for the shaded rows, and then click OK.

Basics For Safer Downloading

Whenever you download a file—whether you open a spreadsheet attached to an email message, grab a cool little screensaver or mouse cursor from the web, or download music or video files from someone else's computer—you could be putting your computer at risk.

Continue reading this article at Microsoft at Work.