SPREADSHEET TIPS FROM AN EXCEL ADDICT
Helping Average Spreadsheet Users
Become Local Spreadsheet Experts
A Free Weekly Publication of TheExcelAddict.com
----------------------------------------------------------------
I Respect Your Privacy And Pledge Not To Abuse This Privilege.
This newsletter is sent ONLY to those who have Subscribed and
NEVER uses unethical methods to gain new subscribers. If you no
longer wish to receive this newsletter, you'll find a simple way
to unsubscribe at the bottom of every newsletter.
This newsletter was sent to: at
----------------------------------------------------------------
CONTENTS
1) Editor Notes
2) Excel "Quick Tips"
3) My "Biggest Bang For The Buck" Contest
3) T-Shirt Contest
4) "How To Excel" Mini-Tutorials
5) Reader Suggestions
6) Spreading The Word
7) "Non-Excel" Tip
8) Subscription Management
----------------------------------------------------------------
EDITOR NOTES *** IMPORTANT NOTICE ***
----------------------------------------------------------------
Hi ,
If you have been enjoying my Excel tips every week, you are one
of the lucky ones. I've been having some problems for a while
with the service that delivers my newsletters. And although my
newsletters are being sent out each week to all of my
subscribers, many times they aren't getting through to
everyone's inbox.
I recently found out that the problem is more widespread than I
had previously thought. Therefore, I have begun testing a new
service for sending my newsletter.
I wanted to let you know in advance because the subscription
email address for my newsletter will change. Plus soon I will be
sending out a separate notification using my new service that
should reach EVERYONE.
I may be another week testing this service but in the meantime,
you could help me by subscribing to my newsletter on the new
service by sending a blank email to
TheExcelAddict@DemandMail.com
and then clicking the unsubscribe link on the bottom of THIS
EMAIL. Otherwise, I will be moving everyone over to the new
service when I've finished testing.
Sorry for the inconvenience if you haven't been getting all the
newsletters but I'm hoping that problem will be resolved very
soon.
Enjoy this weeks tips.
To Your Success!
Francis Hayes (The Excel Addict)
----------------------------------------------------------------
EXCEL "QUICK TIPS"
----------------------------------------------------------------
Replacing A Formula With A Value
----------------------------------------
Whenever you need to replace a formula with its calculated
value, here's a lightning-fast shortcut. Select the cell(s)
containing the formula(s), press F2, then press F9 and press
Enter.
Insert New Sheets Fast
----------------------
If you've been using the Insert, Worksheet menu command to
insert new worksheets in your workbooks, here's an even faster
way. Just press Alt+F11 and a new worksheet will be added before
the current sheet.
----------------------------------------------------------------
MY NEW "BIGGEST BANG FOR THE BUCK" CONTEST
----------------------------------------------------------------
Over the next two months I want you to submit to me a
time-consuming task that you do in Excel month after month that
you would like to find faster and more effective solution for.
I will personally review all entries and select the one that I
think could get "the biggest bang for the buck" with a solution
from The Excel Addict. The best part about this is, it won't
cost you a BUCK and you'll get the BANG absolutely FREE. One
lucky person will get a custom solution to their Excel problem
just for being a loyal reader of my newsletter. Submit your
suggestions to bigbang@TheExcelAddict.com
----------------------------------------------------------------
T-SHIRT CONTEST
----------------------------------------------------------------
Every month I am giving away a really cool t-shirt from
TheExcelAddict.com. You can sneak a peak at my website
http://www.TheExcelAddict.com/images/tshirt.gif
If you subscribed to this newsletter prior to this current
month, you can still get your name in for the draw each month by
helping me share this newsletter.
All you have to do each month is send an email to your friends
and associates, with a BCC to me, recommending my website and
newsletter. For each person that you refer, your name will go
into the draw. The more friends you refer, the more chances you
have of winning a t-shirt.
*** Each monthly winner will be notified by email and will have
10 days to reply with a shipping address. If I don't receive a
reply within 10 days, another name will be drawn.
----------------------------------------------------------------
"HOW TO EXCEL" MINI-TUTORIALS
----------------------------------------------------------------
How To Use Fractions In Excel
-----------------------------
Bet you thought you couldn't use fractions in Excel. Well, as a
matter of fact, Excel does do fractions, but you may find it a
little tricky entering them.
If you enter 1/2 in a cell, Excel will interpret this as a date
and automatically format the cell as a date. To enter a fraction
that Excel can recognize, you have to precede your fraction with
a zero and a space, for example 0 1/2. Excel will now recognize
this entry as a fraction, store it's decimal equivalent in the
cell and format it to display as a Fraction.
How To Avoid #DIV/0! Errors
---------------------------
One of the most common questions I’m asked in Excel is how to
deal with #DIV/0! errors. It's common to get #DIV/0! errors in
worksheets that contain formulas with division operations. This
error results from the divisor part of a division formula
referring to a cell that is blank or has a zero value.
There is no perfect solution for this problem. Most times you'll
want to know that a formula is trying to divide a number by
zero,
but there may be times where you want to suppress this error for
reporting purposes.
You can modify your formula to display either a blank or a zero
whenever the formula results in an error. Use one of these
formulas:
=IF(ISERROR(formula),"",formula) or
=IF(ISERROR(formula),0,formula)
Just substitute your original formula for the word 'formula'.
Keep in mind that, technically, 'blank' or 'zero' is incorrect.
You cannot divide a number by zero. Use this with caution.
----------------------------------------------------------------
READER SUGGESTIONS
----------------------------------------------------------------
TIPS: Do you have an Excel tip you'd like to share with
everyone, please send it to tips@TheExcelAddict.com
TESTIMONIALS: Please drop me a line at kudos@TheExcelAddict.com
and let me know how my Tips, Tricks, Shortcuts, and Techniques
have helped you.
COOL STUFF: Do YOU know of some "out-of-the-ordinary" really
cool thing that YOU can do in Excel? Share it with me and I may
publish it in a new section coming to my website called "Cool
Stuff You Can Do With Excel". Send your suggestions to
coolstuff@TheExcelAddict.com
OTHER COMMENTS: If you have any other comments or suggestions,
please don't hesitate to let me know at
francis@TheExcelAddict.com
----------------------------------------------------------------
SPREADING THE WORD
----------------------------------------------------------------
Currently this newsletter is reaching Excel Addicts in: Canada,
USA, Britain, Germany, Norway, Brazil, Saudi Arabia, China,
Australia, South Africa, Jordan, Singapore, the Philippines
South Korea, India, Thailand, and The Netherlands.
There are tens of millions of other Microsoft Excel users all
over the world. The vast majority of them have a very limited
knowledge of Excel's capabilities. My goal is to share this
information with everyone I possibly can and help them to
benefit from Excel's lesser know capabilities.
, please help me spread the word about my
newsletter. If you know other Excel users, please tell them
about "Spreadsheet Tips From An Excel Addict". I'm sure they'll
appreciate it. Please refer only people you know personally,
who use Microsoft Excel and could benefit from this newsletter.
PLEASE NOTE: Before you forward this newsletter to anyone else,
first delete the Unsubscribe Link at the bottom of this
newsletter. You wouldn't want someone to 'accidentally' remove
your name from my mailing list, would you?
----------------------------------------------------------------
BONUS "NON-EXCEL" TIP
----------------------------------------------------------------
Minimize All Windows In One Click
---------------------------------
Here is one of those little hidden gems in Windows that too many
users overlook. When you have a clutter of windows open (who
doesn't?) and need to get back to your Desktop in a hurry,
you've
got several options.
1) You could minimize them one by one, as most users do. 2) You
could right-click on the Taskbar and choose Minimize All
Windows.
3) You could press the Windows key (if your keyboard has one)
plus the 'M' key. 4) Or you could click on the small Show
Desktop
button on your Quick Launch toolbar in your Taskbar.
If you don't see the Quick Launch toolbar in your Taskbar,
right-
click on the Taskbar and choose Toolbars, Quick Launch.
Which one is your favorite? I have two. I like to have a
keyboard
shortcut AND a mouse shortcut for almost everything I do in
Windows.
----------------------------------------------------------------
SUBSCRIPTION MANAGEMENT
----------------------------------------------------------------
If this newsletter was forwarded to you from a friend and you
would like to get your own copy, just send a email to
TheExcelAddict@DemandMail.com and include your FIRSTNAME,
LASTNAME, CITY, and COUNTRY in the Subject line
----------------------------------------------------------------
"Spreadsheets Tips From An Excel Addict" is a weekly publication
of TheExcelAddict.com. Copyright 2003, FJH Marketing. All Rights
Reserved. 8 Lexington Place, Conception Bay South, Newfoundland,
Canada, A1X 6A2 Phone: 709-834-4630
----------------------------------------------------------------
|