(1) formula.

Used for data calculation, you can use hundreds of functions provided by Excel to process data flexibly.

(2) Pivottable.

Powerful data analysis tool, very efficient.

(3) making charts.

Use tools to display data graphically and display results intuitively.

Generally, the above content is enough to develop general applications. If you study all day, it only takes about 1 week to get started with the above contents.

In addition, you can learn as needed:

(1) macro.

By recording macros, you can write simple programs efficiently.

(2) form.

Establish a window operation interface corresponding to the macro.

(3)VBA .

Realize the flexible control of data. Develop powerful and computationally efficient independent applications.