Second, the Quick Analysis Tool is only designed to work with numerical data. This means that it can’t effectively analyze data that has more than two variables. First, it only supports two-dimensional data. There are a few limitations to the Quick Analysis Tool in Excel.
What Are the Limitations of the Quick Analysis Tool? You can also use the tool to create charts and graphs of your data.
You can use the Quick Analysis Tool to quickly summarize data, find averages and sums, and calculate percentages. The Quick Analysis Tool is an Excel feature that allows you to quickly analyze data in a table or range of cells.