Row by row, find anything you want in a table or range with XLOOKUP.
Excel: dynamic matrices
Write one formula and return an array of values. Accelerate calculations and insights with six new functions: FILTER, SORT, SORTBY, UNIQUE, SEQUENCE and RANDARRAY.
Excel: LET function
The LET function assigns names to the results of the calculation. This allows intermediate arithmetic operations, values, or defining names to be stored within a formula.
Excel: XMATCH function
The XMATCH function searches for a specific element in an array or range of cells, and then returns the relative position of the element. You can also use XMATCH to return a value in an array.
Power point: New and improved slideshow recording
Slideshow recording now supports presenter video recording, toner recording, and laser pointer recording.
Power point: Restart your ink strokes
You can redraw the ink strokes as they were drawn; This allows you to clarify things step-by-step or demonstrate the thought process. You can also pause replay, and select the point from which to start replay.
Power point: Arrange items in slides for screen readers
Watch the items in screen-reading order and rearrange them as necessary to communicate your message effectively.
prospects: Translator and Ink in Outlook
Instantly translate emails into more than 70 languages and view text — all from within Outlook. Comment on email pictures or draw a separate canvas using your finger, pen, or mouse.
prospects: In Outlook, use Instant Search to quickly find emails
Select the search bar (located at the top of the Outlook bar) to help find email messages anywhere in Outlook.
Word, Excel, Powerpoint and Outlook: a visual update
Work with a fresh start experience and newly updated tabs in the ribbon. Experience a clean, crisp style with monolin icons that convey movement and features in simple visuals.
Word, Excel, Powerpoint, Outlook and Visio: Find out what’s new in storage media
We’re constantly adding more rich media content to our suite of Office Premium Creative Content, a curated library of stock images and icons, and more to help you express yourself.
Word, Excel, Powerpoint, Outlook, and Notes: Find what you need with Microsoft Search
At the top of your Microsoft Office applications on Windows, you will find the new Microsoft search box. This powerful tool helps you quickly find what you’re looking for, from text to commands for help and more.
Word, Excel, Powerpoint and Outlook: Performance improvements
Enjoy improved performance, stability, and speed across Word, Excel, PowerPoint and Outlook. Get faster calculations from popular Excel functions such as SUMIF, COUNTIF and AVERAGEIF.
Word, Excel and Powerpoint: The Draw tab has been updated.
Quickly access all your inking and color changing tools in one place. Simplify the way you work with ink with the new Drawing Tab add-ons: Point Eraser, Ruler, and Lasso.
Word, Excel and Powerpoint: Save your changes as they happen.
Upload your files to OneDrive, OneDrive for Business, or SharePoint Online to make sure all your updates are saved automatically.
Word, Excel and Powerpoint: OpenDocument Format (ODF) 1.3 . support
We now include OpenDocument Format (ODF) 1.3 support. The ODF 1.3 specification adds support for many new features.
joining: 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 the linked table manager based on your feedback.
joining: Try the new extended date/time data type 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.
joining: Keep tabs on database objects in Access
You can clearly see the active tab, easily drag tabs to rearrange them, and close database objects with just one click.
Visio: New Azure stencils and shapes in Visio
We’ve added several stencils to help you create updated Azure diagrams. You can use these new stencils to create Azure diagrams for network topologies, virtual machine configurations, processes, and more.
Visio: New AWS stencils and shapes in Visio
We’ve enabled forms of infrastructure from another major cloud provider: Amazon Web Services (AWS). You can now use stencils with the latest AWS shapes to help you create infographics.
Visio: Content for social distancing planning in the workplace
Many workplaces need to be re-planned to follow established social distancing guidelines. This new Visio template, the Workplace Social Distracting stencil, offers a number of shapes, fill styles, and line styles, both scaled and unscaled, to aid in the process.
Word, Excel and Powerpoint: Try Sketched style chart
Give a casual, hand-drawn look to the shapes in your presentations with a Sketched style chart. Try the Curved, Freehand, or Scribble options under Shape Format > Font > Scribble Style.
Word, Excel, Powerpoint, Acces, Outlook, Notes, Visio, Publisher: choose the perfect color
Based on your feedback, we have added a new input field in the colors dialog for hex color values. Now you don’t have to spend time converting hex color values to RGB values. For any property where you can specify a color, you can now enter a hex color value into the Hex box, for example, #0F4C81 or 444.
