|
SPREADSHEET TIPS FROM AN EXCEL ADDICT (Online Edition) Helping Average Spreadsheet Users Become Local Spreadsheet Experts A Free Weekly Publication of TheExcelAddict.com Publication Date: April 7, 2004 I respect your privacy and promise not to abuse this privilege. This newsletter is sent only to those who have requested it. If you no longer wish to receive my tips, you'll find simple instructions at the bottom of every newsletter. CONTENTS
been receiving my newsletters regularly in your email.
GREETINGS FROM CANADA Top
Hi Fellow Excel Addict, Welcome to another edition of my newsletter. Did you try all of last weeks tips? Many of the tips I share with you each week will be ones that you can use almost every day. Those are the ones that, over time, will significantly boost your productivity. Some other tips are ones that you may use less often, but they are the ones that will save you some frustration. When less common tasks come up that otherwise would take much longer, you'll be glad to know a quick and easy solution. This week I have a couple of every-day tips and one once-in-a-while tip that will help you rise above most average Excel users. As I've often said, 'Try each of these tips, even if at first it doesn't appear relevant to your situation. You will probably think of numerous uses for a tip that you weren't even aware of before.' As always, I love to hear comments and suggestions from my newsletter readers. I hope you have a fantastic week.
To Your Success!
EXCEL SCREENSAVERS: Don't forget to check out the cool Excel screensavers in the new downloads section of my website. http://www.TheExcelAddict.com/downloads
DISCOVER NEWFOUNDLAND AND LABRADOR, CANADA: EXCEL "QUICK TIP" Top Troubleshooting Formulas When you create formulas, especially more complex ones, and you don't get the solution your expect, it can sometimes be tricky finding out where the problem is. Here's a trick that I often use to pinpoint the problem. Click in the formula bar or double-click the formula (in cell) to enter 'edit mode.' Drag to select only a portion of the formula that you want to evaluate. Press the F9 key to calculate just that portion of your formula. Continue the same procedure for each part of the formula. Remember to press Esc or click on the X to the left of the formula bar to restore your original formula. If you accidentally press Enter, resulting in your formula being entered as partially calculated, you can simply click Edit, Undo (or CTRL+Z) to restore your original formula. If the problem IS with your formula, this should help you quickly identify the problem.
Jim Rohn says, "What you don't know WILL hurt you." I wish I had known this when
I was younger. I can honestly say that, over the past two years,
the wisdom of Jim Rohn has had a major positive affect on my
life, both personally and in my business. If you are
looking to improve yourself personally and/or professionally, Jim
Rohn can help you just as he has helped millions of others around
the world.
If you would like to benefit from the wisdom of 'America's
Foremost Business Philosopher' check out his FREE weekly E-Zine.
Jim Rohn's Weekly E-Zine is a free weekly publication dedicated
to providing valuable insights and information that can help
empower and improve both your business and personal life. Find
out more at
http://www.TheExcelAddict.com/rd/jimrohn.htm.
REFERRAL CONTEST Top Each month I select a name from everyone who refers my website or newsletter to a friend or colleague and they receive a cool prize from TheExcelAddict.com. All you have to do to qualify each month is send an email to your Excel friends and associates recommending my newsletter and website. Include a BCC to referral@TheExcelAddict.com and for each person that you refer, your name will go into the draw. Please, recommend only to people you know and who are Microsoft Excel users. All you have to do each month is click here to recommend my newsletter and website to a friend. For each person that you refer, your name will go into the draw. The more Excel friends you refer, the more chances you have of winning, but please, recommend it only to people you know and who are Microsoft Excel users. If you use the 'Tell A Friend' link at www.TheExcelAddict.com you could win $10,000 and you will also qualify for my Referral Contest draw. *** 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-TUTORIAL Top Bullet Lists In Excel Have you been told that you cannot use bullet characters in Excel? I have! Well, don't believe everything you hear. I'm going to show you how you CAN add bullet characters to text in Excel. This tip applies only to text entries.
SPREADING THE WORD Every week this newsletter is being read by Excel Addicts in: Albania, Antarctica, Antigua and Barbuda, Argentina, Australia, Bahrain, Brazil, Canada, Chile, China, Colombia, Costa Rica, Cote d'Ivoire, Croatia, Cuba, Cyprus, Denmark, Dominican Republic, Estonia, Finland, France, Germany, Great Britain, Guam, Hong Kong, Hungary, India, Indonesia, Ireland, Israel, Italy, Jamaica, Japan, Kazakhstan, Korea, Malaysia, Malta, Mauritius, Mexico, Nepal, The Netherlands, New Zealand, Nicaragua, Nigeria, Norway, Pakistan, Peru, Philippines, Portugal, Puerto Rico, Reunion, Romania, Saudi Arabia, Singapore, Slovenia, South Africa, Spain, Sweden, Switzerland, Turkey, Uganda, Ukraine, United Arab Emirates, United States, Vanuatu, Venezuela, Viet Nam. 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 amazing 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. Maybe you know someone who supervises or employs many Excel users. That's where your referral could have a big impact. VERY IMPORTANT: Please refer only people you know personally, who use Microsoft Excel and would benefit from this newsletter. BONUS "NON-EXCEL" TIP Top Email A Webpage Link To A Friend I'll bet you often come across a webpage that you think might interest a friend or colleague. Rather than open your email program, start a new email message and type out the webpage address (or copy the link from the Address Bar), there's a much quicker way to zip off your recommendation in a few seconds. In Internet Explorer click on the File menu, move down to Send, and click 'Link by E-mail.' A new email message will open with a hyperlink to the current website already included. Just fill in your friend's email address and click Send. Note that, on the Send menu you also have an option (Page by E-mail) to send the complete webpage by email but my experience with this option is that, if there are graphics on the page, many of them are missing when the email arrives. SUBSCRIPTION MANAGEMENT Top This online version of Spreadsheet Tips From An Excel Addict is available only to subscribers of my free email newsletter. Each week, in addition to the email version of my newsletter, you will be emailed a special link to the online version. If you haven't subscribed yet you can click here to subscribe NOW or you can send a blank email to TheExcelAddict@DemandMail.com
Send tip suggestions to tips@TheExcelAddict.com • Send testimonials to kudos@TheExcelAddict.com • Send your suggestions for 'out-of-the-ordinary' uses for Excel to coolstuff@TheExcelAddict.com • Any other comments send to francis@TheExcelAddict.com is a FREE weekly publication of TheExcelAddict.com. Copyright © 2004, Francis J. Hayes All Rights Reserved. 8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630 | ||||