However, Excel 2016 makes this process a little easier with an Auto-Detect ­button that can compare multiple database tables to identify common field names, and then establish the join (s) ...

Excel 2016 provides a new tool called Forecast Sheet that automatically calculates and plots your upper and lower forecast boundaries based on your desired level of confidence.

Use INDEX and MATCH for simple database queries in Excel The bigger your spreadsheet, the more you need these, which you can combine with SUM, AVERAGE, and MAX to refine your searches.

Excel 2016’s many new features include six new chart types. We’ll go over Histogram, Pareto, and Waterfall and talk about how they could be used with your data.

After a relatively short beta, Microsoft today announced that the Excel API -- a way for developers to programmatically use Excel for Office 365 for doing calculations, building dashboards and ...