Menu
101 Excel Secrets – Recommended E-Book
products - 10 comments
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.
Go here to get a copy of the 101 Excel Secrets e-book.
Hello Awesome...
My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.
I hope you enjoyed this article. Visit Excel for Beginner or Advanced Excel pages to learn more or join my online video class to master Excel.
Thank you and see you around.
Related articles:
|
Leave a Reply
| « Making a Dynamic Dashboard in Excel [Part 2 of 4] | How to Visualize Survey Results using Incell Panel Charts [case study] » |
At Chandoo.org, I have one goal, "to make you awesome in Excel & Power BI". I started this website in 2007 and today it has 1,000+ articles and tutorials on data analysis, visualization, reporting and automation using Excel and Power BI. 
10 Responses to “101 Excel Secrets – Recommended E-Book”
Duh.. Friday isnt first of april (although it would make a good foolsday statement to say today is friday...). Please know that the offer lasts until 2nd april mid night. So Go...
I checked his site. It looks like a sleazy infomercial.
Sorry, but I just don't trust people who resort to scammy-looking sites like that. That's an example of the worst type of marketing on the Web.
@J-Walk... I had similar impression, but after hearing about his newsletter from numerous sources, I had to sign up for his email updates (unfortunately he doesnt have a blog, so the only way to get updates is thru emails) so that I can keep my excel knowledge up to date. I have been reading his emails since Jan 12th this year and I can vouch for the quality and originality of Francis ideas and tips.
During recent earth quake in Haiti, Francis even donated the entire ebook sales (totaling to $ 2200+) to the victims (the canadian govt. doubled up his donation totaling to almost $5k). You can see more about it here: http://www.theexceladdict.com/haiti/
It is slightly unfortunate that his web page and sales pages look like old school internet snake oil sales pages. But may be his html skills are not as good as his excel skills. I guess we should not judge a book by its cover.
I suggest that you buy his book and see the quality for yourself. Since there is 60 day money back guarantee and the cost is only $8, you dont really loose much by testing what it is...
It may be the best Excel book ever, but I'll never support anyone who puts up a site like that. That style of marketing is associated with scams designed to attract stupid people.
John...So what if this guy is out there selling his wares with bad copy? That's not a crime. The guy offers a money back guarantee, and assuming he makes good on it if you asked, and that he's not breaching someone else's rights, I don't see the problem.
You're essentially saying that this guy looks guilty. To paraphrase Forrest Gump, scam is as scam does. Shouldn't you wait until you've actually been scammed before you definatively call this guy a scammer?
I normally respect you for your writing, and I've got a whole bunch of your books to prove it. But your tone in this piece of writing seems more than a little sanctimonius.
I agree with Chandoo...don't judge a book by its cover.
Hi Chandoo
Thanks for the tip about this book. I am always look for good ways to update my knowledge of Excel, and I respect your judgement and recommendation.
@Catherine... Thank you 🙂 I am honored and fortunate to have members like you in our community.
If you have a minute, I request you to share your feedback of the book with all of us thru comments. It would help others to make a decision whether or not to buy the book.
Yes I bought this book.. and am very happy with it! It does have lots of tips and ideas that I can use. I like the way Francis writes - very clear and good pictures. In my opinion its good value for the price and its the sort of book you can dip into and learn something each time. thanks Chandoo for the tip
I don't know what J-Walk is ranting about. I not only purchased this ebook I also promote it now. Clickbank promises anyone a full refund if they are not satisfied with any product promoted through them.
This is a great value. Get it. There are probably a lot of things in it that you already know if you are a power user, but there are always some nuggets of information that you have never known. At this modest price even one shortcut, trick or trip that saves you time or aggravation is worth the expense.