Tātari Arā i roto i Excel: tauira. Me pēhea te ki te hanga tātari matatau i roto i Excel, me pehea ki te whakamahi i te reira?

He maha ngā kaimahi o ngā whakahaere e whai ki te hopoia mahi ki Mircosot Excel, ahakoa maha e fehangahangai Accountants noa me kaitätari ki te pai rawa o te maha o ngā uara i te ngohi nui o ngā raraunga. Hei te faaohie i tēnei mahi, me te i hanga e te pūnaha filtration.

tātari Simple me matatau

I roto i te Excel whakaatu te tātari ohie e tīmata ana ki te ripa "Raraunga" - "Tātari» (Raraunga - Tātari i roto i te putanga Ingarihi o te hōtaka) ranei te whakamahi i te pokatata ki runga ki te paeutauta, rite ki te kōrere tihi-āhua mō te whakawhiti wai i roto i te ipu ki te kaki kuiti.

I roto i te nuinga o te wā ko te tino te tātari te kōwhiringa pai. Otiia, ki te hiahia koe ki te kawe i roto i te kōwhiringa o te tau nui o ngā āhuatanga (a tae noa puta noa tīwae maha, rarangi me ngā pūtau), he tokomaha e miharo ki te hanga i te tātari matatau i roto i Excel. huaina te putanga Ingarihi te tātari Arā.

Ko te whakamahi tuatahi o te tātari matatau

I roto i te Excel, te nuinga o te mahi e wahi ki tepu. Tuatahi, he watea reira, a tuarua, i roto i te kōnae kotahi, ka taea e koe te whakaora mōhiohio i runga i te maha o ngā whārangi (ripa). Runga ake te tepu matua, he reira e minaminatia ki te hanga i te torutoru rārangi, te pito o nei mahue te ki te potae, ko te reira i roto i te rārangi raraunga ka pai nga tikanga o Excel tātari matatau. I muri, pea ka puta ke te tātari, ki te rapu utu atu tikanga, ka taea e koe te kōkuhu tonu i roto i te wahi e tika ana ara he raina kotahi. Heoi, ko reira e minaminatia e tikanga i waenganui i ngā pūtau me ngā pūtau o te awhe pūtake raraunga i kotahi rarangi unactuated.

Me pēhea te ki te whakamahi i te tātari matatau ki Excel, kōrero te tauira i raro nei.

Hoatu he tātari

I roto i ngā rārangi i te tepu 1 me 2 e hangaia mo te whānui o ngā tikanga, ngā rārangi 4 ki te 7 - o te awhe pūtake raraunga.

Hei timata ki te tomo ki roto ki te rārangi 2 o uara hāngai, ka e kia fakalili'a e te tātari matatau i roto i Excel.

Tīmata i te tātari i te whakamahi i tohu pūtau o raraunga tuatahi, ka me tīpako koe i te "Raraunga" ripa, ka pāwhiri "Arā» (Raraunga - Arā, aua).

whakaatu ana te mata i te awhe o ngā pūtau tīpakohia i roto i te "Range Pūtake". E ai ki te tauira i runga ake, riro te raina te uara «$ He $ 4: $ F $ 12".

Ko te "tikanga awhe" kia whakakiia uara «$ He $ 1: $ F $ 2."

hoki kei roto i te matapihi e rua tikanga:

• tātari i te rārangi i roto i te wahi;
• tārua i te hua ki te tauwāhi rerekē.

Ko te tu o mua ka taea te hanganga o te hua i runga i te wahi, i raro i te pūtau awhe pūtake wahi. Te huru tuarua taea ki te whakaputa i te rārangi o hua i roto i te ropu, kotahi nei kia tohua i roto i te "Tāpiri i te hua ki te awhe." kōwhiria e te kaiwhakamahi te kōwhiringa watea, hei tauira, katia te matapihi tuatahi, "Whiriwhiringia Arā" i roto i te Excel te.

I runga i nga raraunga tomo, ka hanga i te tātari i te tepu e whai ake nei.

A, no te whakamahi i te ngā "Tārua hua ki tētahi atu wāhi" e whakaaturia uara o 4 me te 5 ngā rārangi i roto i te awhe tomu'a e te kaiwhakamahi. Ka noho te whānuitanga tuatahi tonu.

Whakangāwari o whakamahi

