where is quick analysis button in excel 2013

We hope you found this article helpful and learned something new. If you choose Blank Pivot Table, you will find a new blank pivot table inserted on a new worksheet ready for you to build Click Table and a preview will be placed over the data – click to insert.Instead of selecting the data and choosing Format as Table from the Home Ribbon you can use quick analysis to get a standard table or a quick pivot table The chart is then placed on the spreadsheet – see below.Hover over the different charts to see a preview of how they will look – to select one click on it.Choose the type of total you want to add – Here I selected a Sum note that Excel added a total row to the data with the word Sum and also added the formula to the data.Choose whether to add them underneath the data or in a column to the right With the totals quick analysis you are offered a selection of functions that can be performed on the data. Choose from the formats offered – Excel will preview the chosen format on the selected data so you can flip between them before making a decision.Spark lines – Excel will offer you spark lines to be added to adjacent cells Tables – A selection of tables will be found here There are five main types of analysis and within each type you will be offered more options.įigure 234-various quick analysis optionsįormatting – here you can find various conditional formats – Excel will guess which are best suited to the data selectedĬharts – A selection of charts will be suggested Once you get used to using it, you will wonder what you did before! Check out our easy steps to Quick analysis below… Quick analysis looks at the data you have selected and offers you various options to analyze and summarize the data. Quick analysis is a new feature in Excel 2013.

Where is quick analysis button in excel 2013