How-To Geek on MSN

How to randomize rows in an Excel table without scrambling your data

Whether you're assigning random shifts, anonymizing a study, or shuffling a deck, randomizing rows in an Excel table manually ...
How-To Geek on MSN

Stop manually hiding Excel rows and columns for meetings: Use this hidden tool instead

Excel's Custom Views tool lets you create a snapshot of your spreadsheet, allowing you to toggle between layouts.

Learn What GROUPBY Can Really Do in Excel : From Smart Sorting to Percent of Totals

Learn how GROUPBY passes both subset and full arrays into LAMBDA in Excel, letting you compute percent shares fast and explain results clearly.
GitHub

The Sound of Sorting - Visualization and "Audibilization" of Sorting Algorithms

Sorting algorithms are an essential chapter in undergraduate computer science education. Due to their easy to explain nature and fairly straight-forward analysis, this set of algorithms offers a ...

Build Faster Excel Workflows Using FILTER, IFS, XLOOKUP, and LET for Real-World Data

Learn the difference between Excel COUNT and COUNTA, plus TEXTBEFORE and TEXTAFTER tricks, so you clean text and totals with ...
GitHub

Switchable readonly/editable PCF OOB-like subgrid with optional sorting, filters, and support for hidden and locked columns.

HiddenSortGrid is a Fluent UI v9 DataGrid-based Power Apps custom PCF control for Dynamics 365 / Power Apps model-driven apps that extends the functionality of the standard OOB subgrid. It was built ...