Single template tablePreparation:
Basic information
Factory logo
Company Name (Company)
Detailed Address
Post code
Contact name
Job Title
Phone number (Telephone No.)
Fax number (FAX No.)
Mobile number (Mobile No.)
1: Multi -conditioning summary
The total subsidy of the statistical department for production and position is mainly based on posts.
The formula is:
= Sumifs (D2: D9, B2: B9, F2, C2: C9, G2)
2: Condition count
Statistically count the number of business pens of specified stores. That is, how many designated shop names are there in column B.
= Countif (B2: B12, E3)
3. Change the number format
Excel's shortcut key is not messy, but follows a certain logic.
For example, if you want to quickly change the format of the number, such as you can immediately add the number to the US dollar symbol, because the symbol $ and the number 4 share the same key.
In the same way, "Ctrl+Shift+5" can quickly change the number of numbers to percentage (%).
The quotation single -board table is a very practical table, and most of the forms are used in common purposes. If you just need to quote the single template table Excel table download, come and download it.The annual assessment form is described by myself,Annual assessment form summaryIt is also a good software, please click to download the experience!
it works
it works
it works