Mahi ki tepu "Excel": taahiraa i tohutohu taahiraa, āhuatanga me te tūtohutanga

Te nuinga o ngā kaiwhakamahi rorohiko i runga i ngā pūnaha Windows e hāngai ana i runga i te huinga e tino e fehangahangai Microsoft Office ki tono MS Excel. I roto i ngā kaiwhakamahi tauhou hōtaka ai te tahi mau fifi i roto i te whanaketanga, ahakoa te mahi "Eksele" ki te kore e pera uaua rite kia mea he i mawhiti tuatahi, ki te mohio koutou i te mau parau tumu whakatakotoria iho i roto i te Annex tātai me tepu.

He aha te mea Excel?

Ere Ko Excel he mīhini pāngarau oti ki te mahi i te plurality o tauhanga, taurangi, pākoki, me ētahi atu ngā mahi matatini atu na roto i te whakahaere te maha o ngā momo raraunga taketake, e kore e pā ana tonu te reira ki te pāngarau.

Mahi ki tepu "Excel" fakahu'unga te whakamahi o atu whai wāhitanga ki te uniana me te rorohiko, me te kuputuhi mania, me rongorau. Otiia i roto i tona hōtaka puka taketake i hanga reira āta rite te ētita pāngarau kaha. Etahi, Heoi, tangohia te tono tuatahi mo tetahi tātaitai ki ngā āhuatanga arā atu anō. hapa hohonu!

Jobs "Eksele" ki tepu mō tīmata: mohio tuatahi ki te atanga

Ko te mahi tuatahi i muri i te whakatuwheratanga i te hōtaka, kite te kaiwhakamahi te matapihi matua, e kei te mana taketake me te taputapu mo te mahi. I roto i te putanga i muri, puta te matapihi, ka tīmata koe i te tono, e opua nei ki te hanga i tētahi kōnae hōu, i te taunoa i huaina "pukapuka 1" tīpako i te tauira mō te mahi anō ranei.

Mahi ki "Excel" ripanga mō tīmata i runga i te atamira tuatahi o te mohio ki kia te hōtaka kia iti ïa ki te waihanga i tētahi ripanga kau. Ahakoa whakaaro tatou i te huānga taketake.

ni'ai mara Main te tepu iho, e wehea nei ki ngā pūtau. Kei te taua ia, whakawhetai ki te taunga e rua-ahu - te ti'araa tau aho, me te tīwae reta (hei tauira, te tango i te Excel 2016). hiahiatia ana tēnei taua i roto i te tikanga ki roto i te ririki tātai taea āta tāutu rite nga raraunga pūtau, ka kia hua te mahi o nei.

Mai i runga ake, pera i roto i te tahi atu tono tari, i reira te mea he rōpū o te tahua matua, a tika i raro - taputapu. I raro i reira i reira ko te raina motuhake te wahi tomo koutou te tātai, me te iti ake ki te maui taea kite koe i te matapihi ki te taunga o te pūtau hohe tēnei wā (i te mea he tapawhā). E whakaatu ana rōpū raro nga pepa, me te kaupapa whakapae o te rēreti, a i raro i he reira momo pātene pana me te zoom. Ki te tika, ko te Unuhia poutū o te pepa ki te neke ake / iho.

momo Basic o mahi tāuru raraunga me te kararehe pūtau

I te tuatahi, kua riro te reira e te mahi i roto i te "tepu Eksele 'e te kaiwhakamahi mō te tīmata ki te kia whakamahia ki reira nga ngā mahi maheni, hei tauira i roto i te kaiwhakatika kuputuhi taua Kupu.

I mua, e taea te hanga te tepu, he mahi tārua, he raraunga whakauru whakairo ranei, tomo kuputuhi raraunga tau ranei.

Ko maka ana i te iti rerekē i te tetahi hanga i roto i te ētita kuputuhi. Ko te meka e te tīmatanga whirihora te hōtaka ki te mohio ki aunoa aha tuhituhia te kaiwhakamahi i roto i te pūtau hohe. Hei tauira, ki te tomo koutou te aho 01/02/2016, ka kia mohio nga raraunga rite te rā, me te i roto i te pūtau hei utu o nga tau ka tomo ka waiho te rā i roto i te puka māmā - 02/01/2016. Hurihia te hōputu whakaatu e taea e rawa ohie (reira i taua he iti i muri mai).

A pera ko reira ki tau. Ka taea e koe te tomo tetahi raraunga tau, ara ki te maha te noho o nga wahi ira, a ka whakaaturia e ratou i roto i te puka i roto i nei e katoa o ratou whakamahia ki te kitenga. Otiia, ki te tomo koutou he tau tōpū, ka tukua atu, kahore mantissa (wahi ira rite ngā kore). Huri he taea ano hoki.

Ko e oti koutou, e tamata maha kaiwhakamahi tauhou ki te neke ki te pūtau muri mā te whakamahi i te mau taviri pere papapātuhi (rite ki pehea e taea te mahi i te reira i roto i tepu Kupu). A e kore e mahi i te reira. Te aha? Ko anake no te mea he rerekē i te kupu ētita kuputuhi rawa tino te mahi ki "Excel" ripanga. kia kawea ai te whakawhiti i mā te pēhi i te tomo matua mā te whakanoho i te tapawhā hohe ki tetahi atu pūtau mā te whakamahi i te pāwhiri kiore maui ranei. Ki te i muri i tuhi te tahi mea i roto i te pūtau hohe, pēhia Esc, ka kia whakakorea tāuru.

