At only 30 pages, The World’s Shortest Excel Book was designed to cram the things you need to know into an easy-to-read electronic book (Adobe Reader .pdf file) along with Excel practice files to go with the lessons.
The book is not designed to teach Excel basics to new users. Instead, it addresses some of the more advanced topics and also some subjects that are too easy to overlook in Excel — and some errors that are too easy to make, too.
I bought the earlier version of The World’s Shortest Excel Book several years ago and found it quite useful and helpful. I’d go back and reread it occasionally to keep those thoughts refreshed. When the 2012 version was released recently, I quickly bought a copy.
Richard Kraneis, the author, has now updated The World’s Shortest Excel Book to cover both Excel 2007 and Excel 2010. While the 2004 version of the book was excellent for its time, and still usable today, it still required the reader to "translate" between the Excel 2003 menus and the menus/ribbons of Excel 2007 and Excel 2010.
With the new 2012 version of The World’s Shortest Excel Book has the following chapters:
- 1: Welcome
- 2: Comparing Excel 2003, 2007, and 2010
- 3: What’s the Secret to Excel?
- 4: Formulas — "Good" formulas can give bad numbers.
- 5: Format techniques Worth Knowing.
- 6: Printing — A Review, Problems, and a Few New Ideas.
- 7: Date Math — How old are you exactly?
- 8: Making Sense of Formula Functions.
- 9: Why is =IF so important?
- 10: Sheet Tabs — 255 Ways to Succeed.
- 11: Understanding Pivot Tables.
- 12: Excel Charting: Three Powerful Concepts.
- 13: The Tools Menu and Goal Seek
- 14: The VLOOKUP Formula Function
- 15: Your Excel Coach has a Forum — Join Us Today
Click here to learn more about The World’s Shortest Excel Book…