Basic usage of Excel functions

Time:2022-1-14

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.

Basic usage of Excel functions

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:

Basic usage of Excel functions

Basic usage of Excel functions

Basic usage of Excel functions

Basic usage of Excel functions

Basic usage of Excel functions

Basic usage of Excel functions

Basic usage of Excel functions

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

Recommended Today

Network counting experiment I Division VLAN

Experiment 1  vlanCreation and division of 1、 Experiment purpose: 1. Understand the working principle of VLAN; 2. Learn the method of dividing VLANs based on ports; 3. Understand the communication between the same VLANs across switches; 4. Further learn the configuration commands of switch ports. 2、 Experimental principle: VLAN (virtual local area network), that is, […]