How to Extract Information from Excel Tables NOW

Produce Excel Reports to Please your Boss and Everybody
"Who Else Wants to Instantly Avoid All Headaches Extracting Data from Excel Tables?"

This Could Be You !

The book is my ”lookup bible"

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 book I am much more comfortable with a number of ways to lookup values from a table. The book is my ”lookup bible”.

Harold Grady
Analyst Professional
Boston

Get The Book Now

Hi, I'm John Franco, if you would like to discover how to extract data from Excel tables, to answer unusual "end users" questions and to create perceptive reports for you and for your manager I can show you exactly how to do it quickly and easily.

Listen closely now...

This is something I do extremely well. I have been successfully manipulating Excel Tables with hundreds/thousands of rows, multiple columns, and with multiple and complicated criteria for over 5 years...

I started with the same problems you are having today, and I know what it feels like to be pulling my hair out for failing to adapt the existing formulas I knew, (VLOOKUP, IF, SUMIF, COUNTIF) and not knowing the direct Lookup formulas that I knew exist or should exist.

That's not all, These things really scared me...

Wanting to be able to tell Excel that if certain columns match a given complex condition, then summarize these lines and give me a sum/count/vlookup in a different column or cell
Having multiple lines which all pertain to one record and needing to be able to summarize them into one line, while they match a multiple column criteria
Getting rid of unwanted #N/A errors
Implementing a VLOOKUP unsuccessfully

And that's just for starters!

Being fond of my hair, (it hurts when I pull it) I reached the point in which I said to myself...

"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, I could NOT seem to figure out which functions I needed to use, to pull the answers I wanted...

After years of being "blank" in front of intimidating Excel tables, visiting forums, doing research, etc. I discovered the direct Lookup formulas you need to translate "end users" unusual questions into reports. It changed my life and career dramatically!

Do you understand what this means?

Once I discovered this, I started to please my boss and customers with the reports they requested.... in a big way!
Once I discovered it, I wrote a complicated Lookup formula in just minutes, and the report was configured in front of me
I even started to massage the data for my own consumption in ways I could not do before. I started to make sense of the data and gain knowledge to make better decisions. Suddenly, I knew more than all my peers about our company's figures
Generating further "meaningful information" from Excel tables was no longer a time consuming process
I no longer feared my boss when he came with new and unusual reporting requests

And check this out...

I was soon considered for a promotion, and my career advanced!

But wait - there’s more

Now...I am helping hundreds of data professionals... of all experience levels with the same flat-table-conversation problems like yours; they are aspiring Data Analysts, Finance Assistants, Data Analysts, Financial Experts, HR Department Heads, and OTHER professionals, SOME OF whose clients include MANY of the best known companies in the world, such as Shell Oil, American Express, General Electric, Mr. Excel.com, BMW, Merrill Lynch, Kaiser Permamente, Honda, and several others.

For example...

"The easiest way to impress everyone at work and get things done"

"I recommend the "How to Extract Information from Excel Tables" book for anyone working on Excel to manage and report data. The book can teach you some really awesome tricks and help you become better at writing lookup formulas. That, my dear reader is the easiest way to impress everyone at work and get things done."

Chandoo
Pointy Haired Dilbert
Chandoo.org

Your book is my ”lookup bible"

"I view myself as an expert when it comes to Excel and using formulas, at least I thought so until I read your book. From a Vlookup perspective, I was very comfortable but your book 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 book I am much more comfortable with a number of ways to lookup values from a table. Your book is my ”lookup bible”.

The ease of use of the book is very helpful and very friendly to use especially the How To with "the needle and haystack"

Harold Grady
Analyst Professional
Boston

I don't care if you've never written a lookup formula in your life.

What's in it for you....

