Data-Load-by-File
Data-Load-by-File

Excel > Data > Get Data > From File > 
> Browse to Folder with the data > Select File > Import
  > Navigotor > Select worksheet with the data 
    > Load
      > Queries & Connections > Connection is created > Double-click 
      > [Power Query Editor]
    
Excel > Data > Get Data > From File > 
> Browse to Folder with the data > Select File > Import
  > Navigotor > Select worksheet with the data 
    > Load (Dropdown) > Load To > Table, Existing Worksheet, Cell A1
      > Queries & Connections > Connection is created > Double-click
        > Delete, Rename, etc