How does WeChat report its performance every day?

How to report daily performance quickly? If you have to re-enter the date every time and manually sort out the calculation data, it will not only take too much time, but also be easy to make mistakes. Today, Miss Miao wants to share with you a fully automatic Excel performance report, freeing your hands and eyes. Come and have a look!

Xiao Hu: "Teacher Miao, can you teach me how to report data on WeChat? Today, I was criticized by the leader again, saying that I was slow in reporting and always made mistakes. But with so much data, I still have to read, find and calculate, which is so fast. And I have to do it every day, and I am tired of it. "

Teacher Miao: "Xiao Hu, speak slowly. You said so much when you came in that I was confused. Please show me the report of your sales department first. "

Xiao Hu: "That's it. On May 3, 2020, the time schedule of that day was 33.9%, the income of that day was 337,000 yuan, and the accumulated income of the whole year was 3.707 million yuan, which was 7,465,438+0% of the annual target of 5 million yuan. More than 40.3% of the time schedule. " The following is the income and ranking of each store, as shown in figure 1.

Figure 1

Teacher Miao: "Actually, this briefing is very simple. I think there are several important issues, one is the completion rate of indicators, the other is the comparison of time and progress, and the other is the ranking in the store. "

Xiao Hu: "There is an appointment. I wrote the date wrong several times. "

Teacher Miao: "Let me look at your value table again."

Xiao Hu: "Let me show you." As shown in figure 2.

Figure 2

Teacher Miao: "Now I will help you solve the problems one by one. Let's talk about form first. As for the date in the table, you can use TODAY () to get the date of today directly. If you report yesterday's data, you can use TODAY()- 1, and the data will change every day with the date. " We put the date in a fixed position, such as cell A2, as shown in Figure 3.

Figure 3

Miss Miao: Then we can make a title with a date for this report, using the connector &; You can associate the text with the date. We put the table and title in B 1, and then enter:

= A2& Sales announcement of each store "

Because the "sales bulletin of each store" is written, it is necessary to put double quotation marks in English on both sides.

Xiao Hu: "Miss Miao, isn't it? How come a string of numbers comes out after input? " As shown in figure 4.

Figure 4

Teacher Miao: "Don't worry, it is because the date and text are linked together and become a text format, so the date format is gone. We can use the text function here to adjust its format. "

The formula is adjusted to =TEXT(A2, "yyyymm DD YY")&; "Sales announcement of each store"

The second parameter of TEXT represents the format to be displayed, and y, m and d represent the year, month and day respectively. After setting, the title is generated according to our requirements, as shown in Figure 5.

Figure 5

Students who are not familiar with text function can read the previous article "5 minutes, learning the king of text function-common routines of text".

The title section is ready. Let's look at the data in the income section. Although the value of the income part is relatively simple, you need to understand a concept first: when we make tables, it is best to have a foreground table and a background table. The foreground table is mainly used to put our notifications, and the background table is used to put data, and then they are related by functions.