From here, you can send an invitation for other people to share your current document and find people with whom you've previously shared and worked on documents. Ĭommand central for collaborating is a new Share pane that displays when you click the Share icon in the upper-right part of an Office document that can be shared. (At some point Microsoft will roll out the feature to the non-subscription version of Excel, but the company isn’t saying exactly when.) This real-time collaboration works in both home and business versions of Office 2016, although business users have a few extras not found in the home versions, as I'll explain. In July 2017 Microsoft finally made the feature available in Excel as well - but only for Office 365 subscribers who have updated to Version 1707 Build 8326.2058 or later. When Office 2016 was released in September 2015, real-time collaboration worked only with Word, PowerPoint and OneNote documents.
Now you can easily work on a document with other people in real time, as long as the document is stored in OneDrive, OneDrive for Business, or SharePoint Online. As someone who makes a living as a writer, I can't imagine doing without them.īut previous versions of Office fell short in real-time collaboration features that allow people to work on documents simultaneously no matter where they are in the world, as long as they have Internet connections. The Office suite, particularly Word, has long had the best features of any productivity-tool suite for letting people review each other's documents – I've always thought that its change-tracking, markup and reviewing features were the gold standard for document review.
How successful has Microsoft been in adding collaboration features? And how useful are the handful of non-collaborative features added to the core of Office? That's what I'll cover in the rest of this review. That's not necessarily a bad thing – Office is already so stacked with features that adding new ones just for the sake of it could harm rather than help its usability. If you work by yourself and will use Office as a standalone product, you'll find far fewer changes from Office 2013. After seeing the chart, you probably already know the answer.Ĭonclusion: in this example, when using the FORECAST.ETS function, you can also use the value 4 for the fourth argument.If Microsoft were to have a motto for Office 2016, it could well be the old coaching adage "There is no 'I' in "team." The suite offers considerable collaborative and teamwork features that turn Office from a tool for a single person into one that helps people work together. You can use the function to find the length of the seasonal pattern. Enter the value 49 into cell C13, select the range A1:C17 and insert a scatter plot with straight lines and markers.ģ.
The default value of 1 indicates seasonality is detected automatically.Ģ. The fourth argument indicates the length of the seasonal pattern. The FORECAST.ETS function below predicts a future value using Exponential Triple Smoothing. The FORECAST.ETS function in Excel 2016 or later is a great function which can detect a seasonal pattern.ġ. This equation predicts the same future values. Note: when you add a trendline to an Excel chart, Excel can display the equation in a chart. Enter the value 89 into cell C11, select the range A1:C14 and insert a scatter plot with straight lines and markers. Explanation: when we drag the FORECAST.LINEAR function down, the absolute references ($B$2:$B$11 and $A$2:$A$11) stay the same, while the relative reference (A12) changes to A13 and A14.Ģ.