Analyse quickly with the Quick Analysis tool

Did you know? Excel now has a Quick Analysis tool.

⚡📈 Select some data and the Quick Analysis icon appears at the bottom right with lots of options organised in the following areas:

  • Formatting
  • Charts
  • Totals
  • Tables and
  • Sparklines (mini charts in individual cells).

For example: If you have multiple columns to SUM, you can use the Quick Analysis tool like this.

  1. Select your data
  2. Select the Quick Analysis tool that appears (or use the shortcut Ctrl Q)
  3. Select Totals
  4. Select Sum

🤩 Check it out!