For quick, one-off questions about a spreadsheet, speaking in plain English to Copilot in Excel can be faster and less fiddly than building a PivotTable — and for many routine analysis tasks it gives the same answers without the clicks.
Background
PivotTables have been Excel’s go-to interactive...
Microsoft’s latest Excel headlines have been dominated by bold AI stunts — Copilot, on-cell generative functions and natural‑language formulaing — but one of the oldest, most reliable features in the spreadsheet deserves a second look: PivotTables. Used judiciously, PivotTables remain the...
ai in excel
auto refresh
beta channel
copilot
dashboard
data governance
data integrity
data refresh
excel
insider beta
inworkbookdata
it admin
pivotcache
pivotcharts
pivottable auto refresh
pivottables
power query
real-time data
slicers
tables
Microsoft Excel users are entering a new era of productivity this August, as fresh features arrive across Windows, Mac, and the web—moving the world’s leading spreadsheet platform ever closer to a seamless, modern, and highly collaborative experience. These updates, mainly available to Microsoft...
cloud integration
collaboration tools
data analysis
data import
excel
excel compatibility
excel features
excel for mac
excel for web
excel updates
get data redesign
insider program
onelake
pivottable auto refresh
pivottables
power query
productivity tools
text functions
unicode
workflow automation
The Microsoft Power BI Publisher for Excel add-in enhances your self-service Business Intelligence experience in Excel. Now you can quickly and easily share key insights in Excel by taking snapshots of cell ranges, PivotTables, and Charts and “Pin” them to dashboards in Power BI.
Link Removed
With new chart types and improvements to PivotTables and business intelligence (BI), Microsoft Excel 2016 makes it easier to work with large amounts of data and give it even more meaning. Unlock insights, and tell the story in your data by organizing it in spreadsheets (workbooks). View your...
The Office Show is in a budget crisis, and the numbers are a mess. In this episode, watch how we use Link Removed and the super-powerful PowerPivot add-in to pull in all the data and discover some, um, surprising results. And once we get that figured out, Link Removed shows us how to use Link...