6 ara ki te hanga tūkinotia ko pirau Kōnae Excel

Ka rite ki te geek rorohiko (koe pea e tetahi, ki te e pānui koe i tenei), kia tino pai mohio koutou e kore koutou raraunga ko te rau ōrau haumaru noa i runga i kōpae mārō rohe o tō rorohiko whaiaro mai ahu maha kōnae ki te kia kino e tika ana ki te maha o ngā take .

• Wāhanga 1: tūkinotia / pirau Excel kōnae Putanga
• Wāhanga 2: Me pēhea te ki te hanga tūkinotia / pirau Kōnae Excel
• Part 3. 5 Ngaahi Founga ki Tapia Kōnae Excel

Wāhanga 1: tūkinotia / pirau Excel kōnae Putanga

Kōnae Excel mahi rite te-pātengi raraunga mini mō te pupuri nui ā-e pā ana me te iti o te raraunga. Heoi, raraunga rongoa i roto i te whārangi Excel he nui o tairongo, me te tika ki ngā mahi i runga i-aho e pea atu ki te tiki kino enei kōnae. Heoi, i reira e rawa tokomaha atu take. Kua riro i tetahi te taputapu kōnae hanga Excel i te fokotu'una i roto i te tikanga ki te whakamahi i te reira, no te titau ia ki te hanga kino kaka kōnae . He mea nui mai i tetahi kia whai raraunga super nui rongoa i roto i taua kōnae. Tapia kōnae pakaru, kua meinga nei te tukanga super ngāwari mai i reira e maha hira taputapu kōnae hanga e wātea ana ki te mahi i te kōnae mahi me te hanga pakaru.

Various tikanga o ora raraunga i ngā kōnae kino e kia kōrero i muri. I mua, i konei te tahi mau tumu e meinga kino ki te kōnae Excel:

1. rahunga pūnaha ohorere: kore Pūnaha whakaweto pokanoa ranei he maha take i muri i te reira. E nehenehe te reira i te pirau i roto i matapihi whare pukapuka, pānga o te pūmanawa ranei huaketo ranei te tapahia te mana ohie. Ki te tupu tetahi o enei i roto i te mahi i runga i te kōnae Excel, he reira nui pea ki te tiki kino, a ka rapua e koe i te taputapu kōnae hanga Excel i roto i te tikanga ki te hanga kino kaka kōnae.

2. Virus Attack: Viruses e kino hira āta e tino nohinohi kōnae. Heoi, i reira e maha wheori e kua auraa ki ngā kōnae kino, me te hanga e ratou kahore rerekē i waenganui i ngā momo o ngā kōnae kia e taea e ratou te kino i te kōnae Excel rite te pai.

3. pūrere rokiroki kua tūkinotia: rokiroki Media ko te wāhanga tinana o te pūnaha rorohiko. Kei te waiho i raro te reira ki ati tūturu. E pāngia e puehu, marama, wiri, te whakamahi, etc mo te wā ēnei wāhanga. He pea ki te kia pakaru me te kia huaketo ngā wāhi mahara nui ratou. Ki te oho te kōnae i roto i taua pūrere, kua reira mōrea o te pae kino.

4. Waiho ana tono kore tiaki: kia tangi te reira tipua ki te tangata e mahi wā i runga i MS Excel. Matauranga Common Ko e koutou mahi mate whakamutunga i e whakaora, ki te kore koutou e whakaora i te kōnae i mua i te putanga atu i te matapihi. Heoi, i reira te mea ano hoki he mōrearea iti o te ngaro raraunga mua, me te whiwhi i tētahi kōnae pai kua kino na kia wa i muri tupato.

5. Kōnae pupuri rau maha: ko reira noa ki te whai atu i te 10 mea 20 ngā rau i roto i te kotahi hira kōnae ina tae mai te reira ki te whakamahi mōhiohio i roto i te tauhokohoko ranei. E tino ēnei pepa e pā ana ki ia atu. A, no te utaina ki runga ki mahara matua o te pūnaha enei kōnae ngā mōrea o te ngaro raraunga, me te whiwhi kino mai te mea i reira he nui nui o te kawenga mahara ki te hapai i mo te pūnaha.

Wāhanga 2: Me pēhea te ki te hanga tūkinotia / pirau Kōnae Excel

Na kia neke tatou te kōrero ki te whakatika i te kōnae Excel papaka, me te kino. Tenei e pai 6 ara o te raveraa i taua mahi.

Tapia 1. Stellar phoenix Excel

Tenei Ko tetahi o nga taputapu pai e wātea ana i roto i reira i roto i te tikanga ki te hanga kino kaka kōnae. Tenei taputapu kōnae hanga Excel Ko te ahei nui ki te hanga papaka kōnae whakawhetai ki te ähuatanga ahurei, me ngā whakaritenga. Tenei ko ētahi āhuatanga matua:

