Taking Advantage Of Excel’s GROUPBY Function Not long ago, I wrote about Excel’s PIVOTBY function – a recently published Excel feature that allows you to build formula-based PivotTables in Excel.…
Tag: Excel
Can You Build Formula-Based PivotTables? Now You Can With PIVOTBY!
Can You Build Formula-Based PivotTables? Now You Can With PIVOTBY! For years, I’ve said that PivotTables are Excel’s best feature. Their near-limitless number of ways to summarize without writing formulas…
Improved Audit Trails In Excel With The Show Changes Feature
Improved Audit Trails In Excel With The Show Changes Feature Many long-time Excel users are aware of the application’s Track Changes feature. Although Track Changes is a useful and reliable…
Adding Data Types To PivotTables
Adding Data Types To PivotTables Many business professionals consider PivotTables one of Excel’s most powerful features, if not its’ most powerful feature. Although not as widely used as PivotTables, Excel’s…