Tepu Whakarāpopototanga Excel: me pehea ki te waihanga me te mahi? Mahi ki Excel RipangaKaurori

maha fehangahangai He maha ngā kaiwhakamahi tari he maha o ngā wero ka ngana ana ki te waihanga me te whakatika i tetahi tuhinga Office. Pinepine he tika ki te meka e whakamahi kamupene e rave rahi hōtaka tari tenei, te mau parau tumu o e taea rerekē nui. Rawa te rota o te raruraru e taea te waihanga RipangaKaurori Excel.

Aua'e, āhua tata puta MS Office 2010-2013, e ngā he maha o te pūmanawa whakahoutia hoki ngā kōnae kuputuhi tukatuka, ripakaute, pātengi raraunga me whakaaturanga kore anake, engari ka taea ano hoki ki a koe te mahi ki a ratou wā kotahi ki te maha o ngā kaimahi i roto i te taiao rangatōpū he faufaa rahi.

He aha te putanga hou?

Hei matau tenei pātai, e hiahia ana koe ki te whakaaro o te katoa o nga rerekētanga tino nui e kua puta ki tenei huinga tari.

Ka rite ki te aroaro o, he reira Excel ko te rua o nga tono mo te hōtaka e taea e kore anake ki a koutou te hanga tepu ohie, engari ara te hanga i tētahi pātengi raraunga tika matatini. Ka rite ki ki te atu wāhanga, kua reira kua tapiritia ki te pātene "Tari", pāwhiri i runga e taea e koe te whakaora i te tuhinga i roto i te hōputu e hiahiatia ana, te huringa whakapūtā te mehua e hiahiatia ana mo tona tiaki ranei. I tino ake te reira i te kōwae haumarutanga o te tuhinga.

Ko te huringa tino nui ki Excel, kia tuhia ai fakatonutonu hapa maha i roto i ngā tātai, no te mea o te mea maha puta putanga o mua hape rawa nui i roto i te tātai.

Me mea te reira e te putanga hou o te mōkihi - e kore ko tenei te huinga tika o ngā hōtaka tari, engari ano hoki i te taputapu kaha, e tika ana ki te whakaoti tae noa te mahi tino matatini. Ka rite ki a koutou e taea e matau tatou e kia whakaaro tenei ra tepu kaurori Excel.

He aha te mea te reira, a he aha te mea te reira hoki?

Ko te huringa tino nui i roto i te putanga hou o "Office" Ko to ratou atanga tino perekroenny, kua oti nei te karanga a nga kaihanga o te Rīpene (rīpene). Kei te wa nga rïpene whakarōpūtia 1500 whakahau katoa i ngā kāwai, na e kore koutou e whai roa ki te kitea ratou. Ki te tino ū ki enei tawhā, te ngā i tapiritia ki Excel ake hoki RipangaKaurori.

I teie mahana, whakaaro tatou Excel «mō te horoi,." tepu Whakarāpopototanga - he taputapu motuhake, i roto i nei mārama whakarōpū nga hua o te tukanga. Mämä noa iho, e taea te whakamahi ratou kia kite e hia o te hunga atu taonga ranei hokona nga kaihoko mo tona neke. I tua atu, kei te whakamahia ratou i roto i te wā i reira he mea tika:

• A faaineine i tātaitanga tātari mō te tuhi pūrongo whakamutunga.
• Tātaitia ratou tohu katoa motuhake.
• Kawea mai whakarōpū i te momo o ngā raraunga.
• Hei tātari me i roto i-hōhonu tātaritanga o nga raraunga.

I roto i tēnei tuhinga ka titiro tatou ki huarahi ohie ki te waihanga ratou. Ka ako koe e founga tauturu tepu kaurori Excel ki te waihanga me te tātari raupapa wa, ki te waihanga me te poroporo i te matapae taipitopito.

Waihanga i te tuhinga e hiahiatia ana

