101 Excel Secrets – Recommended E-Book
Francis J Hayes runs probably one of the most popular excel news letters. His email newsletter, called as “The Excel Addict” has an interesting nugget, tip or trick every week. I have been reading his emails for the last few months and I really enjoy them. So naturally I got curious when I heard about Francis’ e-book titled “101 Secrets of a Microsoft Excel Addict“. Yesterday I purchased a copy of the book and there are so many hidden gems in the book that I had to tell you about it.
What is in the E-Book?
This 100 page ebook contains exactly what it says on the cover. 101 Excel Tips, neatly explained with fun, insightful commentary of Francis.
What are these tips?
The tips range from simple time savers to some really amazing uses of excel powers. For eg. in tip # 58 Francis tells a very quick way to convert positive values to negative values. In Tip # 35, he tells a ridiculously simple way to copy formulas without changing references.
Who is this E-book for?
Whether you are a heavy or casual user of excel, you are bound to save time and energy with few of the tips in this book. The book presents each tip with clear illustrations.
Please note that the tips in the book use Excel 2003 for explanation and illustration. But most of these tips work exactly same in Excel 2007.
How Much is it?
The E-book is priced at $14.97. But until this Friday (that is 1st of April), Francis is running a 50% discount. That means, you get it for $7.47.
What is my opinion of this E-book?
If time is money, then this book is worth more than what its price is. It is a steep bargain at the 50% discount. I have always wanted to buy Francis’ book and when I saw the discount email notification, I couldnt wait a second. I regret not buying it earlier now. There are so many very good and valuable excel tips for day to day use. I have gotten inspiration for future PHD posts as well.
That said, the book’s excel 2003 focus can be a draw back for new excel users who have never tasted Excel 2003. If you have never used Excel 2003, you might find few of the tips totally foreign. But I would still think the book as a valuable source of ideas and excel trickery for most of them are applicable even in Excel 2010.
I recommend getting a copy of this book if you spend more than 1 hour a day on excel. Trust me when I say you would save few minutes a day with this book.
Disclosure: I receive small commission whenever you buy a copy of this ebook. But I am sure you will derive more benefit out of this than Francis or I will make out of the sale.
|Making a Dynamic Dashboard in Excel [Part 2 of 4]||How to Visualize Survey Results using Incell Panel Charts [case study]|