Me pēhea te ki te Tapia Excel Kōnae Hapa pānui

Kei te whānui Microsoft Excel i titiro rite te pūmanawa ripanga pai i roto i te ao. He he taunakitanga rahi e tuara ake tenei mana'o rite te pai. Kei te whakamahia Excel hoki e rua take whaiaro, me te arumoni. Ko te āhuatanga pai e tuku reira hanga reira he taputapu pai hoki whakahaere raraunga, me te whawhe. Mai i hoko pūrongo ki te pūtea moni ki te tahua, e whakamahia MS Excel mo te hanganga o te maha o ngā tuhinga nui mō pakihi iti. Ko te kupu, ina mahia he kōnae Excel he hapa, me te e kore e whakatuwhera rite te mahara reira ki, riro te reira i te take o te āwangawanga. Ko te whakaatu o te Excel kōnae hapa pānui ko te take i roto i te wāhi.

• Part 1: He aha te mea te Excel Kōnae Hapa pānui?
• Wāhanga 2: Tapia Kōnae pirau Excel ki Pūmanawa Tapia Excel
• Part 3: Ata hoki Excel Kōnae Hapa pānui

Part 1: He aha te mea te Excel Kōnae Hapa pānui?

Ko te Hapa pānui Kōnae Excel ko te hapa noa e kārewa ka te whakatuwheratia te kōnae Excel e te kaiwhakamahi. rite tenei te karere hapa e puta i runga i te mata titiro:

"Kitea Excel ihirangi tē i roto i '[kōnae] .xls'. E hiahia ana koe ki te ora i te tirotiro o tenei pukamahi? Ki te whakawhirinaki koe te pūtake o tenei pukamahi, pāwhiritia, ae!"

Viewing he hapa taua taea tangi pere whakaoho i roto i te feruriraa o te kaiwhakamahi. Issuance o tenei karere hapa tohu e kua whakawhanakehia te kōnae etahi ahua o te take, me etahi o ona ihirangi hei kua pānui mo te pūmanawa. I roto i te karere hapa, tuku Excel koe ki te whakahoki mai i nga raraunga o te kōnae rawa, ki te whakaaro koe e te puna o te kōnae he pono. ui te reira koe ki te pēhi ae, ki te meatia e koe whakawhirinaki i te pūtake o te kōnae. Ki te mahi koe i pēhi ae, Excel e titiro ki te ora i te ihirangi o te kōnae, e ai hua i roto i te ora tonu o te raraunga ngaro ranei o te katoa o nga raraunga i roto i roto i te kōnae.

Etahi o nga take taea e taea meinga te Excel Kōnae Hapa pānui ngā:

• Pirau o ētahi wāhanga o te kōnae Excel.
• Pirau o te katoa hira kōnae.

Wāhanga 2: Tapia Kōnae pirau Excel ki Pūmanawa Tapia Excel

Ka taea e koe te hanga kino kōnae Excel i hanga whakamahi o te pūmanawa hanga Excel. He taputapu e kua hangaia mō te ora i te raraunga o te kōnae Excel kino, me te whakaora ia ratou ki to ratou ahua taketake enei. He he maha o taua taputapu Excel hanga e wātea ana i runga i te ipurangi, engari te tetahi anake e he whai hua, me te pono i roto ia ratou, ko te Tapia Stellar Phoenix Excel.

Ko te Tapia Stellar Phoenix Excel ko te Excel taputapu hanga pai e taea ki a koe kihai kino anake hanga kōnae Excel engari whakatika ano hoki nga karere hapa e kua meinga e enei kōnae Excel kino. Ko te take i te reira he aha te whakaaro kia pono, me te whai hua, ko te no te mea he maha o ngā āhuatanga mīharo e kore e e hakari i roto i tetahi atu taputapu kōnae Excel hanga.

Hipanga-Na-Hipanga Guide mō te pakaru kino Kōnae Excel

Hipanga 1 Tāpiri Kōnae: Ko te mahi tuatahi, ko te ki te tāpiri i te kōnae ki te taputapu Tapia Excel. Faatupu i tenei mā te whakamahi i te 'Tāpiri Kōnae' kōwhiringa kitea i roto i te 'Kōnae' tahua.

