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 & use new ideas. |
|
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
|