Hi, this is Wayne again with a topic “The Excel Quick Analysis Tool”.
In this article i will show you the excel quick analysis tool, which is a great shortcut for adding some useful visualizations to your excel spreadsheets. So here i have a pretty big financial data spreadsheet for a business and the numbers get so big in this spreadsheet that it could be easy to get confused about what i’m looking at here – 600, 000 versus 600 million, etc. Now, of course, i could highlight a particular column and use the conditional formatting tools to add some useful visuals to this spreadsheet and help me to be able to understand this data better. If you want to learn all about the conditional formatting tools in excel watch. My other videos that i’ve made about that topic, but in this article i want to show you an even quicker way to do something similar step. One is to select the data that i want to quickly analyze and produce visualizations, for in many cases you can just click and drag to highlight the range that you want to use the excel quick analysis tool with, but in this case it’s going to be kind Of hard, there are lots and lots of different rows in this spreadsheet and many columns as well. So what i’m going to do is hold ctrl and tap a to select everything that selects all and now, if i look in the lower right corner of my excel window, you can see a little button has popped up. That is the excel quick analysis tool and the nice thing is you don’t have to go down to the lower right corner of your data in order to see that tool, it should pop up whether you’re at the bottom of the data or at the top or In the middle, at least, it works that way when you hold ctrl and tap a to select everything in a big spreadsheet, i’m going to go ahead and click on it, and you can see there some of the nice visualizations that might be available to me, using That excel quick analysis tool, so i could add some data bars, i could add some color scales and you can see each one illustrates some truth about the numbers in this case of color scale, the higher the number the more green it is. So it helps to draw attention to certain data.
I can also go to an icon set option. We have arrows pointing up arrows, pointing down arrows sideways now, don’t be concerned about the hashtag symbols that are appearing. The reason for that is because there’s not enough width in each column, but that’s easy to fix just by clicking and dragging so icon sets, are another great option, there’s also greater than and top ten percent. There are also some chart options. I can put my mouse over clustered bar to see what that chart would look like, or sum of profit by segment and year, some of manufacturing. So these are just quick charts that excel is just figuring out that i might want, and i can get a preview of each one just by putting my mouse over them. If i don’t want any of those – and maybe i want another type of chart, i could click more charts and it brings me even more options. I’Ll, cancel that and go back to the excel, quick analysis tool in addition to formatting and charts.
We also have totals so. If i go down to the bottom of the screen and i select totals i can put my mouse over sum – average count percent total running total. It’S automatically adding totals for each column and giving me some options as to how those totals will appear tables are another option. I can use this table here, a quick pivot table and other kinds of pivot tables, and then finally, there are some sparkline options. Now some of these visualizations will be perfect for the spreadsheet that you’re working in and some will not here’s my sparklines over here on the right, i’m going to undo that one, but that’s one of the nice things about the excel quick analysis tool.
You can just try things out and if they don’t look good or if they don’t make sense, if they’re not useful to you just move on to the next one and try out a different visualization after looking through these various visualizations, i think i’m going to go With this color scale to again draw attention to the highest numbers to the lowest numbers, and i think i’ll also add a chart i’ll go to more charts and i’ll select this one here, click! Ok, the chart is added to my spreadsheet and, if i wanted to, i could go back to the excel quick analysis tool. It looks like it’s disappeared, so i need to redo control a to get it back and i think i’ll put in some totals as well running totals so next time. You’Re working on an excel spreadsheet.
That has a lot of data, give the excel quick analysis tool. A try and see what it can do to help you illustrate and draw attention to key information in your spreadsheet thanks for watching. I hope you found this tutorial to be helpful. If you did please like follow and subscribe and when you do subscribe, click the bell.
So you’ll be notified whenever i post another video. If you’d like to support my channel, you can do that through my patreon account and you’ll see a link to that in the description below .