In your daily life, you may use Excel to record a large amount of information. As the information accumulates and the original table is expanded, you will find that placing some information completely in a table obviously cannot meet your requirements, so you Start building a second table (or even more tables) to assist in recording information that the first table cannot accommodate. This situation will put you in a dilemma when performing statistical analysis at the end of the month. Specifically, it is to extract from table A. Some fields then extract some information from Table B and combine it for analysis or printing. For example, Table A records the employee's salary information, and Table B records the employee's mobility information (employee insurance, rewards and penalties) that vary by month. , mainly based on Table A. Every time a person is counted from Table A, he has to go to Table B to find additional information about the corresponding person. If the records reach 300 or more, then manual statistics and search will greatly increase the operation. Error rate, the spreadsheet merge tool was developed under this demand environment. In the operation, you set one table as the main table, another table as the appendix, and set a field that both tables have (such as name or work title). No.), follow the operation prompts, the speed and quality of the generated results will amaze you.!
- Green versionCheck
- Green versionCheck
- Green versionCheck
- Green versionCheck
- Green versionCheck
it works
it works
it works