Excel Power Query and Power Pivot

As we all know Excel is a very powerful tool, however sometimes where your data is spread across various spreadsheets and other files trying to summarize it all can be tricky.  You can add various lookups to pull in data but when you [...]