Learn how to easily implement a VLOOKUP succesfully
Stop the hair pulling and headaches! Discover - like many others who used to swear by VLOOKUP, - it is NOT the only way
No more time sucking searches in several places (forums, blogs, several books, etc) only to find superficial results on the lookup formulas topic. This is like no other book on the market ! An in-depth EASY TO FOLLOW reference guide about Excel Lookup formulas for Report generation
Learn how RIGHT NOW - to easily execute a successful Vlookup (free of unwanted #N/A errors) with a step by step proven checklist and expert "best practice" guidance
Never again feel "in the dark" and having no ideas about how to get rid of #N/A errors
Avoid being paralyzed by lack of knowledge in all the ways to manipulate data. In this guide you will quickly learn that there are so many methods Excel possess for manipulating data effectively
Find the direct Lookup formulas to crunch multiple columns and multiple lines - FAST and EASY
Fearlessly work with Excel lists having multiple and complicated criteria
Stop experimenting with formulas you are not familiar with, and achieve the exact data extraction you want.... right now!
Quit going in circles, trying to adapt formulas that are not suitable for your multiple criteria purposes: VLOOKUP, COUNTIF, SUMIF
Instantly become the master of the most powerful methods to perform a complicated criteria or multiple column lookup by using: INDEX and MATCH, SUMPRODUCT, Array Formulas
Say goodbye forever to lost opportunities to shine at work, because you are not able to massage or make sense of information that lies dormant in your Excel List
Permanently stop your "end users" from complaining about the layout of the report being too complicated, since you will easily be able to provide only the data they need and request
Consistently answer unusual "end users" questions, letting them know that the last occasion was no coincidence or fluke
Satisfy diverse "end user" format preferences, by developing any "end user" layout needed

Become an Excel Power User

Via secure server

Who else uses this ?

"Anybody who has anything to do with data lookup should definitely read this book"

"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 "How to Extract Information from Excel Tables"

Anybody who has anything to do with data lookup should definitely read this book.

Thanks John"

Karthik G
HR Manager at Mascon Global Limited
India

What else is in it for you?

Stop sending so many Pivot Tables to "older versions users" and Excel veterans, who usually hate PTs because they don't know how to use them and it takes them too long to figure out
Quickly understand the many useful functions yet unknown by many "Excel Experts"
Always have options when you are not "comfortable" with one lookup method in particular. This guide offers you many very useful methods that will now, always be available
Stop fighting your way through hard to understand technical guides full of "Geek Speak", that are not written or formatted in a "User Friendly" way. This guide is not only VERY helpful, but EASY to use
Instantly gain a deep understanding of the Lookup Formula arguments, making them much more manageable
Stop racking your brain, wasting precious time in forums, and listening to "wanna be" experts to get the formulas you want
Silence the complaints from your manager and customers about not being able to change the inputs in the reports and see the results immediately
Prepare the reports exactly as your "end users" requested, with the same layout and figures, and no more
Instantly have the expertise to know exactly how these complex lookup formulas work, so you can maintain them, even months after completing the work
Kill the frustrations with complex computations, like multiple column and multiple criteria, that you can neither find a direct formula for, or don't know how to apply your knowledge of the formulas you do have, to them
No Worries about listening to a manager, and easily translating what she says into data fields
Stop 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 frontend
Your boss will trust your reports since they will receive legitimate and professional messages ("Items not found", "Missing", etc) instead of unexpected #N/As messages
Never again struggle with a lack of resources (only Vlookup) when you face "growing-in-complexity" lookup computations
Now you will feel comfortable and confident doing Lookups everyday, and have the energy to analyze data. You will start sending eye-opening and highly functional reports to the busy professionals and decision makers who request them

As it turns out...

I've put all this information into a simple ebook that you should check out right now. The cost is just $29.99.

Become an Excel Power User

Via secure server

It gets even better!

You Risk Nothing !!!

100% Money Back Guarantee

Try my book for two months! and...

If the Formulas and tips in this ebook don't Measurably Advance your skill level and Improve your Productivity with Lookup Functions, Excel Report generation, AND Seriously Increase Your Enjoyment of using Excel, then simply request a full refund from ClickBank.com

NO Hassle, NO Run Around, NO questions asked.

To download this book, just click here, fill out the order page and follow the simple directions. You are literally - only seconds away from TURBOCHARGING your Excel Reporting skills by 1000% with this amazing ebook. And you can see for yourself what all the fuss is about !

One more thing - it’s important!

As a free gift to you just for trying my book, I'm also going to throw in these two "killer compliments" - - which will free you from unnecessary debugging unwanted #N/A errors and will accelerate your ability in getting trends, based on your lookup queries!

Bonus 1

Explore for yourself, how the Basic and Advanced LOOKUP Formulas work, with a compilation of the 45 Excel .xls files with the 45 Examples of the eBook.

You can play with these files, they are completely editable and you can even use the formulas as templates to adapt to your own solutions.

Bonus 2

Stop being trapped in a #N/A dead end for the rest of your life. Be aware of the factors that produce problems in Lookup formulas, with this handy matrix in PDF format ready to be used as a troubleshooting wizard.

You will no longer dedicate your analysis time to debugging awful #N/A errors.

The data will flow effortlessly from the Table to the frontend report

>>>>>>>>>><<<<<<<<<<

Become an Excel Power User

Via secure server

Thanks

John Franco

P.S This is a limited introductory price, so grab it NOW before the price goes up!

P.P.S Remember, No More frustrations and headaches trying to manipulate data, or returning to the office tomorrow and being asked by "end users", for reports you won't know how to do.

P.P.P.S Don't let the errors keep draining your energy before the analysis starts. What would you do with your time if you wouldn't be in a lookup trap anymore?

If you have any question about the product, drop me an email: john@excel-spreadsheet-authors.com

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.

� 2010 Excel-Spreadsheet-Authors.com All rights reserved