Me pēhea te ki te Tapia 'he pirau kōnae Excel, a kore e taea e tuwhera' take

Na i tenei ra e haere tatou ki te kōrero i runga i te āhua o ki te hanga kino kōnae Excel . I mua whiwhi i roto i tetahi kōrero matatau i runga i te mea ko nga take hanga tou tuhinga pānui, he aha te te taputapu hanga Excel pai i roto i reira, a muri pehea ki te mau hanga kōnae Excel e kore e taea te whakatuwheratia, kia tuatahi whakamahana tatou ake to tatou roro ki ngāwari ki te kapo kōrero i runga i Excel. E mohio ana ahau e inaianei kia maheni ki tenei kōrero ai te katoa, engari kia mohio koutou e te tuatahi whakaurua Microsoft te pūmanawa ripanga hoki na i roto i te '80s. Papau whakamahia reira he Excel momo hōputu kōnae atu i tahito ra, engari reira tino i hanga te ora o ngaio maha kia nui māmā

• Wāhanga 1: Pūmanawa Hapa Tapia Kōnae Excel
• Wāhanga 2: Rongoā ki Tapia 'he pirau kōnae Excel, a kore e taea e tuwhera'

Fakatāutaha, te whakamahi ahau Excel mo te rota o mea. Homai toku nui i roto i te whakahaere i ahau ki te mahi i te rota o tātaitanga pūtea, ngā pūrongo, me te whakaputa nui o kauwhata me ngā tūtohi atamai. I te tahi taime, e ahau i rite ki te mahi i ngā mahi ohie rite whakatuwhera te pepa, me te tika te whakamahere toku ra i mua. Ko tētahi o aku hoa kei te ara e pupuri i ana pūtea whaiaro, me pupuri ara o utu rā. Whakamahi People reira mo te rota o mea haurangi, e ai kua koe e kore whakaaro o. Heoi, ki te tukitukia koutou tuhinga tangata e kore koe e taea e ki te ngaro ngā mōhiohio nui, e tika? Ko te te wāhi i reira tauturu tenei tuhinga koutou e founga ki te hanga kōnae Excel e kore e taea te whakatuwheratia.

'Ko pirau kōnae Excel, a kore e taea e tuwhera' Overview o

Ka taea e tō tuhinga tiki pakaru hoki te rota o take. He take noa, ka ai koutou i tutuki i runga i te hapa "Ko kino te kōnae, me te kore e taea te whakatuwheratia.", Ko ina e ngana koe ki te whakatuwhera i te tuhinga ki te putanga hōu Excel e te ka te tikiake i te tetahi i hanga ai i roto i. Tētahi atu take i te kōnae i te ipurangi, me te ngaro te hononga kei te tika ki te aroaro o te wāhi mutu. Ko te taua mea e taea tupu, ka whakawhiti i ngā kōnae i runga i te īmēra me te ngaro te hononga tangata e. Ko te mea tino, ko te e ka waiho koe taea ki te whakatuwhera i taua tuhinga.

Ko tētahi atu take onge, engari tino he, ina e huri koe i te hōputu kōnae hoki me puta ngā wā maha. Kia hua tenei mahi i roto i taki ake te kōrero i roto i roto i te pane o te tuhinga, i arahi ki te pirau o te kōnae. He he pūnaha pātūahi rawa tino he wheori ranei e taea te hoki tūkino te pane kōnae, a kore e taea ki te whakatuwhera i te tuhinga koutou. Kei te tino Ētahi atu take e here ana ki te taputapu. Ka taea e puku manoao kino hoatu koe po taoto rawa. He mahi whakaora e taea te āwhina ia koutou Excel hanga kōnae Excel kino . Ki te kore e e mahi, ka hiahia tino koe ki te whakamahi i tētahi taputapu hanga Excel.

Wāhanga 1: Pūmanawa Hapa Tapia Kōnae Excel

Ko nga wa katoa te whakatika kōnae Excel kino te whakamahi i te taputapu hanga Excel te ohipa ohie, whakawhirinaki ahau. Na, ki te e puritia e koe tono koe te mea te he taputapu hanga Excel me mēnā ka taea e koe te whakamahi i te reira ki te hanga kōnae Excel e kore e taea te whakatuwheratia, ka whiwhi tatou i reira i roto i te meneti, a ka whakaatu ahau ki a koe rite ki te whakamahi i te reira. E korero matou i konei e pā ana ki te pūmanawa e he taea ki te hanga pakaru kōnae Excel. Ko te taputapu tino tōtika e taea mahi ki e rua "xls" me "xlsx" hōputu kōnae. Oranga Tapia Phoenix Excel ko tetahi o enei hōtaka hauhautanga me te mea pai e pā ana ki te mea e pupuri ana te reira i te hōputu taketake o te kōnae i waho whakakē tetahi: tepu, ngā tūtohi, kōrero, tātai, whakapakoko, me o whiriwhiringa akoranga.

