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


PASS EXCEL BI VC presents Gil Raviv - Power Query in Excel 2016

Tue, Jul 21 2015 15:00 W. Europe Daylight Time


Power Query in Excel 2016

Did you try out Excel 2016 Preview? Join us in this session to learn how we have integrated Power Query in the new Excel - Power Query is no longer an add-in. It is accessible via the Get & Transform group in the Data Ribbon, and work better with native Excel functionality like Undo/Redo & Copy/Paste. In this session we will show you plenty of demos that will focus on the biggest advantage of Power Query technology in Excel – Its support of Object Model. You will learn how to incorporate Power Query formulas into VBA, Powershell or other languages to create powerful self-service ETL scenarios, and use Macro recoding to quickly get your automation working.

Gil Raviv

Gil Raviv is a Senior Program Manager at Microsoft, and is working on the future of Get-Data experience in Excel. For the last 1.5 years, Gil worked on the integration of Power Query technology into Excel 2016. Before Gil joined Microsoft two years ago, he was Director of Product Management at a cybersecurity startup, and a Product Innovation Leader at Check Point Software Technologies.


Back to Top