E kore te mea watea te tikanga whakaahuatia, no te mea hei whakapai ake te whakamahi te nuinga o VBA hōtaka reo, me i ake tonotono ki te whakaaunoa tātari matatau i roto i Excel.

Ki te mohio o VBA te kaiwhakamahi, e tūtohu ana ki te ako i te maha o ngā tuhinga i runga i tenei kaupapa, me te ki te whakatinana angitu i to tatou mahere. Ki te huri koe i te rarangi o ngā pūtau 2, wahi i raro i te tātari matatau Excel, ka huri i te whānui o ngā tikanga te tautuhinga tautuhi tonu a tīmata ano i roto i te whānuitanga tika ka hanga i te mōhiohio e tika ana.

uiui matatini

I tua atu ki te mahi ki te uara këtia ïa, tātari arā atu anō i roto i Excel, a he ahei o whāwhā pātai matatini. E tomo ēnei raraunga, te wahi wahi o nga pūāhua whakakapi e te kārimākā.

Ko te tepu tohu mō uiui matatini tabulahia i raro nei.

Ko reira utu i mohio e te tohu * taea tikanga tetahi maha o ngā pūāhua. Ko, ina hoki te uara "n *" tomo uara katoa, ahakoa o te maha o ngā pūāhua muri i te pukapuka "n."

Ko te tohu "?" Te tikanga kotahi anake pūāhua.

Paihere o ME me RĀNEI

Me mōhio e te mōhiohio homai i runga i tetahi raina i roto i te "whānui o ngā āhuatanga" e whakaaro tuhia i roto i te paihere o te kaiwhakahaere arorau (AND). Tenei te tikanga e rave rahi tikanga e wā kotahi makona.

Ki te tuhia te raraunga taua i roto i te kotahi tīwae, tātari arā atu anō i roto i Excel whakaae ratou kaiwhakahaere arorau e hāngai ana (RĀNEI).

Ripanga o ngā uara e te puka e whai ake nei:

tepu whakarāpopototanga

Ko tētahi atu huarahi ki te tātari raraunga mā te whakamahi i te whakahau "Kōkuhu - Ripanga - tepu Whakarāpopoto» (Kōkuhu - Ripanga - RipangaKaurori i te putanga Ingarihi).

Ko te tepu rite mahi ki te tīpakohia-i mua i ngā raraunga i whakatapua, me ngā uara ahurei ki te kia tātarihia muri. I roto i te meka, rite te mahi o te titiro i te reira rārangi taka-iho o mara ahurei (hei tauira, ingoa o ngā kaimahi o te kamupene) me te whānuitanga o ngā uara e kua homai te kōwhiringa o te mara ahurei.

Ko te ngoikoretanga o te whakamahi i nga tepu whakarāpopototanga ko te akiaki ia o whakarerekētanga ā-ka huri i te raraunga raw ratou.

mutunga

Roto i te whakamutunga, kia tuhia te reira e te mea tino whanui, me te kanorau te hōkai o te tātari i roto i te Microsoft Excel. tatu ki te tono whakaaro me te whakawhanake i ō rātou ake mōhiotanga, me ngā pūkenga.

I tahaki, he ngāwari ki te whakamahi, me te ako, ngāwari ki te matau me pehea ki te whakamahi i te tātari matatau i roto i Excel te tātari, engari kua hangaia reira mo tono tono he nui iti o te wā ki te hanga tātari mōhiohio mō te tukatuka atu. Ka rite ki te tikanga, e kore e whakarato i te reira no te mahi ki huinga nui o ngā raraunga e tika ana ki te tauwehe te tangata i ia te wā. He kua tae mai ki te āwhina o te hangarau tukatuka mōhiohio atu mātanga, me te matatau i roto i Microsoft Excel.

tonotono rongonui nui, unu ake i roto i te reo o VBA. tukua ratou ki a koe rere i te maha nui o whiriwhiringa, ngä nga uara whiriwhiri me te putanga ratou ki nga awhe tika.

Tonotono pai whakakapi maha haora o te mahi i runga i te tuhi ake te whakarāpopoto, pūrongo wā, me te tahi atu, whakakapi tātaritanga-wa roa o moni nui o te kotahi anake pāwhiri tuarua.

Mā te tonotono whakatikaia me fiemālie. Tangata e kua tūpono te hiahia ki te whakamahi i, ki te hiahiatia, ka kitea tonu nui rauemi ki te whakawhanake i ō rātou mōhiotanga, me te kitenga whakautu ki ngā pātai.