Excel’s Quick Analysis Tool provides shortcuts to a selection of some of the great options offered by various analysis features including Conditional Formatting, Charts, Totals, Tables and Sparklines. It cuts down the time you might spend “surfing” the Ribbon looking for commands and provides quick analysis in a few seconds.

The Quick Analysis Tool appears bottom right corner of a cell range selection and can also be activated with the keyboard shortcut CTRL+Q. It offers live preview so that you can point and see the impact of applying features to your data before committing and uses built-in logic to make recommendations based on the type of data (numbers, dates or text) you have selected.

To watch without sound, turn captions on by clicking 'CC' then selecting 'English'.

Share:

Stay up to date

Subscribe to our mailing lists:

I would like to receive the following emails:
Mailing lists

We are collecting your email address to send you the emails you select above and we require your consent. By clicking the Subscribe button, we are treating this as your consent. To withdraw your consent, please use the unsubscribe option at the bottom of the received email(s)