Power Query is an amazing tool since it allows you to set up a query once and...

What is Power Query? Power Query is a business intelligence tool available in...

In this post I'll show you how to hack into tons of top secret government data...

Given two separate lists of items, how can you create a list of all possible...

This post will explore how we can easily create a file inventory from a folder and all of its subfolders using Power Query.

This situation happens a lot. Someone creates a pivot table based on some...