Row by row, find everything you need in a table or row with XLOOKUP.
Excel: Dynamic arrays
Write one formula and return a series of values. Speed up calculations and insights with six new features: FILTER, BLACK, BLACK CITY, UNIQUE, SEQUENCE and RANDARRAY.
Excel: LET function
The LET function assigns names to calculation results. This allows you to store intermediate calculations, values, or define names inside a formula.
Excel: XMATCH function
The XMATCH function searches for a specified element in a matrix or cell range and then returns the relative position of the element. You can also use XMATCH to return a value in an array.
Powerpoint: New and improved Record Slide Show
Record Slideshow now supports video recorder presentation, inkjet recording, and laser pointer recording.
Powerpoint: Repeat your ink strokes
You can play your ink strokes as they were drawn; this lets you illustrate things step by step or show a thought process. You can also pause playback and select the location from which replay should start.
Powerpoint: Arrange items on your slides for screen readers
See the items in screen-reading order, and rearrange them as needed to communicate your message effectively.
Outlook: Translator and ink in Outlook
Translate emails to more than 70 languages on the go and see the transcript – all in Outlook. Annotate email images or characters on a separate canvas with your finger, pen, or mouse.
Outlook: In Outlook, you can use Instant Search to quickly find emails
Select the search bar (located above the Outlook ribbon) to help find emails anywhere in Outlook.
Word, Excel, Powerpoint, Outlook: Visual update
Work with a modernized Start experience and recently updated tabs in the ribbon. Experience a clean, clear style of Monoline iconography that communicates action and features with simple images.
Word, Excel, Powerpoint, Outlook, Visio: See what’s new in stock media
We are constantly adding richer media content to the Office Premium Creative Content collection, a select library of stock images, icons and more to help you express yourself.
Word, Excel, Powerpoint, Outlook, Notes: Find what you need with Microsoft Search
At the top of your Microsoft Office apps on Windows, you’ll find the new Microsoft search box. This powerful tool helps you quickly find what you’re looking for, from text to commands to help and more.
Word, Excel, Powerpoint, Outlook: Performance improvements
Experience enhanced performance, stability and speed across Word, Excel, PowerPoint and Outlook. Get faster calculations from common Excel functions like SUMIF, COUNTIF and AVERAGEIF.
Word, Excel, Powerpoint: Updated Character tab
Quickly access and change the color of all your color tools in one place. Simplify how to work with ink using new additions to the Drawing Tab: Point Eraser, Ruler and Lasso.
Word, Excel, Powerpoint: Save your changes as they happen.
Upload your files to OneDrive, OneDrive for Business or SharePoint Online to ensure that all your updates are saved automatically.
Word, Excel, Powerpoint: OpenDocument Format (ODF) Support 1.3
We now include support for the OpenDocument format (ODF) 1.3. The ODF 1.3 specification adds support for many new features.
Access: Update, relink or remove linked tables
The updated Linked Table Manager is a central location for viewing and managing all data sources and linked tables in an Access database. See all the improvements we’ve made to Linked Table Manager based on your feedback.
Access: Try the new data type Extended Date / Time in Access
To improve syntax compatibility with SQL and to increase the accuracy and level of detail in records that include dates and times, we have implemented the SQL DateTime2 data type in Access.
Access: Keep track of your database objects in Access
You can clearly see the active tab, easily drag tabs to rearrange them and close database objects with just a single click.
Visio: New Azure stencils and shapes in Visio
We’ve added many more stencils to help you create up-to-date Azure charts. You can use these new stencils to build Azure charts for network topologies, virtual machine configurations, operations, and more.
Visio: New AWS stencils and shapes in Visio
We have enabled infrastructure forms from another major cloud provider: Amazon Web Services (AWS). You can now use stencils with the latest AWS shapes to help you create charts.
Visio: Content for planning social distancing in the workplace
Many workplaces need to be rescheduled to follow the current guidelines for social distancing. This new Visio template and Workplace Social Distance stencil provide a variety of shapes, fill patterns, and line patterns, both scaled and unscaled, to help with this process.
Word, Excel, Powerpoint: Try the outline of outlined style
You can give a relaxed, hand-drawn look to figures in your presentations with the outlined style contour. Try the options for curved, freehand or scribbling under Format Shape> Line> Outlined Style.
Word, Excel, Powerpoint, Access, Outlook, Notes, Visio, Publisher: Choose the perfect color
Based on your feedback, we’ve added a new input field in the Colors for Hex color values dialog box. Now you do not have to spend time converting Hex color values to RGB values. For any property where you can define a color, you can now enter a Hex color value in the Hex box, for example # 0F4C81 or 444.
Source: https: //support.microsoft…5d-4b1b-bc12-acd2bfb3910a