Tuhinga

Me aha koe mēnā kua wareware koe ki ngā kupuhipa Excel

I whakatakoto koe i tētahi kupuhipa hei tiaki i tētahi pukapuka mahi Excel nui, ā, i whakaaro koe kei te pupuri tonu koe i te kupuhipa i roto i tōu mahunga. Heoi, i muri i ētahi haora, i ētahi rā rānei, ina whakatuwhera anō koe i te pukapuka mahi, ka puta he raruraru: ka kitea e koe kua wareware kē koe i te kupuhipa tuturu. Ka ngana koe ki te whakauru i ngā reta, ngā tau me ngā tohu rerekē engari kei te kī tonu a Excel ki a koe "Kāore te kupuhipa i tukuna e koe i te tika", pēnei i tēnei:

He hē te Kupuhipa i tukuna mai e Microsoft Excel

Āe, he tino pouri tēnei, inā koa mēnā he mea nui te kōnae.

Hei whakahaere i tēnei, me mōhio koe kāore e taea e te kamupene Microsoft te whakaora i ngā kupuhipa Excel māu engari māu ake. Whāia ngā tohutohu i raro nei, ki te kore tonu e taea e koe te hoki mai ki ngā maharatanga mō te kupuhipa, ka taea e koe te whakamātau ki te iriti i te pukapuka mahi mā te whakamahi i tētahi tango kupuhipa Excel pēnei i Pāhi mō Excel .

Ina kī tātou ka whakahokia mai ngā kupuhipa Excel, he maha ngā wā e pā ana ki te "whakatuwheratanga kupuhipa a Excel". Kāore e taea te whakahoki mai i te kupuhipa kua whakatakotoria hei aukati i te whakatika Excel kaua ki te whakatuwhera, engari ka taea te tango ngāwari i roto i te hēkona kotahi. Peke atu ki tēnei wāhanga o te whārangi kia mōhio ai koe ki ētahi atu kōrero.

Ētahi Whakaaro hei Kimi, hei Maumahara rānei i te Kupuhipa Excel kua Warewaretia

  • I tuhia e koe te kupuhipa ki tētahi pepa iti, ki tētahi tuhinga matihiko rānei?

Ka tuhia e ētahi te kupuhipa i mua i te whakatakoto. Kātahi ka wareware rātou kua mahia e rātou tēnei i mua. Nō reira, ka taea e koe te tirotiro i ngā pepa i runga i tō tēpu, tae atu ki ō taupānga tuhipoka me ngā paetukutuku e whakamahia whānuitia ana.

  • Kia tika te tuhi i ngā reta matua me ngā reta matua.

He mea āta tuhi ngā kupuhipa Excel ki ngā reta me ngā reta iti. Ka taea e koe te pato i te kupuhipa ki runga i tētahi tuhinga kia tino rite te kupuhipa e tāuruhia ana e koe ki tāu e whakaaro ana. Mena i tuhia e koe te kupuhipa Excel ki runga pepa, kia aro ki ngā reta me ngā tau e ōrite ana te āhua, pērā i te reta nui i me te reta iti L.

  • Hangaia anō ngā nekehanga, okioki rānei. Noho marino.

Hei whakamahara ake i ngā mea i tupu tata nei, ka taea e tātou te mahi anō i ngā nekehanga, te wāhi kotahi, te tūranga kotahi. Ki te ngenge koe, okioki noa. Tērā pea ka āwhina tēnei ki te whakamahara i te kupuhipa Excel kua warewarehia e koe.

Whakaorahia ngā Kupuhipa Excel kua Warewaretia mā te Pāhi mō Excel

Mā te whakamahi i ngā taputapu motuhake ka nui ake te tūponotanga o te tiki kupuhipa. I konei ka whakamahia e mātou Pāhi mō Excel hei tauira. I hangaia mō te whakaora i ngā kupuhipa whakatuwheratanga a Excel me te tango i ngā here whakatika a Excel.

He tino haumaru tō tūmataitinga mā tēnei taputapu. Mēnā ka whakahaerehia te "Dictionary Attack", me whai hononga ipurangi hei tango i te kōnae papakupu hou ki tō rorohiko. Kia oti, ka taea te whakahaere me te kore he whatunga. Kāore he tuhinga whaiaro e tukuna ake ki ā rātou tūmau.

Anei te pātene tikiake mō te whakamātautau kore utu.
Tikiake Koreutu

* Mō Windows anake tēnei hua. Mena kei te whakamahi koe i te Excel mō Mac, ka taea e koe te whakawhiti i te pukapuka mahi mai i te Mac ki te Windows mō te pakaru.

Whakaorahia te Kupuhipa Whakatuwheratanga o Excel

Hipanga 1. Kōwhiria te "Whakaora Kupuhipa"

Whakarewa Pāhi mō Excel . e rua ngā wāhanga kei tōna atanga matua. Hei whakaora i ngā kupuhipa whakatuwheratanga o Excel, pāwhiritia te poraka tuatahi – “Whakaora Kupuhipa”.

Pāwhiritia te Whakaora Kupuhipa i runga i te Passper mō Excel

Hipanga 2. Tīpakohia te Kōnae Excel

Pāwhiritia te ⊕ hei tīpako i te kōnae Excel me te kupuhipa whakatuwhera. Ki te kitea e koe te mea hē, pāwhiritia te ⓧ hei whakakore me te tīpako anō.

Tīpakohia te Kōnae Excel hei Whakaora i te Kupuhipa

