Course Template Excel Usage Tips How to prepare the course table template Excel?
1. The elements required for the curriculum are "title, date, course preface, curriculum".
2. The title refers to the introduction content of the introduction of the category such as "XX School XX Class" and "Study".
3. The date is Zhou X, and it can be reflected on the table in the afternoon.
4. The sequence can be divided into two types: the order of the next afternoon and the one -day order. In the afternoon, the order of the morning class will be re -counting in the afternoon. One day refers to the use of a course in the day.
Course Template Excel General Skills
Tips 1
Hook/cross in Excel
First select the cells to be hooked or cross, and select the font in the start tab as WingDings 2
Then enter R in this cell is hooking, S is a cross.
Automatic extraction of birthday
You only need to enter = Text (MID (H6,7,8), "0000-00-00") in the birthday cell. *Among them, H6 is the cell number of the ID number
Xiaobian recommended by Huajun Software Park Course Template ExcelFor free Excel templates, download it if you need it! Huajun Software Park provides a boutique Excel template download.Production order tracking table,Safe person monitoring management tableDownload you can get the source file for you to edit and modify and replace it. Download the course table template Excel to the Huajun Software Park.
it works
it works
it works