|
The Excel Lookup Toolbox that Pulls Answers from your Excel® Lists
"How to Save Time and Effort, Impress Others, and Get Things Doneby Turbocharging
your Excel Reporting Skills""The
Last Secrets You will ever Need to Easily Turn End-Users Intentions into End-Users-Speak Reports"Dear Excel User,
I am John Franco, the founder of Excel-Spreadsheet-Authors.com and in
just a moment I will show you how to load your “What are our numbers for the XYZ for the month of December?” in an Excel sheet and then present a shiny "manager-speak" report.
...Just as Excel Veterans sit and converse with flat
tables, day in day and day out.
I have felt the horrible frustration of having the data that the IT
guys put in your workbook, but not being able to access to it from a
formula in a cell. You reach the point in which you say to yourself...
"Self, there has got to be a way to do this,"
but I
just
can't
figure out what it might be. Even after having looked through
Excel
Help you can't seem to figure out which functions you need to use to do
what you want... Having multiple lines which all pertain to one record
and
needing
to be able to summarize them into one lineWorking with thousands of lines of data and dozens of
columnsWanting to be able to tell Excel that if
certain
columns
match, then summarize these lines and give me a sum total on
other
column or cellWanting to be able to tell Excel that if
certain
columns
match, then return the value that meets any given criteria on
other
cellBelieve me that when I didn't know how to do it, I desperately copied and
pasted the values in a static report that was outdated as soon as I
created.
Now, after years of being blank in front of intimidating Excel
tables, visiting forums, doing research, etc. I have filled my Excel
toolbox with all the tactics to extract data from tables. I am helping hundreds of data guys with the same flat-table-conversation problems like yours; they are data analysts, financial guys, HR guys, and professionals who work with lists every day.
Trust me on this (my testimonials also back my up)... Here's the story: Esther is a Finance
Assistant from Singapore...
She faced great problems last year when she was trying
to
work
on a payroll in Excel that had multiple & complicated criteria...
There were tables (local, PR1, PR2 and PR3) to look into
with
ranges
of ages, salary levels that had different rate computation to calculate
the staff's required CPF contribution set by the government.
On top of this, there were many other types of
computations
that she
could not either find a direct formula to it or did not know how to
apply her knowledge to the available ones.
Do you understand what this means?
She was conscious about her kind of
formula-short-sightedness.
Her Excel Toolbox was limited to the IF & AND
formula
and
the
VLOOKUP that she knew, and had to find her way to experiment with the
rest.
She was not familiar with many of the formulas
that
she
knew
should exist for extracting data from complicated tables.
Anyway, she needed to get the job done.
Have you been in those
moments in which you are prone to do whatever it takes?
At last; she was
able
to
write the formula, with more than 7 criteria in the IF function.
Believe me, the hostile formula had paragraphs in just
one cell that
was
complicated to maintain.
But wait, there's more...
It took her months to complete the work of making the
formula
user-friendly and not only applicable to her own use.
Don’t quit reading now - I have something really
important for you right here
October
09, 2009
"I feel lucky to be able to own a copy of your guide, something I wish to look for."
Esther
Low
Finance
Assistant
Manufacturing
Singapore
One day, I thought I had found the solution to my
reporting headaches...
I started using Pivot Tables; until I
was
unable to
eliminate all the space it occupies in the sheet to present the
information my boss needed.
Moreover, this tool didn't allow me to nest my lookup
values
in
other formulas, neither having control cells I could change to see the
output immediately.
I discovered why the Excel Lookup
Formulas are
irreplaceable!
Just get straight on this
fact: Your life at work will NOT
take off... until you get your reports done with the tested Lookup
formulas and proven secrets that ONLY an Excel
veteran can
reveal to you.
You can do it too...
It won't take you years as it took me to learn to do all
those intricate Lookup computations
very
intuitively.
I was sure I was going to die...
I spent time and effort on trial and error attempts,
visits
to
forums, asking local experts at my office, gazing at some consultant's
spreadsheet, etc to fill my Excel toolbox with the formulas that allow
me to produce reports to answer the unusual questions from my boss or some
customer.
What do you need to do in order to get these secrets?
First, you must be aware that the reporting workload
won't
stop for
the rest of your work-life; even, it will increase.
So...
Get the determination today to learn the relevant
formulas
you
need
to get your reports doneBe aware that taking the learning by yourself may
take
you
yearsBe aware that Pivot Tables are a great resource but
not
applicable for creating reports in the format end-users wantBe aware that Pivot Tables have limited aggregate
functions
availableYou should be able to present a value from a table in
any
given
cell and to embed it in formulas
Are you ready?
September
24, 2009
"I
view myself as
an
expert when it comes to Excel and using formulas, at least I thought so
until I read your guide. From a Vlookup perspective, I was
very
comfortable but your guide goes beyond the basic Vlookup.
In
my
work with data
tables, If the table was not in the right format to fit a Vlookup, I
would arrange the data so that it would work. After reading your guide
I am much more comfortable with a number of ways to lookup values from
a table. The guide is my” lookup bible”.
The
ease of use of
the
guide is very helpful and very friendly to use especially the How To
with the needle and haystack"
Harold
Grady
Analyst
Professional
Boston
It does not make sense that you spend time again in finding the lookup
techniques that will solve your data related problems.
At last, dispose of fundamentals, techniques and
available
functionality to do Lookups effectively and comfortably so you get
critical insights from any problematical Excel List immediately
Introducing…
The Excel Lookup
Toolbox
45 formulas that will
pull
almost any
answer
from your list
Rediscover the sense of achievement of
identifying
trends
built
on you queries in a cell.
This eGuide is a handy eBook that really
empowers
you to
deal
with Lists with multiple and complicated criteria effectively.
What's inside for you?
It contains friendly explanations of the 10 most potent
Excel
Lookup
formulas: VLOOKUP, INDEX and MATCH, SUMPRODUCT, Array Formulas,
COUNTIF, COUNTIFS, SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS.
And a ton more...
Be proactive with Data problems. Answer new questions
that will empower you to know more about your numbersYou will soon be creating multiple and
complicated
criteria
Lookup FormulasBecome adept to present information and satisfy
customer questions day after day in the formats that make sense to themStop wasting your analysis time by
developing
error-proof Lookup Formulas. You will do this by preparing the backend
list to be queried properly, and by following clear guidelines at the
frontendMake your boss trust your reports since he will
receive
legitimate and professional messages instead of unexpected #N/AsYou won’t struggle anymore with Vlookup when you face
growing-in-complexity computations
The book presents those formulas in action, showing you
how to
solve
45 Lookup scenarios you may need for your job.
No matter if you previously did basic reports only or no
reports at all, the
lookup secrets you never knew will be revealed to you
Important
notice
for Excel 2003 users
The following
formulas are
not supported
in
Excel 2003: SUMIFS, COUNTIFS, AVERAGEIF, AVERAGEIFS but the book gives
you the alternative methods to achieve the same functionality.
Those methods involve
Array
Formulas or
SUMPRODUCT.
You will have step-by-step blueprints and formulas for
getting your own end-users-speak reports as fast as possible...
This video anticipates you 6 great benefits you will
enjoy
using The
Excel
Lookup Toolbox...
You will be required to be on the team, as you gain
expertise in working with lists…
You will feel comfortable doing Lookups everyday and
have
the
energy to analyze data. You will start sending eye-opener reports to
the guys who take decisions day after dayYou will lead the understanding of key trends in your
office
since you massage the data in ways that make sense to you.
You
will get new insights and be prepared to defend your point of view in a
meeting or discussion. In other words, create your own
reports and
consume themSooner or later you will be promoted because you add
value
to the
bottom line of your business or department. Yes, you will gain the
respect of the guys who receive your high quality answers and reportsSave money by using existing Excel software licenses
instead of
buying complex BI software, Database or Add-in. One thing for sure,
those packages will export reports back to Excel; you will
need
again to
analyze data exploiting Excel flexibilityAnd more…
No one helped me during my
first years. I KNOW how
important a little mentoring can be... and I am now very happy to BE
that mentor to others.
October
09, 2009
"The
result of your
work is successful because your guide contains no lengthy but only
plain and important information.
I
could
see that you
are
very careful and detailed in your illustrations.
Not
only you try
your very
best to include every single bit of element that could help users to
understand better in your illustrations, your extra effort in further
emphasizing on the elements like bolding and enlarging them to make
them very visible so that users will not miss them."
Esther
Low
Finance
Assistant
Manufacturing
Singapore
Disclaimer
This site and the products and services offered on this
site
are not
associated, affiliated, endorsed, or sponsored by Microsoft, nor have
they been reviewed tested or certified by Microsoft.
It gets even better...
Turn End-Users
Intentions
into Usable
Reports
Here's
another story: I got nervous each time Nilton (my boss) approached me
for a new report, a single phrase meant hours of work. "John, I need
the October Sales of Susan, Frank and Tom compared against the June
Sales", "John, prepare a list with the Sales by suppliers..." I hated
those seconds because I was not able to turn their words into
reports as fast as he communicate them.
I don't
feel the same anymore.
Imagine yourself going straight to produce the
reports...
Because in a moment, I
will reveal you the Excel lookup secrets to extract answers from flat
tables.
For that reason I prepared this book so
you discover the methods to turn those questions into queries
that work.
Does it sound improbable?
Well, the eBook contains 45 Lookup scenarios so you can
crunch almost any Flat Data
Table.
The guide is a kind of Lookup Dictionary full of
techniques
that you
can apply immediately.
You will learn the different methods that exists in
Excel
to do
Lookups (VLOOKUP, Array Formulas, SUMPRODUCT, etc) and conditional sum
formulas (SUMIF, SUMIFS, COUNTIF, AVERAGEIF, etc)You will be able to find the direct Lookup formulas
to do
crunch
multiple columns and multiple linesYou will be able to work with Excel lists with
multiple and
complicated criteria
Can you Google this info?
I would like to ask you a question too...
Can
you find on the web how to raise a baby? Of course, but at what cost,
the information is spread, you need to compile it, uniform different
formats, different authors, etc. The worst part is dealing with
recycled content.
So, I have processed what is said out there,
polished it and added my years of experience (to avoid typical costly
mistakes) so you find all you need here, a book that you can take with
you and study as you demand.
So, The Excel Lookup Toolbox eBook
is more
than a
glossary,
it offers you complete and detailed Lookup information: you have a
formula explanation, highlighted graphics, handy guidelines to avoid
reaching #N/A dead-ends...
It tells you what to do at the backend and frontend, for
example: How to delete duplicates in the index
column, How to
hard code a Date into the lookup_value…
Gain the expertise to
write complex formulas faster and
without
committing errors that novice users commit.
This independence gives you momentum that keeps your
motivation high
to overcome data related problems; you will provide increasingly
complex answers day after day.
You will use your creativity and also spend
less time
for
creating complex reports requested by upper management that
they
need immediately.
But wait, there's more...
September
14, 2009
"I
work
in the Human
Resources industry and data lookup and report generation is something
that we need to do day in and day out, prior to reading this book I
thought VLOOKUP was the only way and used to swear by the formula.
This
e-book was
truly
enlightening and got to know so many ways to do an easy and effective
lookup.
Still
exploring the
application of the lessons learnt from "The Excel Lookup Toolbox".
Anybody
who has
anything
to do with data lookup should definitely read this book.
Thanks
John"
Karthik
G
Manager
-
Human
Resources at
Mascon Global Limited
India
Stop Guessing about
the
Possible Lookup
Solutions
Trust me on this: If Esther and I experienced a
lookup-method-search
desperation, why being in the same situation. This is a typical path of
Excel users: struggling for years until they discover that the solution
was two formulas away.
You have an advantage over us...
The Ebook Contains 35 Lookup Formulas Scenarios so…
You will be able to
work with Excel lists
with
multiple
and
complicated criteria with total confidenceYou will know the different methods that exists for
lookup
data
from listsYou will stop experimenting with formulas and achieve
the
data
extraction you wantYou will find the direct lookup formula for
a
complicated
criteria by using: INDEX and MATCH, SUMPRODUCT, Array FormulasYou will save time in producing the lookup formula
you want
because you have the more typical cases here. If your case is not here,
you can produce it by combining the Lookup building blocks that the
book offers you
What's
better than a digested advanced formula?
For example:
LOOK UP the Max/Min Number:
=INDEX($A$2:$D$7,MATCH(MAX($D$2:$D$7),$D$2:$D$7,0),1)LOOK UP a Number with Decimal Places:
{=INDEX(Haystack!$A$2:$E$14,MATCH(A2,ROUND(Haystack!E2:E14,2),0),1)}LOOK UP a Month Using SUMPRODUCT:
=SUMPRODUCT((MONTH(Haystack!$B$2:$B$7)=A2)*Haystack!$C$2:$C$7)And more…
And don't commit this mistake...
You can buy a software package in the market that
produces
complex
reports like: SAS, Access, Oracle, many Add-Ins, etc but they take time
to learn, they are expensive and moreover, if your department already
has one you are more productive manipulating the data in
Excel at
your own style.
Each section of this in-demand Excel book has
been carefully designed to
short-cut your path to becoming a KILLER creator of usable and
perceptive reports in Excel.
September
16, 2009
"This
book is
extremely
helpful and insightful. Well worth the read.
I
have
to say the
most
refreshing thing about this is that most industry books spend way too
little time on VLOOKUP and all the DATA functions (DSUM, DGET and
DCOUNT). You would think the world went Pivot Table crazy."
Kevin
Fitzpatrick
HR
Compensation &
Business Analysis Manager at DTCC
Greater New York City Area
Don't lose what's next!
You will also know the 8 Different Methods that Exists for Conditional
SUM, COUNT and AVERAGE...
You will be able to summarize large amount of cells
quicklyYou will combine totals, counts and averages with
lookup
results
of the 35 lookup methods of the guideYou will be able to work with Excel lists with
multiple and
complicated criteria as you would be working with other powerful
commands like: Pivot Tables, Filter
For example: you will produce reports like these ones…
Sales by Salesperson, by Product, by Region, etcAverage sales by Salesperson, by Product, by Region,
etcNumber of Yes answers in a poll, etcAnd more…
I don't care if you've never written a
lookup formula in your life.
Or if you're just starting out.
Gain all these expertise in a very intuitive way…
Now you may be thinking that learning sophisticated
Lookup
formulas
will be difficult and bored…
Take the Advantage
of
Learning very
Advanced
Lookup Techniques in a Friendly Format…
The eBook contains Examples full of details: Frontend, Backend,
highlights, how to box, syntax, etc.
Gives you a better overview of the items involved in
the
backend/frontend areas but no more than necessaryDepicts in your mind the Lookup Formulas variables
and
makes them
more manageableYou will be able to write formulas for complex
criteria in
an
intuitive wayYou will enhance
your skills further so you will face
new
and
complicated lists in a positive attitudeYou will be able to solve any Excel list problem by
yourselfYou will gain independence and confidence for new
challenging
assignments
Well, I have considered everything very carefully before offering it to
you...
September
18, 2009
"Jonh's
Toolbox to
Excel
Lookups is a very useful book for people working with data using
Excel.
The
book details several scenarios of Lookup using Vlookup, Index
&
Match in great detail. The language is simple to understand
and
easy to follow.
I get tremendous productivity
in my work by using the right Lookup tricks.
I
recommend
reading
this book if you work a lot with data and tables."
Chandoo
Pointy
Haired Dilbert
chandoo.org
So here you have my...
Risk-Free Money-Back
Guarantee
If for any reason whatsoever, you are not completely
satisfied,
simply let me know within 60 days and you will receive a full and total
refund. Absolutely no questions asked.
Request a refund here: Contact Me
Today's lack of
relevant skills, tomorrow's lost opportunities
As a Staff Auditor, Bill apply the Vlookup function to
find it not
producing the precise results he was looking for, it results in N/A
errors,
or he is inefficient to implement it and rely on it.
He doesn't know where to find the formulas and the
guidelines to get the answers... Don't
feel blank when it comes to massage and present data from flat
tables. You will continue receiving such files day after day...
I
had to slog through years of trial and error, making
every lookup mistake possible, learning my Excel lessons painfully...
and moving
forward slowly to listen my boss and translate his head into
reports.
Trying to write an advanced Lookup formula without
success
impedes
you to massage data in the ways that make you learn, and to present
information.
With these lookup tactics, these things will be soon an
experience from the past.
You are about to dispose of a complete Excel
Lookup
Formula
Dictionary with the scenarios that will allow you to work with lists
full of multiple and complicated criteria.
Click
Here to
Order Now!
You will EASILY make your entire
investment back the FIRST TIME you put almost any of my stuff to work
for you. (the testimonials here back me up.)
If you order now the Toolbox that really pulls tons of
answers
from
your lists at the incredible price of $29.8
$19.85
(low
price is not forever)
you will receive...
The toolbox as an instant downloadable Pdf
file
and
also…
Bonus 1 – The complete set of 45
.xls
files with
examples.
Explore the Lookup formulas by yourself at any time and discover the
techniques from within Excel
Bonus 2 – The Error Manager
Factsheet.
No more #N/As
traps. Save time by avoiding unnecessary errors with this handy matrix
that outlines all the Lookup variables that may lead to problems. An
unwanted error will be a thing from the past
60 Days Guarantee - If for any
reason
whatsoever,
you are
not completely satisfied; you will receive a full and total refund.
Absolutely no questions asked
Decide for yourself…
Click
Here to
Order Now!
(secure online
ordering)
September
07, 2009
"I
must
say that
this is
very valuable content. I have used many excel tutorial books when I was
starting off but yours is leagues above.
I
never
thought that
somebody could give the Lookup function so much thought and studied it
so much in depth. We could definitely benefit from your mega
work.
What I like best in your book is the language, I really like the free
flow expression of ideas through practical and easy to relate to
illustrations.
I
look
forward to
reading
more of your books and I wish you all the very best!"
Abhishek
Raju
Lead
Researcher at
Indian
Institute of Management
Bangalore
Area, India
abhishekraju.com
What you are about to have in your own hands... is the
EXACT
same formulas that has brought such wondrous results for so many others
Excel veterans in their work with lists....
Wouldn't you want to
implement your lookup queries and rely on them?
I've spent HUGE amount
of time with #N/A wallpapers.
You know what I mean...
2% of your
time writing the formula and 98% troubleshooting it.
I
did this for almost every flat table I wanted to pull. The errors
drained my energy for the analysis.
What would you do with your time if you wouldn't
be in a lookup trap anymore?
Imagine
yourself massaging data, redoing the reports as your end-users require,
learning more about the data and be proactive about numbers.
Feel the
Sense
of
Achievement of Getting Trends Based on your Query in a Cell.
Learn...
How to prepare the list to be queried
How to reference or hard code parameters in formulas
How to control the causes of unexpected errors and
make the
data
flow to the front end
And more...
People love to see trusting numbers breathing
in front
of
them, if
you are
the guy who provides such insights; you are near to gain their hearts.
Your promotion is just a matter of time...
This handy Toolbox
that
pulls tons
of
reliable answers from the same lists you have had in front of you, day
after
day, will cost you 29.80.
But
now get it at a very Limited Offer $19.85
(launching price,
low price not forever)
Order
Now
That’s not all, you will receive two bonuses…
Bonus
1
Explore by yourself how Basic and Advanced LOOKUP
Formulas
work,
with a compilation of 45 .xls files with the 45 Examples of the eBook.
Bonus
2
Keep away of reaching a #N/A dead-end for the rest of
your
life.
Control all the variables that produce problems in Lookup formulas.
October
09, 2009
"You
are able to
produce
this Excellent Guide because I could feel that you are a very
thoughtful person.
You
take the
great
trouble to always stand at the user's point of view to capture and
address all the possible problems not only advanced but also elementary
users would face and cleverly design you work that even
elementary
users could understand and be able to learn the advanced functions
easily.
Thanks
for your
THOUGHTFULNESS!"
Esther
Low
Finance
Assistant
Manufacturing
Singapore
P.S Enjoy the sense of accomplishment of
trusting
results. Become
adept to massage and crunch Lists with multiple and complicated criteria.
Click
Here
to Download the eBook Now!
P.S.S You will do Lookups comfortably
and
effectively
day
after day. The sense of accomplishment of extracting trends
and
putting them in cells is priceless.
P.S.S.S Don’t hesitate. You are
completely
covered with
my
full refund 60 day guarantee. Click
Here to
Download the eBook Now!
var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www.");
document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));
try {
var pageTracker = _gat._getTracker("UA-8396218-1");
pageTracker._trackPageview();
} catch(err) {}
If you have any question about the product, drop me an email: john@excel-spreadsheet-authors.com
|
