Click the button that represents the total you want to apply. To add totals by using the Quick Analysis LensĤ. Click the button that represents the formatting you want to apply. If necessary, click the Formatting tab.Ĥ. Click the Quick Analysis action button.ģ. To add formatting by using the Quick Analysis LensĢ. If you select a new summary column or row when one exists, Excel displays a confirmation dialog box to verify that you want to replace the existing summary. You can add one summary column and one summary row to each data range. You can use the tools on the Totals tab of the Quick Analysis toolbar to add summary operations to your data. Select from several categories of analysis tools

You can also add total columns and rows to your data range. The Quick Analysis toolbar makes a wide range of tools available, including the ability to create an Excel table or PivotTable, insert a chart, or add conditional formatting. After you select the data you want to summarize, clicking the Quick Analysis action button displays the tools you can use to analyze your data.Ĭlick the Quick Analysis action button to display analysis tools

One useful tool in Excel 2016 is the Quick Analysis Lens, which brings the most commonly used formatting, charting, and summary tools into one convenient location. This chapter guides you through procedures related to examining data by using the Quick Analysis Lens, defining an alternative data set, defining multiple alternative data sets, analyzing data by using data tables, varying data to get a specific result by using Goal Seek, finding optimal solutions by using Solver, and analyzing data by using descriptive statistics.Įxamine data by using the Quick Analysis Lens You can also create a data table that calculates the effects of changing one or two variables in a formula, find the input values required to generate the result you want, and describe your data statistically.

The data in your worksheets is great for answering “what-if” questions, such as, “How much money would we save if we reduced our labor to 20 percent of our total costs?” You can always save an alternative version of a workbook and create formulas that calculate the effects of your changes, but you can do the same thing in your existing workbooks by defining one or more alternative data sets. You can summarize your data quickly by using the Quick Analysis Lens to create charts, calculate totals, or apply conditional formatting. When you store data in an Excel 2016 workbook, you can use that data, either by itself or as part of a calculation, to discover important information about your organization.

Microsoft excel quick analysis button