Hohenga ki te pepa

Mahi ki pepa meinga tuatahi e kore kia fifi. I runga i te rōpū raro he pepa pātene tāpiri motuhake i muri i te pēhi e ka waiho he tepu hou ki whakawhiti aunoa ki reira, me te te tauwhāiti he ingoa ( "Rau 1", "Whārangi 2", ko D. na i runga i.).

pāwhiri-Double, ka taea e koe te whakahohe i te whakaingoa i tetahi o ratou. Hoki, ka taea te whakamahi tahua pāwhiri-matau ki te karanga ake he tahua atu, te wahi i reira he he torutoru whakahau taketake.

hōputu pūtau

Na te mea tino nui - hōputu o te pūtau - tetahi o nga ariā taketake, i te mea he aha whakatau te momo o te raraunga kia e ka whakamahia mo te aronga o ona tirotiro. Ka karangatia hoki hōputu whakatika ko taea i roto i te tahua pāwhiri-matau, te wahi tīpakohia aho tika te mā te pēhi i F2 ranei.

Ko te matapihi i runga i te maui whakaatu hōputu katoa e wātea ana, a ka whakaatu te tika te kōwhiringa mō te whakaatu raraunga. Ki te titiro koe i te tauira ki te wā e whakaatu ana i runga ake, pera tīpakohia te hōputu te, "Rā", me te tika ki te whakaturia te puka e hiahiatia ana (hei tauira, 1 Pepuere 2016).

Ka taea te whakamahi ētahi o hōputu ki te kawe i ngā mahi pāngarau, engari i roto i te take māmā, tīpako Number. I te tika, i reira e rave rahi ngā momo o te whai wāhi, te atatohu ki te maha o ngā mati i muri i te ira i roto i te mara mantissa me te whakanoho i te kaiwehe rōpū. Mā te tahi atu hōputu tau (taupūtanga, hautanga, te moni, me te pera i runga i. D.), rawa, e taea te whakaturia te tawhā e hiahiatia ana.

Na roto i te taunoa, whakaturia āhukahuka raraunga aunoa i te hōputu noa. Otira ka pato koe i te torutoru pukapuka ranei noa e taea te te hōtaka tahuri reira ki te tahi mea atu. Na reira, ki te tomo kuputuhi he tika mo te pūtau hohe ki te whakaturia te kōwhiringa e tika ana.

Mahi i roto i "Excel" ki tātai (tepu): Tauira

Hei whakamutunga, he torutoru nga kupu e pā ana ki ngā tātai. Hoki te tīmatanga, kia whakaaro tatou i te tauira o te moni o tau e rua i roto i te A1 ko A2. Ko te tono ngā pātene aunoa aofangatuku ki etahi mahi atu (te tātaitanga o te tauhanga, mōrahi, mōkito, me pera i runga i. D.). Noa tāuta Ko te pūtau hohe i roto i te tīwae kotahi, i raro, me te pai rawa o te moni ka kiia reira aunoa. Ko te taua mea mahi hoki nga uara whakapae, engari e hiahia ana hoki te nui o te pūtau kaha ki te hoatu tika.

Ko taea e koe te tomo i te tātai ā (mahi ki tepu "Excel" me fokotu'u mai he pea taua ka kore te whakaratohia te mahi aunoa). Hoki kia te nui ano i roto i te pae tātai ki te taurite te me te whakahau i te mahi o A1 + A2 ranei SUM (A1: A2), a ki te hiahia koe ki te tautuhi i te whānuitanga o ngā pūtau, te whakamahi i te puka i muri i te tohu rite: (A1: A20), i muri i nei e te reira Tātaitia te reira i te moni o te tau katoa i roto i nga pūtau i te tuatahi ki te rua tekau, whakakotahi.

Tūtohi

Mahi ki tepu "Excel" he ngā ano i roto i taua whai wāhi te whakamahi o motuhake rauhanga taputapu aunoa me hoahoa e hāngai ana i runga i te awhe i tīpakohia.

Hoki tenei whakaaro, he pātene motuhake i runga i te rōpū, i muri i te pāwhiri i runga e koe e taea te tīpako i tetahi tawhā titiro hiahiatia ranei. I muri iho, tūtohi kauwhata ranei whakaaturia i runga i te pepa hei whakapakoko.

Cross-hononga, kawemai raraunga me te kaweake

Ko te hōtaka e taea te tāuta hoki kōrero raraunga i ngā rau rerekē, te whakamahi i ripeka-tohutoro ki ētahi atu kōnae hōputu ahanoa ranei i roto i tūmau i runga i te Ipurangi, me maha atu tāpiri-ake.

I tua atu, e taea te kaweake i ngā kōnae Excel ki ētahi atu hōputu (hei tauira, PDF), tārua raraunga i a ratou, a pera i runga i. D. Ko e taea te hōtaka whakatuwhera kōnae hanga i roto i te tahi atu tono (hōputu kuputuhi, pātengi raraunga, ngā whārangi Tukutuku, XML- tuhinga, a na i runga i. d.).

Ka rite ki a koutou e taea te kite, te taea he ētita tata mutunga. A, o te akoranga, ki te whakaahua a ratou he noa te katoa e kore te wa nui. Tenei ko nga taketake o te tīmata tika, engari ka whai i te kaiwhakamahi hiahia ki te pānui i ngā mōhiohio whakamārama, ki te rangatira te hōtaka i te taumata teitei.