Highline Excel 2016 Class 21

Power Query Import Multiple Excel Workbooks with Multiple Sheets

DESCRIPTION

In this video learn about how to import multiple Excel files using Power Query (Get & Transform):
(00:15) Introduction
(01:32) Files used for Import
(02:46) Multiple Excel Workbooks with Multiple Sheets
(03:50) Get “City” names from Excel file names
(04:40) Use Power Query Function: Excel.Workbook([Content],true) to get Excel Data and Promote Headers in each excel File.
(06:06) Get “Sales Rep” names from Excel Worksheet names

WORKBOOKS

Download “Highline Excel 2016 Class 21” 2z3qiunpc1wte3ad4mce0l3wzeuax5a1.zip – Downloaded 20 times – 8 B







Be the first to comment

Leave a Reply