Ngati mukufuna kuti Excel iwonetsere zolemba zomwe zimakwaniritsa zofunikira zina, gwiritsani ntchito fyuluta. Za ichi:
- Dinani pa selo iliyonse mu dataset.
- Pa Advanced tabu Deta (Deta) dinani fyuluta (Sefa). Mivi imawonekera pamitu yazazambiri.
- Dinani muvi womwe uli pafupi ndi mutu Country.
- Dinani pamzere Sankhani zonse (Sankhani Zonse) kuti muchotse mabokosi onse, kenako chongani bokosilo USA.
- Press OK.Zotsatira: Excel imangowonetsa deta yaku US yogulitsa.
- Dinani muvi womwe uli pafupi ndi mutu kotala.
- Dinani pamzere Sankhani zonse (Sankhani Zonse) kuti muchotse mabokosi onse, kenako chongani bokosilo qt 4.
- Press OK.Zotsatira: Excel imangowonetsa deta yogulitsa ku US kotala lachinayi.
- Kuletsa kusefa, pa tabu Deta (Deta) dinani woyera (zomveka). Kuti muchotse fyuluta kwathunthu, mwachitsanzo, chotsani miviyo, dinani batani kachiwiri fyuluta (Sefa).