How to do the win loss data analysis using Quick Analysis?

Win-loss data analysis in Excel can be done using the Quick Analysis tool, which is a feature that allows you to quickly analyze and visualize data in your worksheet. Here’s how to perform win-loss data analysis using Quick Analysis:

Data preparation

The first thing we’d need is having a data that looks like this:

1. Mark the data with values (1), click on the small chart showing on the right low angle (2), and choose greater than (3).

Quick Analysis data table

2. Write the amount you’d like to format, if it is greater than that specified amount (1), and then press ok (2).

Quick Analysis write amount

The formula

3. Click under the last row, and type total (1), and beside it, type =sum(b3:b6) (2). This will show the whole sum on the last row, and now press the small square on the lower right corner, and drag it throughout the columns.

Quick Analysis drag total

4. Mark the data beside total (1), click on the small chart beside the data (2), click sparklines (3), and then click the Win/Loss (4).

Quick Analysis win loss sparkline

Note: You can do this by first marking all the data with value.

5. You can now check the values you’d like to be visible, on the win/loss.

Quick Analysis check visible values

Note: If the values have minus in front, then they would also automatically be negative (showing red).

This is a simple way to perform win-loss data analysis using Quick Analysis in Excel. The tool is designed to make data analysis and visualization quick and easy, so you can get insights from your data faster.