Letter from the Author, Richard Kraneis
Your Excel Coach
3427 North Tripp, Chicago, IL, USA 60641
My name is Richard Kraneis and I’ve decided to bring my Excel computer training to you, anywhere in the world.
OK, I’m a “words” person.
How will The World’s Shortest Excel Book help me?
Whether you are a manager or a staff person, The World’s Shortest Excel Book is going to make you feel a whole lot better about using Excel. And my ebook will solve some very real problems for you at work or home.
“Excel Budget Meetings make me nervous.”
Have you ever felt uneasy at a budget meeting because you don’t know how the presenter calculated all the numbers? Many people are afraid to ask questions in a budget meeting. Chapter 1 of my ebook teaches you how to analyze formulas in a spreadsheet that you’ve never seen before. It’s like taking an x-ray of an Excel spreadsheet.
My Excel Formula looks “good” but the result is “wrong”
Did you know that formulas that “seem” to work can still produce incorrect numbers? At a very minimum, experts believe 20-40% of all spreadsheets have errors. Chapter 3 shows you how a “good” formula can be horribly inaccurate.
Need Help with Microsoft Excel and Date Math?
This is date math folks. “How old is the patient?” “How overdue are these receivables?” When Excel users have learned how to do date math, all of their spreadsheets seem more valuable. It’s chapter 6 in my ebook.
Microsoft Excel is like purchasing a new mobile phone with a bunch of new apps
A friend tells you about a mobile phone ap and you just have to have it. My ebook will teach you some really wonderful stuff about pivot tables, =IF statements, 3D formulas, mind maps and more. It’s not that tough to learn, you’ll save hours of time. And, most likely, you’ll feel good about Excel and your new skills.
The World’s Shortest Excel Book – Table of Contents
Let me be perfectly clear with you. These are the best Excel techniques I know for making solid intermediate Excel users out of Excel beginners. After teaching several thousand adults how to use Microsoft Excel in the Chicago, IL region, I put my favorite topics into my ebook. It’s only 27 pages long and people from 41 countries have purchased it and studied it.
Here is its table of contents.
Chapter 1: Welcome
TESTIMONIALSOne reader said, “Thanks for the inspiration.”
Chapter 2: Comparing Excel 2003, 2007, and 2010
Chapter 3: What’s the Secret to Excel?
Chapter 4: Formulas – “Good” formulas can give bad numbers.
Chapter 5: Format techniques Worth Knowing.
Chapter 6: Printing – A Review, Problems, and a Few New Ideas.
Chapter 7: Date Math – How old are you exactly?
Chapter 8: Making Sense of Formula Functions.
Chapter 9: Why is =IF so important?
Chapter 10: Sheet Tabs – 255 Ways to Succeed.
Chapter 11: Understanding Pivot Tables.
Chapter 12: Excel Charting: Three Powerful Concepts.
Chapter 13: The Tools Menu and Goal Seek
Chapter 14: The VLOOKUP Formula Function
The review you see below was from Glenda of Kansas, U.S.A. Glenda was one of the first customers to purchase my ebook. Glenda made my day.
|Reading your 28 pages was well worth the small investment! I’ve had no “formal” training in Excel, but use it daily–for many things, and find it difficult to function without it. But, I tend to not use it to its capability, only because I don’t know what it is. You’ve given just enough information in 28 pages to stir the creative juices and begin to explore and experiment. Thanks for the inspiration! It’s pretty embarrassing to find that there were shortcuts and smarter ways of doing things that I’ve been doing for years…
Kind Words from REVIEWERS of
The World’s Shortest Excel Book
New Hampshire, USA.
|I also want to thank you for an excellent publication. I would say that I knew about half of the content, but that the half I didn’t, was invaluable.
Jacques W., Montreal
I just 3 seconds ago sent an email to Debbie Weil and asked her to tell you that I had bought your book right after reading her good comments. I, in Montreal, read Debbie’s column who brings me to your page, so that I can buy this little booklet that will certainly help me improve my Excel skills (which is about time at 41…).Good luck with your online sales ! Merci.
Cleveland, OH, USA
First Email: Thanks for saving my butt last week with your book. I was totally lost in pivot tables with over 10,000 source records. I paid the 17 smackers just to learn how to sort of work with them. I can’t say it was comprehensive, but you DO have a gift for stating the obvious. THEY MOVE. Perfection.
Second Email: I’m a quick study, but am so busy just trying to get THROUGH things that I don’t have time to sit down with a manual and digest it all. You do have a talent for getting the important information across in a concise and easy to follow manner. You may certainly use my comments, and hey, keep those cards and letters coming. I’ll look for more goodies as they’re available.
|So much is packed into these 28 pages, I know that I will use your book as a standard from which I judge other Excel books. It is written in clear, easy to understand language and the examples are reliable and utilize the very features you profile. I would recommend this book to anyone who uses Excel – what a great addition to your computer library.
Michaela T., Germany,
Business Development Manager, IT industry
To be honest: there are so many excel-books. The only reason why I bought yours was the fact … that it is so short. I learnt Pivot in 10 minutes! Great!
|Dear Mr. Kraneis;Thank you so much for your practical, down to earth book. In just one weekend I can now do practically anything the advanced skills test would require—and it all makes sense! I have bought other “quick study” books and never could get through them. Your clear, precise explanations and instructions on the most practical of tasks has opened up a world of possibilities in Excel that I assumed could only be obtained in one of those expensive Excel training courses.
|Richard – Just a note to say thanks for taking the time to publish your World’s Shortest Excel Book. As a long time Excel user (& lotus before that), I can honestly say it was a good refresher for me ..and I picked up a few new ideas. You know how spreadsheet lovers like to discover & use new ideas.
(87 years young)
I have found the book interesting, very informative, well written, and just great to learn formulas, and very enjoyable to use.
It is precise, condensed, bolded words, easy to quickly thumb through, and a benefit to anyone struggling as hard as I was.
Thanks for the book, I’m still busy reading it but have already found some great tips.
I am from South Africa , work with Excel on a daily basis and need to complete a project with which I hope your e-book will help.
An International Note
As of 02/12/2014 readers from 45 countries have purchased my e-book.
- United States
- Great Britain
- New Zealand
- South Africa
- Arab Emirates
- Hong Kong
- Netherlands Antilles
- Papua New Guinea
- Saudi Arabia
- St. Kitts and Nevis
- Trinidad and Tobago
I am grateful to my readers from all countries for making my e-book a small international success.
Relax. Start enjoying Excel today.
Order my ebook, The World’s Shortest Excel Book today.
I will email The World’s Shortest Excel Book (a 30 page ebook) and its 4 Excel practice files to you within 24 hours of purchase. It’s a great investment in your career for using Microsoft Excel.
Yes, “words” people can definitely become better with “numbers” and Excel after studying The World’s Shortest Excel Book.
This 29-page e-book is a delight. Clearly written and easy to follow, it gives you a dozen concepts you can use immediately to better understand Excel.” – Debbie Weil, Publisher of WordBiz Report.
Best wishes from Chicago, IL, USA.
rich at yourexcelcoach dot com