This is the first issue of a new series on all things Excel. In each edition, I will share with you some Excel articles of interest that you might not be aware of. I hope that this will be a valuable resource to you. It will (eventually) cover all aspects of Excel, ranging from old to modern Excel topics.
How to sort an Excel slicer without a custom list, DAX, or VBA
DAX Patterns: Related Distinct Count
Calculation of Molecular Weight using an Excel Formula
Combinatorics using Excel formulas
Make the Sample Binary file path Dynamic (Power Query)