Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Teach you to make Excel dynamic attendance sheet in a simple way.

2025-04-06 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > IT Information >

Share

Shulou(Shulou.com)11/24 Report--

The title of the original text: "making a dynamic attendance schedule, this may be the easiest way!" (practical) "

Hello, everyone. I'm "beating worker" for half a month.

The little friend sitting next to me the day before yesterday was doing the attendance statistics of the company. When I saw that table, I could not help but marvel at "good guy"!

Do you want to clock in thousands of lines and make everyone's attendance statistics according to the date?

I looked at it a little and felt that my eyes were dazzling.

As a veteran artist who "used to" prefer copying and pasting.

I calculated that if this attendance table is to be arranged for me to do, it is estimated that there will be an increase in the class this year!

Fortunately, now I have learned an efficient little skill-you can easily make attendance statistics by clicking on a PivotTable.

As an obscure and helpful citizen:

Today, I decided to "impart" this little trick to you, so that when you have to do attendance statistics,

Take the road of no return of copy and paste.

❶ select the table, select "insert" in the menu bar, then click "Table", select "PivotTable", and click "OK".

❷ drags the name directly to the row area, then the date to the column area, and the time to the value area.

Click [count item: sign-in time], and select "value Field Settings".

Next, it will pop up a window ~ in this window, select [minimum] in the calculation Type and rename it to "go to work".

Then click "number format", and then select "time" format in "Classification".

❸ drags the time to the value again, similar to the ❷ setting. Select the maximum value in the calculation Type and rename it to "off work".

(do you feel excited when you see the word "off work"?)

❹, click "Design", and in "layout", click "Total"-"disable rows and columns".

After doing this, an attendance statistics table is presented in front of us!

Does it feel good to use after reading it? The key is to save time and effort than copy and paste!

Come on, everybody, learn to play!

This article comes from the official account of Wechat: Akiba Excel (ID:excel100), author: half month, editor: Yali Zi, Zhu Lan

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

IT Information

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report