1. Excel maximum functions: Data Processing and statistical analysis.
2. Data Validity Verification:
Long numeric input method. The text is preceded by an English "'" (single quotation marks) or converted using text.
ID number: data, data validity, and text length.
Gender: data, data validity, sequence, and multi-data content are separated by commas.
3. Gantt chart table (Construction Period chart): insert, bar chart, two-dimensional bar chart, stacked Chart bar chart, set the data series format, fill or background to none.
:
4. Combined charts: insert, column chart, two-dimensional column chart, change chart type, set data series format, and subcoordinate chart.
:
5. formula: The formula must start with an equal sign, followed by a function.
6. The cell address is definitely referenced. Use the $ symbol (shortcut key shift + 4 or F4)
Excel supports creating Gantt charts