Collaborate on Excel workbooks - Excel 2-16 New feature

Collaborate on Excel workbooks at the same time with co-authoring

If you need a co-author

Step-1 Upload your workbook
Step-2 Share It
Step-3 Other People can open it
Step-4 Co-author with others

Explore Excel 2016

In this video, you will explore the Excel overview,  using the tell me box and add or delete a worksheet.





Click here to view the original source

Close All file on a single click in Excel 2013 and 2016

Excel Tutorial

Close All file on a single click in Excel 2016

In Excel 2013 & 2016 All the excel files open in separate window so it's not possible to close all the opened file at once. This is by default, there is no option to close all excel workbook/files at once in version 2013 & 2016.
Previous version of Excel workbook/file opened in one window and we can easily have closed all the files just using the Alt+F4. Excel 2013 each excel file open on separate window and continue in 2016 version.
For example, if we have 10 files open we must close all the files separately or hit the Alt+F4 command 10 times.

How to enable / disable Quick Analysis feature

When a data set is selected, Excel displays a Quick Analysis button in the lower right corner of the range. But this option can be disabled.

Create a Forecast Chart in Excel 2016

If you have time based on the historical data it can be used to create a forecast. When a forecast is created, a new worksheet is created with a table of historical and projected values and a graph showing this. A forecast can help predict things like future sales, inventory requirements, or consumer trends