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

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


You May Also Like

About the Author: Oren Garnes

17 Comments

  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.

  4. great video!  Do you have any more dashboard creation vids? I did a search but this is all I found. Thanks for your response

Leave a Reply

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