The essence of accounting is a set of procedures and systems for collecting, processing and reflecting information,
The information in this world is nothing more than numbers, words, pictures, videos and so on. The meaning of words is vague, and different people have different understandings; The meaning of pictures and videos is rich, and different people have different feelings; But the numbers are not ambiguous. One is one and two is two.
As financial personnel, they deal with data every day and pay attention to cross check relations and data differences all the time. But tigers also nap. Who can guarantee that they don’t make mistakes? Fortunately, computer technology is advanced and excel is available to help finance.
Excel is important because finance itself is dealing with huge data every day, and excel is a super calculator, which can help financial personnel accurately and quickly process data in batches.
The above figure shows the grading of Excel. To be honest, I should be an advanced user, but I don’t need to write VBA, but I use Python instead, because compared with VBA, python can help me reach the stage of developing independent programs.
However, I will not talk about Python for the time being to avoid thinking that I am selling advertisements. Here I will talk about the basis of excel – functions.
Functions in Excel can be divided into text functions, information functions, logic functions, search and reference functions, statistical functions, trigonometric functions, financial functions, engineering functions, cube functions, compatibility functions and web functions
Of course, we don’t need to master the usage of all functions. Usually, we only need to master seven functions, such as SUMIF, countif, if, and, left, right, vlookup, and so on.
The usage of these functions is summarized as follows:
If you are still excel Xiaobai (who can only add, subtract, multiply and divide, copy and paste), you can basically master these functions and become a primary user. I won’t say any examples of functions. There are many on the Internet.
This work adoptsCC agreement, reprint must indicate the author and the link to this article