Ko te huānga matua o te ripanga, ko te ... Ko te āhuatanga taketake o te ripakaute Excel

Katoa kaiwhakamahi PC hou, kotahi fehangahangai ki ngā hōtaka Microsoft Office, he teie mahana tetahi o te noa tino, e matau ana ia e ko te reira whakahauanga hakari tono MS Excel. Na titiro tatou ki te ariā taketake o ripakaute. Te taha te ara, ka hoatu ki a te whakarāpopototanga o te āhuatanga matua o te hanganga o te tepu o ngā huānga me raraunga, me etahi o ratou āhuatanga.

He aha te mea he ripanga Excel?

Ko te whakahua tuatahi o Excel, e pā ana ki te 1987, ka tukua Microsoft tona rūma tari tino rongonui o ngā hōtaka, me tono, i raro i te taitara whānui o MS Office.

I roto i te meka, te ripanga Excel ko te tikanga ao o te tukatuka raraunga pāngarau o ngā momo me ngā taumata o te uaua katoa. Kei roto i tēnei pāngarau me te taurangi, me te āhuahanga, me te pākoki, me mahi ki te tāhū, me te tātari pāngarau, me te otinga o te pūnaha tino matatini o ngā whārite, me te ake. O ngā mea katoa e pā ana ki te pūtaiao tangohia o te mahere aroaro i roto i te hōtaka. mahi Ripakaute He pera e maha ngā kaiwhakamahi e kore ka ratou e kore e matau e pā ana ki a ratou, e kore ratou e ite pēhea te kaha tenei pūmanawa. Ko nga mea tuatahi te tuatahi.

Getting Started ki ripakaute

Ka rite ki oroko te kaiwhakamahi te hōtaka Excel, kite ia he tepu hanga i te tātauira taunoa pera-ka karanga. Kei roto i te rohe te mahi matua o nga rarangi, me tīwae, tona pūtahitanga hanga te pūtau. I roto i mahara ki te mahi ki te katoa momo raraunga, te huānga matua ko te pūtau ripanga, mai te mea te reira e whakahaerea e ratou.

kua he raupapa taua tënei o te haupae me te tīwae iku'anga ia pūtau, Heoi, i roto i putanga rerekē o te tono kia rerekē. Hei tauira, i roto i te putanga 2003 Ko te pūtau tuatahi, kei i te pūtahitanga o te tīwae «te» me «1» raina, tuku ki rite te «A1». I roto i te putanga 2010, kua puta ke tenei huarahi. Here māngai te momotuhi te rite te raupapa o ngā tau, me tau, engari te whakaahuatanga o tīwae i roto i te rarangi whakaritea rite «C», me te rārangi - rite te «R». e kore e tokomaha matau te mea kua hono reira. Ko he kuware mea katoa: «R» - te reta tuatahi o te rarangi kupu Ingarihi (tau rarangi), a «C» - te tīwae reta kupu tuatahi (he tīwae).

Ko te raraunga whakamahia

Whakahua e te huānga matua ko te pūtau ripanga, kia mohio ki taua mea e pā anake tenei ki nga raraunga tāuru (ngā uara, kuputuhi, tātai, ngā hononga mahi, me ētahi atu). kia whai i te hōputu rerekē nga raraunga i roto i te pūtau. Ka taea te huaina hōputu Cell huringa mahi i te tahua horopaki , ina pāwhiri koe i runga taua mea RMB (pātene kiore matau).

Ka taea te aroaro raraunga i roto i te kuputuhi, tau, ōrau, momotuhi pūtaiao, moni (moni), hōputu hautanga me te wa, me te he rā. I tua atu, ka taea e koe te whakapūtā tawhā atu momo o nga wahi ira ranei i te whakamahi i ngā tau.

Ko te matapihi hōtaka matua: Hanganga

Ki te titiro koe tata ki te matapihi tono matua, ka taea e kite koe i e i roto i te putanga paerewa i roto i te tepu e taea i roto ake ki 256 tīwae me ngā haupae 65,536. I te raro o te pepa ripa e whakaritea. I roto i to ratou kōnae hou e toru, engari e taea ki te whakaturia me te ake. Ki te amo tatou e te huānga taketake ko te whārangi o te ripanga, kia pēnei tenei ariā ki te ihirangi i runga i ngā rau rerekē o te raraunga rerekē e taea te whakamahi ina te tauwhāiti ripeka tātai tika mahi ranei.

He tino whai hua taua ngā mahi ka hanga i te tepu whakarāpopototanga, pūkete, ranei ngā pūnaha tātai matatini. kia hoki tatou mea e tātai te aroaro i runga i ngā rau rerekē e pā ana hua raraunga o te huringa o ngā pūtau ririki me pepa e aunoa kahore anō-tomo i te tātai mahi ranei e faaite te hononga ngā o taurangi me aumou.

