If you need to add symbols such as a copyright symbol, trademark symbol, or registered trademark symbol to your Microsoft Word 2007 document, there are a few ways to do so, including the following:
Keyboard Shortcuts
The following keyboard shortcuts will insert special characters:
1. Copyright Symbol: Alt + Ctrl + C
2. Trademark Symbol: Alt + Ctrl + T
3. Registered Trademark Symbol: Alt + Ctrl + R
Ribbon
1. If you prefer to use the Ribbon or need to access other symbols,
do the following:
2. Click the "Insert" tab in the ribbon at the top of Word 2007.
3. In the "Symbols" group click the "Symbol" command.
4. A pop-up will appear, allowing you to select from several
frequently-used symbols.
5. If necessary, click the "More Symbols" button on the pop-up
to open the "Symbol" dialog box. Find the symbol you want
and click “Insert”.
August 26, 2010
Microsoft PowerPoint - Do the Research!
When preparing for a presentation, you often need to research facts and figures, as well as find quotes and opinions, before you draw your own conclusions (or to back up your own opinions). It's important to get the facts right.
How do you research a topic? Where do you go? Of course, it depends on your topic, but the principle is the same: look for non-partisan, original sources of the highest caliber.
Look for Academic Sources
In the field of multimedia, for example, look for academic sources. There's a fair amount of research that's been done in the field. In business, you can also look for academic research on marketing, human resources, productivity, and more.
Find Writers Who do their Research
You might not have the time or resources (such as subscriptions to the journals) to do all of your own research. In this case, you may want to rely on articles that others have written. If you do so, you need to carefully judge the credentials of the author and the thoroughness of the research.
Look for articles that include references, indicating that the author did the research you don't have the time to do. Also, when you do a search on the Internet, go to Web sites that have reputable names.
Keep Track of your Sources
Write down and keep your sources, making them as complete as if you were creating a bibliography. This means you should include the following:
• Author
• Name of book or article
• Date published
• Journal or publisher
• Place published (if a book)
• Issue number (if a journal)
• Page number
• URL, if any
Verify your Sources
If a claim seems doubtful, try to find corroboration.
Citing Opinions
Opinions are different. Anyone has the right to an opinion, but whose opinion do you trust? Whose opinion do you want to put out there as authoritative? Therefore, look for the most well-known and respected sources for opinions.
Of course, you're entitled to your own opinions. And in fact, a presentation is stronger when you have a point of view and have drawn a conclusion from your research. But make clear that the opinion is yours. Don't pass it off as absolute fact. If you can cite respected third-party opinions, and bring the audience through your facts, data, and logic, you'll be able to bring them around to agree with your opinion. That will be an impressive success!
How do you research a topic? Where do you go? Of course, it depends on your topic, but the principle is the same: look for non-partisan, original sources of the highest caliber.
Look for Academic Sources
In the field of multimedia, for example, look for academic sources. There's a fair amount of research that's been done in the field. In business, you can also look for academic research on marketing, human resources, productivity, and more.
Find Writers Who do their Research
You might not have the time or resources (such as subscriptions to the journals) to do all of your own research. In this case, you may want to rely on articles that others have written. If you do so, you need to carefully judge the credentials of the author and the thoroughness of the research.
Look for articles that include references, indicating that the author did the research you don't have the time to do. Also, when you do a search on the Internet, go to Web sites that have reputable names.
Keep Track of your Sources
Write down and keep your sources, making them as complete as if you were creating a bibliography. This means you should include the following:
• Author
• Name of book or article
• Date published
• Journal or publisher
• Place published (if a book)
• Issue number (if a journal)
• Page number
• URL, if any
Verify your Sources
If a claim seems doubtful, try to find corroboration.
Citing Opinions
Opinions are different. Anyone has the right to an opinion, but whose opinion do you trust? Whose opinion do you want to put out there as authoritative? Therefore, look for the most well-known and respected sources for opinions.
Of course, you're entitled to your own opinions. And in fact, a presentation is stronger when you have a point of view and have drawn a conclusion from your research. But make clear that the opinion is yours. Don't pass it off as absolute fact. If you can cite respected third-party opinions, and bring the audience through your facts, data, and logic, you'll be able to bring them around to agree with your opinion. That will be an impressive success!
August 24, 2010
Microsoft Excel 2007 - Selecting Non-Adjacent Cells in Excel
By selecting multiple cells in Excel you can delete data, apply formatting such as borders or shading, or apply other options to large areas of a worksheet all at one time.
While using the drag select method with the mouse to quickly highlight a block of adjacent cells is probably the most common way of selecting more than one cell. However, there are times when the cells you want to highlight are not located beside each other.
When this occurs, it is possible to select non-adjacent cells. Although this cannot be done solely with the keyboard, it can be done by using the keyboard and the mouse.
Follow these easy steps:
1. Click on the first cell you want to select with the mouse pointer to
make it the active cell.
2. Press and hold down the Ctrl key on the keyboard.
3. Click on the rest of the cells you want to select Without releasing
the Ctrl key.
4. Once all the desired cells are selected, release the Ctrl key.
5. Do Not click anywhere else with the mouse pointer once you
release the Ctrl key or you will clear the highlight from the selected
cells. If you release the Ctrl key too soon and wish to highlight more
cells, simply press and hold down the Ctrl key again and then click
on the additional cell(s). If you select a cell by mistake, click on it
a second time while still holding down the Ctrl key to clear the
highlight.
6. Now use your mouse to click on the action you wanted to perform
(i.e. font, add borders, bold, add shading, delete, etc.).
While using the drag select method with the mouse to quickly highlight a block of adjacent cells is probably the most common way of selecting more than one cell. However, there are times when the cells you want to highlight are not located beside each other.
When this occurs, it is possible to select non-adjacent cells. Although this cannot be done solely with the keyboard, it can be done by using the keyboard and the mouse.
Follow these easy steps:
1. Click on the first cell you want to select with the mouse pointer to
make it the active cell.
2. Press and hold down the Ctrl key on the keyboard.
3. Click on the rest of the cells you want to select Without releasing
the Ctrl key.
4. Once all the desired cells are selected, release the Ctrl key.
5. Do Not click anywhere else with the mouse pointer once you
release the Ctrl key or you will clear the highlight from the selected
cells. If you release the Ctrl key too soon and wish to highlight more
cells, simply press and hold down the Ctrl key again and then click
on the additional cell(s). If you select a cell by mistake, click on it
a second time while still holding down the Ctrl key to clear the
highlight.
6. Now use your mouse to click on the action you wanted to perform
(i.e. font, add borders, bold, add shading, delete, etc.).
August 20, 2010
Microsoft Excel 2007: Clearing Everything Except Formulas
Need to get rid of everything in a worksheet except for your formulas?
If you want to do the clearing manually, you can follow these steps:
• Press F5. Excel displays the Go To dialog box.
• Click the Special button. Excel displays the Go To Special dialog
box.
• Select the Constants button. The four check boxes under the
Formulas option then become available.
• Make sure that all the check boxes under the Formulas button
are selected.
• Click OK. Excel selects all the constants (cells that don't contain
formulas) in the worksheet.
• Press the Del key.
This works great if you only need to clear out the non-formula contents of a worksheet once in a while.
If you want to do the clearing manually, you can follow these steps:
• Press F5. Excel displays the Go To dialog box.
• Click the Special button. Excel displays the Go To Special dialog
box.
• Select the Constants button. The four check boxes under the
Formulas option then become available.
• Make sure that all the check boxes under the Formulas button
are selected.
• Click OK. Excel selects all the constants (cells that don't contain
formulas) in the worksheet.
• Press the Del key.
This works great if you only need to clear out the non-formula contents of a worksheet once in a while.
August 17, 2010
What can your Alt Key Reveal in Microsoft Excel, Word & PowerPoint 2007?
I came across a little known secret in the Microsoft 2007 Office Products that I would like to share with you.
Open any of these 2007 Microsoft Office Products, Excel, Word & PowerPoint. Now press the Alt key. Did you see what happens in your ribbon?
Yes, it gives you all the short-cut keys that are available. You no longer have to remember every short-cut key. Just press the Alt key, and a number or letter shows up next to all the short-cut keys.
For example in Word 2007, “ALT P” gets me to the shortcut of Page Layout. It also shows me more short-cuts within Page Layout. For example “ALT M” drops down my margin options.
WOW! I find this amazing and what a way to increase your productivity. Try it!
Open any of these 2007 Microsoft Office Products, Excel, Word & PowerPoint. Now press the Alt key. Did you see what happens in your ribbon?
Yes, it gives you all the short-cut keys that are available. You no longer have to remember every short-cut key. Just press the Alt key, and a number or letter shows up next to all the short-cut keys.
For example in Word 2007, “ALT P” gets me to the shortcut of Page Layout. It also shows me more short-cuts within Page Layout. For example “ALT M” drops down my margin options.
WOW! I find this amazing and what a way to increase your productivity. Try it!
August 12, 2010
Microsoft Word 2007 - Turn Off the Ribbon
Some people would prefer to have as much screen space as possible when working on a document. To do this, Word 2007 allows you to turnoff the Ribbon.
The Ribbon will still be available when you want it, all you need to do is click on the appropriate menu (Home, Insert, Page Layout, etc.) and it appears. It then discreetly goes away when you are no longer using it.
There are several ways to turn off the Ribbon:
• Click the Down arrow to the right of the Quick Access toolbar button
and select Minimize the Ribbon.
• Press Ctrl-F1 to turn the Ribbon off. Press Ctrl-F1 to make it appear
again.
• Double-click the current tab above the Ribbon to make it disappear
and then reappear again.
The Ribbon will still be available when you want it, all you need to do is click on the appropriate menu (Home, Insert, Page Layout, etc.) and it appears. It then discreetly goes away when you are no longer using it.
There are several ways to turn off the Ribbon:
• Click the Down arrow to the right of the Quick Access toolbar button
and select Minimize the Ribbon.
• Press Ctrl-F1 to turn the Ribbon off. Press Ctrl-F1 to make it appear
again.
• Double-click the current tab above the Ribbon to make it disappear
and then reappear again.
August 11, 2010
Marketing Calendar
Jennifer Maggiore makes a great point in her post about using an Editorial Calendar. Here's a link to a sample that I use for YCL and my clients. It's just an easy Excel file. But it makes you think through your actions (Oh wait, the newsletter is scheduled to go out the day AFTER our class!!) and gives you a place to gather ideas. Nothing is worse than sitting down in front of a blank piece of paper on the day of your deadline to write the newsletter. But if you've been gathering ideas and plugging them into the Calendar, you know what to say!
Sample Marketing Calendar
Sample Marketing Calendar
August 10, 2010
Microsoft PowerPoint 2007 – Compressing Pictures
You can ask PowerPoint to compress pictures in your presentation so that you can optimize your presentations more efficiently. With this decreased size you can email them and transport them easily.
To allow for maximum amount of editing later, PowerPoint saves pictures within presentations in a poorly compressed format. When working on a presentation locally, this is highly desirable because it gives you the most flexibility in editing later. However, when trying to get your huge PowerPoint file small enough to fit into an email or on a USB drive, this can be a problem. Here’s how to decrease the sizes.
1. Click Save
2. Click the Tools drop down menu besides the save button
3. Select Compress Pictures
4. Click Options
5. Check automatically perform basic compression on save
6. Check Delete cropped areas of pictures
7. Check the appropriate target output (print, screen, or email)
8. Click OK
To allow for maximum amount of editing later, PowerPoint saves pictures within presentations in a poorly compressed format. When working on a presentation locally, this is highly desirable because it gives you the most flexibility in editing later. However, when trying to get your huge PowerPoint file small enough to fit into an email or on a USB drive, this can be a problem. Here’s how to decrease the sizes.
1. Click Save
2. Click the Tools drop down menu besides the save button
3. Select Compress Pictures
4. Click Options
5. Check automatically perform basic compression on save
6. Check Delete cropped areas of pictures
7. Check the appropriate target output (print, screen, or email)
8. Click OK
August 5, 2010
Microsoft Excel 2007 – Centering Your Worksheet Data
If you are working with smaller worksheets, they can look odd when printed. Why? Because Excel normally prints your worksheet data at the upper-left corner of a piece of paper. If the worksheet data is small enough, the placement of the data on the printed sheet can detract from what you are trying to convey.
To help offset this problem, Excel provides a way you can easily center your printed information. You can center the data horizontally, vertically, or both. Follow these steps:
1. Display the Page Layout tab of the ribbon.
2. Click the small icon at the bottom-right of the Page Setup group. Excel displays the Page Setup dialog box.
3. Select the Horizontally check box if you want the information centered left-to-right between the margins of the page. OR Select the Vertically check box if you want the information centered top-to-bottom between the margins of the page. You can check both so that your worksheet centered both horizontally and vertically.
4. Click OK.
To help offset this problem, Excel provides a way you can easily center your printed information. You can center the data horizontally, vertically, or both. Follow these steps:
1. Display the Page Layout tab of the ribbon.
2. Click the small icon at the bottom-right of the Page Setup group. Excel displays the Page Setup dialog box.
3. Select the Horizontally check box if you want the information centered left-to-right between the margins of the page. OR Select the Vertically check box if you want the information centered top-to-bottom between the margins of the page. You can check both so that your worksheet centered both horizontally and vertically.
4. Click OK.
August 3, 2010
Microsoft Word 2007 - Showing or Hiding Formatting Marks in Word 2007
Over the years, many users have switched from WordPerfect to Microsoft Word. And, they virtually all miss one very cool WordPerfect feature, the ability to reveal formatting marks.
Displaying formatting marks has a couple of benefits. First, it allows you to troubleshoot formatting in your document. Second, you can select formatting options just the same as you would text.
Word will display certain formatting marks. You can see formatting marks for spaces, returns, tabs and tables. The feature isn't as powerful as WordPerfect's. However, it will still save you considerable time.
The formatting marks are helpful when you're editing a document. You will be able to spot inconsistencies at a glance, before you print your document.
You can enable formatting marks in Word 2007 from the Home ribbon. In the Paragraph section, simply click the paragraph symbol. Clicking it again will disable the formatting marks.
You can also have greater control over the formatting marks you see. For example, you can display just the spaces or tab characters, if you’d like.
Follow these steps:
1. Click the Office button
2. Click Display
3. Select the formatting marks you’d like to display
4. Click OK
To disable the formatting marks, open the options again and deselect the formatting marks you want hidden.
Displaying formatting marks has a couple of benefits. First, it allows you to troubleshoot formatting in your document. Second, you can select formatting options just the same as you would text.
Word will display certain formatting marks. You can see formatting marks for spaces, returns, tabs and tables. The feature isn't as powerful as WordPerfect's. However, it will still save you considerable time.
The formatting marks are helpful when you're editing a document. You will be able to spot inconsistencies at a glance, before you print your document.
You can enable formatting marks in Word 2007 from the Home ribbon. In the Paragraph section, simply click the paragraph symbol. Clicking it again will disable the formatting marks.
You can also have greater control over the formatting marks you see. For example, you can display just the spaces or tab characters, if you’d like.
Follow these steps:
1. Click the Office button
2. Click Display
3. Select the formatting marks you’d like to display
4. Click OK
To disable the formatting marks, open the options again and deselect the formatting marks you want hidden.
Network For Good
Great web site for volunteering or donating to good causes. They offer excellent services for the donor, the non-profit.agency and even companies looking for community involvement.
Network For Good
Network For Good
Subscribe to:
Posts (Atom)
