Excel using Mac

Copper Contributor
I cannot find the quick analysis button when I select a cluster of cells. It does not show up. I’ve tried anything HELP! I think it’s office 365
5 Replies

Hi Brittany,

 

This feature isn't available in the Mac version of Excel!

By the way, this idea in the Excel's suggestion box asking for this feature to be added, you can vote for it as I did.

 

Regards

So how do I do the functions without using the features?

Sorry, but I didn't understand your question!

So sorry. What I meant was; I’m in a class and they give worksheets to complete with specific directions. So how do I do the things on the sheet when it’s asking to use the quick analysis feature. How do I still do the same steps without it. Are there other ways to do it without using the quick analysis feature.

Hi Brittany,

 

The Quick Analysis is just a shortcut menu for some features, tools, and techniques in Excel.

 

You can find most of them in the ribbon in their associated tabs.

Quick Analysis.png

 

 

So, you will find the Charts, Tables, and Sparklines in the Insert tab.

The Formatting tools are located in the Home >> Styles >> Conditional Formatting.

With regards to Totals, you will find most of them in the Home >> Editing >> AutoSum menu.

 

Regards