Back to Newsletter Archives
Back to The Software Pro Home
Smart & Easy Software Tips: Tons of Tips-August 2004, #1
Welcome to our many new subscribers who signed up through
http://www.SoftwarePro.com
(see bottom to leave "Smart & Easy Software Tips")
Geek Speak Becomes People Friendly(TM)
============================================================
Smart & Easy Software Tips, Tricks & Techniques
August 2004 - Issue 1
Publisher: Dawn Bjork Buzbee mailto:Dawn@SoftwarePro.com
The Software Pro(TM), Microsoft Certified Office Expert
http://www.SoftwarePro.com
============================================================
IN THIS ISSUE - Tons of Tips for Editing & Formatting-Part 2
(an on-going series)
============================================================
1. Microsoft Office: Quick Formatting Shortcuts
2. Microsoft Word: Easy Automation & Formatting
3. Microsoft Word: Change Case
4. Microsoft PowerPoint, Word, Access: Keyboard Shortcuts
5. Microsoft Excel & Access: Easy Data Entry
6. Microsoft Word: Quick Random Text
=====================================================
1. Microsoft Office: Quick Formatting Shortcuts
=====================================================
Try these easy keyboard shortcuts the next time you want to
turn on (or turn off) formatting for selected text:
[Ctrl] + B Bold
[Ctrl] + U Underline
[Ctrl] + I Italics
Each of these works like a toggle or on/off switch depending on
the current formatting.
=====================================================
2. Microsoft Word: Easy Automation & Formatting
=====================================================
When you create a new Word document are you ready to type or do
you need to spend extra time changing the font, margins, and
other formatting? Find out how to automate your formatting
preferences:
http://www.SoftwarePro.com/articles/wrd_easyautomation1.htm
Do you have text that you type frequently such as an address or
signature line? Make it easy with AutoCorrect and AutoText:
http://www.SoftwarePro.com/articles/wrd_easyautomation2.htm
=====================================================
3. Microsoft Word: Change Case
=====================================================
Do you have text that is all upper case or lower case and you
want to change it without re-typing?
a) First, select text
b) Press [Shift] + [F3] and repeat until the text looks
the way you want. Choices include:
UPPER CASE, lower case, Sentence case
For more options, select text and pick:
Format > Change Case
=====================================================
4. Microsoft Word, PowerPoint, Access: Keyboard Shortcuts
=====================================================
For your own desktop copy of common keyboard shortcuts:
Word:
http://www.SoftwarePro.com/tips/word.htm
PowerPoint:
http://www.SoftwarePro.com/tips/powerpoint.htm
Access:
http://www.SoftwarePro.com/tips/access.htm
=====================================================
5. Microsoft Excel & Access: Easy Data Entry
=====================================================
Try these quick and easy ways to enter data in Excel & Access
(thanks to subscriber Dan Riley for reminding me about these
great shortcuts):
[Ctrl] + ;
enters current date
[Ctrl] + '(single quote)
repeats data from cell or row immediately above
=====================================================
6. Microsoft Word: Quick Random Text
=====================================================
Would you like to easily create practice test to try out
Microsoft Word techniques? Stop typing and just enter:
=rand(# of paragraphs, # of sentences/paragraph)
For instance, =rand(10,5) will create the practice text "The
quick brown fox jumps over the lazy dog" in 10 paragraphs of 5
sentences each.
=====================================================
With these tricks and techniques, quick data entry and
formatting is easy to do.
------------------------------------------------------------
Please pass this along to others who may appreciate it!
------------------------------------------------------------
Past issues are found at:
http://www.SoftwarePro.com/archives.htm
For Website or e-zine questions: mailto:Dawn@SoftwarePro.com
If you are receiving this issue as a forward, and want
your own subscription, visit
http://www.SoftwarePro.com/subscribe.htm
Privacy Policy - We hate receiving spam as much as
you do. Therefore, we never rent, trade, or sell
our e-mail lists to anyone for any reason. You or
someone you know subscribed you to this e-zine list.
We never add names to our list until you voluntarily
subscribe.
(c) 2004 The Software Pro (TM)
All rights reserved.
http://www.SoftwarePro.com
To Subscribe go to:
http://www.SoftwarePro.com/subscribe.htm or e-mail
any message to mailto:join-softwarepro@mh.databack.com
============================================================
Geek Speak Becomes People Friendly(TM)
Dawn Bjork Buzbee
The Software Pro(TM)
Post Office Box 5319
Englewood, CO 80155-5319 USA
(303) 699-6868, Fax (303) 766-0886
Dawn@SoftwarePro.com
http://www.SoftwarePro.com