How often have you been in the audience for a PowerPoint slide show and suddenly it was over? No indication that the end was here. Just last slide and it's done.
Let your audience know that the slide show is over by simply ending it with a black slide. You don't even have to create a new slide and make it black. There is a convenient feature in PowerPoint that does this for you. Here is how it is done.
Steps
1. Click on the Office button.
2. Click on the PowerPoint Options button at the bottom of the dialog
box.
3. Select Advanced in the list of options on the left.
4. Scroll down in the list of options, until you get to the Slide Show
section.
5. Check the box for End with black slide.
6. Click OK
July 29, 2010
A happy client!!
This kind of response is the goal of Your Computer Lady!!
Pamela,
You were sent to me from Heaven!
David Gill
Lights Up Arizona LLC
P: 480-600-2504
www.lightsuparizona.com
Lights Up Arizona is a relatively new company but David has been involved in the lighting industry for over 30 years! Great experience to help you with your lighting projects. Check out the beautiful options on his web site!!
July 27, 2010
Microsoft Excel 2003 & 2007 – Merge & Center Cells
The merge and center formatting featured in Excel 2003 & 2007 is a handy option to quickly format titles and headings in Excel spreadsheets. It allows you to center titles evenly above your data by merging a number of cells into one and then centering the title/text in this one cell.
1. Highlight the cells you want to merge/center.
2. Right click your mouse, Format Cells
3. Click on Alignment.
4. Click on Horizontal, Center
5. Click the Merge Cells box
6. Click OK
You text is now centered over the data you requested. Using this Right Click format short-cut key, allows you to also, change the text type, size, style, format your numbers, add a border and fill in the cell with a color or pattern. Finding quick and easy ways to do things will always increase your productivity.
1. Highlight the cells you want to merge/center.
2. Right click your mouse, Format Cells
3. Click on Alignment.
4. Click on Horizontal, Center
5. Click the Merge Cells box
6. Click OK
You text is now centered over the data you requested. Using this Right Click format short-cut key, allows you to also, change the text type, size, style, format your numbers, add a border and fill in the cell with a color or pattern. Finding quick and easy ways to do things will always increase your productivity.
July 22, 2010
Microsoft Word 2007 – Saving Frequently Used Tables
Do you seem to create the same size table often? Now you can create this table and save the table in the Quick Tables gallery.
Follow these steps:
1. Create your table.
2. Highlight the table.
3. On the Insert tab, click Table, click Quick Tables, and then click Save Selection to Quick Tables Gallery and Name the table.
4. To find/use this table, click on the Insert tab, click Table, click Quick Tables, and scroll down until you find the name of your table.
It’s that easy!
Follow these steps:
1. Create your table.
2. Highlight the table.
3. On the Insert tab, click Table, click Quick Tables, and then click Save Selection to Quick Tables Gallery and Name the table.
4. To find/use this table, click on the Insert tab, click Table, click Quick Tables, and scroll down until you find the name of your table.
It’s that easy!
July 20, 2010
Microsoft PowerPoint 2007 – Customize Auto Correct
AutoCorrect is a feature in PowerPoint 2007 that will automatically correct a common spelling error. You can also tailor it to use as a quick way to enter repetitive, lengthy phrases.
For Example - You work for the law firm of Hokkel, Pokkey and Lynderrocker, and must type that name on the slide often in your PowerPoint presentation. It is very easy to make a mistake typing such a difficult set of names.
Steps to Add an AutoCorrect Entry
1. Click on the Office button in the top left corner of the PowerPoint
2007 window.
2. Click on the PowerPoint Options button in the bottom of the
dialog box.
3. Select the Proofing option in the list and then click on the
AutoCorrect Options button.
4. Enter the misspelled word or specific keystrokes in the
Replace text box.
5. Enter the correction in the With text box.
6. Click on the Add button to add the item to the list.
7. Click on the OK button when all entries have been made.
Now test it.
1. Go back to your PowerPoint presentation
2. Type what you put in the Replace text box on your PowerPoint
slide, and then hit the space bar on your keyboard, and your
entire word should show up.
Neat trick to not only make sure you spell long names correctly, but also a short cut to cutting down on keystrokes. Try it!
For Example - You work for the law firm of Hokkel, Pokkey and Lynderrocker, and must type that name on the slide often in your PowerPoint presentation. It is very easy to make a mistake typing such a difficult set of names.
Steps to Add an AutoCorrect Entry
1. Click on the Office button in the top left corner of the PowerPoint
2007 window.
2. Click on the PowerPoint Options button in the bottom of the
dialog box.
3. Select the Proofing option in the list and then click on the
AutoCorrect Options button.
4. Enter the misspelled word or specific keystrokes in the
Replace text box.
5. Enter the correction in the With text box.
6. Click on the Add button to add the item to the list.
7. Click on the OK button when all entries have been made.
Now test it.
1. Go back to your PowerPoint presentation
2. Type what you put in the Replace text box on your PowerPoint
slide, and then hit the space bar on your keyboard, and your
entire word should show up.
Neat trick to not only make sure you spell long names correctly, but also a short cut to cutting down on keystrokes. Try it!
July 15, 2010
Microsoft Excel 2007 – Adding Data Quickly
One of the shortcuts provided in Excel 2007 allows you to copy data from the cell above the current cell.
All you need to do is press CONTROL SHIFT "
How does this works. For example if you enter 12345 in cell A4. If you then move to cell A5 and press Control Shift ", 12345 appears in the cell. If you then go to cell A6 and type ABC and press Control Shift ", you end up with ABC12345 in the cell.
This shortcut can be handy when you are entering data that has a lot of similarities like inventory numbers or part numbers.
All you need to do is press CONTROL SHIFT "
How does this works. For example if you enter 12345 in cell A4. If you then move to cell A5 and press Control Shift ", 12345 appears in the cell. If you then go to cell A6 and type ABC and press Control Shift ", you end up with ABC12345 in the cell.
This shortcut can be handy when you are entering data that has a lot of similarities like inventory numbers or part numbers.
July 13, 2010
Microsoft Word 2007 – Save Default to .doc Format
Microsoft Office 2007 is a major update. Word and other programs in the suite will use new document formats. Word 2007 saves files in the .docx format, which is different from the .doc format used in Word 97-2003.
The new document format in Word 2007 can cause difficulties when it comes time to share your documents electronically. You cannot open a Word 2007 document saved in the .docx format in Word 97-2003. When save your Word 2007 documents, you can save it in the Word 97-2003 format, but you would have to remember to do that every time you save a document.
You can ask Word 2007 to always save your documents in Word 97-2003 format so that you don’t have to worry about having any problems sharing documents. To do this, follow these simple steps:
• Click the Office button
• Click Word Options
• Open the Save options
• Beside Save files in this format, select Word 97-2003
• Click OK
Your documents will be saved in the .doc format, which is compatible with earlier versions of Word and you don’t have to worry about sharing your documents with people who don’t have Word 2007.
The new document format in Word 2007 can cause difficulties when it comes time to share your documents electronically. You cannot open a Word 2007 document saved in the .docx format in Word 97-2003. When save your Word 2007 documents, you can save it in the Word 97-2003 format, but you would have to remember to do that every time you save a document.
You can ask Word 2007 to always save your documents in Word 97-2003 format so that you don’t have to worry about having any problems sharing documents. To do this, follow these simple steps:
• Click the Office button
• Click Word Options
• Open the Save options
• Beside Save files in this format, select Word 97-2003
• Click OK
Your documents will be saved in the .doc format, which is compatible with earlier versions of Word and you don’t have to worry about sharing your documents with people who don’t have Word 2007.
Subscribe to:
Posts (Atom)
