Excel's PIVOTBY function allows you to group your figures without needing to recreate your data in a PivotTable. What's more, ...

Excel provides built-in tools to help you to find discrepancies like Filters, Conditional Formatting, advanced functions (If and IS, VLookUp, etc.), and Add-ins.

TL;DR Key Takeaways : Excel 365 offers a feature called calculated columns, which allows for dynamic calculations that automatically update with changes in data.