Modern business intelligence demands speed, and utilizing AI tools for Excel is the ultimate way to hyper-charge your data workflows this year.

Learn how to customize Copilot in Excel to automatically apply your preferred date formats, table styles, and modern formulas ...

PivotTables can do more than you think, from splitting reports by category to calculating unique counts and percentage growth ...

Learn how to use Excel's new GROUPBY and PIVOTBY functions through five real-world examples, ranging from easy to hard. This ...

A practical guide to OpenCode — from your first prompt to custom agents, skills, plugins, and MCP integrations. Built around clear mental models and real examples, not marketing. Who this is for: ...

This example uses the calculateSummaryValue function to detect Grand Total and Total rows and columns in the DevExtreme PivotGrid and applies custom aggregation logic to each cell type.