Kei runga i te tihi o te paraharaha paerewa ki te tahua taketake torutoru, tika i raro i te pae tātai. A paraparau o te raraunga i roto i roto i te pūtau, e taea te mea te reira e te huānga matua ko te ripanga, me te huānga kaha, i roto i mai whakaatu te nuinga o rarangi he kuputuhi ranei raraunga tau tomo ki te pūtau te tātai ranei me te fakafalala mahi. I roto i ngā o tātai haupae whakaatu pūtau me te taua. Heoi, hoki te hōputu rarangi e hāngai ana momo raraunga o te mahi ranei. Reira anake te tikanga o te mātakitaki me te patopato.

Tātai i roto i te ripakaute Excel

Ki te whakaaro ki te tātai o te hōtaka he maha. Etahi o ratou kahore e matau tokomaha a Nick. O te akoranga, ki te mahi ki te katoa o ratou, he reira taea ki āta pānui i te aratohu tohutoro taua, Heoi, whakarato te hōtaka i tētahi whai wāhitanga me te tukanga aunoatanga motuhake.

Mā te pāwhiri i runga i te maui pātene taha «f _x» (ranei te tohu "="), ki he rārangi i nei tīpako i te mahi e hiahiatia ana, e ka whakaora i te kaiwhakamahi i whakauru ā tātai.

He he ano hoki tetahi atu taputapu nuitia whakamahia. Tenei TapekeAunoa taumahi aroaro i roto i te puka o ngā pātene i runga i te paeutauta. Here, rawa, koe e kore e whai ki te tomo i te tātai. Ko reira nui ki te whakahohe i te pūtau i roto i te rarangi me te tīwae muri te awhe tīpakohia, te wahi e mahara ai ki te hanga i te tātai, ka pāwhiri i runga i te pātene. A e kore ko te tauira anake tenei.

rau tūhonohono raraunga, ngā kōnae, me ripeka-tohutoro

Ki te whakaaro ki te hononga haumitanga, ka taea te piri tetahi pūtau me te whārangi raraunga i te wāhi rerekē o te tuhinga, image mata raraunga o te rauemi Ipurangi hōtuhi whakamahi ranei. Reira ka taea noa ki a koutou te whakaora te mokowā kōpae, me te whakaiti i te rahi o te tuhinga taketake. O te akoranga, me pehea ki te hanga i taua hononga i ki tino matau. Engari kia rite ki te mea ratou, e hiahia ai.

Tāpiri-mai, hoahoa me ngā tūtohi

I roto i ngā o taputapu atu me ngā āhuatanga whakarato ripakaute MS Excel te kaiwhakamahi ki te kōwhiringa whānui. E kore e ki te whakahua i te tāpiri-mai motuhake ranei hōtuhi Java kawe me te Visual Basic, ka arotahi ki te hanganga o taonga ataata whakairoiro mātakitaki o ngā hua tātari.

Ko reira mārama e ki te utu i te tūtohi ranei kua hangaia kauwhata i runga i te pūtake o te maha nui o ngā raraunga ririki ā, me ka kōkuhu i te whakairoiro ki te tepu i roto i te kōnae kotahi te pikitia piri ranei he kore ki te katoa, me te hiahia.

Ko Ko te aha te whakamahi o te hanganga aunoa o te kōwhiringa-mua o te puka, me te momo. Ko reira mārama e hāngai ana ratou i runga i ngā wāhanga raraunga motuhake. Ka rite ki te wā i roto i te hanga kauwhata me ngā hoahoa e taea te tohe e te huānga matua ko te ripanga rohe maha o ngā wāhanga i runga i ngā rau rerekē ranei rerekē kōnae tāpirihia, ka e kia tangohia i te uara o ngā taurangi me ngā hua tätaitanga ririki ranei tīpakohia.

Hoatu ngā tātari

I roto i ētahi wā, kia rapu ai i te whakamahi o whiriwhiringa motuhake tāutatia i runga i tetahi atu ranei tīwae. I roto i tona puka māmā, e tauturu te reira ki te rapu mō raraunga, kuputuhi, ranei uara i roto i taua tīwae. A, no te ka kia whakaaturia te tāpiritanga o ngā hua i kitea katoa wehe.

Ki te mea i reira e pararau, ki tetahi tīwae o te raraunga tātari e whakaatu i ētahi atu uara kei roto i te tahi atu tīwae me nga rarangi. Ko Ko te tauira tino māmā tenei, no te mea ia tātari ritenga he ona tahuaroto ake ki paearu rapu tauwhāiti tautuhinga motuhake ranei.

mutunga

O te akoranga, kia whakaaro i roto i te tuhinga kotahi nga āhuatanga katoa o te mōkihi pūmanawa MS Excel e taea noa. I te iti rawa i konei e taea kite koe i ngā tūemi e i roto i te papa matua i runga i te kaupapa o ia take takitahi ranei āhuatanga, me te he iti moka ki matau, na ki te korero, ki te taketake o te mahi i roto i tenei hōtaka ahurei. Ko mo tona whanaketanga tonu ka whai ki te mahi pakeke. E mea pinepine ngā ratou kahore e matau i nga wa katoa te mea he ahei ratou tamaiti.