2. Advanced articles: Excel application encyclopedia is produced by ExcelHome technical expert team. Excel application encyclopedia is roughly divided into seven parts. This paper introduces the technical characteristics and application methods of Excel, profoundly reveals the principles and concepts behind it, and cooperates with a large number of typical and practical application examples to help readers master the application technology of Excel comprehensively.
The contents include: basic functions of Excel, using formulas and functions, creating charts and graphs, data analysis of Excel, advanced functions of Excel, collaboration with Excel, and automation of Excel. The appendix also provides descriptions of Excel shortcuts, worksheet functions, VBA functions, specifications and restrictions.
For example:
1. First, enter three groups of characters or data in cell A1/b1of the excel table, and the three groups of data need to be merged into one cell.
2. Enter the "=" symbol in cell D 1.
3. Then enter the complete formula: = a1&; b 1 & amp； C 1 means "&"combination of three groups of data.
4. Click the "Enter" button to generate the calculation result according to the previously entered formula. You can see that three sets of data are merged in cell D 1.