Module 02 · Pull in and combine 12 files
Checkpoint: pull & combine data
A quick 4-question quiz: From Folder, ~$ files, the sample file in Combine Files, and the Import Data choices, before you move on to Power Query.
- After Data → Get Data → From File, which item do you pick to pull in all 12 expense files at once?
- From Excel Workbook
- From Text/CSV
- From Folder
- From PDF
- The file list shows 13 rows, and one of them starts with ~$. What should you do?
- Close every open expense file, then run Get Data again
- Click Load so that file gets read too
- Delete one monthly file from the folder
- Switch to From Excel Workbook
- Excel combines the 12 files by learning from one sample file. What is required for every file to combine correctly?
- All files must be open
- Every file must have the same number of rows
- File names must start with a date
- Sheet names and column headers must match in every file
- In the Import Data window, which combination does this course use?
- Table + Data Model ticked
- Only Create Connection + Data Model ticked
- PivotTable Report, Data Model unticked
- Only Create Connection, Data Model unticked