Office Insider Monthly (Targeted) v2002 build 12527.20092 - Feb. 11 Office

    Office Insider Monthly (Targeted) v2002 build 12527.20092 - Feb. 11

    Office Insider Monthly (Targeted) v2002 build 12527.20092 - Feb. 11

    Category: Office
    Posted: 11 Feb 2020
    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.



    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.



    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.



    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



    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 Open, Table Design, Size to Fit, and Hide Table.



    • SQL view - Added find and replace.



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




    Source:

    Latest Office Updates for Windows

    Change the update channel after you enable Office 365 clients to receive updates from Configuration Manager



    Brink's Avatar Posted By: Brink
    11 Feb 2020


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 10 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 10" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 18:35.
Find Us




Windows 10 Forums