Francis Hayes "The Excel Addict" Reveals...
"101 Secrets That Will Have
Everyone Around You Thinking
You're An Excel Magician"
Be Careful !
The SECRETS revealed in this eBook are highly ADDICTive
| ||||||
Below is a complete list of the Excel Tips, Tricks and Secrets you'll find inside my eBook. Each one of these tips has the potential to save you much valuable time. How much is your time worth to you? Multiply that by 101. 101 Secrets of a Microsoft Excel Addict
1. Let Excel Read To You
2. The Quick And Easy Way To Move Rows and Columns
3. Put Pop-Up Pictures In Your Cells 4. Put Checkmarks In Your Cells 5. Create Cool 3D Effects In Your Cells 6. Fonts In Any Size You Want 7. Quickly Enter Duplicate Formulas 8. Combine Text And Numbers From Different Cells 9. Instantly Move To The End Of A Long Column 10. Make Your Spreadsheet Fit Your Screen 11. Hide Duplicate Values In A List 12. Quickly Select All Blank Cells In A Range 13. Turning The Tables 14. Recover A Deleted Sheet 15. Print Your Spreadsheet On A Specific Number of Pages 16. Dialog Box Tip 17. Quicker Data Input Using 'Pick From List' 18. Entering Data Into Cells In A Specific Order 19. A Double-Click Fill Handle Trick 20. Move A Little Closer 21. Create A Table of Contents For Your Workbook 22. Fill Handle Secret Revealed 23. Easily Move Sheets Between Workbooks 24. Turn Off That Annoying Paste Options Button (XL2003) 25. Prevent Automatic Creation Of Hyperlinks 26. AutoFill Your Own Custom Lists - Cool! 27. Make Your Worksheet Look Less Like A Worksheet 28. View Two Parts Of Your Worksheet Simultaneously 29. Give Me The Full Menu! 30. Create Dynamic Row Numbering 31. Sum Only Data That Meets A Condition You Specify 32. Cycle Font Color Tool Trick 33. Floating Colors 34. A Solution To The 'Last Used Cell' Mystery 35. A Neat Trick To Copy Formulas And Maintain Their Original Cell References 36. Cutting Corners On Your Text Boxes 37. Filter Your List With One Click 38. Delete Those Pesky HTML Objects From Pasted Web Data 39. Zoom Out For A Bird's-Eye View 40. Supress #DIV/0! Errors 41. Quickly Increase Your Value 42. Force Your Worksheet To Print Only One Page Wide 43. A Simple Trick To Replace A Formula With Its Value 44. Link a Text Box to Data in a Cell 45. Quickly Sum Non-Contiguous Cells 46. Display A User Input Message In A Cell 47. The Extend Selection Mystery 48. Formulas To Show The Path, Filename and Sheet Name 49. Extract Unique Items From A List 50. Align Objects With Cell Borders 51. Quickly Enter The Months Of The Year 52. F4, One Of Excel's Best Kept Secrets 53. Format Only Part Of The Text Within A Cell 54. A Quicker Way To Move or Copy Cells 55. Hide A Sheet Tab 56. Getting Rid of Those #$@& Spaces In Imported Data 57. Print Just A Small Section Of Your Worksheet 58. Quickly Convert Positive Values To Negative 59. Fonts and Cell Backgrounds In Every Color Of The Rainbow 60. Print Your Company Logo At The Top Of Each Sheet 61. AutoShape Perfection 62. No More Counting Characters 63. Quickly Access A Calculator From Excel 64. Create A Keyboard Shortcut For Windows Calculator 65. Advanced Windows Calculator 66. Use Your Keypad To Operate Windows Calculator 67. Have Multiple Print Areas On The Same Worksheet 68. Custom Sort Your Data 69. How To Subtotal Your List 70. Make Your Subtotals Really Stand Out 71. Sort Your Data Sideways 72. Move The Active Cell Within A Selection 73. Return The Day Of The Week From A Date 74. Change The Font in Your Footer or Header 75. Easily Convert Formula Results To Fixed Values 76. This Tip Is Wheel Cool! 77. Make Your Data Really Stand Out With Linked AutoShapes 78. Paste Everything Except Borders 79. Quick Solutions with Goal Seek 80. Create A Linked Picture Of A Cell Range 81. What Column Number Is It? 82. Prevent Unwanted AutoFilling 83. Convert Numbers With Minus Sign On Right-Hand Side 84. Change Excel's Default Open/Save To Location 85. Create Bullet Lists in Excel? Yes, You Can! 86. Avoid Vertical Alignment Problems with Wrapped Text 87. Can't Find That Recently Used File? 88. Change Excel's Default Font 89. Create Cell Comments Of Various Shapes 90. Formula To Calculate Last Day Of The Month 91. Easily Clear Just Your Input Cells 92. The Fastest Way To Select A Block Of Cells 93. Create Your Own Custom AutoFilter Toolbar 94. Copy Just The Subtotal Rows 95. Display Your Numbers As Thousands 96. Create A Running Total' Formula 97. Create A Custom Menu For Frequently Used Workbooks 98. Use Wildcards To Speed Up Your Auto Filtering 99. Avoid Excel's Out-Of-Control Scrolling 100. Calculate The Number Of Days, Months Or Years Between Two Dates 101. Create A Personalized Default Workbook Page 107 Get More Tips For FREE You can get all of these NOW
for only 15 cents per tip.
(CLICK BOOK FOR PREVIEW COPY)
Special Introductory Price
As an incentive to get my Excel Secrets into the hands of as many Excel users as possible, I have slashed 40% off my regular price.
Regular Price
You can get it NOW for only
$14.97(US)
(THIS LOW PRICE WON'T LAST FOREVER) To Get It At This Low Price
Easy, Fast,
Safe and Secure Checkout |
Dear Fellow Excel User,
If you're new to Excel, I've got some good news for you. Those people who have been using Excel for years are not that far ahead of you. Excel is probably the most popular business software program ever written, yet most users are utilizing less than 5% of its best, time-saving features.
However, if you're someone who has been using Excel for years and have yet to discover all these wonderful secrets everyone is talking about, now's your chance to make a giant leap in your productivity.
After reading this eBook, you will have discovered many of Excel's best secrets that have been hiding right under your nose. These secrets are guaranteed to catapult your skills and productivity far ahead of anything you have even imagined.
Once you uncover just a few these seemingly unlimited supply of amazing, almost-magical Excel secrets, you will understand why so many people become 'addicted' to Excel .
I've been using Microsoft Excel for over 15 years and I can't seem to get it out of my system.
If you have enjoyed my tips in the past, I think you will really love 101 of my best 'secrets' all compiled in one convenient resource. I'm sure that my eBook will save you many, many more times its value in the hours and hours of work you will save month after month.
You can buy my eBook and learn the solutions to 101 common problems that Excel users everywhere are faced with daily or you can waste countless hours trying to find answers elsewhere. You know which option is best, right?
To your success,
Francis J Hayes (The Excel Addict)
Proceed with CAUTION ! You too are at risk of becoming an Excel Addict.
Important Note: The tips contained in this eBook are primarily for use with Excel 2003. Most will also work with Excel 2002 and Excel 2000. However, these tips have not been tested in Excel 2007 or Excel 97.
Special Introductory Price
As an incentive to get my Excel Secrets into the hands of as many Excel users as possible, I have slashed 40% off my regular price.
You can get it NOW for only
$14.97(US)
(THIS LOW PRICE WON'T LAST FOREVER) INSTANT ACCESS
You can be learning 101 of my best tips in minutes
Purchase Online with Credit Card by Secure Server
(Easy, Fast, Safe and Secure Checkout)
This product is a downloadable eBook in PDF format (107 pages, 5.6MB). You will need Adobe Acrobat to open, read and print this eBook. This shouldn't be problem because most computers have Adobe Acrobat already installed.
More Reader Testimonials
These tips are really amazing !!!!!!! There are so many things which we would not be aware of. Thanks a lot for these tips. Thanks -- Chetana
Your tips and tricks have been more helpful to me than the monstrous Excel handbook I keep on my bookshelf. Again, thank you and keep up the good work. -- Lynne M Hi Frank - Success!! This will save me significant frustration! All the best - Andy Hi Francis, I am very grateful of the tips as it improves my turn around time. Thanks -- Clave Hi Francis: Thanks you hugely. I am singing the praises of Excel Addict. Cheers -- Marcia Dear Francis, I never cease to be amazed by your knowledge and expertise. Many many thanks and please keep up your inspirational work. Sincerely, Stephen Dear Mr. Hayes, You are doing a great and excel-lent service,-- Arul, Kuala Lumpur, Malaysia You most definitely are the 'Excel Addict'. Thank you so much! I was told by an advanced Excel instructor that the only way to solve this was to reload Microsoft Office. I knew that there had to be a way and it was sooooo simple. Thank you! - Scott, Trinidad I just want to say that your tips are extremely helpfull. You are concise. You make it all seem so simple -- Jason I have often wondered how to do this but never knew how to!!! THANK YOU THANK YOU THANK YOU!!!! -- Christie Hi Francis, Thanks. This is one of the best "Excel Addict" tips I have had in a long time. Regards, Jake Hey Francis! You always make things look so very nice and "follow-on-able" for us! Have a super day! Thanks -- Shirley : ) Another great tip ... I gave up on finding a way on how to format part(s) of a cell. I have asked a lot of supposed to be self-proclaimed Excel experts and they told me it could not be done. I guess now I can tell these "experts" that it indeed could be done. Again, thanks a whole lot ... I always look forward to your tips. More power to you and regards. - Benjie, Houston TX Hey Francis - I found your Excel tutorials, well, simply amazing. I always get a chuckle when I come across something like this. The examples you've given are just so simple, I can't believe they aren't just readily known, but I copied down at least a dozen I've never heard of before. Regards, Robin
HI Francis, Just like to say thank you for all the Excel Tips, I'm amazed how much excel knowledge I have accumulated through you're XL tips. Thanks again Peter Dear Francis J Hayss I am getting great help from your tutorial, the way it is explained is so easy to understand , practice & implement in daily use. Thanks -- Pravin Hi Francis Thank you very much. Looking at it now, it is so simple and I did not see it. You're making me look very clever to my staff :) That is a good thing. Thanks -- John TheExcelAddict: A note of gratitude for you THANK YOU!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! My administrator and I have being going absolutely nuts for months trying to massage data from our Urchin and other web-generated statistics reports trying to get the mysterious white space out of the cells. Excel "Help" was no help, my boss was convinced we were idiots (what could be so hard about TRIM or search and replace?), and we spent way too much time pressing the delete key manually. NOW, we know. Thanks to your tip: Getting Rid of Those #$@& Spaces In Imported Data THANK YOU SO MUCH. What a relief to finally understand what is going on here! -- Courtney Francis, Thank you for your tips. They have been very helpful and are definite time savers. Regards -- Rob ( Project Co-ordinator ) Hi Francis, My name is Vivek and i am writing this mail to you from India in order to give my regards to the great work you are doing and the kind of help i have received from your work has improved my work efficiency by 15 - 20% in office. My work profile has started to a better outlook to it lately. Keep up the great work and do let me knw if you come to India any time in future. Regards -- Vivek Helo Francis, I have regularly used your tips to improve my office and the spreadsheets they currently use and would not be able to do this without your valuable assistance...again thanks -- Tony | |||||
Copyright Francis J Hayes © All Rights Reserved 8 Lexington Place, Conception Bay South, Newfoundland, Canada A1X 6A2 Phone 1-709-834-4630 |
Keywords: Francis J Hayes, The Excel Addict, Microsoft Excel eBook, Microsoft Excel Tips, Microsoft Excel Book, Excel Help, Francis Hayes, Excel Addict, spreadsheet tips, training, keyboard shortcuts |