It is no secret that Excel is one of the most widely used business tools around, and millions of business users load up Excel to work on spreadsheets every minute. On Thursday, Microsoft shared more about Excel 2016 and its new business analytics features.
Excel has gone far beyond just its original spreadsheet program, and has transformed itself to work with a number of business software suites. The number of Microsoft owned and operated business analytics tools sheerly show how well Excel can work with them effortlessly.
Getting Data & Using Quicker
With Excel 2016, users can now use the built-in functionality to get data and bring all the data into one place. It had been available separately via Power Query, but now it will be found natively within Excel 2016. It will be found in the Get & Transform section on the Data tab.
Now, users can connect to data from websites, databases, Azure cloud platforms, Hadoop services, and even Salesforce. The Query editor will allow users to prepare data sets, work with them and get the data in ways that the user needs, and can work with via Excel 2016.
New Built-in Functionality
In addition to the Power Query and other features, Excel 2016 will also include numerous new features. These include automatic relationship detection, automatic time grouping, pivot-chart drill-down buttons, smart rename, allowing for searching in pivot tables, and more.’
New forecasting capabilities are also built into Excel 2016, and these allow forecasting based on Exponential Smoothing. It’s available as a new one-click forecasting button, and users can create a forecast visualization from their data series in a matter of seconds.
Excel 2016 should give businesses a number of outstanding tools for business analysis. It’s available now via the Office 2016 Preview for Windows, and is worth checking out.