QuickTip: Consolidate Excel Data
Consolidate data from multiple tables within Excel into one table using PowerQuery, a basic function, and a parameters table in under 7 minutes.
The Promise Of PowerQuery Custom Data Types
PowerQuery custom data types offer promise of bold and powerful new features in the future; however, their current implementation is currently limited to simple, non-hierarchical data.
Quick Tip: Find The Missing (Data) Links
This QuickTip offers a quick use-case for PowerQuery's Merge command to connect data together in order to locate potential missing pieces.
Subscribe
Subscribe to our newsletter and receive access to exclusive posts and content updates. We don't spam and your email won't be shared with third-parties.