The Excel BI Virtual Group offers training and support to individuals who use Excel.

News and Updates

The Conference for SQL Server & BI Professionals

Connect, Share & Learn at the largest conference for SQL Server & BI Professionals. Stay ahead of the curve with the most technical sessions, delivered by the world’s experts, and connect with 5,000 attendees from around the world. Join us in Seattle, WA, Oct. 30 – Nov 3, 2017.

Interested in presenting?    
Please contact us at


From VLOOKUP to table relationships by Dany Hoter/Guy Humkin

Thu, Apr 30 2015 12:00 Central Daylight Time


From VLOOKUP to table relationships by Dany Hoter/Gut Hunkin

We'll do an in-depth comparison of this two ways to join data tables in Excel. We'll talk about performance aspects as well as advanced VLOOKUP scenarios and how they can be solved in Power Pivot using relationships

Dany Hoter

Senior Program Manager at Microsoft ILDC


Back to Top