2. Tapia tūkinotia ko pirau Kōnae Excel

Hipanga 1 Hei tāpiri kōnae Excel i te röpü maui pāwhiri tāpiri kōnae icon me ngā kōnae kawemai.

Hipanga 2 Ka taea te tāpiri kōnae mā te rapu whaiaronga, ngā kōnae tauwāhi ranei kōpaki matawai.

Hipanga 3 taea e koe te tirohia i te ngaro o ngā kōnae rapu, seclect kotahi kōnae kino mo te hanga, me te pāwhiri te pātene Sacn ki te tīmata whakatika tukanga.

Hipanga 4 Arokite nga kōnae Excel e hanga ana, ka whiriwhiri ki te whakaora.

Hipanga 5 Tīpakohia wāhi, pāwhiri ok.

Part 3. 5 Ngaahi Founga ki Tapia Kōnae Excel

He hoki etahi tikanga e kore e e rapua e tetahi hira kōnae taputapu hanga i roto i te tikanga ki te hanga kōnae Excel kino . E whakarārangitia ēnei i raro:

1. Tapi ā kōnae

Hipanga 1 Open MS Excel. Kia kite ai koe i inaianei te pepa pātea.

Hipanga 2 Open tahua kōnae, me te pāwhiri i tuwhera ranei tika pēhi Ctrl + e.

Hipanga 3 Na kitea te kōnae e hiahiatia ana, me te tīpako tuwhera, me te hanga i te pātene tuwhera maturuturu iho tahua.

Hipanga 4 Ki te tonu e kore e whakatuwheratia, pāwhiri i runga i raraunga wāhanga, me te pāwhiri ae.

2. Opening hira kōnae ki HTML

Hipanga 1 tenei tikanga anake mahi ki te taea e koe te whakatuwhera kino kaka kōnae. Whakatūwhera reira ka pāwhiri i rite anake.

Hipanga 2 Tīpakohia te tauwāhi rerekē i kōnae taketake, me te whakaora i te reira rite te whārangi tukutuku. Hanga tīpakohia tino ripanga tonu te.

Hipanga 3 Na whakatuwhera i te kōnae ora ki a MS Excel, me te whakaora i te reira i ano i roto i te hōputu Excel.

Hipanga 4 Kia haere ka whakangaromanga, ki te he koe waimarie nui.

3. raraunga Moving / tārua wāhi kē:

Hipanga 1 Me whiwhi tēnei aratuka hoki koe ki te whakatuwhera i te kōnae kino. Mahi i te reira.

Hipanga 2 Matau pāwhiri i runga i tetahi ripa pepa, me te pāwhiri tīpako rau katoa.

Hipanga 3 Matau pāwhiri i runga i te ripa pepa ano, ka pāwhiri i runga i te nekehanga kape ranei.

Hipanga 4 Kōwhiri pukapuka hou, me te mahara ano ki te tohu hanga te kōwhiringa tārua whakamutunga i runga i te nekehanga pouaka kape ranei.

Hipanga 5 Hit ok me e mahi koe.

tikanga 4. XML

Hipanga 1 Whakatūwhera te kōnae kino ki te taea e koe, ka pāwhiri i rite anake.

Hipanga 2 I mua whakaora tīpako te XML hōputu i te rārangi e wātea ana.

Hipanga 3 Whakatūwhera te kōnae ano, ka pāwhiri i rite anake.

Hipanga 4 Huri te ingoa kōnae, me te whakaora i te reira i ano i roto i te hōputu taketake.

5. E ngana ana etahi waimarie

Hipanga 1 Katia MS Excel. Re-whakatuwhera i te kōnae, me te kite, ki te he tonu te kupu kino i reira.

Hipanga 2 He? Tīmata anō i te pūnaha katoa, me te ngana te whakatuwhera anō i te kōnae.

Hipanga 3 Tonu kahore waimarie? Haere ki te c: \ matapihi \ rangitahi, me te muku katoa. Whakamātauria ki te whakatuwhera anō i te kōnae.

Hipanga 4 Whakamātauria whakatuwhera i te kōnae mā te whakamahi i tuwhera tari. Ko hototahi ki ngā tuhinga katoa Microsoft me mahi tino pai a tawhio noa mau haaviiviiraa tēnei hōtaka.

I roto i te mutunga, kei te tumanako te reira e mahi tenei tuhinga koutou te mea i rapu koutou mo. Inaianei e matau ana koe me pehea e taea e koe te hanga papaka kōnae me te whakamahi hira kōnae taputapu hanga ki te hanga Excel kōnae kino. He rawa e rave rahi atu mau rave'a. Heoi, ko te tikanga tuatahi o te whakamahi i te pūmanawa aunoa ko pai i roto i o te katoa mō ngā iwi e kore e tino hāneanea he geek hangarau nei.