Mathematical input control
Mathematical input controls provided in OneNote and Windows can now be used in Word, Excel and PowerPoint. You can use a digital pen, pointing device or even fingers to write mathematical formulas, and you can convert ink into "input" format.
convenient to use
Improved conflict resolution method in PowerPoint.
This function can simplify conflict resolution when * * * works together. You can choose between two versions of conflicting slides (your changes or changes made by others) instead of filtering the conflicts one by one.
Fast shape formatting
This feature increases the number of default shape styles by introducing new "preset" styles in Word, Excel and PowerPoint.
New calendar view in the project
We improved the Calendar view in Microsoft Project so that multiple calendar bars can be displayed in one view, and you can set the date range of calendar bars so that they can only represent a specific stage of the project. To try it out, click the schedule, and then go to the Format tab. Notice the new "Date Range" and "Insert Timetable Column" commands.
Visio input function
The drawing function of Visio chart may be complicated for the novice Visio, so the rich tools provided have not been applied yet. Now start to use some core solutions to help users use templates by providing a series of smarter prefabricated diagrams, thus making Visio canvas more attractive. In addition, some tips about charts are provided to help users edit and complete their chart creation experience. Using Visio is easier than ever.
Provide higher DPI support for 250% and 300% display ratios.
This preview version provides a higher DPI to support the display ratio of 250% and 300%, so your Office documents can be clearly displayed on the big screen.
Pan and zoom when loading large charts and SmartArt.
There is no need to wait when loading large charts and SmartArt charts, because the text will be displayed immediately so that you can start editing immediately. The placeholder for the chart or SmartArt will be displayed until the object is completely rendered, but you can still interact with the document.
Color office theme
We changed the default Office theme to match the visual effects of modern applications. Now, the default theme is color (previously the default theme was white). You can change the theme at any time by going to file > account > Office theme.
Insert the image in the correct direction.
Now, with automatic image rotation, the image will automatically rotate after being inserted into the application to keep in line with the direction of the camera. After inserting an image, you can manually rotate the image to any position. Please note that this feature only affects newly inserted images and does not apply to images in existing documents.
Lync is now Skype for Business.
This preview shows the new image of Lync (recently renamed Skype for Business) and the new logo and brand in the user interface. There are many new features to try, including call monitoring, which is one of the most popular features of Skype. When you move the focus away from the current call, the screen displays a mini version of the call with mute and end call buttons so that you can interact with the call while doing other operations. Glance menu/dialog control simplification is no longer hidden until hovering. By combining Skype's core dialog box controls with the hierarchical structure of the task menu, you can access tasks faster and discover functions easily. Advanced users need quick and convenient access to dialing and other calling functions, so Skype for Business provides an updated dialing layout, which can reduce the number of clicks when performing core call management tasks. Similar to the consumer chat experience, the updated IM experience now contains chat message bubbles, and the new tab layout in the conversation window provides unread message notifications so that you can always be notified in time.
Content updates in Visio
Architectural design and electrical molds have been updated with new shapes, so you have more choices.
Outlook e-mail attachment
Now, you can easily attach recently used Office documents to Outlook e-mail messages from the ribbon or the action bar (just select the documents from the drop-down options), thus saving time. For existing files in OneDrive, OneDrive for Business or SharePoint, you can choose to share them as "edit" or "view only" links instead of traditional attachments, so that you can collaborate with one document instead of multiple documents.
Outlook searcher suggested.
When you search for mail in Outlook and the search string is similar to people you often communicate with, you will see people's suggestions, which will make it easier for you to find the mail involving them.
Use the "Messages to Filter" function in Outlook to sort low-priority messages.
Messages to be filtered will move low-priority messages out of the inbox and put them in their own folders, thus saving time in scanning important messages. The message function to filter will look at what you have done in the past to determine the messages that you are most likely to ignore. Then, it will move these messages to a folder named "Items to Filter" in the inbox. No matter how you access your account, you can use the Messages to Filter folder. From the Outlook desktop, you can access the Filtered Messages folder, configure the experience of filtered messages, and indicate that messages are not filtered.
Read-only mode of Excel
Quickly open an Excel workbook in read-only mode in SharePoint, so as to handle the most important things quickly.
New default fonts for Chinese and Japanese
Office 20 16 has updated the existing Japanese and simplified Chinese fonts, and now all major creative applications have adopted a unified modern look, including Excel, Word, PowerPoint, Outlook Mail and OneNote.
cloud connection
Make file sharing and collaboration easier.
These changes combine two important aspects of collaboration: who can access a given document and who is currently working with you on the document. Now, you can view both kinds of information in one place through the * * * Enjoy dialog box.
"Save As" Improvement
These improvements simplify the process of saving new files by allowing you to select a location in OneDrive, OneDrive for Business or your local computer, provide a file name, and then click Save. Now saving a file is as simple as creating a file, and all the work can be done in the background of Word, Excel and PowerPoint.
Please note that this feature is the first time to use, and may not be available in the whole preview.
Real-time synchronous creation in Word
When you collaborate on a document, you can see the text changes made by others and the position of their cursor in the document. When users use and update documents, the changes will be displayed automatically. You can use this feature when working with documents stored on OneDrive for Business and Office 365 SharePoint sites.
Please note that this feature is the first time to use, and may not be available in the whole preview.
Updated Backstage user interface
The background is where you can open and save documents, and now the storage location is more intuitive. The browse button is more eye-catching. In the open and save as tabs, the order of the storage location tabs has been updated to reduce confusion. Such as onedrive >; OneDrive for Business & gt online location > local computer. To avoid confusion, for online storage locations, the corresponding e-mail addresses have been added to the tab labels to help distinguish the tabs. The Browse button in each Open/Save As pane has also been upgraded, which is more eye-catching and allows you to enter the file browser faster.
Cloud attachments in Outlook
Send a link to the cloud document so that everyone can access the latest version of the document and support collaborative processing of the same master copy (when you need it). With this version of Outlook, you can now select and attach files from SharePoint or OneDrive accounts, even if they are not displayed in the summary of the recent items list. When you choose to attach an existing document in OneDrive or OneDrive for Business to a message, a link is automatically attached (and appropriate permissions are granted). You can set permissions for each file and choose it as a traditional attachment, embedded attachment or cloud attachment * * *.
If the file does not exist in OneDrive (OneDrive for Business or OneDrive Personal Edition), Outlook now allows you to quickly upload the file and send it as a cloud attachment. Or, if you receive the attachment and want to quickly save it to OneDrive for later use, it can also be realized.
Reduce Outlook storage space on small devices
By default, Outlook usually downloads e-mail for one month on a small device, which is the shortest time that can be downloaded. Now, you can choose from the following values through account settings: 1 day, 3 days, 7 days, 14 days, and only download the latest emails, so that you can deal with the most important things quickly.
Support vertical layout of Outlook small screen
Similar to the Outlook experience on Windows Phone, you can now select messages from the list and see the reading pane displayed on the right side of the screen. Just use the back button to return to the mailing list.
Intelligent experience
Insight in Office
This function has been provided in Word and Outlook, and can now be used in Excel and PowerPoint. It helps you understand your content in detail by providing accurate information in the context of your reading or writing. With information from various sources (such as Bing Snapshot, Wikipedia, Bing Image Search and Oxford Dictionary), you can do anything without leaving the Office application. You can access insights by right-clicking a word or phrase on the Review tab or the How-to search box on the ribbon. Bing supports insight, which uses selected text and some environmental content to obtain contextual results.
Operating instruction search
Operating Instructions Search can save the time you usually need to find a specific function in the ribbon. You can enter what you are looking for in the "Operation Description Search" box in the upper right corner of Word, Excel, PowerPoint and Access ribbon. Instructions Search uses the Text Rotation function to display the results as soon as you start typing. Every extra word you enter will make the result more accurate, so when you see what you are looking for, you can click on what you want. For example, if you want to mark a document as confidential, just enter "Confidential" or "Confidential Flag" and "Instruction Search" will display the "Insert Watermark" command. When you click the "Operating Instructions Search" box, you will also see a list containing the last five commands you ran from the "Operating Instructions Search", thus saving you the time needed to go to the function you want to use.
Outlook desktop group (Office 365 enterprise mailbox only)
A group is an evolved version of a distribution list, which is used to communicate and collaborate with team members. Using groups in Desktop Outlook, you can now:
Create and manage groups in Outlook.
You can learn about the activities in the group without leaving your inbox.
Access the conversation history of the group, even before you join the group.
Organize files and notes related to the group in the OneDrive of the group and access them through Outlook.
Schedule meetings on the group calendar, which everyone in the group can update.
You can also use it as a distribution list.
Auxiliary function
Dark theme
This new theme is suitable for visually impaired users, who can't clearly see the too bright display content in Office 20 13. It can present a background with better visual effects in applications. Dark themes also include improvements to the Word navigation pane (better readability, fixing white flicker) and several Outlook readability fixes (white text on a light background, dark text on a dark background, and disabling illegible text). The contextual ribbon tab text, hover status and task pane controls have also been improved.
Keyboard access of PivotTable and slicer in Excel
In the past, it was forbidden to use keyboard operation for functions such as pivot table and slicer in Excel, but now it has been realized, which can provide more powerful Excel functions for all users.
Use the keyboard to access the shape panel in Visio.
Now, you can easily access the Visio shape panel using the keyboard. Press F6 to enter the shape panel, and press Tab to switch between different parts of the shape panel. Users can use arrow keys to navigate between elements. Users can use Ctrl+Tab to quickly switch between stencil view and search view.
Built-in business intelligence
New chart type
You can use the following new chart types. They are particularly suitable for visually presenting financial or hierarchical information and displaying statistical attributes in data:
Finance: Waterfall Map
Statistics: Histogram, Pareto Diagram, Box Diagram.
Hierarchical: tree diagram and rising sun diagram
Quick data links in Visio
You can link Visio charts to Excel data and then turn them into dynamic dashboards.
Search in field list and data model improvement
Excel field lists are used to add fields to pivottables and pivotcharts, and now support the search function so that you can quickly find the fields you are looking for in a long list.
Excel Power query integration
Microsoft Power Query for Excel was originally an independent downloadable add-in for Excel 20 13 and 20 10, and now it is integrated in Excel. By providing an intuitive and consistent experience of discovering, combining and optimizing data across multiple sources (including relational sources, structured and semi-structured sources, OData, Web, Hadoop, Azure Marketplace, etc.). ), Power Query enhances the self-service business intelligence (BI) service for Excel.
Excel prediction function
The time series prediction worksheet function is used to predict future values based on historical data. For example, a valuable monthly plan or annual plan on the first day of each month. For this type of plan, it is very useful to summarize the original detailed data before applying the forecast, which can also generate more accurate forecast results. In this preview, the following prediction functions are available:
Forecast. ETS()- Returns the predicted value of a specific future target date.
Forecast. ETS. Confint()- Returns the confidence interval of the predicted value of the specified target date.
Forecast. Ets.seasonality ()-Returns the length of the repeating pattern detected by Excel in the specified time series.
Supports multi-selection of slicer items by touch.
Because of this change, you can now select multiple items when you open the Excel slicer with a touch device. Compared with the previous version of Excel, this is a change. In previous versions, when using slicer, only one item can be selected at a time through touch input. You can also use the new controls in the Slicer tab to enter the Slicer multi-selection mode.
Drill down on time groups and pivotcharts.
Drilling up and down time groups and other levels of data is a common data analysis operation. This preview version makes it easier for you to perform these operations through two new updates. Now, when you add a time field row to the PivotTable, the system will automatically detect and create a time group. In addition, you can now drill down the data hierarchy directly from the visualization of the PivotChart, so as to get a deeper understanding of the data directly from the charts and graphs.
PowerView using OLAP connection
Microsoft PowerView now adds reporting options for online analytical processing (OLAP) cube connections. Simply connect your Excel spreadsheet to the OLAP cube, and then choose to view the data as a PowerView report in the workbook. In PowerView, you can now use KPI, hierarchy, calculation and tabular data in OLAP cube to generate reports.
Automatic relationship detection of data model pivot table
Now, everyone who uses Office 365 can use automatic relationship detection. If you generate a PivotTable report that uses two or more tables with undefined relationships, you will be notified to run automatic relationship detection. This will detect and create all the relationships between the tables used in the data model PivotTable report, so that you don't have to do these operations yourself. You can also run automatic relationship detection through the Relationships dialog box.
Discoverability of double functions
Now, it is easier to find business intelligence functions in the Excel experience. If you use one of the BI functions (Power View, Power Pivot or Power Map), the other functions will be automatically enabled for you. You can also go to the following path in Excel to enable all BI functions: File > Options > Advanced >; Enable data analysis instead of going to the following path: file > options > add-ins > manage COM add-ins >; "Start", thus saving time.
Rename the tables, columns and measures in Power Pivot and adjust the PivotTable.
Now, you can rename tables, columns and calculated fields/measures in the Power Pivot add-in, and you can use the PivotTable to seamlessly adjust the new names in the data model.
Excel: data card
When the mouse hovers, the data card displays rich tabular data or selected visual forms of a specific geographical location. Users can carefully examine and display hidden data when presenting or sharing stories. The hidden data may be aggregated data that cannot be displayed in the existing visual form. For example, a column chart cannot show a description of a group of events that occurred in a specific location: for example, a list of food poisoning events that occurred in a specific restaurant at a specific time.
IT control and manageability
Azure department template availability
When an IT department defines a set of related department templates in Azure Rights Management (RMS), you can use Information Rights Management (IRM) to access them from related Office applications.
Deploy plug-ins through plug-and-play
Add-ins for Solver, Eurocurrency and Analysis Toolbox can be deployed in the selected language by clicking.
IT solves the ready-to-use manageability problem of IT professionals.
Plug and Play is a streaming media and virtualization technology, which makes it very easy for large enterprises to install Office products on a large scale, so they can quickly provide the latest and most advanced Office to end users. In this preview version, the necessary security updates, bug fixes and compliance requirements have been solved, so it is easier to click and use.
Data Loss Protection (DLP) in Excel
Data Loss Protection (DLP) is the most popular high-value enterprise function in Outlook. For this preview, we introduced DLP into Excel to realize real-time content scanning according to a set of predefined policies for the most common sensitive data types, such as credit card numbers, social security numbers and bank account numbers in the United States. In the future preview, this function will synchronize the DLP policy of Office 365 in Excel, Word and PowerPoint, and provide a unified policy for organizations on the content stored in Exchange, SharePoint and OneDrive for Business. Another advantage of DLP is that it administrators can do some supervision and help end users in the organization manage sensitive information better and more wisely.
Information Rights Management (IRM) protection has now been added to the Visio file.
Visio files now provide information rights management (IRM), providing permanent online and offline protection for e-mails and attachments, documents and charts. Now, you can protect sensitive information, such as confidential product information in Visio diagrams, financial and sales process visual materials, research and patent information, customer or employee data. Because users can access files from almost anywhere now, many potentially sensitive information may be leaked, which is a serious threat to the organization. To help prevent information leakage, please use the new information rights management (IRM) function to protect your Visio diagram.
Multiple authentication
Multi-factor authentication (MFA) simplifies the login of the whole office suite through the integration with ADAL(Active Directory Authentication Library), and strengthens the security of the whole process through single sign-on.
Other improvements
Safer translation options
These options can solve the address security and privacy issues related to translation functions (full-text translation, translation screen prompts, information retrieval and reference pane translation).
Communication with the machine translation provider is now through SSL connection.