Na me pehea ki te hanga i tētahi ripanga kaurori i Excel? Tuatahi e hiahia ana koe ki te waihanga i tētahi tuhinga ohie i roto i nei hanga tatou i te raraunga mō te tātari i muri. kia whakaaro kotahi tīwae hoki kotahi tawhā. E mau ki te tauira ohie:

• wā hoko.
• Taonga hokona.
• Ko te tapeke utu o hoko.

Ko te kupu, i roto i ngā tawhā katoa hangaia i roto i ia hono tīwae: amo e kua hokona hu ki 9 am, hanga te pai n-moni.

tepu hōputu

I muri te whakarite i te kōrero taketake katoa, hoatu te pehu i roto i te pūtau tuatahi o te tīwae tuatahi, whakatuwhera te ripa "Kōkuhu" a ka pāwhiri i runga i te pātene "Ripanga Whakarāpopotonga". Ka kite tonu koe i te pouaka kōrero i roto i nei e taea e koe te mahi i te ngā mahi e whai ake nei:

• Ki te pēhi tonu koe i te pātene "OK", ka e kia whakaaturia tonu Excel RipangaKaurori i runga i te pepa motuhake.
• Fully whakarite excretion.

I roto i te take whakamutunga, homai nga ngā tatou te whai wāhi ki te whakatau i te whānuitanga o ngā pūtau kia e ka whakaaturia ngā mōhiohio rapu. I muri i tenei, me whakatau i te kaiwhakamahi te wahi i hanga te tepu hou te āta, ki te ngā hou hanga i runga i te rau ranei. Mā te pāwhiri "OK", ka kite tonu koe i te mua o te tepu rite. I te hanganga o ngā ripanga kaurori i Excel te ngā oti.

I te taha ki matau o te wāhi pepa kei, ki nei e mahi koe. Ka taea te toia mara, a maturuturu iho ki ngā wāhi motuhake, i muri nei i te raraunga e ki te whakaatu i roto i te ripanga. Nä, ko te tepu kaurori ano ka kei i runga i te taha ki maui o te mokowāmahi.

E pupuri ana i te pēhi i te pātene kiore maui, te "hua", te tuku i te reira ki te "pae taitara", ka pāwhiri "Pauna moni o Sales" i roto i te ara ano whakamua i roto i te "uara" (i te taha ki maui o te pepa). Ko te pehea e taea te tiki e koe i te nui o hoko mo te wā tātarihia katoa.

Te hanga me te whakarōpū raupapa wā

Hei tātari i te hoko i runga i te roa motuhake o te wā, me whakauru koe i te kōwae e hāngai ana i roto i te tepu iho. Ki te mahi i tenei me haere koe ki roto ki te whārangi "Raraunga", me te ka kōkuhu toru tīwae hou tonu i muri i te rā. Tīpakohia te tīwae ki te ingoa o te hua, me ka pāwhiri i runga i te pātene "Kōkuhu".

He mea tino nui, kia i katoa tīwae hou hanga i roto i te ripanga ngā ki te raraunga pūtake. I roto i tenei take, ano e hiahiatia te hanganga o ngā ripanga kaurori i Excel. Koe ka tāpiri noa mara hou ki nga raraunga e hiahiatia ana.

tātai whakamahia

Hei tauira, ka taea te huaina nga tīwae hou hanga te "Tau", "Marama", "Marama-tau." Ki te tiki i te raraunga e tatou hiahia i roto i ia tetahi o ratou e whai ki te rēhita i te tātai motuhake mo te tātaitanga:

• Ko te "Annual" kōkuhu te tātai o te puka: "= TAU" (uhinga ki te rā).
• Me kō Marama e te faaiteraa: "= MARAMA" (ano ki tohutoro ki te rā).
• I roto i te tīwae tuatoru o te puka whakauru tatou te tātai "= CONCATENATE" (uhinga ki te tau me te marama).

