Office Insiders have some new features to play with, including a major update to Excel

News
By
published

Office Insiders can now use Power Query to create their own data types.

Laptop with Office 365
Laptop with Office 365 (Image credit: Windows Central)

What you need to know

  • A new update is available for Office Insiders.
  • The update brings support for creating custom data types with Power Query in PowerPoint.
  • The update also brings support for text predictions within Outlook.

Microsoft recently rolled out an update for Office Insiders that brings new features to test out. The update includes the ability to create custom data types with Power Query in PowerPoint, one-click writing suggestions in Word, and many other features. The update started rolling out on November 9, 2020 and is available for Office Insiders in the Current Channel (Preview).

Live and custom data types are the biggest features to arrive on Excel in years. Now, Insiders have their first opportunity to try them out. These data types add another dimension to Excel and allow any cell to include a rich set of structured data.

Microsoft's Insider Office page breaks down the new features:

Excel

  • Unhide multiple sheets at once: By popular request, this feature helps you unhide multiple sheets at once.
  • Create Data Types with Power Query: Use the Power Query Editor to create your own custom data types from any supported data source. Go to Power Query Editor, select several columns and use the Create Data Type button on the Transform tab of the ribbon to convert them into a new data type. Finally, load the data to the Excel grid, and easily consume and explore your custom data types with interactive data cards and formulas.
  • Create Power Platform dataflows from queries: You can now export your queries into Power Query templates that can be used to create new Power Platform dataflows. This feature allows users to easily create a cloud-powered Power Platform dataflow from the queries they already have in their Excel files so that their data can now be refreshed on the cloud and at regular intervals rather than manually.

Word, Outlook

  • One-click writing suggestions: We are introducing a new click-to-review model for Editor's spelling, grammar, and advanced style suggestions. This change also includes a new dedicated card surface for reviewing the suggestions.

PowerPoint

  • Export animated GIF in a range: Select a range of slides when exporting an animated GIF.

Outlook

  • Text prediction as you're typing an email: As you type an email, we'll show ghost text prediction to help you complete your sentences faster. You can accept it by pressing tab.
Sean Endicott
Sean Endicott
News Writer and apps editor

Sean Endicott is a tech journalist at Windows Central, specializing in Windows, Microsoft software, AI, and PCs. He's covered major launches, from Windows 10 and 11 to the rise of AI tools like ChatGPT. Sean's journey began with the Lumia 740, leading to strong ties with app developers. Outside writing, he coaches American football, utilizing Microsoft services to manage his team. He studied broadcast journalism at Nottingham Trent University and is active on X @SeanEndicott_ and Threads @sean_endicott_.