Microsoft Excel Power Pivot Power View 3D Maps Data Mining add-Ins for Excel SharePoint 2013 Power BI Q & A Power BI Apps for Mobile Devices Groups Data Catalog Excel Workbooks Power BI Desktop Microsoft Excel Microsoft Excel enables you to collect and analyze data, and to develop reports. Excel Services enables you to render a workbook in a browser window and refresh the associated data connection. Others have access to the workbook or specific parts of it without being able to modify the workbook or calculations, thereby ensuring a single version of the workbook is maintained and viewed by everyone. With an Excel Services workbook you can also perform live, interactive analysis through any supported browser, including sorting and filtering of data, as well as expanding or collapsing of PivotTables. Excel 2016 Excel 2016 for Windows has all the functionality and features you're used to with some added features and enhancements. Several of the top new and improved features include the following. New chart types to help you create some of the most commonly used data visualizations of financial or hierarchal information, or for revealing statistical properties in your data. The new chart types include Treemap, Sunburst, Waterfall, Histogram, Pareto, and Box and Whisker. Built-in functionality that makes it easy to quickly get and transform your data. These new capabilities, previously only available as a separate add-in called Power Query, can be found natively within Excel. The FORECAST function has been extended to forecasting based on Exponential Smoothing. This functionality is also available as a new one-click Forecast Sheet button.
Microsoft Excel Power Pivot Power View 3D Maps Data Mining add-Ins for Excel SharePoint 2013 Power BI Q & A Power BI Apps for Mobile Devices Groups Data Catalog Excel Workbooks Power BI Desktop Microsoft Excel Microsoft Excel enables you to collect and analyze data, and to develop reports. Excel Services enables you to render a workbook in a browser window and refresh the associated data connection. Others have access to the workbook or specific parts of it without being able to modify the workbook or calculations, thereby ensuring a single version of the workbook is maintained and viewed by everyone. With an Excel Services workbook you can also perform live, interactive analysis through any supported browser, including sorting and filtering of data, as well as expanding or collapsing of PivotTables. Excel 2016 Excel 2016 for Windows has all the functionality and features you're used to with some added features and enhancements. Several of the top new and improved features include the following. New chart types to help you create some of the most commonly used data visualizations of financial or hierarchal information, or for revealing statistical properties in your data. The new chart types include Treemap, Sunburst, Waterfall, Histogram, Pareto, and Box and Whisker. Built-in functionality that makes it easy to quickly get and transform your data. These new capabilities, previously only available as a separate add-in called Power Query, can be found natively within Excel. The FORECAST function has been extended to forecasting based on Exponential Smoothing. This functionality is also available as a new one-click Forecast Sheet button.
introducing_microsoft_bi_tools.docx