Welcome to all the new subscribers! (Information on how
to leave this list or change your e-mail address are at
the bottom of the list)
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
Communicating Using Technology
Vol. 3 Issue 17 August 17, 2004
Published and Copyright by Dave Paradi
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
In this issue:
1. Don't put text at the bottom of your slides
2. Clearing certain elements of cells in Excel
3. Useful Resource - http://www.word-answers.com
--------------------------------------------
Privacy Policy: I will never sell or distribute your
e-mail or information to anyone.
--------------------------------------------
If you have received this as a forward from a friend, sign up
for your own copy at:
http://www.communicateusingtechnology.com/newsletter.htm
--------------------------------------------
Reminder of Upcoming Seminar
Just a reminder of the upcoming public seminar in St. John's NL
on September 16th. Contact Cindy Lu at 709-737-6201 for more
details and to register.
1. Don't put text at the bottom of your slides
When you are designing your PowerPoint slides, leave the bottom
10-15% of the slide blank or for footer graphics or logos. Many
room setups have the bottom of the screen so low that anyone past
the front row can't see the bottom 10-15% of the screen because
of the heads in front of them. You will see the audience members
bobbing and weaving to try to see around the heads in front of
them when you put your points too low on the slide. I was in the
audience at a recent presentation and saw this happen. I suggest
using this space at the bottom of your slides for your web site
address, your logo and perhaps the client logo as well. You may
even put a horizontal line at about that spot to separate your
points from the slide footer information. I had this room setup
problem happen to me recently and this is what I did. During the
pre-presentation checks, I tested how my slides looked by sitting
half way back in the room with one or two people directly in
front of me. I suggest you perform this test when setting up for
your presentations as well. You want to do everything possible
to make sure that each member of the audience can see the points
you are making easily and clearly.
-------------------------------------------------------
Make Your Next PowerPoint Presentation Compelling
Do you have an important presentation coming up? Would you like
to make it so compelling that people sit on the edge of their
seats listening to you? If you do, let me help you with my ten
step PowerPoint presentation consulting approach. This is way
more than just slide design, this is professional input on the
structure, design and delivery of your PowerPoint presentation.
One of my consulting clients wrote "I can confidently say my
sales have already increased as a result of this astounding
presentation." If you are interested, click on this link:
http://www.kickstartcart.com/app/adtrack.asp?AdID=85889
-------------------------------------------------------
2. Clearing certain cells in Excel
I recently had an e-mail exchange with a subscriber on how to
clear only certain elements from a range of cells in Excel. What
she was trying to do was clear just the values from these cells
without affecting any cells that had formulas so that her
spreadsheet could then be used as a template for others to use.
This is quite a common occurrence so I thought I would share the
solution she came up with after we went back and forth trying
different things. It actually involves a technique to select
only the cells containing constant values from a range of cells.
Once the correct cells are selected, the delete operation can be
done. Here are the steps:
1. Select the range from which the data should be removed.
2. Click the Edit menu item and Click the Go To menu option.
3. In the dialog box, Click the Special button to display another
dialog box.
4. Click the radio button beside Constants, and then check the
applicable checkboxes in the Formula list (Text, Numbers, etc.)
5. Click OK and only the cells containing the type of constants
you selected will now be selected and highlighted.
6. Press the Delete key to clear the selected cells.
The next time you want to create a template for others from a
spreadsheet you have created, remember this technique.
--------------------------------------------
Learn to use PowerPoint in under 2 hrs
Why wade through a big book - get a 13 step process that teaches
you the 20% you REALLY need to know. "It takes the mystery out
of learning PowerPoint and really gets you up and running much
quicker." -Neil Schwartz "It will save you time and make your
presentations shine!...just about the best bargain out there" -
Brainy Betty. Click on this link:
http://www.kickstartcart.com/app/adtrack.asp?AdID=45805
--------------------------------------------
3. Useful Resource - http://www.word-answers.com
Most of us use Microsoft Word on a regular basis, some of us
multiple times per day at least. I discovered a great resource
web site if you have a question on Word. According to the site
"There are 919 articles and tips available on this site,
categorized across 112 topic areas." I explored a few of the
categories, enough to know that there is a ton of great ideas on
this site. Check it out at http://www.word-answers.com.
--------------------------------------------
Tools I use to sell my products:
KickStartCart shopping cart system:
http://www.kickstartcart.com/app/default.asp?pr=31&id=42487
Credit Card Processor 2checkout.com:
http://www.2checkout.com/cgi-bin/aff.2c?affid=90267
--------------------------------------------
Would you like me to speak to your professional association
or chapter event? I am always looking for opportunities to
share my information with others and would consider speaking
to your group if you are in or near the following areas:
Rochester, NY, Buffalo NY, Detroit, MI, Cleveland, OH,
Pittsburgh, PA or Toronto, ON. Just e-mail me at:
dave@communicateusingtechnology.com for more info.
--------------------------------------------
Check out the books, e-books and other learning tools at:
http://www.communicateusingtechnology.com/tools.htm
********************************************
This newsletter is:
CUT Aug 17/04 [PPT Text Position, Excel clearing cell elements]
If you want to read back issues of this newsletter, click on
the following link to go to the Archives:
http://tinyurl.com/nhgl
********************************************
| 
