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. Ease of Use Improved Conflict Resolution in PowerPoint This feature simplifies conflict resolution while 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 expands the number of default shape styles by introducing new "preset" styles in Word, Excel, and PowerPoint. New Timeline View in Project We've improved the Timeline View in Microsoft Project so that you can display multiple timeline bars in one view, and you can set a date range for timeline bars so that they can only Represents a specific phase 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. Getting Started with Visio Visio diagramming functions 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 includes higher DPI support for 250 and 300 display ratios, so your Office documents look clear on the big screen. Pan and zoom while loading large charts and SmartArt No more waiting when loading large charts and SmartArt charts because the text appears instantly, 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. Inserting images with the correct orientation Now, with automatic image rotation, images are automatically rotated when inserted into the app to match the orientation of the camera. 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 You can now easily attach your recently used Office documents to your Outlook emails from the ribbon or action bar (just select the document from the drop-down option), saving 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 your search string is similar to someone you communicate with regularly, you'll see people suggestions that make it easy for you to find messages about them. Use Clutter to sort low-priority messages in Outlook Clutter moves low-priority messages out of your inbox and into their own folders, saving time when scanning important messages. 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 regardless of 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 makes files safe Sharing and Collaboration Easier These changes bring together two important aspects of collaboration: who can access a given document and who is 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 saving new files by letting you pick a location in OneDrive, OneDrive for Business, or your local computer, provide a filename, and click Save. 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 user interface Backstage, where you can open and save documents, is now more intuitive.
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 location > 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 links to cloud documents, giving everyone access to the latest version of a 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. Reduce 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 pane appear on the right side of the screen. Just use the "Back" button to return to the mailing list. Intelligent Experience Insights in Office Already available in Word and Outlook, now available in Excel and PowerPoint, this feature helps you learn more about you by providing precisely the right information in the context of what you are reading or writing. content. 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 to communicate and collaborate 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, a new theme for users with impaired vision who have trouble seeing overly bright displays in Office 2013, provides more subtle visual effects in apps background. 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 Scenarios that previously prohibited keyboard access to features such as PivotTables and Slicers in Excel have now been implemented, providing 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 suitable for visualizing financial or hierarchical information and showing statistical properties in your data: Financial: Waterfall Chart Statistics: Histograms, Pareto Charts, and Box Plots Hierarchical: Treemaps and Sunburst Charts Quick data links in Visio You can link Visio diagrams to Excel data and then convert the diagram into a dynamic dashboard. Search and data model improvements in field lists Excel field lists, used to add fields to PivotTables and PivotCharts, now support search capabilities so you can quickly find the fields you are looking for in longer lists. Excel Power Query integration Microsoft Power Query for Excel, originally a standalone downloadable add-in for Excel 2013 and 2010, 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. The Excel Forecast Function 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 the forecast value for a specific future target date Forecast.ETS.Confint() - Returns the confidence interval for the forecast value for a specified target date Forecast.ETS.Seasonality() - Returns the length of a detected repeating pattern in Excel for a specified time series Supports multi-selection of slicer items via touch As a result of this change, it is now possible to 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 Groups and PivotChart Drill-down Drilling up and down into 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: "File" > "Options" > "Advanced" > "Enable Data Analysis Features" instead of going to the following path: "File" > "Options" > "Add-ins" > "Manage COM Add-ins" > "Get Started" and save time. Rename Tables, Columns and Measures in Power Pivot and PivotTable Adjustments You can now rename tables, columns and calculated fields/measures in the Power Pivot add-in and take advantage of seamless adjustments to the data model PivotTable report with new name. Excel: Data Cards Data cards display rich tabular data for a specific geographic location on mouseover or selected visual form. 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 your IT department defines a set of related department templates in Azure Rights Management (RMS), you can access them from within the relevant Office apps using Information Rights Management (IRM). Add-in deployment through Click-to-Run Solver, Euromoney, and Analysis ToolPak add-ins can be deployed through Click-to-Run in the language of your choice. Solving Click-to-Run Manageability Issues for IT Pros Click-to-Run is a streaming and virtualization technology that makes it easy for large enterprises to install Office products at scale, allowing them to quickly deploy the latest and most advanced Office products. of Office into the hands of end users. 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 now available for Visio files Visio files now offer Information Rights Management (IRM) functionality, providing permanent online and offline protection of e-mail messages and attachments, documents and diagrams. 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. Multi-Factor Authentication Multi-Factor Authentication (MFA) simplifies sign-in across the Office suite and strengthens the security of the entire process with single sign-on through integration with ADAL (Active Directory Authentication Library). Additional improvements More secure translation options These options address address security and privacy issues associated with translation features (Full-text translation, Translation ScreenTips, and Information Retrieval and Reference pane translation). Communication with the machine translation provider now occurs over an SSL connection.