How to Extract Information from Excel Tables

Greatest Gold-Mine of Easy "Know the Direct Advanced Lookup Formulas" Advice ever Crammed into One Book
"Who Else Wants to Instantly Avoid All Headaches Extracting Data from Excel Tables, to Translate "End User" Intentions into Reports?"

This Could Be You !

"The guide 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 guide I am much more comfortable with a number of ways to lookup values from a table. The guide 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 your team, 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...

1. 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
2. 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
3. Getting rid of unwanted #N/A errors
4. 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?

1. Once I discovered this, I started to please my boss and customers with the reports they requested.... in a big way!
2. Once I discovered it, I wrote a complicated Lookup formula in just minutes, and the report was configured in front of me
3. 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
4. Generating further "meaningful information" from Excel tables was no longer a time consuming process
5. 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...more detail...