1. Five one-dollar bills. Excel data analysis method 1. Quick filling: select cell B2, enter steamed bread, and press CTRL+E...22. Column: select A2:A20 data area, data tab and column. Next, choose a comma as the separator, and then choose $2$2 as the target area. 3. Grouping comparison method: After grouping, we can summarize and calculate the data. The common method is to summarize similar data into one data through summation, average, percentage and technology to reduce the amount of data. 4. PivotTable report: Click the PivotTable report in the Insert tab to open the dialog box, confirm your selection, and then click OK. Then, you can see the PivotTable view in the new worksheet. Just drag the table fields into rows, columns and values, and you can get the corresponding data statistics table. 5.VBA custom function: Alt+F 1 1 Open the VBE editor, insert the module, and enter the following custom function. Excel is mainly used for statistical analysis of data, which has a low threshold and can be easily converted into reports, and is located in small-scale data processing. Access is mainly used for data storage, and the threshold is high. It can establish a database management system, which can search and activate data conveniently and quickly, and is located in large-scale data processing.