Runga i, kitea tatou toru tīwae ki te raraunga taketake katoa. Na haere ki te tahua "Summary", pāwhiri i runga i tetahi wāhi kau i roto i te tepu i runga i te pātene kiore matau, a ka i roto i te whakatuwheratia tahua horopaki tīpako i te tūemi "Update". Kia whai whakaaro! Āta tuhituhi tātai i roto i Excel RipangaKaurori, rite tetahi hape e arahi ki hapa forecasting.

Me pēhea te ki te whakahaere i te tātari o hoko raraunga?

pēhi ano tatou i te pātene kiore maui pāwhiri i te "Tau", a ka toia te reira ki te "Ingoa Tīwae", a ka tīmata te tepu whakarāpopoto whakaatu nga hua o te ahua ngā o hoko hua puta noa i nga tau katoa. A, ki te hiahia koe ki te tātari tika hoko marama? Waihoki, pēhi tatou te LMB "Marama", e kukume ana i te reira i raro i te tīwae ā-tau.

Ki te tiki i te akiakinga ataata o ngā rerekētanga ā-marama i roto i te hoko i runga i te tau, te "Marama" ki te toia tika i roto i te tīwae ā-tau, oho mua i roto i te "Ingoa Tīwae". I muri whakaoti i tenei taahiraa, ka kite koe i te tepu i roto i te whakaaturanga e whai ake nei:

• Ko te nui o hoko o te hua ngā mo katoa o nga tau.
• Ko te akiaki a te hoko o ia o ratou i runga i nga tau.

Tangohia nga raraunga o te issuance

Me kī e te take o, e ti'a ia tatou ki te tango i te raraunga Oketopa, na e kore matou e whai tatauranga whānui i runga i te reira. Ko te tepu whakarāpopototanga titiro "Tātari Report", a ka toia te reira ki te "Tau - Marama".

puta tātari runga ake te tepu wahi e hiahia ana koe ki te hoatu i te pouaka i te taha ki te "Tīpakohia tūemi maha." I muri i taua, ko te rārangi e puta, wetetaki Oketopa, a ka pāwhiri i runga i "OK".

Ko te kupu, ka taea e koe te tāpiri i me te tango i nga mea timatanga tātari, hanga he akiaki tino me e hiahia ana koe whakamātautau. Tātaitia aunoa i te hōtaka i te tatauranga mo te hunga marama i roto i nei e hiahia koe, mārama whakaata i te akiaki o te huringa tohu.

titau tatou i haurangi

Whakamātauria ki matapae i te hua o hoko mo etahi wa ki te haere mai. Ki te mahi i tenei, kia mono koutou nga hua mua-ngā e kore i hanga e ratou he hapa i roto i te matapae i hanga.

Ki te mahi i tenei, hoatu te pehu i roto i te "Tapeke Grand", ka pāwhiri i runga i te pātene "Tangohia te tapeke rahi." I muri iho, te whakahou aunoa o te tikanga Excel RipangaKaurori whakaahuatia i runga tatou (pāwhiritia i runga i te pātene kiore matau, tīpako "Update").

Ka rite ki te hua, kei te ngaro i to tatou tepu whakarāpopototanga enei raraunga. Hei hanga i te kanohi ataata o matapae i runga i te hoko, hoatu te pehu ki te tau, e e whakamahere ki te hanga i te tīmatanga, me ka pāwhiri tatou te mahue pātene kiore i runga i te pātene "tauira Apiti forecasting."

I muri i taua i reira ko te kauwhata ataahua, me te kōrero aroaro i roto i te puka ataata nga hua e tūmanakohia ana o mahi kiritaki i runga i ngā matapae. Tenei ka whakaora koutou pūngao, me te whakaora i te moni e taea te poto i runga i te mea tino tika te hoko o taonga.

whakamahi tatou ētahi atu puna raraunga mo te hanganga o te RipangaKaurori

Ko te wa ki te whakaaro haapiiraa Excel matatini ake. Ka taea te hanga i te tepu whakarāpopototanga i runga i te pūtake o te tuhinga e kua ētita e ētahi atu kaiwhakamahi.

E tauturu mahi tatou "Hanumi". e āhei ana tēnei hōtaka ki a koutou ngā aunoa i te kuputuhi o te tuhinga me te wāhitau tika, ingoa ranei ētahi atu mōhiohio e tika ana ki te hanga i matapae whaiaro e i roto i tenei take, me te hiahiatia te.

hanumi mahi i roto i te putanga i muri o te "tari" kore i puta ke nui whakaritea ki te Office 2003. Otiia uiui pātengi raraunga ki te tīpako i te pūtake raraunga taea te whakamana ki te whakamahi o Microsoft Query. Ki te tiki i te whakarāpopototanga raraunga Excel ripanga, me whai koe i rua ngā:

• Kei roto i te tuhinga matua te mōhiohio e hiahia ana koe, me te mara tohu hōtaka Excel, te raraunga ki te kia whakaurua ki roto ki te tuhinga. Ko te tepu matua ko te tuhinga paerewa, ripanga, engari me whakapūtā koutou i roto i te Hanumi kōrero (Kaiāwhina Hanumi Mēra), te aha kia whakamahia reira rite te tuatahi.
• Kei roto i te pūtake raraunga te mōhiohio e he e tika ana mo te faaineineraa o te matapae. Ka taea e koe te hanga i tētahi ripanga hou i roto i te ara e kua tuhu matou i roto i runga ake.

A, no te te tukanga o te hanga o ngā tuhinga whakarāpopoto, hangaia e te hōtaka kotahi kape mo ia o nga pūkete roto i roto i te kōnae pūtake raraunga. taea te whakaatu i ēnei kōnae i roto i te wāhanga motuhake o te tuhinga hou, whakamahia hei arai o koutou tepu kaurori ranei.

He Kotahi anake ki pāwhiri i runga i te mara e hiahiatia ana o koutou pātene kiore maui, a ka taea e kite koe i te pūtake o te raraunga hei utu o nga ingoa mara e puta i roto i te tuhinga matua. Ka taea te kōkuhu mara i tetahi wahi i roto i te tuhinga.

kāwai whakamahia

Hoki e taea e koe te whakamahi i ASK kāwai, e te tikanga "rapu" ko FILLIN aha te tikanga o te reira ki "whakakiia" te NEXT ko NEXTIF, ELSE. Ka taea hoki e ki nga tawhā o te ngā matapae e whakaaturia e koe rangi i roto i te ripanga whakamutunga. Kimihia he taea mā te whakamahi i te tātari motuhake e ranei te tomokanga e hiahiatia ana kōmaka noa nga raraunga, rite kua mea matou i runga.

A, no te e rite ki te waihanga i tētahi tuhinga ariki koe, Hanumi pouaka kōrero taea te kaiwhakamahi ki te tautuhi me te whakatika i te tahi mau hape i mua i tupu ratou. A, no te takina mea katoa te, ka taea e koe pēhi humarie te pātene "Hanumi". Ki te, Heoi, kia kawea te hanumi i mā te ī-mēra, ka ākina kia koe ki te tāuta i te hōtaka mēra (ki te kore i kē tāuta koe).

I roto i te take te wahi i reira ko tetahi pohehe, ko reira i roto i te tukanga o te mau a'oraa hanumi e pā ana ki te mara hē tohua i roto i tetahi atu tuhinga, ranei ki te whakamahi i ko te raraunga i roto i te hōputu tautokona. Na reira, ano kia arotake tenei tukanga.

I roto i te whānui, Excel (mahi ki RipangaKaurori i roto i nei kua kite tatou) e āhei kore anake tātari āhua matatini o te mana hoko, engari ano ki te hanga a ratou i runga i te pūtake o matapae.