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 computer
training to you. Are you disappointed with Excel
classes and books that are either too simple or too
complex? When's the last time you read a computer
book that was short, immediately useful,
and worth your time?
If you
check my short
bio you will find that
I have earned a B.A. in Economics and an M.B.A. in
Management. I have taught approximately 10,000
people how to use computers around Chicago, IL, USA,
over the past 12 years. At least 3000 of those
clients were in Excel classes.
I know,
on the Internet it's hard telling who is real and who
isn't. Stay a while, read this web page, get to
know my style and what I can do for you. I love
using Excel and it's my plan to help you enjoy it also,
quickly.
Remember, you can build better Excel macros, starting
today.
excelling with macros
Here is
the Table of Contents
Here are all
eighteen chapters of Excelling with Macros.
It's 60 pages with helpful advice on building your first
simple macro and advancing to more difficult macros.
Altogether, there are 7 practice macros to build.
Chapter 1:
Welcome
Chapter 2: When Excel Tasks are
Boring or Repetitive - You Need a Macro
Chapter 3:
Your First Simple Macro
Chapter 4:
Four Ways to Launch Macros
Chapter 5:
Two Places to Store Macros
Chapter 6: Two Ways to Build Macros
Chapter 7: Rich's Method for Problem
Solving with Macros
Chapter 8: 1st:
Let's Build a Custom Toolbar for our 2 Macros
Chapter
9: 2nd: Now, Build One Macro,
the PasteCustomer Macro
Chapter 10: 3rd:
Assign the New Macro to the Custom Toolbar
Chapter
11: Build the Next Macro Entirely on Your Own
Chapter 12:
Practice: A Universal Macro - Quality Control in
Color
Chapter 13: Practice: A Faulty Macro - The
Relative vs. Absolute Problem
Chapter 14: Practice: Finding and Using Free
Macros on the Internet
Chapter 15: Final Practice: Brian's "Rainy
Day" Macro
Chapter 16: Using Macro Buttons Instead of
Toolbars
Chapter 17: Tips on Building Good Macros
Chapter 18: Thank You, Your Feedback, and Training
Services
TESTIMONIALS
(These are
testimonials from The World's Shortest Excel Book)
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
|
|
"An hour of reading this book
and you'll know more than 95% of all Excel users." -
Bill Jelen, renowned Excel expert. |
|
 |
"This 26-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. |
|
 |
"WOW - this book has 5 Excel tips I've
searched everywhere for and could never find!
Richard's book will help you learn all the
best tips, tricks and techniques without having to
wade through those computer manuals that will have
you snoring in minutes! If you use Excel - you need
this e-book!" - Jim Edwards, e-book author
and online marketing expert. |
Kind Words from PURCHASERS 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;
I bought your book over the weekend and cant get
over how simple it all was!! I was certified in
Lotus (DOS) in 1995, but have always worked in
Excel, mostly just simple spreadsheets. Only
recently have I been called upon to utilize all the
Excel features and I was really struggling. In fact
I lost out on a promotion because my pivot table
skills couldn't beat the competition.
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.
Our company uses Excel extensively and I am going to
recommend to the staff development department that
they consider buying books for each employee as a
part of training. (after I pass my test, of course) |
|
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.
|
ORDER NOW
An
International Note
January,
2004, I began advertising my Excel e-books on the Internet.
As of
08/17/2005
readers from 40 countries have purchased my e-books.
-
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
-
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-books a small international
success.
You
will receive my E-Book and some bonuses
#1:
You receive Excelling with Macros.
The
e-book is 60 pages long with 7 practice macros for you
to build. You can learn macros from the basics
onward. If you need a macro e-book to get you
started, this is the e-book to choose. If you are
looking to advance your macro skills, this e-book will
also help you.
#2:
You receive Seven Excel Macro Mini-Projects.
You need
sample problems for learning and building your macro
skills. Here are the 7 macro projects from my
e-book.
- Your first macro. Building a
macro to print ranges.
- The PasteCustomer macro.
This is a macro I built to process my e-book sales.
It's a real macro taken from a real business
environment.
- The
PasteSale macro. This is another macro for
adding a new sale to a sales database.
- The QC macro. QC means
quality control. And, this macro helps you
colorize formulas in any spreadsheet in living color.
-
The Faulty macro.
One of the reasons that macros malfunction is because
people fail to understand the difference between
absolute and relative recording. This macro
example teaches you the difference.
- The Insert Blank Rows macro.
A macro that inserts a blank row of data before every
valid row of data. Plus, we use the Internet to
find a solution to this macro.
- Brian's Rainy Day macro.
On a
rainy Saturday morning I helped a potential client
build a macro in 45 minutes via emails over the
Internet. The macro completed in 2 minutes what
would have taken him 5 hours. And, this macro
saves him time every month.
#3:
You Get Educational Emails
People
have started emailing me hellos and Excel
questions. Although I can't promise to answer
every email I receive, I do read every question from my
readers. Sometimes I answer your emails directly.
I also send useful educational emails several times a
month. When you purchase the Excelling with
Macros e-book you automatically receive my
educational Excel emails (you can unsubscribe at any
time).
Guarantees
You can't lose with my unconditional
guarantee!
I'm so sure
that you will learn Excel effectively from my
Excelling with Macros e-book that I'm willing to
stand behind it with an
unconditional guarantee.
If you are dissatisfied for any reason with
Excelling with Macros within the first 90 days, just let
me know and I'll refund every penny you paid.
The
Richard Kraneis Promise
In the
United States my last name is pretty unique. In the
U.S. there are only 3 Kraneis names listed in the entire
phonebook. So, I take my name and my
workmanship pretty seriously. I know your
skepticism and doubt when buying an e-book. Is this e-book really
worth it's price? Does this e-book have value?
Who is the author? What is his or her credibility?
As for me and my credibility, I am a
computer teacher of over 10,000 in the Chicago, IL, USA area.
In the classroom, I have taught people from all
backgrounds and professions how to use Word, PowerPoint,
Access, other software, and last but not least, Excel.
Here in
Chicago, IL, USA, on many older sidewalks, you will see that a
craftsman imprinted his name with a stamp onto the
sidewalk he built. They took pride in their
work. I feel the same way about my e-books.
My name is
Richard Kraneis
and
I gave my best effort in
writing Excelling with Macros.
I hope you enjoy it and learn from it.
Here's how to place
your Order
(You can use PayPal, your checking account, or a credit
card)
|
 |
A thorough 60 page tutorial on macros.
Helpful
advice on designing, building, and testing macros. Explanations for
building macro buttons and toolbars. Learn how to legally borrow
Visual Basic code from the Internet.
Finally, the e-book comes with Excel practice
files for building 7 macros.
|
$19.95 |
| |
Or, purchase both of my
e-books today
at a discount.
|
|
|
 |
Invest in Excelling with Macros and The World's
Shortest Excel Book. Normally that would
be $39.50.
If you
purchase them together you save almost 25%
($9.75).
|
$29.95 |
When your
payment method is approved, you will be taken to a
special download page where you can download your files
in a minute.
Purchase Online with a secure server. All major credit cards
are accepted. Or, you can make your purchase with
PayPal or your checking account.
   
It's all about time, isn't it? Invest in Excelling
with Macros now and start saving some time today (no
programming skills required).
Best wishes from Chicago, IL, USA.
Richard
Kraneis
Training New
Technology
3427 North
Tripp
Chicago, IL,
USA
rkraneis@techspectrum.com
Phone:
773-685-8746
|
