Moreover, one can add buttons to the Excel ribbon and run custom functions with add-ins. Once enabled, it activates as Excel is started.įor example, Excel add-ins can perform tasks like creating, deleting, and updating the data of a workbook. Providing additional functions to the user increases the power of Excel. Spreadsheet pros will be pleased with four new features built into Excel 20 - Quick Analysis, Forecast Sheet, Get & Transform and 3D Maps.An add-ins is an extension that adds more features and options to Microsoft Excel. If you’re looking to analyze data in a spreadsheet, the new Quick Analysis tool will help.
Highlight the cells you want to analyze, then move your cursor to the lower right-hand corner of what you’ve highlighted. A small icon of a spreadsheet with a lightning bolt on it appears. Click it and you’ll get a variety of tools for performing instant analysis of your data. For example, you can use the tool to highlight the cells with a value greater than a specific number, get the numerical average for the selected cells, or create a chart on the fly. The Quick Analysis feature gives you a variety of tools for analyzing your data instantly. (Click image to enlarge.) Forecast SheetĪlso new is that you can generate forecasts built on historical data, using the Forecast Sheet function. If, for example, you have a worksheet showing past book sales by date, Forecast Sheet can predict future sales based on past ones.
To use the feature, you must be working in a worksheet that has time-based historical data. Put your cursor in one of the data cells, go to the Data tab on the Ribbon and select Forecast Sheet from the Forecast group toward the right. On the screen that appears, you can select various options such as whether to create a line or bar chart and what date the forecast should end.
(Your original worksheet will be unchanged.) IDG Click the Create button, and a new worksheet will appear showing your historical and predicted data and the forecast chart.
0 kommentar(er)
