Loading...

Highline Excel 2016 Class 21: Power Query Import Multiple Excel Workbooks with Multiple Sheets

14,363 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Jun 9, 2016

Download Files: https://people.highline.edu/mgirvin/A...
In this video learn about how to import multiple Excel files using Power Query (Get & Transform):
1. (00:15) Introduction
2. (01:32) Files used for Import
3. (02:46) Multiple Excel Workbooks with Multiple Sheets
4. (03:50) Get "City" names from Excel file names
5. (04:40) Use Power Query Function: Excel.Workbook([Content],true) to get Excel Data and Promote Headers in each excel File.
6. (06:06) Get "Sales Rep" names from Excel Worksheet names

Loading...

Advertisement
When autoplay is enabled, a suggested video will automatically play next.

Up next


to add this to Watch Later

Add to

Loading playlists...