Microsoft releases Office Insider Monthly (Targeted) v 2002 Build 12527.20092 for Windows users, here is what’s new

Reading time icon 3 min. read

Readers help support MSPoweruser. When you make a purchase using links on our site, we may earn an affiliate commission. Tooltip Icon

Read the affiliate disclosure page to find out how can you help MSPoweruser effortlessly and without spending any money. Read more

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.



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.


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.


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


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

More about the topics: Build 12527.20092, office 365, Office Build, Office Insider, Office Insider Monthly (Targeted)

Leave a Reply

Your email address will not be published. Required fields are marked *