Microsoft has released a new Office Build for Office Insiders who registered in Monthly(Targeted) channel. For those unaware, the Monthly channel is equivalent to the Slow ring where you get a comparatively less buggy update.

The new Build 12527.20092 has introduced a couple of new features to Word, Outlook, Excel, and Access. You can read the official changelog below.

Changelog

Word

Lasso your ink

Do you like to mark up your documents using ink? Wish you could remove just a few inked comments? Now you can easily select an ink object embedded within text and remove it. The Lasso Select feature will automatically ignore text during the selection.

Using Lasso feature to remove ink in a Word document.

Excel

Ask a question about your data

Got a question about your data? Not sure how to get started? Ideas looks for patterns in your data to provide intelligent suggestions and visualizations. You can now type your question into the input box and let Ideas find the answer. Give it try.

  1. From an open spreadsheet, select a cell in a data range.
  2. From the Home tab, click the Ideas button.
  3. In the input box, type a specific question or select one from the drop-down menu.

Ideas will quickly answer your question with formulas, charts, or pivot tables. Ideas works best when your data is formatted as an Excel table with a single header row at the top.

Ask a question in Ideas.

Get more insight from your data

Need more information? Get a deeper understanding of your data using the new data profiling views in Power Query Editor. Quickly drill down into details and take action. Using the different views, you can drill down into your data and identify unique values, errors, and duplications.  Try it out.

  1. In Power Query Editor, create or open an existing query.
  2. On the View tab, check Column quality, Column distribution, and Column profile.
  3. Select a column from the top pane. Power Query Editor will display more details in the lower panes.
  4. Hover over the data to get more information including suggested actions, like remove duplicates.

Power Query Editor Data Profile views

Look left, look right…XLOOKUP is here!

See above.

Outlook

Help protect data in your group 

You asked for it! Keep your emails compliant with your organization’s information protection policies by applying sensitivity labels.

You no longer need to manually apply encryption, or manually insert headers or footers into emails to state how sensitive they are, for example. Now, all you need to do is apply a Sensitivity label (like “General” or “Highly Confidential”), and the Microsoft Information Protection platform will do the rest (based on policies IT administrators create).

How to enable the feature

  • In the Message tab in Outlook, click the Sensitivity button, and choose the label you want.

Learn more

Sensitivity labels

Access

Improved query-based editing features

We’ve heard your feedback. We need to make it easier to edit queries. We’ve made the following improvements:

  • Query Designer – Added more features to the right-click options, including OpenTable DesignSize to Fit, and Hide Table.

New Right Click options

  • SQL view – Added find and replace.

Find and Replace

  • Relationships window – Added multiple table select, table-edge adjustment, and mouse wheel scroll.

Multi Select example

To update to the latest Office Insider Preview Build, open any Office program and go to File > Account > Update Options > Update Now.

Source: Microsoft

Comments