Pen and Ink
Math Input Controls
Math input controls already available in OneNote and Windows are now available in Word, Excel, and PowerPoint. Math equations can be written using a digital pen, pointing device, or even your finger, and the ink can be converted into an "entered" format.
Easy to use
Improved conflict resolution in PowerPoint
This feature simplifies the resolution of conflicts when working together. Instead of sifting through individual conflicts one by one, you can choose between two versions of a conflict slide (the changes you made or the changes someone else made).
Quick Shape Formatting
This feature increases the number of default shape styles by introducing new "preset" styles in Word, Excel, and PowerPoint.
New timeline view in Project
We have improved the timeline view in Microsoft Project so that multiple timeline bars can be displayed in one view and you can Set date ranges for timeline bars so that they can represent only specific phases of the project. To try it out, click on the schedule and go to the Format tab. Note the new Date Range and Insert Schedule Bar commands.
Visio Getting Started
Visio diagramming capabilities can be complex for those new to Visio, so the rich tools provided are not utilized. The getting started experience now makes the Visio canvas more engaging by providing a curated set of smarter pre-made diagrams to assist users in some of the template's core scenarios. In addition, some tips about charts are provided to help users edit and complete their chart creation experience. Using Visio is easier than ever.
Higher DPI support for 250% and 300% display ratios
This preview version provides higher DPI support for 250% and 300% display ratios, so your Office Documents can be displayed clearly on large screens.
Pan and zoom while loading large charts and SmartArt charts
No more waiting while loading large charts and SmartArt charts because the text appears immediately, allowing you to start editing right away. Placeholders for the diagram or SmartArt are displayed until the object is fully rendered, but you can still interact with the document.
Colorful Office Theme
We’ve changed the default Office theme to be consistent with our modern app visuals. The default theme is now "Color" (previously the default theme was "White"). You can change your theme at any time by going to File > Account > Office Themes.
Insert images in the correct orientation
With automatic image rotation, images are now automatically rotated to match the camera's orientation when inserted into the app. After inserting the 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 pictures in existing documents.
Lync is now Skype for Business
This preview shows a new look for Lync (the recently rebranded Skype for Business), with a new logo and branding in the user interface. There are a bunch of new features to try out, including Call Monitor, one of Skype's most popular features. When you move focus away from the current call, the screen displays a mini version of the call, with mute and end call buttons so you can interact with the call while you're working on other things. "Glancing" menu/conversation control simplification now no longer hides until hover. By combining Skype's core conversation controls and flattening the task menu hierarchy, tasks can be accessed faster and features can be easily discovered.
Power users need quick and easy access to the dialpad and other calling features, so an updated dialpad layout is available in Skype for Business that reduces the number of clicks required to perform core call management tasks. Similar to the consumer chat experience, the updated IM experience now includes chat message bubbles, and a new tab layout in conversation windows provides unread message notifications to keep you informed.
Content updates in Visio
The Architectural Plans and Electrical stencils have been updated with new shapes so you have more options.
Outlook Email Attachments
Now you can easily attach your recently used Office documents to your Outlook emails from the Ribbon or Action Bar (just click from Just select the document from the drop-down option), which saves time. For files that already exist in OneDrive, OneDrive for Business, or SharePoint, you can choose to share them as Edit or View-only links instead of traditional attachments, allowing you to work with one document instead of multiple Collaborate.
Outlook Search People Suggestions
When you search for messages in Outlook and the search string is similar to people you communicate with on a regular basis, you will see people suggestions that allow you to Easily find messages involving them.
Use Clutter to sort low-priority messages in Outlook
Clutter moves low-priority messages out of your inbox and into their own folders. Save time when scanning important emails. Clutter looks at past actions you've completed to determine the messages you're most likely to ignore. It then moves these messages to a folder in your inbox called Clutter. The Clutter folder is available no matter how you access your account. From the Outlook desktop, you can access the Clutter folder, configure the Clutter experience, and indicate that a message is not Clutter.
Read-only mode for Excel
Quickly open an Excel workbook in read-only mode in SharePoint so you can quickly work on what matters most.
New Chinese and Japanese default fonts
Office 2016 updates existing Japanese and Simplified Chinese fonts, now with a unified, modern look across all major authoring applications, including: Excel, Word , PowerPoint, Outlook Mail and OneNote
Cloud connectivity
Making file sharing and collaboration even easier
These changes combine two important aspects of collaboration Together: People who have access to a given document and who are currently working on it with you. Now you can view both types of information in a single location through the Share dialog box.
Save As improvements
These improvements simplify Save the new file. Saving files is now as easy as creating them, and you can do it all in Backstage in Word, Excel, and PowerPoint.
Note This feature is debuting and may not be available throughout the preview.
Real-time collaborative authoring 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. As users work with and update the document, changes appear automatically. Use this feature when working with documents stored on OneDrive for Business and Office 365 SharePoint sites.
Note This feature is debuting and may not be available throughout the preview.
Updated Backstage UI
Backstage, the location where you can open and save documents, now has a more intuitive storage location. The Browse button is more prominent, and within the Open and Save As tabs, the order of storage location tabs has been updated to reduce confusion. For example, OneDrive > OneDrive for Business > Online Locations > Local Computer. To avoid confusion, for online storage locations, corresponding email addresses have been added to the tab labels to help differentiate between individual tabs. The Browse button in each Open/Save As pane has also been improved to be more visible and provide faster access to File Explorer.
Cloud Attachments in Outlook
Send a link to a cloud document, giving everyone access to the latest version of the document and enabling collaboration on the same master copy when you need it. With this version of Outlook, you can now select and attach files from your SharePoint or OneDrive account, even files that don't appear in the recent items list summary. When you choose to attach a document that's already in OneDrive or OneDrive for Business to a message, a link is automatically attached (and the appropriate permissions are granted). You can set permissions for each file and choose to share it as a traditional, embedded, or cloud attachment.
If the file doesn't already exist in OneDrive (OneDrive for Business or OneDrive Personal), Outlook now lets you quickly upload and send it as a cloud attachment. Or if you receive an attachment and want to quickly save it to OneDrive so you can access it later, that's possible too.
Reducing Outlook storage space on small devices
By default, Outlook typically downloads one month's worth of email on small devices, which is the shortest time range of email that can be downloaded . You can now choose from the following values ??via your account settings: 1 day, 3 days, 7 days, 14 days, and download only the latest emails so you can quickly work on the most important things.
Support for small screen portrait layout in Outlook
Similar to the Outlook experience on Windows Phone, you can now select messages from a list and see the reading displayed on the right side of the screen pane. Just use the "Back" button to return to the mailing list.
Intelligent Experiences
Insights in Office
Already available in Word and Outlook, this feature is now available in Excel and PowerPoint, and it works in your Help you learn more about your content by providing exactly the right information in the context of what you're reading or writing. With information from a variety of sources like Bing Snapshot, Wikipedia, Bing Image Search, and Oxford Dictionaries, you can take any action with a quick look at detailed browsing without leaving an Office application. Insights can be accessed through the Review tab on the ribbon or by right-clicking a word or phrase through the Instructions Search box. Insights, powered by Bing, uses selected text and some ambient content to get contextual results.
Instructions Search
Instructions Search saves the time you would normally spend looking for a specific feature in the Ribbon. You can enter what you're looking for in the Instructions Search box in the upper right corner of the ribbon in Word, Excel, PowerPoint, and Access. Instructions Search uses text rotation to display results as soon as you start typing. Each additional word you enter makes the results more precise, so you can click on what you're looking for when you see it. For example, if you want to mark a document as confidential, just enter "confidential" or "confidential flag" and the Instructions Search will display the Insert Watermark command.
When you click in the How To Search box, you'll also see a list of the last five commands you ran from the How To Search, saving you the time it takes to navigate to the feature you want to use. time.
Outlook Desktop Groups (Office 365 Business Mail only)
Groups are an evolution of distribution lists and are used for communicating and collaborating with team members. With groups in desktop Outlook, you can now:
Create and manage groups within Outlook.
Stay informed about activity in your group without leaving your inbox.
Access a group's conversation history, even before you joined.
Organize files and notes related to your group in the group's OneDrive and access them through Outlook.
Schedule meetings on a group calendar that everyone in the group can update.
Or just use it as a distribution list.
Accessibility
Dark theme
This new theme is suitable for For users with impaired vision who are unable to see overly bright displays in Office 2013, it can provide visually more detailed backgrounds in apps. Dark theme also includes improvements to the Word navigation pane (better readability, fixed white flash) and multiple Outlook readability fixes (white text on light background, dark text on dark background, Disable illegible text). Contextual ribbon tab text, hover states, and task pane controls have also been improved.
Keyboard access to PivotTables and Slicers in Excel
The situation that previously prohibited the use of keyboard operations for functions such as PivotTables and Slicers in Excel has now been implemented. Provides more powerful Excel functionality to all users.
Use the keyboard to access the Shapes panel in Visio
You can now easily access the Visio Shapes panel using the keyboard. Press F6 to enter the Shapes panel, and press Tab to cycle through different parts of the Shapes panel. Users can navigate between elements using arrow keys. Users can use Ctrl+Tab to quickly switch between Stencil and Search views.
Built-in business intelligence
New chart types
The following new chart types are available. They are particularly useful for visualizing financial or hierarchical information and showing statistical properties in your data:
Financial: Waterfall Charts
Statistics: Histograms, Pareto Plots, and Box Plots< /p>
Layers: Treemaps and Sunbursts
Quick Data Links in Visio
You can link Visio diagrams to Excel data and then convert the diagrams into animations Dashboard.
Search and data model improvements in field lists
Excel field lists for adding fields to PivotTables and PivotCharts now support search functionality so you can find them quickly Field to look for in a longer list.
Excel Power Query Integration
Microsoft Power Query for Excel was originally a standalone downloadable add-in for Excel 2013 and 2010 and is now integrated in Excel. Power Query enhances self-service for Excel by providing an intuitive, consistent experience for discovering, combining, and optimizing data across multiple sources, including relational sources, structured and semi-structured sources, OData, the web, Hadoop, Azure Marketplace, and more Business intelligence (BI) services.
Excel Forecast Functions
The Time Series Forecast worksheet function is used to predict future values ??based on historical data. For example, a monthly schedule or a yearly schedule that has a value on the first day of each month. For this type of schedule, it is useful to aggregate the raw detailed data before applying the forecast, which can also produce more accurate forecast results.
In this preview, the following forecast functions are available:
Forecast.ETS() - Returns forecast values ??for a specific future target date
Forecast.ETS.Confint() - Returns a specified target Confidence intervals for date forecasts
Forecast.ETS.Seasonality() - Returns the length of repeated patterns detected by Excel for the specified time series
Supports multi-touch slicer items Select
As a result of this change, you can now select multiple items when opening the Excel slicer using a touch device. This is a change from previous versions of Excel, where you could only select one item at a time using touch input when using the slicer. You can also enter slicer multi-select mode by using new controls in the slicer tab.
Time group and pivot chart drill-down
Drilling up and down on time groups and other levels of data is a common data analysis operation. This preview makes it easier for you to do these things with two new updates. Now when you add a time field row to a PivotTable, the time group is automatically detected and created. Additionally, you can now drill up and down into data hierarchies directly from PivotChart visualizations to gain deeper insights into your data directly from your charts and graphs.
PowerView using OLAP connections
Microsoft PowerView now adds reporting options for Online Analytical Processing (OLAP) cube connections. Simply connect your Excel spreadsheet to an OLAP cube and choose to view this data as a PowerView report in the workbook. In PowerView, you can now generate reports using KPIs, hierarchies, calculations, and table data from OLAP cubes.
Data Model PivotTable Automatic Relationship Detection
Automatic relationship detection is now available to everyone using Office 365. If you generate a PivotTable with two or more tables that do not have a defined relationship, you will get a notification prompting you to run automatic relationship detection. This will detect and create all relationships between the tables used in the data model PivotTable so that you don't have to do this yourself. Automatic relationship detection can also be run through the Relationships dialog box.
BI feature discoverability
Business intelligence features are now easier to find in the Excel experience. If you use one of the BI features (Power View, Power Pivot, or Power Map), the rest are automatically enabled for you. You can also enable all BI features in Excel by going to the following path: File > Options > Advanced > Enable Data Analysis Features instead of going to the following path: File > Options > Load Items > Manage COM Add-ins > Get Started to save time.
Renaming tables, columns and measures and pivot table adjustments in Power Pivot
You can now rename tables, columns and calculated fields in the Power Pivot add-in/ Measures, and can leverage PivotTables that adjust seamlessly to new names in the data model.
Excel: Data Cards
Data cards display rich tabular data or selected visuals for a specific location on mouseover. Users can scrutinize and display hidden data during presentations or story sharing. This hidden data may be aggregated data that cannot be displayed in existing visual forms. For example, a column chart cannot show an illustration of a set of events that occurred at a specific location: such as a list of food poisoning incidents that occurred at a specific restaurant during a certain time period.
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 access them from within the relevant Office application using Information Rights Management (IRM).
Add-in deployment through Click-to-Run
Solver, Euromoney, and Analysis ToolPak add-ins can be deployed in the language of your choice through Click-to-Run.
Solves Click-to-Run manageability issues for IT professionals
Click-to-Run is a streaming and virtualization technology that allows large enterprises to install Office at scale The product has become very easy to get the latest and most advanced Office into the hands of end users quickly. In this preview, necessary security updates, bug fixes, and compliance requirements have been addressed, making it easier to click and use.
Data Loss Protection (DLP) in Excel
Data Loss Protection (DLP) is a beloved, high-value enterprise feature in Outlook. For this preview, we're introducing DLP in Excel to enable real-time content scanning based on a set of predefined policies for the most common sensitive data types, such as credit card numbers, Social Security numbers, and U.S. bank account numbers. In a future preview, this feature will enable synchronization of DLP policies from Office 365 in Excel, Word, and PowerPoint, providing organizations with unified policies across content stored in Exchange, SharePoint, and OneDrive for Business. An added benefit of DLP is that it enables IT administrators to exercise some oversight and helps end users in the organization manage sensitive information better and more intelligently.
Information Rights Management (IRM) protection is now available for Visio files
Visio files now provide Information Rights Management (IRM) functionality to permanently protect emails and attachments, documents, and diagrams. Online and offline protection. Now you can protect sensitive information such as confidential product information, financial and sales process visuals, research and patent information, customer or employee data in Visio diagrams. Since users can now access files from almost anywhere, large amounts of potentially sensitive information can be compromised, which is a serious threat to organizations. To help prevent information leakage, use the new Information Rights Management (IRM) feature to protect your Visio diagrams.
Multiple Authentication
Multiple Authentication (MFA) simplifies login across the Office suite and strengthens the entire Office suite with single sign-on through integration with ADAL (Active Directory Authentication Library) Process security.
Other improvements
More secure translation options
These options address issues related to translation features (Full Text Translation, Translation Screen Tips, and Information Retrieval). Address security and privacy issues associated with "Reference" pane translation).
Communication with the machine translation provider now occurs over an SSL connection.