Member ① Array function
When I first saw the array function, I was astonished [it is also possible that I have never seen the world, secretly amazed at everything], probably because it can complete many complex calculations in a small function, omitting it. There are a lot of intermediate processes, so it probably took a little time to play this function, but I didn't play the kind that I am very familiar with.


It is probably because I have seen a lot of wind and waves, especially after seeing the powerful sumproduct function [I have used it more recently when calculating the rate of return or even calculating the rate of return based on conditions], I seem to think that this function is nothing special.
In addition, a method of directly writing an array in a function has been unlocked recently [this is a very strange way of writing, which is probably the same as using sum+if combination and count+if in mysql, which belongs to your own inspirational writing method]: =IF(SUM(IFERROR(FIND({"restaurant","convenience store","A","B","C","Zhang San","Li Si"},A1,1),0)) >0,"to be reviewed","")
member ② function
When I went to CQ for an interview, Wayne used English to test if I could vlookup. Of course I wouldn't.
Later, he asked me to draw a quadratic function, and I didn't understand why he told me to go to work in the end.
In CQ, the template for Excel to generate SQL is fixed. After we update the value, the subsequent results will change. Those functions that are so complicated that the scalp is tingling: concat, replace, rept

In the beginning, the function that needed to be implemented with the function was to be accurate to the next few decimal places. At that time, I knew that there was a round that could replace myself to delete one by one, and even unlocked roundup and rounddown later.

The vlookup that cannot be avoided every time and the countif, countifs, sumif, sumifs, average, averageif, averageifs that need to be used later.

The Internet is a good thing, especially Baidu. Every time you ask Du Niang a question you don’t know, it will unlock a bunch of things.

Finding reference classes also unlocks a lot:

index [When the price of futures was updated every month before, I seemed to be Baidu this function to achieve the purpose of being lazy]

offset [Well, this is basically needed in the template, because it will change dynamically]

match [Actually, I don't really use this much, and I have to check the information every time I use it]

Other functions:

rank [a must for ranking, it is not used too much]

datediff [this is a very special existence (in earlier versions of excel, the intelligent prompts did not have this, you have to lose all the functions yourself), I feel it is the same as the functions in mysql]

Financial functions, when I did the insurance calculation model before, it involved the calculation of interest rates and income. I used this function, but I didn't understand it thoroughly. It is probably a state of shallow taste.

VBA

This is probably a big mountain that I have never been able to climb. I have bought several VBA books, but I have never been able to get in. After unlocking the automation of python later, I found that learning these things still has to solve practical problems with purpose. The purpose of learning is to solve problems. If the problem cannot be solved, there is not much difference between learning and not learning.

Fragments at the end of the article:

When you use something all the time, your thinking will be limited. For the time being, I can switch freely between python, mysql and excel. Compared with the previous ones, I feel that the limitations are a little less. It's just a little bit more comfortable, because the purpose is to solve problems and solve problems better, so this is probably the only way~!