Hipanga 2 Kōnae rapu: Ko te taahiraa tuarua ko ki te rapu i ngā kōnae e kua kino i roto i te pūnaha. Faatupu i tenei mā te whakamahi i tetahi o nga kōwhiringa kōnae rapu toru, '(s) Kōnae Rapu', 'Tīpakohia Kōpaki' ranei 'Tīpakohia Kōnae'.

Hipanga 3 Kōnae Matawai: Ko te taahiraa toru ko ki timata te karapa o te kōnae kino e te. Faatupu i tenei mā te tīpako i te reira, me te pāwhiri i te pātene 'Karapa' kei i te raro o te mata.

Hipanga 4 Kōnae Arokitenga: Ko te tuawha taahiraa ko ki arokite te tirotiro o te kōnae kino. Faatupu i tenei mā te tīpako i te kōnae i te rakau whānau kei i te maui o te mata, me te ka pāwhiri-rua i runga i te reira.

Hipanga 5 Kōnae Tiaki: te rima te taahiraa ko ki te whakaora i te kōnae ka hanga ko. Faatupu i tenei mā te whakamahi i tetahi o te tokorua whakaora kōwhiringa kōnae, 'Tīpakohia Kōpaki New' ranei 'Wāhi Taunoa'.

Part 3: Ata hoki Excel Kōnae Hapa pānui

Ko te whai ake e te tahi mau whakatika mo Excel Kōnae Hapa pānui e taea te whakamahi e koe mo te taumira tere o tenei karere hapa:

Hipanga 1 Converting koutou kōnae '.xls' ki 'te pānui i-anake'. Meinga whakamahi o te whai i ēnei ki te tahuri to koutou pukamahi Excel ki te kōnae 'Pānuitia-anake'.

• Tīpakohia 'whakaora rite' ranei 'whakaora' mō te pukamahi ora mua me te pukamahi hou aua i muri i te pāwhiri i runga i te pātene 'Office'.
• Na, pāwhiritia i runga i te pātene 'Kōwhiringa General' i muri i te pāwhiri i runga i te pātene 'Utauta'.
• Heoi, i roto i te kōrero-pouaka Kōwhiringa General, kia te pukamahi pānui-anake mā te pāwhiri i te haki-pouaka kei roto i mua o te kōwhiringa 'lau-anake'.

Hipanga 2 Tāruatia te tirotiro katoa o te Excel kino kōnae ki te pukamahi pātea, me te hou '.xls'. Na, ngana ki te anō-whakatūwhera mai tēnei kōnae i muri i te tiaki i te reira te tuatahi.

Hipanga 3 Kei te kitea te reira maha nga wa e Kōnae te Excel karere Hapa pānui taea te ngāwari whakatau i na roto i te tāuta i te wāhanga o 'Visual Basic' o MS Office 2010. whakamahi Hanga o te whai i ēnei ki te faatupu i tenei:

Pāwhiritia i runga i te tahua 'Tīmata'. Na, pāwhiri i runga i te 'Mana Paewhiri'. I roto i te matapihi e puta, pāwhiri i runga i 'Papatono'. Kōwhiri 'Microsoft Office 2010' i te rārangi. Na, pāwhiri i runga i 'Huri'. I roto i te matapihi e puta, pāwhiri i runga i 'Tāpiri, Tango Papatono ranei'. Pāwhiritia i runga i te 'me' hakari tohu i te mutunga o te rārangi, kei roto i te mua o te kōwhiringa te 'Office tiri Āhuatanga'. Na, pāwhiri i runga i 'Visual Basic for Applications'. I muri i te mahi i tenei katoa, tīpako whakahau 'Run' i 'toku Rorohiko' i muri i tika-pāwhiri runga taua mea, me te ka patu 'tonu'.

I muri kua te tukanga kua oti, e mahara ki te tīmata anō i tō rorohiko.

Tips:

Ka taea te whakamahi i te tohutohu e whai ake nei mō te whakatika Excel kōnae pānui karere hapa, ki te tahi atu tikanga katoa mo pakaru te kōnae Excel kino kua tamata.

• Whakaorangia kōnae te Excel kino ki te ingoa kōnae rerekē, me te tamata anō-whakatuwhera i te reira.
• Whakaorangia te kōnae Excel kino i runga i te PC rerekē i raro i te ingoa kōnae rerekē, me te ka tamata anō-whakatuwhera reira i runga i to koutou PC i muri te tuku hoki i te reira ki koe.