Microsoft’s monthly round-up of new Microsoft 365 functionality across desktop, mobile, and web is now available.
“This month, we’re rolling out improvements to help you build a more productive, collaborative, and secure work environment for you and your organization,” Microsoft corporate vice president Jarod Spataro writes in a new post to the Microsoft 365 Blog. “The new XLOOKUP formula for Excel helps you find data and improve calculation time. OneNote and Yammer mobile updates help you work on the go and find the answers you need more quickly. And the new FastTrack guidance will help ensure seamless Windows 10 migrations.”
You can find the complete list of improvements in the original post, but here’s a quick rundown of the top improvements and changes.
Find and retrieve data quickly in Excel. Microsoft is bringing XLOOKUP, the successor to the VLOOKUP and HLOOKUP formulas, to Excel. XLOOKUP addresses the most common user feedback and takes advantage of recent backend changes to improve calculation time. It‘s available today to Office Insiders, with general availability coming later this year, Microsoft says.
Create work-in-progress diagrams and slides in PowerPoint (and Word and Excel). A new Office style called Sketched Shapes helps you transform standard shapes in PowerPoint, Word, and Excel into rough outlines that look hand-drawn and convey a sense of in-progress work. “Sketched Shapes is perfect for building wireframes, drafting designs, or adding an artistic touch,” Spataro notes. “You can also easily move between sketched and standard shapes.” Sketched Shapes is rolling out to Windows Insiders and Office Insiders for Mac.
Subscript, Superscript, and Change Case in PowerPoint for web. To date, users needed the PowerPoint desktop application to add subscript, superscript, or change text casing in their slides. Now, you can do so on PowerPoint for the web as well.
Add shapes, graphs, and Outlook meeting details in OneNote for iPad. Now, you can insert shapes in OneNote for iPad, including straight lines, basic shapes, and graphs, using the Draw tab. You can also add Outlook meeting details to OneNote for iPad and OneNote for Mac.
Annotate your notes using ink in OneNote for iPhone. OneNote for iPhone now supports ink so you can use your finger or a stylus to annotate with the natural feel of ink on the go.
Dark Mode. As noted in Microsoft is Bringing Dark Mode to Mobile and the Web, Microsoft is, um, bringing Dark Mode to mobile and the web