Get the App
SLTechnology News&Howtos  ›  IT Information  › 

Teach you to make a project status table with Excel

Shulou Source: shulou.com Published: 2023-11-24 18:35:23 11月18日 Update

Today, Mr. Wang teaches you to use Excel icons and digital format to create a beautiful project status table.

The result shows that there are multiple links in the table. Every time we finish a link, we can type "1" in the cell, and it will automatically become a "√" hook. When there is no "√", the completion progress displays "not started" and a red cross icon. When all is complete, the completed and green hook icons are displayed. If you are only completing individual steps, the "in Progress" and yellow exclamation mark icons will be displayed.

Make table ① select all link cells, "right"-"format cells"-"Custom" enter in the type:

[= 1] "√"; at this point, as long as we type "1" into these cells, we will immediately become a "√" hook.

② enters the formula in the "H" column data area:

= COUNTIF (B2:G2, "1") will automatically count the number of hooks.

③ select the "H" column data area, "right"-"format cells"-"Custom", and enter:

[

Tags: Icon unit input format link type area data effect number style table selection status project production beauty number author public Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Redmi MySQL Apple Xiaomi MariaDB