Five major time-savers in MS Office

  1. Spot trends fast: In most cases, it’s the trend that counts – not the heap of numbers. Transform an entire column of data into a single cell using Sparklines (Select cells > Insert > Sparklines)
  2. A picture is worth a thousand words: Instantly chart a mass of data by selecting the cells and hitting F11
  3. See it coming: Tell the future fast with Linear Forecasting (Select chart > Layout > Trend Line > Linear Forecast)
  4. Analysis at a glance: Get an instant view of what’s working and what’s not by selecting cells and hitting conditional formatting
  5. Don’t look at more than you need to: Siphon required information from a pivot table speedily by using Slicer (Insert > Slicer)