This post will explore how we can easily create a file inventory from a folder and all of its subfolders using Power Query.
How To Get A List Of File Names From A Folder And All Subfolders
read more
All Posts
How To Solve a Quadratic Equation
These formulas will give the solutions to a quadratic equation.
How to Create a Normally Distributed Set of Random Numbers in Excel
What is a Normal Distribution? From a purely mathematical point of view, a...
How To Select A Random Item With A Given Distribution
Not all data is numeric, so when creating random sets of sample data it can be...
How To Select A Random Item From A List
This formula will return a random selection from a given list with each item in the list having an equal probability of being selected.
How To Unpivot Data With Power Query
This situation happens a lot. Someone creates a pivot table based on some...
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 😃
