Our digest of new features across Microsoft 365 & other business tech products in written, images & video format covering the last three months.
My top 5
- Use TRIMRANGE to prewrite formulas to expand below data in Excel.
- Extract text based on complex patterns with REGEX in Excel.
- TRANSLATE cell by cell in Excel.
- Add hyperlinks in Teams messages.
- Google sheets files now load significantly faster.
Core Office Apps
Excel, PowerPoint, OneNote, Outlook and Word release regular updates to Microsoft 365 Apps and Services. To see or update your version, click File> Account. The Current Channel should now be on version 2502, which is the year 2025 and month 2 (February) with 2503 (March) coming later this month, the Monthly Enterprise channel releases updates a couple of months after the Current Channel and is currently on version 2412. The Semi-Annual Channel received an update in January 2025 up to version 2408. The Insider or Beta features are only available for a small selection of people who sign up to help test features, so they haven’t been reported explicitly, but they give a good idea of what is coming next.
Excel
You can follow along with the companion file plus this video showcases all that is new and pipeline in Excel:
1. Extract based on complex rules with REGEXEXTRACT: Excel launched 3 new functions which use REGEX coding to perform actions based on complex text strings. The first will extract text e.g. extract the email address from text in a cell regardless of whether it’s at the start, end or middle of the text in a cell using =REGEXEXTRACT(A1, "\b[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+.[A-Z|a-z]{2,}\b", 1). Other ideas are extract the next three characters after any digit (useful for postcodes), any date even if multiple exist etc. Consider using chat GPT or Copilot to write the code for the complex patterns.
- REGEXREPLACE replaces complex text patterns: eg, replace all text inside brackets with your name.
- REGEXTEST will return TRUE or FALSE based on the complex patterns eg, does this have an email? Note that Google sheets uses REGEXMATCH as an equivalent.
- REGEX in XLOOKUP: The successor to VLOOKUP just got an upgrade. The optional match mode input can now use regex patterns to look things up. Eg, the email address to look up could appear anywhere in the cell.
- Cell by cell translation: Use =TRANSLATE(cell to translate, [source language], [target language]). If source language is left blank, it is autodetected, if target is left blank, the result is translated into the default language of your computer.
- =DETECTLANGUAGE can figure out which language a cell’s text is in.
- Convert numbers into words: Interestingly, this was possible in the Thai language for decades using the obscure BAHTTETX function, so now use =TRANSLATE(BAHTTEXT(cell)) eg, 726 > “Seven Hundred and Twenty Six Baht”, but use TEXTBEFORE to exclude the word BAHT, more in this video:
- Microsoft Forms integration: Click Insert tab > Forms to get a pop-up side bar with which to access Microsoft Forms.
Excel Current and monthly enterprise channels
- Create formulas you can drag below for future data with TRIMRANGE: Dragging down a formula column below a table is a drag (pun intended), it often leads to an ugly zero or an error, =IF(cell=””,””,formula) is a common but complex way to avoid it. TRIMRANGE is built to avoid it. =A1+B1 dragged down to the 5th row would become =TRIMRANGE(A1:A5) + TRIMRANGE(B1:B5), the result would spill onto a 5 cell range using a dynamic array (the region would have a blue outline to show it). Optional inputs for TRIMRANGE allow users to specify whether to trim above or below a vertical range of the range or left/right of a horizontal range.
- Use dot notation to trim a range: =A1.:.A5+B1.:.B5 would do the same using TRIMRANGE, you can choose whether to include . before the colon (to trim the top), after (to trim the bottom) or both.
The Monthly enterprise channel and Current Channels also has access to the following features reported on in previous blogs:
- GROUPBY/PIVOTBY/PERCENT OF functions which allow a PivotTable via formulas
- View tab > Focus cell which highlights the row and column of the active cell
- View tab > Navigation Pane for a table of contents of your Excel worksheets
- Insert tab > Checkboxes, tick them off as you go, and they return TRUE or FALSE
- Comment filtering for your own comments, unresolved etc.
- Review tab > Check Performance scans a file for excess formats which may bloat the file size
Excel Desktop Semi-annual channel updates (already in other channels)
Excel Desktop Semi-annual channel updates (already in other channels)
- Images inside cells: Previously, images could only be floating objects above cells, but now you can insert images inside cells. Cells with images can be referenced in formulas, in PivotTables and in filters if you use Alt text for the image. The companion file showcases this.
- Get web data using AI: Often websites are formatted in a non-tabular way making it hard for Excel to extract. With the improved Get data from web (on the data tab), you can choose an AI extracted tabulation or alternatively, write examples to try to convert non tabular website data into tables as shown in the screenshot or video below (or the companion Excel file).
New in other core Microsoft apps by release channel
PowerPoint Current & Monthly enterprise channels
- New find & replace pane: A sidebar on the right now appears when you use Find & Replace.
PowerPoint Semi-annual channel update (already in other channels)
- Insert interactive poll: Audience can scan a QR code then see vote results updated live. To access it click Insert tab > Forms > Choose your form (or make a new one) > Present for interactive meetings.
Word Current and Monthly Enterprise Channels
- Keyboard shortcuts for the format painter: The format fainter is copy & pasting formats, now Ctrl Alt C copies a format and Ctrl Alt V pastes it. Note PowerPoint, Outlook and OneNote still use Ctrl Shift C and Ctrl Shift V (as Word had been using previously), but I imagine this will change soon.
PowerPoint, Word, Excel & Outlook Semi-annual channel updates (already in other channels)
- New theme: Aptos is now the default font, plus there is a new default colour palette and shape outlines are thicker, all is aimed at accessibility improvements.
- Insert Picture from Android mobile device: Paid your computer with your device via Insert Tab > Pictures > Mobile device.
Microsoft Teams
*These features are only available to AI enabled Teams, i.e. Teams Premium or Microsoft 365 with Copilot
- Improved calendar native in Teams: With new views, customisations and sharing capabilities, it’s now similar to Outlook’s calendar, see more here
- Take control of someone’s screen during screensharing on Web: Previously, to take control, both users had to be using Teams Desktop, now the screen shared can be on the web.
- *Intelligent recap now available for ‘Meet now’ and meetings started from the chat
- Record a video or audio of yourself in a Teams chat: Click + from the chat
- Breakout room participants can move between rooms with this new setting
- *Option to turn off copying or forwarding of live captions, transcript, and recap for meetings by organisers.
- Presenters can now moderate the Q&A if permissions are granted. Note that Q&A must be turned on by adding the app to a meeting.
- Forwarding Loop components, channel messages and app cards is now enabled in Teams chat
- Add hyperlinks in Teams messages: Click “Format messages” then Insert link or select text and press Ctrl K (the hyperlink shortcut across many apps)
- Schedule messages in Teams channels: Previously this was only allowed in chat
- Chat, Copilot, and Notes panes can now be popped out during a meeting into new windows
- Resize any popped-out window from Teams
- A new filter is now under “Activity” for tag mentions
- Meeting URLs are now shorter with fewer characters
- *Share the AI composed Intelligent Meeting Recap with others via a link or share to Outlook. Meeting recaps are also now in Town Halls or webinars
- For a webinar, town hall and structured meeting, you can now end a meeting for attendees and presenters return to the green room to debrief
Other Microsoft 365 apps
- Add reactions to specific points in videos in Microsoft Stream
- See a board view for My Tasks (which was previously only visible for organisational tasks)
- Storyline from Viva Engage (formerly Yammer) can now be seen in Teams
- File explorer now supports coloured folders
- OneDrive Sync now automatically removes trailing spaces for file and folder names
Power BI
Power BI releases monthly update blogs, here they are for January and February, December didn’t get an update. The features below marked with a * must be turned on as preview options via File > Options and settings > Options > Preview settings.
- Conditional formatting in visual calculations: The ability to add a calculation just for that table or visual is game-changing, now you can conditionally format them too.
- Explore this Data to tweak your visual: Right click a visual > Explore this data to tweak filters, chart types, add new data and more).
- PowerPoint integration updates: After you embed a Power BI page into a PowerPoint presentation, you can navigate to the next slide with Page Down, and reset all changes to the report
- *Text slicer now supports multiple text terms: It searches your page using OR criteria
- Treemap visual enhancements: Increase the space between groups, space between nodes and choose from one of three tiling methods, squarified, binary and alternating. Read the January blog post for more information.
Google Sheets
- Improved cell referencing in Tables: Make use of #HEADERS, #DATA, #TOTALS to refer to that specific part of the table or #ALL for everything, plus get formula correction suggestions if you make an error.
- Speed up improvements: Pasting data and filtering is now 50% faster and loading up data is 30% faster
- People chip suggestions: If you have an email in a cell or first & last name, Google will suggest how to convert to people chips.
Google Workspace
* Only items available only to paid subscribers of Google Workspace
- Allow only specific people to fill out Google Forms: Click the new “Publish” button on the top right and click “Manage” to specify who can respond.
- Forty new Google Docs templates: These make use of Docs’ newest features: pageless view, tabs and building blocks (all unavailable in Word currently). More here
- Docs tables title rows: Set column types (dates, dropdowns, files, people etc.) and format titles.
- Translate messages in Google Chat: Translation into your own language
- Cover image enhancements in Google Docs: You can now choose from more stock photos, search for a picture from the web or use AI text to image to generate a cover image.
- Add polls in Google Chat: Type /poll in the chat box
- Rename a group chat in Google Chat
- Choose between “Comfortable” or “Compact” density in Google Chat
- A new look for Google Calendar
- *Request an e-signature on PDF files saved on Google Drive: Add fields for signature, name, date, address etc.
- *Easy migration from Microsoft toolkit: Migrate files from OneDrive, chats from teams and more
- Google vids (accessible here https://docs.google.com/videos) can now do looping videos and use a variety of voices for text to voice.
Google Workspace with Gemini package
- Text to image now available in 7 more languages: French, German, Italian, Japanese, Korean, Portuguese, Spanish. You can also chat in the languages on the Google Gemini side panel in Docs, Sheets, Drive etc.
- Ask using Gemini in PDFs on Drive: Open a PDF in Drive and a side panel to chat with Gemini will appear.
- Generate a chart with insights from Google Sheets data: The results show on a side panel.
- Text to image now available in Google Docs
- Use premade Gems to do certain tasks: reduce repetitive tasks, get deep insights etc. with premade packages. More here
Zoom meeting enhancements
- Participants can request access to the recording easier: Request directly from the meeting card or recording link, no need to send separate chat messages.
- Spotlight a shared screen: If multiple participants are screen sharing, hosts can now spotlight the important one
Users of Zoom Workspace can read about more updates here
Canva
- Present offline: When using Canva presentations, you can use slide show mode including animations without internet
- Record yourself narrating presentations with Canva mobile: The video saves automatically to Canva
- On click animations: Click an item to reveal something
- Annotate in presentation mode: On the bottom right, click the pen button to draw
- Customise page numbers in presentations
- Add data labels to charts: display callout values for each segment of a chart
- AI quiz generator: As a follow-on to the recently released polls and quizzes, Canva can now auto generate multiple choice quizzes.
- New templates with built in quizzes and polls aimed at educators
- Generate new AI images inspired by your own image & text prompt: Go to Dream Lab, type a prompt and upload an image, more here.
- Show text with image background using the TypeCutOut app.
- Embed one Canva page into another design: Instead of pasting across designs, you can now embed a page from a design into another. Share & copy link from the source, then in the destination, paste the link into a textbox, click the pencil to edit, switch the “Display mode” to embed, and finally you can switch which page you’d like to view.
That wraps up the updates until February 2025, come back for more new features in June.
Archive and Knowledge Base
This archive of Excel Community content from the ION platform will allow you to read the content of the articles but the functionality on the pages is limited. The ION search box, tags and navigation buttons on the archived pages will not work. Pages will load more slowly than a live website. You may be able to follow links to other articles but if this does not work, please return to the archive search. You can also search our Knowledge Base for access to all articles, new and archived, organised by topic.