Power Query is an amazing tool since it allows you to set up a query once and...
How to Deal with Changing Data Formats in Power Query
read more
All Posts
The Complete Guide to Power Query
What is Power Query? Power Query is a business intelligence tool available in...
How to Create Delete and Rename Folders from a List
I started making videos to go along with my post on pivot tables called 101...
How To Access A JSON API With Power Query
In this post I'll show you how to hack into tons of top secret government data...
How To Conditionally Concatenate A Range
This formula will conditionally concatenate a range based on a criteria in another range.
How To Generate All Possible Combinations Of Items From Two Lists
Given two separate lists of items, how can you create a list of all possible...
Get the Latest Microsoft Excel Tips
Follow Us
Follow us to stay up to date with the latest in Microsoft Excel!
Subscribe for awesome Microsoft Excel videos 😃
