With the data quickly pulled out and formatted, Katie now Quick Analysis icon that appears at the lower right of wants to visualize the data, but isn’t sure what the best the selected cells. formatting, graph, or table is for this type of data. Instead of to open Quick Analysis. selecting the data and creating new charts or tables Formatting, hover over Data Bars. she can use Excel’s Quick Analysis feature to get live previews of what different data visualizations will look like. In over the Icon Set. this case, maybe data bars are the best, or this column chart. Charts. over first Clustered Column chart. Tables. Or maybe a pivot table is the best way to roll up the data. Katie over the Table icon. gets a preview of what a pivot table view of this data would look over the second PivotTable. like, all without even needing to know what a pivot table is! So the preview. you see, the Quick Analysis feature lets Katie focus more on the best way to present data about her customer and get the the second PivotTable icon. necessary insights from it, instead of spending valuable time the Pivot Table, now in a new sheet. focusing on how to set it up. New Chart Types for Excel 2016 Pareto Chart Excel 2016 offers some new charting options that can save Katie the workbook, switch back to the SNAPSHOT tab. a lot of time when analyzing data. C3:C23. One of these is the Pareto Chart, which is useful when you want to analyze what each category contributes to a total. In this the and paste to the right of You will Category. case, Katie is looking into categories of spending on marketing create a new column Amount2. for Northwind. Which are the top spending categories, and how cells (the cells containing data). E4:F23 much do they contribute to the total? the Insert tab. the Ribbon, in the Charts group, tap the down-arrow next to the statistical chart button .
With the data quickly pulled out and formatted, Katie now wants to visualize the data, but isn’t sure what the best formatting, graph, or table is for this type of data. Instead of selecting the data and creating new charts or tables she can use Excel’s Quick Analysis feature to get live previews of what different data visualizations will look like. In this case, maybe data bars are the best, or this column chart. Or maybe a pivot table is the best way to roll up the data. Katie gets a preview of what a pivot table view of this data would look like, all without even needing to know what a pivot table is! So you see, the Quick Analysis feature lets Katie focus more on the best way to present data about her customer and get the necessary insights from it, instead of spending valuable time focusing on how to set it up. New Chart Types for Excel 2016 Excel 2016 offers some new charting options that can save Katie a lot of time when analyzing data. One of these is the Pareto Chart, which is useful when you want to analyze what each category contributes to a total. In this case, Katie is looking into categories of spending on marketing for Northwind. Which are the top spending categories, and how much do they contribute to the total? Quick Analysis icon that appears at the lower right of the selected cells. to open Quick Analysis. Formatting, hover over Data Bars. over the Icon Set. Charts. over first Clustered Column chart. Tables. over the Table icon. over the second PivotTable. the preview. the second PivotTable icon. the Pivot Table, now in a new sheet. Pareto Chart the workbook, switch back to the SNAPSHOT tab. C3:C23. the and paste to the right of Category. You will create a new column Amount2. cells E4:F23 (the cells containing data). the Insert tab. the Ribbon, in the Charts group, tap the down-arrow next to the statistical chart button .
Office_Enterprise_Hero_Demo.docx