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. A dialog box appears.(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. These are only visible when the chart is selected. Once you insert a chart, a new set of Chart Tools, arranged into three tabs, will appear above the Ribbon. The axis that represents the values or units of the source data. The actual charted values, which are usually rows or columns of the source data. The vertical axis is often referred to as the Y axis, and the horizontal axis is referred to as the X axis. The vertical and horizontal parts of a chart. The chart key, which identifies what each color on the chart represents. The chart is updated automatically whenever the information in these cells changes. Charts make it easy to see comparisons, patterns, and trends in the data. Have you ever read something you didn't fully understand but when you saw a chart or graph, the concept became clear and understandable? Charts are a visual representation of data in a worksheet.
0 kommentar(er)
