itineraryThings to note:
Itinerary
An itinerary is the framework of a road book, which includes the travel time period and important places along the way. When connected in series, it forms a route.
Traffic information
After the route is designed, the road book also needs to provide information such as the means of transportation used between the locations, the estimated duration, etc.
Accommodation information
Normally, individuals or companies communicate with customers in advance about their accommodation requirements and budget, and then choose a suitable accommodation location based on this information.
If you want to directly know the sum or average of certain numbers, just select those numbers to find out. After selection, the sum, average, and count will be displayed in the bottom status bar.
2: 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.
3: Conditional summation
Use the SUMIF function to calculate the total score of a class:
=SUMIF(D2:D5,F2,C2:C5)
4: SUMIF usage is:
=SUMIF(condition area, specified summation condition, summation area)
In layman’s terms, it can be described as:
If the class in the D2:D5 area is equal to the "first class" of the F2 cell, then sum the area corresponding to the C2:C5 cell.
Recommended by the editor of Huajun Software Park
Travel itineraryIt is a very practical form, and most of the forms you fill in are for general purposes. If you happen to need to download the travel itinerary, please download it quickly. also,List of retirees,List of Accounting AccountsIt is also a good software. Welcome to click to download and experience it!
it works
it works
it works