Ka rite ki i roto i "Eksele" hanga momo tepu hiato

tepu whakarāpopoto he whakaaturanga pāhekoheko o te mōhiohio e taea ngā kaiwhakamahi ki te tātari ngā rōpū me moni nui o ngā raraunga i roto i te, te hanga ripa poto mō te ngāwari pūrongo me te tātari. Ko tētahi painga o tenei mahi i roto i te Excel ko e taea ai te reira ki a koutou te whakatika, huna me te whakaatu ngā kāwai rerekē i roto i te kōnae kotahi ki te whakarato i tētahi tirohanga kē o te raraunga. I roto i tenei tuhinga ka taea e koe te pānui i te tohutohu e pā ana ki te pehea, ki te "Eksele" hanga i te tepu.

Hipanga 1 o 3: Whirihora i te wahanga

Tīmata Microsoft Excel.

Pāwhiritia i runga i te tūemi tahua "Raraunga", me te ka tīpako i te tepu whakarāpopototanga (tuhipoka: i roto i te putanga o Excel 2007/2010, te mahi "Kōkuhu"> tepu whakarāpopototanga).

Whakapūtātia ki te kitea te raraunga e mea ana koe ki te ahuwhānui. Ki te he tenei kōrero i roto i te rārangi Excel e he tuwhera tēnei wā, whiriwhiri aunoa i te pūmanawa te awhe o ngā pūtau. Pāwhiritia "Next".

Me e tīpakohia te kōwhiringa "rārangi New" Kei muri i te pāwhiri i runga i te "Next" i te taahiraa o mua. Kia kua mahi koe e, pāwhiri "Mutu".

Hipanga 2 o 3: Me pēhea te ki te waihanga i te tepu i roto i "Eksele"

Ki te tika, te whakatika i te awhe i roto i te pouaka kuputuhi. E kei ēnei huanga i raro i te tūemi tahua "Tīpakohia te tepu." Ki te ko te waho, hanga i roto i te hōtaka motuhake (hei tauira, Access) te puna o ngā mōhiohio mō te tepu, pāwhiri i te "Whakamahia ngā pūtake raraunga waho." I muri i taua, kitea te tūemi tahua "Tīpakohia Hononga" a ka pāwhiri i runga i te pouaka kōrero ui "ngā Hononga".

Meinga te kōwhiringa o te wāhi ki te waihanga i te RipangaKaurori. Na roto i te taunoa, hangaia aratau Excel reira rite te whārangi hou ki te tāpiri ki te pukapuka. Te kōrero e pā ana ki te pehea, ki te "Eksele" hanga i te tepu kia i puta ai i runga i te whārangi homai, e hiahia ana koe ki te pāwhiri i runga i te pātene "ngā Rārangi" kōwhiringa, a ka whakapūtā te wāhi o te pūtau tuatahi i roto i te pouaka kuputuhi "Wāhi".

Pāwhiritia "OK". Na, tāpiri i te mātiti pātea hou mo te RipangaKaurori, a ka hiahia ki te whakaatu i te pihanga tūmahi "Āpure Rārangi RipangaKaurori." Kei te wehea tēnei rōpū ki e rua nga wahi.

Whakatūwhera te tūemi tahua 'Kōwhiri mara ki te tāpiri ki te pūrongo "ka whakakiia i nga ingoa katoa o nga mara i roto i nga raraunga pūtake.

whakakī

Ka rite ki i roto i "Eksele" hanga i te tepu? Tonu ki te kawe i nga tohutohu, kia whiwhi koe i te pouaka i runga i te mata, wehea ki ngā wāhanga mahi e wha, kia e whakapūtā te tātari, ngā tapanga tīwae, rārangi, me ngā uara.

Vahe ki mara i roto i te mahi "RipangaKaurori Rārangi Āpure" i roto i ona wahi ngā. Tōia te ingoa mara o te tūemi tahua 'Kōwhiri mara ki te tāpiri ki te pūrongo "i roto i ia o ngā rohe e whā.

Hanga whakarerekētanga rite tika ana tae noa kite koe i o koutou hua pai.

Hipanga 3 o 3: Understanding nga ngā taketake, pehea ranei ki te hanga i te tepu i roto i te "Eksele" māmā

Tuatahi o te katoa tamata ki te matau whakamāramatanga matua. He maha ngā ngā e kia, i mawhiti tuatahi, mea kerekere.

He aha te mea he tātari? Kei roto i tēnei rohe mara ki te rapu hoki i te kōrero i tohua i roto i te tepu whakarāpopototanga, na roto i te tātari a ratou e tetahi tohu. mahi ratou rite tohu mo te pūrongo. Hei tauira, ki te whakaturia koe te "Tau" rite te tātari, ka taea e koe te whakaatu i te raraunga whakarāpopoto i roto i te tepu hoki etahi wā o te wā mo te tau katoa ranei.

tīwae waitohu - tenei rohe, he mara tautuhi i te wāhi o ngā raraunga tohua i roto i te pou tepu whakarāpopoto kua.

Ngā Waitohu rarangi - mea rohe ngā te mara tautuhi i te wāhi o ngā raraunga ngā i roto i te rārangi.

Kei roto mara uara e whakapūtā te mea e māngai raraunga i roto i te pūtau o te RipangaKaurori. I roto i te mau parau te tahi atu, ko reira te mōhiohio whakaräpopototia e te roto i te tīwae whakamutunga (haaputuhia e te taunoa).

whakaaturia mara i te raraunga pūtake e tautapa koe he whārangi (tātari ranei) kei roto i te pūrongo RipangaKaurori.

ka tukua māramatanga o nga uara i runga, me pera me etahi atu tautuhinga ki a koe mahino pai pehea ki "Eksele" hanga i te tepu. Kia mahara ki e putanga rerekē o te hōtaka, kia rerekē te tahi mau tūemi tahua.