I'm not arguing that PivotTables are now useless, because they still solve certain problems very well. However, after seeing how fluid, responsive, and adaptable GROUPBY and PIVOTBY can be, I've found ...
Whether you just closed a tab accidentally or have one in the back of your mind you need back, Command + Shift + T can get it back. Press it once to reopen your last closed tab, and keep pressing it ...
Create a CRM using Excel with dropdown customer selection and FILTER plus XLOOKUP, saving time while keeping leads and deals ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results