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’. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |