Learn how to SQL left join multiple tables from multiple sheets in Microsoft Excel using Power Query. This tutorial outlines differences between using VLOOKUP and SQL like join, shows how to choose join types, like left, right, inner and full, as well as how to concatenate columns in Power Query.

Download Power Query for Excel 2010 & 2013.
https://www.microsoft.com/en-us/download/details.aspx?id=39379

#excel #sql