www.TechSpectrum.com presents The World's Shortest Excel Book
Visit my Store
for all Products
WWW.THEWORLDSSHORTESTEXCELBOOK.COM
52 Weeks of Excel Training - For Free
If you're here, it's because you read one of my Excel web articles
or because a friend referred you to this web page. Thank you for
visiting.
KISS (KEEP IT SUPER SIMPLE) - I PROVIDE SHORT, EFFECTIVE E-BOOKS
AND TRAINING VIDEOS ON THE INTERNET REGARDING EXCEL AND OTHER
MICROSOFT OFFICE PRODUCTS. PEOPLE IN OVER 40 COUNTRIES HAVE TRUSTED ME
WITH TEACHING THEM EXCEL POWER TECHNIQUES OVER THE INTERNET WITH
E-BOOKS AND CAMTASIA VIDEOS.
HERE ARE 3 FREE TRAINING VIDEOS ON EXCEL TO GET YOU STARTED NOW.
SAMPLE MY WORK. JUST CLICK ON THE BLUE LINKS BELOW TO WATCH MY
CAMTASIA TRAINING VIDEOS.
TOPIC MINUTES
THE SECRET TO EXCEL
5:22
IDEA MAPPING
6:07
WHY PEOPLE USE PIVOT TABLES
7:08
JOIN MY MAILING LIST TODAY AND YOU CAN RECEIVE 52 WEEKS OF EXCEL
TRAINING THIS YEAR. (WHY WOULD I GIVE AWAY 52 WEEKS OF EXCEL TRAINING
FOR FREE?)
*
IF YOU GET IMPATIENT AND WISH TO LEARN EXCEL MORE RAPIDLY, YOU CAN
PURCHASE MY EXCEL VIDEO AND/OR E-BOOK WITHOUT WAITING 52 WEEKS.
ORDER THE E-BOOK AND/OR VIDEOS TODAY.
*
MANY PEOPLE JUST CAN'T AFFORD COMPUTER TRAINING. FOR THOSE FOLKS,
IF THEY HAVE THE PATIENCE, MY COMPUTER TRAINING IS FREE. PURCHASES ON
THIS WEBSITE SUPPORT THIS FREE INTERNET SERVICE.
*
IF YOU APPRECIATE GREAT FREE EXCEL TRAINING, YOU'LL APPRECIATE MY
TRAINING METHOD. AND HOPEFULLY, YOU'LL TELL YOUR FRIENDS ABOUT THIS
WEB PAGE. JUST REFER THEM TO WWW.THEWORLDSSHORTESTEXCELBOOK.COM .
-------------------------
LETTER FROM THE AUTHOR, RICHARD KRANEIS
TRAINING NEW TECHNOLOGY
3427 NORTH TRIPP, CHICAGO, IL, USA 60641
PHONE: 773-685-8746
My name is RICHARD KRANEIS (that's my son Fritz and I on the
right) and I've decided to bring my Excel computer training to you,
for free.
I know, you don't believe it, but it's true.
I will send you one of my Excel training videos every week to your
email address for one year, for free.
52 WEEKS OF EXCEL POWER USER TRAINING
WEEK
TOPIC TIME
Week 1
Chapter 1 - Intro
Chapter 2 - The Secret
Chapter 2 - The Secret and Practical Advice 2:29
5:22
4:19
Week 2
Chapter 2 - Other Quality Control Techniques
5:33
Week 3
Chapter 3 - Good Formulas, Bad Numbers
5:24
Week 4
Chapter 3 - Good Formulas, and Very Bad Results
5:55
Week 5
Chapter 4 - Wrap Text
4:45
Week 6
Chapter 4 - Cell Orientation
3:17
Week 7
Chapter 4 - Format Painter
3:37
Week 8
Chapter 4 - Highlighting Cells
6:43
Week 9
Chapter 5 - Print Basics
7:25
Week 10
Chapter 5 - Using Gridlines Correctly
2:58
Week 11
Chapter 5 - Repeating Column Headers
4:41
Week 12
Chapter 5 - Printing Multiple Ranges
2:11
Week 13
Chapter 5 - Printing with Range Names
5:20
Week 14
Chapter 5 - Idea Mapping
6:07
Week 15
Chapter 6 - Date Math Basics
3:09
Week 16
Chapter 6 - Calculating Rich's Age
4:48
Week 17
Chapter 6 - Using =Today in Date Math
3:57
Week 18
Chapter 6 - A Date Math Problem to Solve
6:53
Week 19
Chapter 7 - Formula Functions and Spaghetti Sauce
3:00
Week 20
Chapter 7 - Understanding the = PMT Function
7:39
Week 21
Chapter 8 - Conditional Formatting
4:55
Week 22
Chapter 8 - The Basics of =IF Using Text
6:54
Week 23
Chapter 8 - Using Blanks with =IF
3:26
Week 24
Chapter 8 - Using Math with =IF
2:35
Week 25
Chapter 8 - Building a Nested =IF
5:52
Week 26
Chapter 8 - A Fun Technique with Conditional Formatting
3:08
Week 27
Chapter 9 - Sheet Tab Basics
5:03
Week 28
Chapter 9 - Sheet Tab Replication, Most People Don't Know it
8:44
Week 29
Chapter 9 - Sheet Tabs and 3D Math, A Powerful Tool
6:45
Week 30
Chapter 10 - Why People Use Pivot Tables
7:08
Week 31
Chapter 10 - Manipulating a Pivot Table
10:12
Week 32
Chapter 10 - Building a Pivot Table
7:58
Week 33
Chapter 10 - A Pivot Table Bonus
6:50
Week 34
Chapter 10 - A Final Pivot Table Exercise
3:34
Week 35
Chapter 11 - Charting Intro
7:46
Week 36
Chapter 11 - Charting Advice
6:10
Week 37
Chapter 11 - Charts and Adjacency
3:06
Week 38
Chapter 11 - Charts and non-Adjacency
7:12
Week 39
Chapter 11 - Charts and Customizing
8:47
Week 40
Chapter 11 - Charting and OLE
6:23
Week 41
Chapter 12 - The Tools Menu
5:17
Week 42
Chapter 12 - Simple Goal Seek
5:13
Week 43
Chapter 12 - Intermediate Goal Seek
6:15
Week 44
Chapter 13 - Macros Intro
4:14
Week 45
Chapter 13 - Designing the Macro
4:12
Week 46
Chapter 13 - Practicing the Macro Steps
6:33
Week 47
Chapter 13 - Recording the Macro
5:44
Week 48
Chapter 13 - Testing and Running Your Macro
4:11
Week 49
Chapter 14 - VLOOKUP Basics
3:43
Week 50
Chapter 14 - VLOOKUP Sales Table
10:03
Week 51
Chapter 14 - VLOOKUP Numbers into Words Problem
5:53
Week 52
Chapter 14 - VLOOKUP Chinese Tax Problem
8:29
Week 53
Chapter 14 - VLOOKUP Chinese Tax Answer
4:00
Week 54
Chapter 15 - Thank You
2:53
TOTAL
TOTAL RUN TIME 5+ HOURS
HERE IS THE TABLE OF CONTENTS FOR MY E-BOOK
My training videos are based upon my wonderfully short e-book named
THE WORLD'S SHORTEST EXCEL BOOK. Here are all fifteen chapters of THE
WORLD'S SHORTEST EXCEL BOOK. 12 Major Concepts, 29 Pages, and Over 50
Techniques. It's been read in over 41 countries.
Chapter 1: Welcome
Chapter 2: What's the Secret to Excel?
Chapter 3: Formulas - Good formulas can give bad numbers.
Chapter 4: Format techniques Worth Knowing.
Chapter 5: Printing - A Review, Problems, and a Few New Ideas.
Chapter 6: Date Math - How old are you exactly?
Chapter 7: Making Sense of Formula Functions.
Chapter 8: Why is =IF so important?
Chapter 9: Sheet Tabs - 255 Ways to Succeed.
Chapter 10: Understanding Pivot Tables.
Chapter 11: Excel Charting: Three Powerful Concepts.
Chapter 12: The Tools Menu and Goal Seek
Chapter 13: Basic Macros
Chapter 14: The VLOOKUP Formula Function
Chapter 15: Read, Think, Practice, Experiment
"An hour of reading this book and you'll know more than 95% of all
Excel users." - BILL JELEN, Excel expert and author.
TESTIMONIALS
ONE READER SAID, "THANKS FOR THE INSPIRATION."
THE WORLD'S SHORTEST EXCEL BOOK is still very young. But the review
you see below was from Glenda of Kansas, U.S.A. Glenda purchased my
e-book in January, 2004. Glenda made my day.
Glenda H.,
Kansas, USA. 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
Jeff C.,
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 Hi Richard, 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.
Maggie D.,
Cleveland, OH, USA
Accountant, Manufacturing
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.
Sharon E.,
Kentucky, USA 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 Richard
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!
Lisa Smith
Memphis, TN 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.
Steve Dolyk
Missouri, USA 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 color: black; border-left-style:
none; border-right: .75pt solid black; border-top: .75pt solid black;
border-bottom-style: none; background-color: #E2E2E2">
Albert Naylor
Great Britain
(87 years young)
Hi Rich
I have found the book interesting, very informative, well written,
and just great to learn formulas, and very enjoyable to use.
J. Neal
Florida, USA
It is precise, condensed, bolded words, easy to quickly thumb
through, and a benefit to anyone struggling as hard as I was.
Narriman Lalla
South Africa
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
January, 2004, was the first full month of advertising THE WORLD'S
SHORTEST EXCEL BOOK on the Internet. As of 11/06/2005 readers from 41
countries have purchased my e-book.
* United States
* Great Britain
* Canada
* Australia
* New Zealand
* South Africa
* Singapore
* India
* Belgium
* Arab Emirates
* Hong Kong
* Ireland
* Italy
* Japan
* Norway
* Peru
* Sweden
* Austria
* Bahamas
* Bahrain
* Bermuda
* Brazil
* Denmark
* Finland
* Germany
* Ghana
* Hungary
* Indonesia
* Jamaica
* Lebanon
* Malta
* Mauritius
* Mexico
* Papua New Guinea
* Paraguay
* Philippines
* Saudi Arabia
* St. Kitts and Nevis
* Switzerland
* Taiwan
* Trinidad and Tobago
I am grateful to my readers from ALL COUNTRIES for making my e-book
a SMALL international success.
DO YOU WANT TO BEGIN LEARNING TODAY?
If you'd like to speed up your Excel learning process, click HERE
or on my e-book below to go to the SALES page. Thank you.
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.
RICHARD KRANEIS
RKRANEIS@TECHSPECTRUM.COM
Phone: 773-685-8746
TRADEMARKS:
All terms mentioned on this web page and in this e-book that are
known to be trademarks have been capitalized. TechSpectrum is not
associated with any product or vendor mentioned in this book
© 2003 Training New Technology All rights reserved.
Designed by
Send any comments or suggestions to