Hipanga 3. Kōwhiria he Tikanga Whakaora, kātahi ka Pāwhiritia te "Whakaora"

Ka taea e koe te kite e whā ngā aratau whakaora.

Kōwhiringa 1: Whakaekenga Whakakotahi

Ki te tino mōhio koe kei roto i tō kupuhipa ētahi pūāhua, whiriwhiria tēnei tikanga. Mā tēnei ka taea e koe te tohu/whakauru i ngā mōhiohio mō te roa o te kupuhipa, te kupu whakataki me te kupu whakamutunga, ngā reta iti, ngā reta matua, ngā tau, me ngā tohu.

Pāhi mō te Whakaekenga Whakakotahitanga Excel

Kōwhiringa 2: Whakaeke Papakupu

Ia tau ka puta ngā tatauranga mō ngā "kupuhipa tino noa" i hangaia e ngā kamupene, e ngā whakahaere rānei mō te haumarutanga mamati. He maha ngā wā ka kitea ngā kupuhipa pēnei i te "123456", "111111", "kupuhipa", "p@ssword". Koinei te tikanga o te Dictionary Attack. Pāhi mō Excel Kei roto i tēnei papakupu he rārangi roa o ngā kupuhipa neke atu i te 15,000,000 e tīmata ana me ngā kupuhipa e whakamahia pinepinetia ana. Ka taea hoki e koe te kawemai i ngā kōnae papakupu kua tangohia mai i te Ipurangi.

Whakamahia te Dictionary Attack hei Whakaora i te Kupuhipa Excel kua Warewaretia

Kōwhiringa 3: Whakaekenga Kanohi

Mā te Mask Attack ka taea e koe te tohu/whakauru i ngā mōhiohio e pā ana ki te roa o te kupuhipa, ngā momo pūāhua KĀORE i roto i te kupuhipa, te kupu whakataki me te kupu whakamutunga, me ngā pūāhua ka whakaurua pea. Mena he ahua pōuri tōu mō te kupuhipa Excel, ka taea e koe te whakamātau i tēnei.

Kōwhiringa 4: Whakaekenga Kaha Kino

Mena he roa, he uaua, he matapōkere hoki tō kupuhipa, kāore he tikanga, kāore he painga o Brute Force Attack. Tērā pea ka roa ngā tekau tau ki te pakaru i tētahi kupuhipa e whakaranu matapōkere ana i ngā reta, ngā tau, me ngā pūāhua pēnei i te 8*ETu^ i runga i tētahi rorohiko whaiaro noa.

Hipanga 4. Te tatari kia ora te tukanga

I muri i te whakaoti i ngā tautuhinga me te pāwhiri i te pātene "Whakaora", ka tīmata te hōtaka ki te whakahaere i te tukanga pakaru. I tēnei wā, ka taea e koe te whakamutu, te whakaweto rānei i te rorohiko, kātahi ka haere tonu te whakahaere i tētahi wā i muri mai, kāore te ahunga whakamua o te whakaora e ngaro.

Te whakaora i te Kupuhipa Excel me te Passper mō Excel

Tangohia ngā Here Whakatika Excel i roto i te Hekona Kotahi

Ko te kupuhipa here whakatika Excel te mea whiriwhiri ka whakatakotoria e koe mō te tiaki i ngā pepa, i te hanganga pukamahi rānei. Pāhi mō Excel Ka taea e tēnei momo kupuhipa te tango me te angitu 100%. Kia mōhio koe ka tangohia noa e ia ngā here. E kore e whakahokia mai te kupuhipa i whakatakotoria e koe.

Hipanga 1. Kōwhiria "Tangohia ngā Here"

Whakarewahia te hōtaka. I tōna atanga matua, tīpakohia te "Tangohia ngā Here".

Hipanga 2. Tīpakohia te Kōnae Excel

Tīpakohia te kōnae Excel e hiahia ana koe ki te tango i ngā here, ka pāwhiri i te "Tango". Ka tangohia tonutia ngā here whakatika katoa.

Tangohia ngā Here Whakatika Excel me te Passper mō Excel

Whakamutunga

Pāhi mō Excel Ko tētahi o ngā taputapu pai rawa atu hei whakaora i ngā kupuhipa whakatuwheratanga Excel kua warewarehia. Engari me mōhio koe kāore e taea te kī taurangi i te angitu nā te mea kua tino whakapaitia te pūnaha tiaki kupuhipa Excel. Ko te mahi a te kupuhipa uaua ko te mea kia tata kore e taea te pakaru me te kaha i roto i te wā tika. Engari ki te mea he tino nui te kōnae ki a koe, ā, kua wareware koe ki te kupuhipa, he pai tonu te whakamātau.
Tikiake Koreutu

Whakaahua o Susanna

Huhana

Ko Susanna te kaiwhakahaere ihirangi me te kaituhi o Filelem. He ētita mātau ia, he kaihoahoa tahora pukapuka hoki mō ngā tau maha, ā, e hiahia ana ia ki te whakamātau me te whakamātautau i ngā pūmanawa whakaputa hua. He tino kaiwhaiwhai hoki ia mō Kindle, kua tata ki te whitu tau e whakamahi ana i te Kindle Touch, ā, e kawe ana i te Kindle ki ngā wāhi katoa e haere ana ia. Kāore i roa kua tata te mutunga o te taputapu, nō reira i harikoa a Susanna ki te hoko i tētahi Kindle Oasis.

Ngā tuhinga e pā ana

Pātene hoki ki runga