by DerekHenry | Jan 15, 2025 | Efficiency, Excel Tips
Overview Most Excel users are quite familiar with PivotTables (if not, add that to your to-do list!). But have you ever needed to take a report where the data is already pivoted – spread horizontally across several columns – and stack it vertically...
by DerekHenry | Jan 8, 2025 | Efficiency, Excel Tips
Overview The SEQUENCE function is one of the newer dynamic array functions (DAFs) and it’s extremely versatile – whether by itself, when combined with other functions, and when built into custom functions via LAMBDA. It returns an array of sequential...
by DerekHenry | Jan 1, 2025 | Efficiency, Thought Leadership
Overview The new year means many resolutions will be started, and many will be quickly abandoned. The people who succeed in achieving their resolutions (or at least improving on them in a meaningful way) generally incorporate habits. Our lives are largely shaped by...
Recent Comments