Ntchito yaakaunti

Akaunti ya opaleshoni ikutanthauza ntchito zochulukirapo. Ntchito yake yayikulu ndikuwerengera pamitundu yotchulidwa yomwe ili ndi chidziwitso. Tiyeni tiphunzire zambiri mwatsatanetsatane mbali zosiyanasiyana za kugwiritsa ntchito fomulayi.

Kugwira ntchito ndi akaunti ya wothandizira

Akaunti ya ntchito imanena za gulu lalikulu la ogwiritsa ntchito, zomwe zimaphatikizapo pafupifupi zinthu zambiri. Ili pafupi kwambiri ndi ntchito yanu ntchito ya akaunti. Koma, mosiyana ndi nkhani ya zokambirana zathu, zimatengera maselo odzazidwa ndi deta iliyonse. Nkhani ya wothandizirayo yomwe tikhala tikukambirana mwatsatanetsatane ma cell odzaza ndi deta.

Ndi deta iti yomwe ikukhudzana ndi manambala? Izi ndi zina mwa manambala enieni, komanso tsiku ndi nthawi. Mfundo Zofunika ("Choonadi", "Bodza" Ngati ali m'deralo pepalalo, lomwe limatchulidwanso ndi mkanganowo, ndiye kuti ogwirira ntchito sawaganizira. Zoterezi ndi kuimira kwa manambala, ndiye kuti kuchuluka kwa manambala kumalembedwa m'mawu kapena kuzunguliridwa ndi zizindikiro zina. Apanso, ngati akutsutsana mwachindunji, amatenga nawo mbali pakuwerengera, ndipo ngati ali pa pepalalo, savomereza.

Koma pokhudzana ndi lemba loyera lomwe manambala sapezeka, kapena olakwika ("# za milandu / 0!", #) Zinthuzi ndi zosiyana. Mfundo zoterezi nkhani ya ntchito sizimaganizira mwanjira iliyonse.

Kuphatikiza pa ntchitozo, nkhaniyo ndi akaunti yowerengera maselo odzaza ikukhudzidwabe kwa ogwiritsa ntchito mamita ndi owerengeka. Kugwiritsa ntchito njirazi, mutha kuwerengera zowonjezera. Gulu ili la ogwiritsa ntchito masitepe amadzipereka pamutu.

Phunziro: Momwe mungawerengere kuchuluka kwa maselo odzaza

Phunziro: Nchito za Statection

Njira 1: Mwini ntchito

Kwa wogwiritsa ntchito wosadziwa, ndizosavuta kuwerengera maselo omwe ali ndi manambala pogwiritsa ntchito njira yogwiritsira ntchito wizard.

1. Dinani pa cell yopanda kanthu pa pepala lomwe zotsatira za kuwerengera zidzawonetsedwa. Dinani pa batani la "phala ntchito".

   

   Pali njira inanso yoyambira mfiti. Kuti muchite izi, mukasankhidwa ndi maselo, muyenera kupita ku "njira". Pa tepi mu "ntchito ya Library", dinani pa batani la "phala ntchito".

   

   Pali njira ina, mwina yosavuta, koma nthawi yomweyo imafuna kukumbukira bwino. Timatsindika khungu papepala ndikukanikiza kuphatikiza zazikulu pa kiyibodi ya France + F3.

2. Pazochitika zonse zitatu, maluso aluso ayamba. Kuti mupite pazenera la zotsutsana m'gulu la "Statestical" kapena "mndandanda wathunthu wa zilembo" Tikufuna akaunti ". Tikuunikira ndikudina batani la "OK".

   

   Komanso, zenera lotsutsa zitha kukhazikitsidwa mwanjira ina. Tikutsindika khungu kuti muwonetse zotsatira zake ndikupita ku "njira". Pa riboni mu "ntchito ya Library", dinani pa "ntchito zina". Kuchokera pamndandanda womwe umawonekera, udzabweretsa cholozera kwa malo "owerengera". Mu menyu omwe amatsegula, sankhani "akaunti".



3. Zenera lotsutsana limayamba. Mkangano wokha wa fomulawu ungakhale mtengo woperekedwa ngati ulalo kapena wolembedwa mu gawo lolingana. Zowona, kuyambira kuchokera pa 2007, mfundo zoterezi zingakhale zophatikizika 255. M'matembenuzidwe akale analipo 30 okha.

   Mutha kuyika deta m'munda mwa kulemba zomwe zili mu cell kapena cell pa kiyibodi. Koma pomwe yolumikizira ikhale yosavuta kungoika cholozera m'munda ndikusankha khungu lolingana kapena malo papepala. Ngati magawo aliwonse, adilesi yachiwiri ingagwiritsidwe ntchito mu "Mtengo2", etc. Makhalidwe atalembedwa, dinani batani la "OK".



4. Zotsatira za kuwerengetsa maselo okhala ndi manambala mumitundu yodzipereka idzawonetsedwa m'malo oyambira papepala.

Phunziro: Mzere wa Wizard mu Excel

Njira 2: Kuwerengera pogwiritsa ntchito mkangano wowonjezera

Mwa chitsanzo pamwambapa, talingalira za momwe zikadalilirire zongokhalira zotsalazo. Tsopano tiyeni tiwone njira yomwe malingaliro adalemba mwachindunji pamtunda wokangana wagwiritsidwanso ntchito.

1. Mwa njira zilizonse zomwe zafotokozedwa moyambirira, thamangitsani zenera la ntchito ya akaunti. Mu "Trace1" Tsimikizirani adilesi yazomwe zalembedwa, ndipo mu gawo la "Mtengo Wanzeru" wokwanira mawu oti "Choonadi". Dinani pa batani la "OK" kuti muchite kuwerengera.



2. Zotsatira zimawonetsedwa m'dera losankhidwa. Monga tikuonera, pulogalamuyi imawerengera maselo omwe ali ndi manambala ndipo munthawi yonse yomwe tidawonjezera mtengo wina, zomwe tidalemba mawu oti "chowonadi" mu gawo. Ngati mawuwa adalembedwa mwachindunji m'chipindacho, ndipo m'munda pokhapokha pakanakhala cholumikizira, ndiye kuti sichingawonjezeredwe ku ndalama zonse.

Njira 3: Chiwonetsero cha Chikumbutso cha Formula

Kuphatikiza pa kugwiritsa ntchito mfiti ya ntchito ndi mikangano Koma chifukwa cha izi muyenera kudziwa syntax ya wothandizira uyu. Sizovuta:

= Sum (mtengo1; Mtengo2; ...)

1. Timadziwitsa mu cell kukhala mawonekedwe a formula molingana ndi syntax yake.



2. Kuwerengera zotsatira ndikutulutsa pazenera, dinani batani la Enter, itayikidwa pa kiyibodi.

Monga mukuwonera, izi zitatha izi, zotsatira za kuwerengera zimawonetsedwa pazenera mu khungu lomwe lasankha. Kwa ogwiritsa ntchito odziwa ntchito, njirayi ikhoza kukhala yofunika komanso yofulumira. Kuposa mmbuyomu ndi kuyimbira kwa wizard ya ntchito ndi zenera la zokangana.

Pali njira zingapo zogwiritsira ntchito akaunti, ntchito yayikulu yomwe ikuwerengera maselo omwe ali ndi chidziwitso cha manambala. Mothandizidwa ndi mtundu womwewo, deta yowonjezerayi imatha kuwerengetsa mwachindunji mu mawonekedwe a formula omwe amatsutsana kapena kujambula mwachindunji mchipinda malinga ndi katswiri wa wothandizira uyu. Kuphatikiza apo, pakati pa ogwiritsa ntchito masitepe pali njira zina zomwe zimachitika pakuwerengera maselo odzaza m'malo odzipereka.