(Click image to enlarge.) Forecast SheetĪlso new is that you can generate forecasts built on historical data, using the Forecast Sheet function. The Quick Analysis feature gives you a variety of tools for analyzing your data instantly. 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. Click it and you’ll get a variety of tools for performing instant analysis of your data. A small icon of a spreadsheet with a lightning bolt on it appears.
Highlight the cells you want to analyze, then move your cursor to the lower right-hand corner of what you’ve highlighted. If you’re looking to analyze data in a spreadsheet, the new Quick Analysis tool will help. Spreadsheet pros will be pleased with four new features built into Excel 20 - Quick Analysis, Forecast Sheet, Get & Transform and 3D Maps.
0 kommentar(er)
