Microsoft’s latest Copilot updates, released in November 2026, bring a range of features designed to streamline workflows in Excel, PowerPoint, SharePoint, and beyond. One standout addition is Excel’s clean data skill, which simplifies the process of organizing messy datasets. This feature addresses issues like inconsistent capitalization and formatting errors while allowing users to review and approve proposed changes. For instance, it can standardize date formats or adjust categorical data with just a few prompts, significantly reducing the time spent on manual corrections. These updates reflect a focus on improving efficiency for users managing complex data tasks, as demonstrated by Mike Tholfsen.
Explore how these updates extend beyond data management to tackle challenges in presentation design, document search, and workflow automation. You’ll gain insight into PowerPoint’s clarify my thinking skill, which helps structure slides for intricate topics, and SharePoint’s ability to generate HTML pages and automate workflows using natural language descriptions. Additionally, learn how Copilot enhances PDF search by retrieving content from scanned documents, making it easier to locate embedded information. These features collectively address a wide range of professional needs, offering practical solutions for everyday tasks.
Microsoft Office Q4 2026 Update
TL;DR Key Takeaways :
- Microsoft Copilot for Excel now includes a “clean data” skill that reportedly addresses messy datasets by standardizing formatting, resolving issues like capitalization inconsistencies and categorical mismatches, and prompting users with clarifying questions before applying changes.
- PowerPoint’s “clarify my thinking” skill is claimed to help users draft slides for complex topics by asking targeted questions and generating structured drafts, including hypotheses, data points, and actionable steps, which can be refined further in real time.
- Copilot has reportedly improved image arrangement in Word by efficiently organizing visuals, while updates to the chat interface across Word, Excel, and PowerPoint include a relocated prompt area and a new plus icon for better usability.
- SharePoint now supports generating HTML pages from lists or content, with live charts and data, and natural language workflow creation, such as automating notifications in Teams when specific conditions are met, reportedly enhancing site management capabilities.
- Copilot’s enhanced PDF search functionality is said to allow users to locate content within scanned documents stored in SharePoint, simplifying the retrieval of specific information from large collections of scanned materials.
Clarify My Thinking Skill Structures Presentations
PowerPoint’s clarify my thinking skill offers a structured approach to drafting slides for complex topics. This feature guides users by asking targeted questions about the presentation’s purpose, core narrative, and root causes. Based on these inputs, it generates draft slides that include hypotheses, data points, and actionable next steps. For example, the tool created four slides analyzing a branch’s performance, complete with a bar chart and detailed comparisons. Users can refine these drafts further, with Copilot updating the slides in real time. This functionality is particularly useful for professionals tackling intricate issues in their presentations.
Image Arrangement and UI Updates in Word, Excel, and PowerPoint
Copilot now streamlines image arrangement in Word, efficiently organizing and resizing visuals. In testing, it arranged 25 icons of varying sizes into a neat 5 by 5 grid, eliminating the need for manual adjustments. Additionally, Copilot chat across Word, Excel, and PowerPoint has received visual updates. The prompt area has been moved to the bottom of the chat pane, and a new plus icon has been added, improving the interface’s usability.
Check out more relevant guides from our extensive collection on Microsoft Copilot that you might find useful.
- Microsoft Copilot Adds OpenAI GPT 6.1 and Anthropic Claude Opus 5.5
- Automate Project Plans with 6 Microsoft 365 Copilot Upgrades
- 8 New Features in Microsoft 365 Copilot: Real-Time Editing Arrives
- 6 Powerful Microsoft Copilot in Excel Use Cases & Workflow Examples
- Microsoft Copilot Can Now Build Microsoft PowerPoint Slides from OneNote
- New Microsoft Copilot Super App with Autopilot Assistant to Handle Your Work
- 12 New Copilot Features & Microsoft Edge AI Browser Guide
- Save Hours of Work with These 10 Microsoft Copilot Prompts
- Microsoft Copilot 2026 Adds OpenAI GPT 5.6 and Anthropic Claude 5
- 7 New Microsoft Copilot Features: Integrate Task Management Across Work Apps
SharePoint Adds HTML Page and Workflow Creation
SharePoint now supports generating HTML pages directly from lists or other content. These pages, which can include live charts and data, are publishable and can be set as a site’s default home page. For example, a user created an RFP pipeline dashboard with live data and set it as the main landing page for their SharePoint site. The generated HTML page is stored in the site page library for easy access.
Another addition is natural language workflow creation. Users can describe a process to create workflows. In one case, a workflow monitored changes in an RFP status column and sent an adaptive card to a Teams channel when the status changed to “bid one.” The adaptive card included celebratory visuals and links to the original RFP item and the full RFP list. This workflow was triggered by updating the RFP status for “Schrute Farms” to “bid one,” demonstrating Copilot’s ability to automate complex processes. The adaptive card posted in Teams added a festive touch with celebratory elements and buttons linking to relevant RFP content.
Enhanced PDF Search Features
Copilot’s updated search functionality now includes the ability to locate content within scanned PDFs. Users can search across all files, including scanned documents stored in SharePoint. In testing, a search for “Amber Rodriguez” successfully retrieved an org chart embedded in a scanned PDF from a document library. This improvement simplifies finding specific information within large collections of scanned materials.
The new Microsoft Copilot features introduced in November 2026 offer significant time-saving potential across Excel, PowerPoint, SharePoint, and PDF search. From cleaning datasets to generating workflows and locating scanned content, these tools cater to users managing complex tasks. While some features, like Excel’s clean data skill, require a Copilot license, their value depends on individual needs. Based on testing, these updates are particularly beneficial for professionals handling large datasets, creating detailed presentations, or managing SharePoint sites.
Media Credit: Mike Tholfsen
Disclosure: Some of our articles include affiliate links. If you buy something through one of these links, Geeky Gadgets may earn an affiliate commission. Learn about our Disclosure Policy.
