He aha te mea te mahi i roto i te "Excel"?

I roto i te tikanga ki te tika whakahoki i te pātai e pā ana ki te mea he mahi pai ki "Excel", e hiahia ana koe ki te matau he aha tenei hōtaka.

Tenei tono tari tohunga ana i roto i te mahi ki ripakaute me ngā uara tau.

āhuatanga matua:

1. tātaitanga Economic.
2. tātaitanga Statistical.
3. Vanuatu,.
4. tātaitanga Aunoatanga (kaute, engineering).
5. Handling nui o ngā raraunga.
6. Backfill rarangi o ngā pūtau tīwae.
7. Ko te otinga o ngā whārite.
8. Analysis o nga hua whiwhi.
9. Mā te whakamahi i te reo hōtaka ki te whakatinana i etahi o nga āhuatanga o te momo kore-paerewa.
10. Ko te whakamahi o mahi cartographic.
11. Parenga whiriwhiri e te kaiwhakamahi i whakamahi kāore i.

Mahi i roto i "Excel" Ko tā te tatūkē e whai ake nei:

• te whakaurunga o nga paeutauta matua, e ngā "Standard" me "Hōputu";
• mahere i te pātene taketake ia rōpū mā te neke i te awhi;
• te waea ki te whakaatu "tahua katoa."

Pukamahi me tona hanganga

Roha o nga tuhinga e patua ana mahi i roto i "Excel", whai momo .xls. huaina ia tuhinga taunoa hou hanga te "Ko e Tohi." Kei te hanga tonu te taunoa e toru ngā rau i roto i te pukamahi.

Ia whārangi hou ko te tepu, arā, o 256 tīwae me 65536 rarangi. Ia pae o te tuhinga he "ingoa" i roto i te puka o pukapuka o te tātai reta Latin. Aho - tau Arabic. Nä, ko te wāhitau pūtau (pūtau) i te pūtahitanga o te rārangi me te tīwae arā, o ngā reta me ngā nama.

Ko te mahi o tetahi pūtau kotahi, heka pasikala pūtau awhe ranei kitea i roto i te whakahuahua pouri.

ngā mahi e wātea ana i runga i te whārangi pepa ranei:

1. Whakawhitinga. Pāwhiritia te pātene kiore mahue ranei huinga o pātene Ctrl + PageUp, a Ctrl + PageDown.
2. Hurihia te wāhi o matua - te pātene kiore maui (tō me te taka).
3. Tāruatia - matua Ctrl me te tō.
4. Wehe o te whārangi neke atu i te kotahi i roto i te raupapa rerekē. pātene Ctrl (e aki), ka mahue pāwhiri i te kiore.
5. Wehe o te whānuitanga o te pepa hanga. tahuri pātene Shift (e aki), me te pāwhiri maui i runga i nga whārangi tuatahi, me te whakamutunga.

Mahi i roto i "Excel" tuku te whakahau tahua horopaki e whai ake nei:

1. "Tāpiri." puta te reira i tātauira tua, whakairoiro, a pera te pepa hou. P.
2. "Mukua". Tangohanga o ngā pūtau, haupae, tīwae, aru e te neke raraunga.
3. "Whakaingoa". Te huri i te ingoa o te tuhinga pepa me te m. P.
4. "Hanga te tatau / tere". Homai te kape pai rawa ranei neke te whārangi i roto i te tuhinga motuhake, me te neke raraunga ki te pepa motuhake. I tua atu i hoatu he ingoa ki te rau hou.
5. "Tīpakohia Rau Katoa".
6. "Tapanga Tae".

Kei te mahi hoki te reira ki "Excel" tā te huri i te haupae tīwae ranei rahi. Ki te mahi i tenei, tuu i te pehu i runga i te wehenga i waenganui i nga rarangi / tīwae kia puta ke ai āhua. I pupuri i te pātene kiore maui, me te neke ka kia ngohengohe ki te huri i te whakarahi anō ngā rahi pehu. A, no te kōwhiri i te whānui o ngā rarangi / tīwae me whakarahi anō atu tetahi wāhanga rahi ka puta ke aunoa.

Ko tētahi atu mahi i roto i te hōtaka "Excel" titau whakahōputu pūtau mahi. Meinga he matapihi hōputu taea e koe te whakamahi i te tahua horopaki. Wātea mō te whakatika: te hōputu tau, te tiaki pūtau / tuhinga momo (rahi, tae), momotuhi, hāngaitanga o te ihirangi, momo o rohe pūtau.

Kia tumanako a e mārama inaianei katoa e kua kite i tenei tuhinga, e te mahi i roto i te "Excel" titau tata katoa o to tatou wa.