1. Conditional Formatting Making sense of our data-rich, noisy world is hard but vital. Used well, Conditional Formatting brings out the patterns of the universe, as captured by your spreadsheet. That's why Excel experts and Excel users alike vote this the #1 most important feature. This can be sophisticated. But even the simplest colour changes can be hugely beneficial. Suppose you have volumes sold by sales staff each month. Just three clicks can reveal the top 10% performing salespeople and tee up an important business conversation. 2. PivotTables At 4 hours to get to proficiency, you may be put off learning PivotTables, but don't be. Use them to sort, count, total or average data stored in one large spreadsheet and display them in a n1ew table, cut however you want. That's the key thing here. If you want to look only at sales figures for certain countries, product lines or marketing channels, it's trivial. Warning: Make sure your data is clean first
I write all the information in my blog which can be useful for you. "Valuing YourselfЁЯСН Always give your Best Shot.......