|
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: September 16, 2003 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 removal instructions at the bottom of every newsletter. CONTENTS
haven't been receiving my newsletters in your email.
EDITOR NOTES Top ![]() Hi Fellow Excel Addict, In the past couple of weeks this newsletter has expanded to Ecuador, Spain, Argentina, Afghanistan and Venezuela. Thanks to everyone who is helping me share these great tips with other Excel users who are now benefiting from them. I had some positive feedback on a suggestion that I made last week so I will repeat it one more time in case you missed it. Keep my tips and tutorials close to your computer for easy reference. About two weeks after my tips appear in this newsletter, I post them to my website on my Quick Tips, Mini-Tutorials, and Non-Excel Tips pages. There you will find each individual tip formatted for easy printing. Just print them off, stack them up by your computer for easy reference, and watch your productivity soar. Have a great week and I'll see you again next week.
To Your Success! EXCEL "QUICK TIP" Top Create An Instant Chart Looking at the numbers on the screen doesn't always give you a clear picture of your data. Sometimes a simple chart can give you a whole new outlook. Excel makes creating charts so easy anyone can create a basic chart. After you select the data you want to plot on a chart, simply press the F11 key and you'll have an instant chart.
MY NEW "BIGGEST BANG FOR THE BUCK" CONTEST Top Over the next couple of months I want you to think of a time-consuming task that you do in Excel month after month. One that you would like to find a faster and more effective solution for. Then send me an email explaining what it is. I will personally review every entry and select the one that I think could get "the biggest bang for the buck" with a solution from The Excel Addict. One lucky person will get a custom solution to their Excel problem just for being a loyal reader of my newsletter. The best part about this is, it won't cost you a BUCK and you'll get the BANG absolutely FREE. This could possibly save you hundreds of hours every year. Submit your suggestions to BigBang@TheExcelAddict.com T-SHIRT CONTEST Top Every month I am giving away a really cool t-shirt to one of my newsletter subscribers. You can sneak a peek at my t-shirt here. 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 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 a t-shirt. But please, recommend it only to people you know and who are Microsoft Excel users. "HOW TO EXCEL" MINI-TUTORIAL Top How To Create Vertical Titles For Your Reports Did you know that you can create vertical titles in Excel that span multiple rows? For example, you may have a table and you want a vertical title to go down the left side.
READER SUGGESTIONS Top 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 Every week this newsletter is being read by Excel Addicts in: Canada, USA, Britain, Germany, Norway, Brazil, Saudi Arabia, China, Australia, South Africa, Jordan, Singapore, the Philippines, South Korea, India, Thailand, the Netherlands, and Venuzeula. 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. VERY IMPORTANT: Please refer only people you know personally, who use Microsoft Excel and would benefit from this newsletter. BONUS "NON-EXCEL" TIP Top Finding That Shortcut On Your Desktop If you're like me, you probably use your Windows Desktop as a dumping ground for files that you want to keep temporarily but don't want to store in your regular folders. Things can get a little cluttered after a while. If this happens to you, you probably also find it difficult to locate a particular file in the maze of icons on your Desktop. Here's a quick way to find that file on the Desktop. Click anywhere on the Desktop to make sure that the Desktop is 'active'. Now, just type the first letter in the name of the file you're looking for. The first file (in alphabetical order) will be highlighted. If that isn't the one, just keep pressing the same key to toggle through all files that start with that letter. This little trick should allow you to easily locate a file no matter how messy your Desktop is.
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
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630 |