The Excel High Level Applies

1   High-grade artifice of data handling

1.1 Data perspective Form

1.2 Data Validity

1.3 Data Sift

1.4 Condition Form

1.5 Data be divided into group

1.6 Data function Column

2   Function and Formula

2.1 Subtotal

2.2 Offset

2.3 Sumifand if

2.4 Dsum

2.5 Vlookup

2.6 Date

2.7 Classify

2.8 Much condition sues for peace with mark number

3   Diagram handling

3.1 Constitute Diagrams

3.2 Compound cake picture

3.3 Development Diagrams

3.4 Diagram trend line

4   Merge VBA and Mail

4.1 WORD and Mail merger

4.2 Add-in and Regression analysis

5   Chinese English automatic switching

6   Lock-in element lattice