1. You need to add Analysis Toolbox to the add-in in Excel Options before you can see Data Analysis under Data Options.

2. Data processing stage:

Excel will be used at this time. First of all, we must make a big clean-up of the data! Filter and remove redundant data, make up missing data, and correct or delete erroneous data.

A series of functions are used:

Data duplication (COUNTIF function), delete duplicates.

Missing data IF and/or nested functions, etc.

Data sampling left and right, connection (text 1, text 2 ...), VLOOKUP.

The data calculates the average, sum, maximum, minimum and date, if.

VLOOKUP data grouping function, using approximate matching and search function.

RAND function of data sampling, RAND ()

The above are just some simple explanations, and specific problems need to be analyzed according to needs.