June 2019 – Say hello to the future of Excel

Get the latest news about preview features for Office.

Having trouble viewing this email? View as a webpage.     Welcome Features Tips & Tricks Stay Connected       Hello, Office Insider - By default in Excel, it’s always been One Formula, One Value. When you wanted a value returned, you had to write – or copy – a formula into a cell to do it. If you wanted a second one, you did it again. But that’s all changing! With the introduction of dynamic arrays in Excel, you write one formula, and in return you can get multiple values! Type the formula, hit enter and if multiple values are returned, they seamlessly “spill” into the neighboring cells! Combined with six new functions that return arrays – FILTER, UNIQUE, SORT, SORTBY, SEQUENCE, and RANDARRAY – Excel has never been more powerful, or let you get this much done in this little time. Say hello to the future of Excel! READ MORE ABOUT DYNAMIC ARRAYS IN EXCEL >             Preview Features for Insiders     Office for Windows & Mac: Play Animated 3D Models in Excel. We’ve brought the animated 3D models you’ve been using in PowerPoint and Word to Excel! Get started with our library of over 50 animated models available in Office. Available now for all Office Insiders on Windows and Mac. Enjoy :) LEARN MORE ABOUT 3D MODELS > Office for Windows - Insider: Map more data automatically. Excel Map Charts automatically plot data on a map for you. With the recent update, Excel Map Charts can leverage the richness of Excel’s Geography Data Types enabling you to accurately map countries, counties, states, regions, zip codes and cities! Using Data Types, you can pull out interesting stats about the region you’re plotting. LEARN MORE ABOUT EXCEL MAP CHARTS UPDATES > Office for Windows - Monthly Channel (Targeted): Share more folders in Outlook. Sharing folders in Outlook in an easy way to let others view or manage your Calendar, Contacts, a specific email file and more. Thanks to recent updates to mailbox sync, most customers will be able to share up to 5,000 folders – 10 times more than the current 500 limit. LEARN ABOUT RAISING THE 500 FOLDER LIMIT > Office for Mac – Fast: Power Query now available for Mac. We’re excited to announce the first step in a journey to support Power Query in Excel for Mac - a powerful set of tools to gather and shape data fast and easily in Excel. In this release, you can refresh your Power Query queries on Mac from Text, CSV, XLSX, XML and JSON files. LEARN ABOUT POWER QUERY IN EXCEL FOR MAC > Office for Android: Actionable messages in Outlook. When you receive an email that has an option to take action, such as approving a timesheet, granting system access, or quickly answering a survey, you can act on it right inside the email, without leaving your Inbox or switching apps. GET THE LATEST OFFICE FOR ANDROID RELEASE NOTES > Office for iOS: Quicker access to your files. Find and access cloud files stored across your favorite cloud storage options: OneDrive, OneDrive for Business, SharePoint, Google Drive, iCloud, Dropbox, and Box. GET THE LATEST OFFICE FOR iOS RELEASE NOTES >             Office Insider Tips & Tricks     What you should know about Office Insider Release Notes. We’ve made some important updates to our release notes. Get tips on where to find them, when to check them, and what exactly is in them to help you get the most out of each Insider build. READ THE OFFICE RELEASE NOTES BLOG > New YouTube Channel for Office 365 ProPlus Deployments. This new channel will provide Desktop IT admins with tips, tricks and best practices for Office Deployments starting with Mac & Win32. Each week, we will release a new video to help inform admins about the awesome work that individual teams are delivering each month. GO TO THE OFFICE DEPLOYMENT INSIDERS CHANNEL > Find out what’s new for Microsoft Graph. Use Microsoft Graph to access the rich data, capabilities and insights behind Microsoft 365 to power great, people-centric experiences in your own applications and solutions. Check out all the latest updates available to developers. VISIT THE MICROSOFT GRAPH DEVELOPER BLOG >             STAY CONNECTED     OFFICE INSIDER BLOG > @OFFICEINSIDER ON TWITTER > OFFICE INSIDER ANSWERS COMMUNITY > As always, your feedback is what makes the Office Insider program great! The Office Insider Team Was this newsletter forwarded to you? If so, sign up for your own newsletter delivered to your inbox.         Privacy Statement Microsoft Corporation One Microsoft Way Redmond, WA 98052