Ahakoa te whakaurunga o te mahi "tiaki" ki roto i te Excel ka whakapakari ake i te haumarutanga o ngā kōnae nui, ka taea hoki e ia te whakaputa i ngā raruraru maha mena ehara koe i te kaituhi o te kōnae (arā, kāore pea e taea e koe te wete tika i te tiakitanga) kua wareware rānei koe, kāore rānei i te mōhio ki te kupuhipa (mēnā kei te tiakina te kōnae mā te kupuhipa). He mea whakarihariha tēnei take mena kei te tiakina te tuhinga i tētahi ara, ā, kāore e taea e koe te whakatika, te hōputu rānei.
E rua ngā momo kōnae Excel e tiakina ana, tētahi e āraia ana kia kore e taea te whakatika, me tētahi atu e āraia ana kia kore e taea te whakatuwhera. Mā te tuhinga nei e whakarato he otinga mō ngā āhuatanga e rua.
Ka whakaratohia e mātou he aratohu whānui, ngāwari hoki mō te wetewete i te parenga o tētahi Pepa Excel, o tētahi Pukamahi rānei, kia taea ai te whakatika i ngā wā katoa e pai ana ki a koe.
Wetewete i te Ārai Māmā o Excel
He maha ngā tikanga ka taea e te kaituhi te tiaki i tētahi kōnae Excel. Ko te āhuatanga tino noa, ā, he māmā noa iho, ko te wā kei a koe he kupuhipa, kāore rānei koe e hiahia ki tētahi kupuhipa. I tēnei wā, he tino māmā te tukanga i runga i te Excel 2010, 2013, 2016 me te 2019.
Tērā pea ka "Tohua hei Whakamutunga" te kōnae, ka waiho te ripanga tātaitai hei "Pānui-Anake", ā, ka kore e whakaaetia kia mahia ētahi atu huringa ki reira, ā, ka whakaaturia he tohu ki te rīpene o runga. Hei uru atu ki tētahi kōnae pēnei, pāwhiri noa i te pātene "Whakatika Ahakoa Pēhea" i te rīpene, ka hoatu ki a koe te urunga katoa ki te whakatika i tāu e pai ai.
Kei te kaituhi anō hoki te kōwhiringa ki te tiaki kupuhipa i tētahi kōnae mā te "Tiaki i te Rau o Nāianei" i raro i te "Kōnae > Tiaki Pukapuka Mahi". Ka taea e koe te whakatuwhera i tētahi kōnae i tēnei wā engari kāore ētahi o ōna mahi e wātea. Hei whakatika i tētahi kōnae pēnei, pāwhiritia te ripa "Arotake" kātahi ka pāwhiri i te "Tangohia te Rau". Whai muri i tēnei, ka taea e koe te whakauru ngāwari i te kupuhipa me te uru katoa ki te kōnae Excel.
Mena kua tiakina te kōnae mā te kōwhiringa "Whakamuna me te Kupuhipa" i raro i te "Kōnae > Tiaki Pukapuka Mahi", ka āraia koe ki te whakatuwhera i te kōnae me te kore e whakauru i tōna kupuhipa. Ina pāwhiri rua koe i tētahi kōnae, ka puta ake he tohu e tono ana mō te kupuhipa mō te kōnae. Whakauruhia noa te kupuhipa ki reira ka pēhi i te Enter. Ka whai urunga katoa koe ki te kōnae me ōna mahi katoa.
Wetewetehia te Parenga o te Pepa Excel mā te Tango i ngā Here
Ki te kore he kupuhipa āu, he maha ngā arai ka pā mai ki a koe i te wā e whakatika ana, e whakahōputu ana rānei i tētahi kōnae Excel.
Koinei te wāhi e wātea ai tētahi pūmanawa tino watea pērā i te Pāhi mō Excel He kōwhiringa whai hua a Passper. He tino whai hua a Passper ki te tango tere me te mohio i ngā here taumaha mai i a Excel, me te whakarite kia rite rawa te kōnae ki te whakatika me te hōputu i te wā e pai ana ki a koe.
Ko ētahi o ngā āhuatanga āwhina e whakaratohia ana e Passper mō Excel ko:
- He 100% te whai huatanga ki te wetewete i te parenga o tētahi pepa mahi/pukamahi Excel.
- He atanga māmā, ngāwari hoki e kore e hiahiatia he raruraru.
- He whānui rawa ngā kōwhiringa hototahi, ā, ka taea te tango i te parenga o Excel 97/2000/2003/2007/2010/2013/2016/2019.
Ka taea e koe te pāwhiri i tēnei pātene Tikiake hei tiki
Pāhi mō Excel
.
Tikiake Koreutu
Mā tēnei aratohu taahiraa-i-te-taahiraa koe e whakaatu ki te whakamahi i a Passper hei wetewete i te parenga o tō pukamahi/pepa mahi Excel:
Hipanga 1: Tīpakohia te Mahi e Hiahiatia ana
Kia oti te tāutanga, whakarewahia a Passper i runga i tō rorohiko ka pāwhiri i te "Tangohia ngā Here".
Hipanga 2: Kōwhiringa Kōnae
Pāwhiritia te "Tīpakohia he Kōnae" hei tīpako i te kōnae Excel e hiahia ana koe ki te Wetepare.
Hipanga 3: Tangohia ngā Here
Kia oti te whiriwhiri i te kōnae e tika ana, pāwhiritia noa te pātene "Tangohia", ā, ka tangohia wawetia ngā here katoa mai i tō Pepa Mahi/Pukamahi Excel. Ka whai wāhi atu koe ki tētahi Kōnae Excel ka taea te whakatika katoa, kāore hoki e tiakina.
Nō reira, ka kite tātou i tērā Pāhi mō Excel Ka huakina tētahi āhuatanga matua o tō pūnaha matihiko, e āhei ai koe ki te uru atu ki te maha mutunga kore o ngā kōnae Excel i tō wā e pai ai. He taupānga tēnei e tika ana kia tikiakehia mēnā kua hoha koe ki te mahi me ngā kōnae Excel e tiakina ana, e puta mai ana hoki ngā wero koretake.
Wetewete i te Tiakitanga o te Kōnae Excel mā te Whakaora i te Kupuhipa
Mena kei te mahi koe me tētahi kōnae Excel e tiakina ana e te kupuhipa whakatuwheratanga, Pāhi mō Excel He otinga tere tā Passper hei whakatika i tēnei take. Ka taea e Passper te whakatuwhera i ētahi kōnae Excel kua tiakina e te kupuhipa, ā, kāore e taea te whakatuwhera hei tiro mēnā kāore i a koe te urunga ki te kupuhipa e pā ana. Me whai whakaaro ki te uauatanga o te kupuhipa e pā ana ina ngana ana ki te wawahi mā te Passper (tērā pea kāore e taea e ia te wawahi i ngā kupuhipa tino uaua, tino roa hoki).
Kei raro nei tētahi aratohu māmā e whakaatu ana me pēhea te whakamahi i a Passper hei iriti i tētahi Kōnae Excel e tiakina ana e te Kupuhipa:
Hipanga 1: Tīpakohia te Mahi e Hiahiatia ana
I muri i te tāutanga Pāhi mō Excel I runga i tō rorohiko, me tīmata e koe te hōtaka, ka pēhi i te "Whakaora Kupuhipa", kātahi ka pēhi i te tohu "+" hei rapu i tō kōnae, ka tīpako.
Hipanga 2: Tīpakohia te Aratau Whakaeke
I muri i tēnei, ka taea e koe te whiriwhiri mai i ngā momo whakaeke e whā e ai ki ō hiahia.
Mā ēnei kōwhiringa ka taea e koe te whakamahi i te whānuitanga o ngā huarahi, i runga i tō mōhiotanga (tō kore mōhiotanga rānei) mō te kupuhipa e tika ana. Ka taea e tēnei huarahi maha te whakamahi hei tere me te whai hua mō ngā kōnae kua rakahia e te kupuhipa.
Hipanga 3: Whakaora
Whai muri i tēnei, ko tāu noa he pāwhiri i te pātene "Whakaora" ā, ka tīmata a Passper mō Excel i te tukanga tiki i tō kupuhipa. Ko te roa o te whakaora kupuhipa e whakawhirinaki ana ki te roa me te uaua o te kupuhipa.
Kātahi ka taea e koe te tārua ngāwari i te kupuhipa hou kua riro mai, ka rongoa haumaru. Mēnā ka pā mai anō tētahi raruraru rite, ka wātea a Passper mō Excel hei āwhina i a koe ki te tiki anō i tētahi kupuhipa, me te whakatuwhera i te whakamahinga katoa o tētahi kōnae Excel. Ka taea e koe te whakamahi i te kupuhipa kua wetekina, me te whakatika me te whakahōputu noa i tō Pepa Mahi Excel.
E ai ki te tuhinga, he mahi uaua te whakahaere i ngā kōnae Excel kāore i tiakina, he tino uaua rawa atu ina he tuhinga Excel kāore e taea te uru atu me te kore he kupuhipa.
He taputapu tino hira a Excel i roto i te ao pakihi me te tauhokohoko. He nui te utu mō ēnei arai, ā, ka pā mai pea he maha ngā raruraru ki te kaiwhakamahi, arā, te taha pūtea me te taha whakahaere.
Waimarie,
Pāhi mō Excel
Hei whakamama i ēnei āwangawanga katoa, he taputapu "Whakatikatika Katoa" e aro nui ana ki ia o ēnei raruraru me te whai hua, me te iti o te utu ki te kaiwhakamahi. Ka taea e koe te whakamahi hei tango, hei pakaru rānei i ngā kupuhipa Excel, me te iriti i te kōnae kia uru atu ai ki te ripanga tātai. Ki te whakaritea ki ētahi atu kaupapa, ka whakaratohia e Passper he whakaritenga māmā ake, he ngāwari ake hoki, e pai ake ana i te whakataetae i roto i te hangarau me te watea.
Tikiake Koreutu
