where is the quick analysis button on excel

#Where is the quick analysis button on excel free

I’ll select the entire range of data from B3:I20 (Names column all the way to Sales 2011 column), and take a look at the CHARTS gallery in the Quick Analysis callout. Now let’s say I want show my data as a chart, but I’m not yet sure exactly what I want. (Date values in the “Dates” column selected, showing a live preview of the “Last Week” Conditional Formatting rule) Charts (Text values in the “Territory” column selected, showing a live preview of the “Text Contains” Conditional Formatting rule) If I select all Text or all Date values, the items in the Conditional Formatting gallery change to work better with those types of data: In the example above I’ve selected numbers, so it makes sense that I’m seeing Conditional Formatting options that work well with numeric values.

If you like what you see, click the button to add that to your selection, otherwise if you just move your mouse away the live preview will disappear. Below are some examples with Data Bars and Color Scale. Hovering my mouse over the various icons in the gallery gives me a live preview of what choosing that option will do. Looking at my sample data, I might first be interested in taking a closer look just at the numbers, so I select G4:I20, and click the button. The Charts, Totals, Tables, and Sparklines tabs in this callout each show a handful of choices from those respective categories to explore. The way to bring up the Quick Analysis interface is to select a range of data, and then click the little button that appears near the bottom right of the selection:Ĭlicking the button brings up a gallery of options to explore:īy default the Conditional Formatting gallery comes up, showing just a handful of choices, but there are other galleries to explore as well.

#Where is the quick analysis button on excel free

Live preview makes it quick and painless to see what’s going to happen to the workbook before committing to a change.įeel free to open the workbook and come along as we take a closer look at how it all works.

The Quick Analysis galleries are dynamic: what appears in them changes depending on the type of data you’ve selected. We set out to create a dynamic interface that allows fear-free exploration of Excel’s analytical capabilities. These are the main motivations behind Excel 2013’s Quick Analysis feature. Many people are simply unwilling to navigate away from the home tab to go looking for interesting features & capabilities.Some people feared they wouldn’t be able to change it back if they didn’t like the result

Many people are hesitant to create / insert new features, even a chart.Many people aren’t familiar with the variety of data analysis features that Excel has to offer.Of course several patterns and themes were observed, but here are a few that caught my interest and really resonated with me and with several others on the team:

We went in small groups to someone’s work environment (whether that was a large corporation, a small business, or even a home office), watched them use Excel, and talked with them a bit about what they were doing. This blog post is brought to you by Chad Rothschiller a Program Manager on the Excel team.Īs part of our planning work at the beginning of the Office 2013 project, we (the Excel team) participated in several customer visits. Here is a new blog post from the Official Microsoft Excel 2013 blog about Quick Analysis:”by Diego M.