

It's much better than the old Quick Analysis feature.

To use Excel's really great Ideas feature, just click anywhere in a data table and click the Ideas button on the Ribbon. To add sparklines, click the Sparklines button on the Insert tab of the Ribbon

That's on the Ribbon when your selection is within an Excel Table Totals is a feature of Excel's Table feature. To make a chart, use Insert tab and choose a chart type They're just in different places on the interface.įormatting is available by right-click > Format.Ĭonditional Formatting is on the Home tab of the Ribbon near the middle of the Ribbon It's always touchy when a student has to explain to the professor that they are teach out of date concepts, but really, I think they should be teaching the "Ideas" feature instead of the old Quick Analysis feature, which you don't even have.Īll the features of the quick analysis tool are in Excel for Mac. Your version of Excel doesn't have this old feature. This article describes the old quick analysis tools: Excel Quick Analysis | How to Use Quick Analysis Tools in. Assuming you have an Office 365 subscription and that you have enabled connected experiences in Excel > Preferences > Privacy, your version of Excel should have the much newer "Ideas" feature.
