Basic Excel Business Analytics #28: Power Query: Import Multiple Text Files & Build Grade Dashboard


17 comments on “Basic Excel Business Analytics #28: Power Query: Import Multiple Text Files & Build Grade Dashboard

  1. Great video !!!!!!!! Maybe just as an interesting fact, When I was doing a dashboard I had pivot tables coming from worksheets and powerpivot as well. The pivot tables from different sources could not be connected to the same slicer

  2. I didn't think 'refresh all' updated pivot tables unless it was the one selected???… Is it that you clicked the sub-menu 'refresh all' instead of the big button or a newer behavior or am I just crazy???

  3. @ around 12:30 the trick with the diagram title from a cell doesn't work for me 🙁 I have Excel 365, does this make a difference? I put the equal sign into the diagram title field but when I click it just selects the cell.

Leave a Reply

Your email address will not be published. Required fields are marked *