The main content of the itinerary registration form during the epidemic period: date, name, contact information, ID number, visit matters, departure place, whether it is a high-risk area, remarks and other related information. Huajun Software Park provides downloads of high-quality Excel templates, including the itinerary registration form excel template during the epidemic. You can download the source file for you to edit, modify, and replace. The itinerary registration form template during the epidemic can be found at Huajun Software Park.
General tips for travel registration forms during the epidemic
ETick/cross in xcel
First, select the cells you want to check or cross, and select the font Wingdings 2 in the Home tab.
Then enter R in the cell to make a check, and S to make a cross.
Automatically extract birthday
You only need to enter =TEXT(MID(H6,7,8),"0000-00-00") in the birthday cell and press Enter. *H6 is the cell where the ID number is located
Quickly sum and average
If you want to directly know the sum or average of certain numbers, just select those numbers to find out. After selection, summation, average, and count will be displayed in the bottom status bar.
Format brush
The use of Format Painter is very simple. Just click on Format Painter, then select the format you want to copy, and finally select the cells you want to modify. You can modify it in batches.
Recommended by the editor of Huajun Software Park
The nucleic acid testing registration form is a free Excel template, download it if you need it! Huajun Software Park provides high-quality Excel template downloads.14-day thermometer,Itinerary registration form during the epidemicDownload to get the source file, which you can edit, modify and replace. Download the nucleic acid testing registration form and go to the Huajun Software Park.
it works
it works
it works