Once data is loaded into Excel, Copilot allows users to ask questions in natural language instead of building new formulas.
Speed up Power Query from SharePoint by swapping SharePoint.Files for SharePoint.Contents, cutting refresh from 44.6s to about 6.1s for faster updates.
Sync your drop-down menus with table headers using this robust, auto-expanding Named Range trick.
Discover 17 new Excel features and functions for 2026, so you track edits and data faster. Including auto-refreshing pivots ...
Excel files bloat from ghost used ranges, formatting, pivot caches, and images. These quick fixes massively cut the size of my workbook.