The big wins that change daily work
Copilot with Python becomes mainstream
- What it does, deeper analysis inside Excel without switching tools, with clear tables and charts for review.
- Try it, ask Copilot to analyse sales by region and produce a summary table with a chart that you can share
Text Analysis at scale inside Excel
-What it does, summarises large text data like surveys and support tickets, pulls themes and sentiment.
- Try it, paste responses, run Text Analysis, insert a small chart to show top themes, list three actions.
Copilot that understands the grid
-What it does, creates tables from a prompt and writes formulas from plain English.
-Try it, describe the table you need, then ask for a variance formula across months, check the range it selects.
Clean data and speed, quick wins you will feel
TRIMRANGE and tidy references
- What it does, removes empty borders and noisy ranges so Power Query steps and PivotTables do not break.
- Try it, clean a vendor file with blank rows, convert to a table, then load to Power Query for a stable pipeline.
Power Query refresh and data source settings on the web
- What it does, lets you manage refresh and credentials from a browser for easier handoffs.
-Try it, set a scheduled refresh for a shared report, confirm credentials once, share the link with your team.
Govern and scale with confidence
Compatibility Versions per workbook
- What it does, preserves older calculation behaviour while you opt in to improvements in a controlled way.
- Try it, enable the new version on a copy of a key file, validate formulas, then roll out with confidence.
Two mini playbooks
From messy sheet to summary.
-Paste the raw file, use TRIMRANGE to tidy, ask Copilot to create a clean table, request a one line summary and a small chart, share the workbook with the team.
From free text to decisions.
-Paste the raw file, use TRIMRANGE to tidy, ask Copilot to create a clean table, request a one line summary and a small chart, share the workbook with the team.
Availability note
Features roll out by channel and license. If you cannot see a feature, check that your Excel version and plan support it.
