We will show what the various kinds of analysis tools it has are. Unfortunately, not many of excel users make use of this wonderful tool. I know you have seen this icon before, but you have not worried about this. Once we select the data, we can see a small icon to the bottom right of the selection. This tool appears when we select the data range in excel. Now all important question where is this tool. You can download this Excel Quick Analysis Template here – Excel Quick Analysis Template Where is Quick Analysis Tools in Excel? TEXT and String Functions in Excel (26+).
Lookup and Reference Functions in Excel (36+).