Oranga Tapia Phoenix Excel kua he ton o ngā āhuatanga hauhautanga, engari e haere ana ahau ki te whakaatu i te torutoru hunga e hāngai ana. kia mohio koe e taea tenei wahi o te pūmanawa ora tata tetahi hira hapa kōnae. Ki te tupu te tahi mea ki tou pūmārō me ka kino o koutou kōnae katoa i kotahi, ka kore koe e hiahia ana ki te manukanuka reira no te mea ka taea e koe te whakahoki mai i ngā kōnae maha i kotahi. Windows 10 ranei Windows XP? Kāore he raruraru. mahi te reira i runga i tetahi matapihi, a ka whiwhi koutou tautoko mō te Microsoft Excel 2000 me ki runga ki te 2016 rite te pai. E taea e ki te arokite i te kōnae ara i mua i tīmata te tukanga whakaora hoki koe.

Wāhanga 2: Rongoā ki Tapia 'he pirau kōnae Excel, a kore e taea e tuwhera' take

I mua i taea matou peke tīmata ki te hanga i tetahi kōnae Excel kino, tēnā tiki tenei taputapu hanga Excel. I muri hanga koe i te reira i roto i ki te mutunga o te tukanga tāuta, tika pato te pātene "Mutu" ka tatari mo te hōtaka ki te whakarewa ake. Arumia ahau a ka whakaatu ki a koe e ahau rite pehea ki te hanga kōnae Excel e kore e taea te whakatuwheratia :

Hipanga 1 Ka āwhina te reira koutou i roto i te rapu i te kōnae e hiahia ana koe ki te ora. Tap "Tīpakohia Kōpaki" ranei "Tīpakohia Kōnae", ki te matau koutou te wāhi tangohia o koutou kōnae hāmate. Kia hoki e koe te tīpako i te tauwāhi puku hanga te tahua taka-iho, ka pato "Rapu (s) Kōnae" ki te tuku i te pūnaha kitea ngā kōnae hei utu o koutou;

Hipanga 2 Kei te ki tonu te pouaka hua rapu inaianei ki ngā tūemi. Kia tīpako koe kōnae maha. I muri i whakaritea e koe e ki tetahi ora, pato te pātene "Matawai".

Hipanga 3 Kei te hangaia te arokite o te kōnae i muri i matawai mutu;

Hipanga 4 Ki runga ki te hanga i tō whakaaro ki runga i ngā kōnae e hiahia ana koe ki te kaweake, pāwhiritia te pātene "Tiaki". Kōwhiria he wahi ki te whakaora o koutou kōnae, me te pato "ok".

Tenei ko matou i te mutunga o tenei tuhinga i runga i te āhua o ki te hanga kōnae Excel kino . Tīmata I mua te whakamahi i te taputapu hanga Excel fokotu'u i roto i tenei tuhinga e kore e wareware ki te tuatahi whakaora, a ka kati i tetahi wātū Excel, no te mea kei te whakamahi i tenei pūmanawa etahi wāhanga ngā. Tenei he atu he torutoru tohutohu mo koutou:

• Taime atoa e ngana ana koe ki te hanga i tetahi kōnae Excel e kore e taea te whakatuwheratia, e kore e wareware ki te hanga i te tārua pūrua. I roto i te take tupu te tahi mea i roto i te tukanga whakaora koe he tārua e manawapa ki te ngana anō;
• Ki te kei te whakaora koe me te whakatika o koutou kōnae Excel i runga i te puku o waho, e kore aruaru te hononga i tāruatanga, tiaki me te muku. Mahi i taea e te reira tūkino koutou tapatahi kōnae;
• Ko reira he mea pai ki te pupuri i nga wa katoa i tō pūnaha whakahoutia, ka tirohia koutou pūmārō mō hapa i te iti rawa i te wa wa ki. Tetahi o enei e ārai koe i te tūmanako tonu he ki te mahi ki te pirau raraunga meinga e koutou ake pūnaha.