where is quick analysis button in excel 2013

This gives a nice visual bar chart representation of each data value.

The first option on the left is Data Bars. The first menu option that pops up is the Formatting tab which has some neat features. If you hover over it, you will see that it is the Quick Analysis tool. Notice on the bottom right there is a little icon. Highlight the actual data and not the headers. For this example we are going to analyze some January metrics over a five year span. Let’s take a look at what it can do.įirst, pick a set of data to analyze. This handy little tool offers some really quick and easy, yet powerful ways to visually analyze data. I thought, ‘Wow, that’s cool!’ This is a new feature in Excel 2013 called ‘Quick Analysis’. You can format it.Last November while I was at PASS Summit, one of the presenters used Excel and added some data bars right on top of the data. But for now, I'll just click the Action button, and doing so displays the Quick Analysis Lens, and this gives you many different ways to look at your data. If you want, you can also open the Quick Analysis tool by selecting your data and pressing Ctrl+Q on the keyboard. And when I hover the mouse pointer over it, you'll see that it is called the Quick Analysis. When I select that cell range, you see that a new button has appeared at the bottom-right corner of the selection.

In this case, my data is in cell A1 to B7. To use the Quick Analysis Lens, the first thing you need to do is to select the data you want to summarize. Excel 2013 comes with a new feature called the Quick Analysis Lens that helps you decide. That's great, because it gives you a lot of ways to look at your data, but the problem of course is that you have to decide what to do. Excel is an incredibly powerful and flexible program.

Where is quick analysis button in excel 2013