Forum Discussion

Copper Contributor

Sep 14, 2018

Excel using Mac

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

excel

Haytham Amairah

Silver Contributor

Sep 14, 2018

Hi Brittany,

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

By the way, this https://excel.uservoice.com/forums/304933-excel-for-mac/suggestions/17901199-quick-analysis-for-mac in the Excel's suggestion box asking for this feature to be added, you can vote for it as I did.

Regards

Brittany Lapointe

Copper Contributor

Sep 15, 2018

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

Haytham Amairah
Silver Contributor
Sep 15, 2018
Sorry, but I didn't understand your question!
- Brittany Lapointe
  Copper Contributor
  Sep 15, 2018
  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.
  - Haytham Amairah
    Silver Contributor
    Sep 16, 2018
    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.
    
    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