WEBUse the Quick Analysis Tools: Select the cell range you want to summarize. Click the Quick Analysis button that appears. Select the analysis tool you want to use. Choose from formatting, charts, totals, tables, or sparklines. Outline and Subtotal: Click the Data tab on the ribbon and click the Subtotal button. Use