Me pēhea te ki te whakaraneatia i tīwae Excel i tīwae, me te tīwae ki runga ki te maha o

Ko te hunga iwi e mahi maha i te rorohiko, maoro, e fehangahangai ki te hōtaka pērā i Excel. Ko te whakahaere i roto i te tuhinga haere i runga i nga AtAKi katoa me ngā raruraru o te hōtaka, me e pā ana ki ona wāhanga takitahi, "Tātai". O te akoranga, i roto i ngā kura me ngā whare wānanga i runga i te pūtaiao haapiiraa ākonga me ngā ākonga te tango he akoranga i runga i te kaupapa, engari mo te hunga e kua wareware - to tatou tuhinga.

Ka kōrero tatou e pā ana ki te pehea, ki te tini i te tīwae Excel ki tīwae. Ka whakarato te reira i tohutohu āmiki i runga i te āhua o ki te mahi i tenei, ki te taahiraa i te tātari taahiraa o ia tūemi, kia taua katoa, ka taea ki te titiro ki te mea ara te ākonga tauhou.

Tini tīwae i te tīwae

Me pēhea te ki te whakaraneatia i tīwae Excel i tīwae, ka noho matou hei tauira. Kia whakaaro a e i roto i te pukamahi Excel koe te hanga i te tepu ki te uara me te nui o te taonga. E hoki koe te pūtau ki raro ki te tapeke. Ka rite ki a koutou kia imi, e hiahia ana koe ki te hohoro tini nga pou tuatahi e rua, ka kitea e ratou moni.

Na, i konei he taahiraa i tohutohu taahiraa:

1. Miramirahia te wāhi e hiahiatia ana, ka pēhi i te mahi icon, kei nei i i te tihi o te paeutauta matua.
2. puta matapihi "etahi" Ka kia tīpakohia i mua o koutou wahi e hiahia ana koe.
3. Next, me te whiriwhiri koe i te rōpū o ngā mahi pāngarau.
4. Tīpakohia "SUMPRODUCT".

I muri i taua, puta he matapihi i roto i nei e ui koe ki te tīpako i tētahi awhe e kei roto i te raraunga, e taea e koe kia rua ara haere. fakahu'unga te tuatahi e whakamahi koe i te pehu ki te tīpako i te tīwae tuatahi (te utu), ka tohua ona ngā i roto i te "Huānga, 1", me te tuarua (utu) - whakarārangitia i roto i te "Huānga, 2". Ka rite ki a koutou e taea te kite, i tohua te awhe i roto i ngā pūāhua (C2: C6). uhinga a te tikanga tuarua e koutou e tomo ki enei uara ā, te rerekētanga i tenei kahore.

Na e matau ana koutou tetahi ara e founga ki te tini i roto i te tīwae Excel i tīwae, engari ehara i te mea anake te kotahi, a ka kia kōrero te tuarua ake nei.

Ko te tikanga tuarua o te whakareatanga

Hei tini tīwae o te tikanga tuarua, ka hiahia koe ano ki te tīpako i te rōpū mahi "pāngarau", tena ko tenei tatou ki te whakamahi i "hanga". Na i reira e rua mara i mua o koutou, "Tau 1" me te "tau 2". Pāwhiritia i runga i te "Tau 1" me te tīpako i te uara tuatahi i te tīwae tuatahi, rite tukurua me te ki te "Tau 2", anake kōwhiria e te uara tuatahi o te tīwae tuarua.

I muri te pāwhiri "OK" i roto i te pūtau ki te tātai ka hei te hua o ngā uara tīpakohia, taea anake hua pūtau whakakīaunoa, mo tenei, neke i te pehu ki te mata matau o raro o te pūtau, ka toia ki raro ki te maha e hiahiatia o ngā.

Na kua ako koe i te ara tuarua o pehea ki te tini i roto i te tīwae Excel i tīwae. Na kia kōrero a pā ana ki te pehea, ki te tini i te maha o te tīwae.

Tini i te maha o te tīwae

Na, me pehea ki te tini i te tīwae i Excel i te tau? I roto i te meka, te reira noa māmā. Ki te mahi i tenei:

1. Tīpakohia te pūtau wahi e te hua e kei.
2. E tomo i roto i reira te tohu o "te taua".
3. miramira te pehu te uara tuatahi i roto i te tīwae, engari kia kia tohaina te tau e i ki tini te uara.
4. I muri i taua, neke i te pehu ki te maha me te pēhi i te K4.
5. Te reira i teie nei tonu hoatu anake te pehu i runga i te kokonga matau o raro o te whakautu pūtau me toia reira ki te nui e hiahiatia ana o ngā tūemi.