![]() ![]() Using the same sales data from the examples above, the LARGE functions is able to quickly identify the top two products for each month of our data. While everyone knows MAX and MIN functions, very few take advantage of LARGE and SMALL-functions that help you find the first, second or nth largest (or smallest) value in your data. You can also adjust color scale options by editing the formatting rule. To create a heat map using Conditional Formatting, select your raw data and then on the ribbon under Home, click Conditional Formatting > Color Scales and then pick a color scale. This is a simple and effective way to explore your data and find interesting patterns.īelow is a heat map where the color scale option was applied in literally 10 seconds from the same sales data used in the Sparklines example above to illustrate the high (dark green) and low (white) sales data across products and time. The options available in the Conditional Formatting feature allow you to quickly create heat maps, turning a table of data into a continuous spectrum of colors for insightful visual analysis. Next enter the target range where you want the Sparkline displayed. To create your own Sparklines, select the data range and on the ribbon click Insert and then select the Sparklines type-Line, Column or Win/Loss. ![]() And yet, not many analysts capitalize on these powerful tiny charts. This feature is unbelievably cool and ridiculously simple to use. Sparklines offer excellent real-estate savings on crowded dashboard worksheets and can be extremely insightful for the amount of space used. Sparklines, first introduced in Excel 2010, are charts that provide simple visualization representations of trends across a row of your data-in a single worksheet cell. Let’s take a look at these features-what I like to call the low-hanging fruit- including Sparklines, Conditional Formatting, Slicers and a few simple but useful formulas you may not have noticed. I believe that, among the great secrets of Excel, there are several that are easy to use and quickly add value to your work. We all know that Excel is packed with tons of powerful features, libraries of formulas and galleries of interesting charts, making it one of the most useful tools for business analysts. Today’s post on Excel was written by Purna Duggirala president of. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |