Pogwira ntchito ndi matebulo, nthawi zambiri pamakhala zochitika, kuphatikiza pazonse, ndikofunikira kugulitsa apakatikati. Mwachitsanzo, patebulo la malonda a mwezi, momwe mzere uliwonse umafotokozera kuchuluka kwa ndalama kuchokera kugulitsa mtundu wina wa zinthu patsiku, mutha kuwonjezera magawo tsiku lililonse kuchokera kugulitsa zinthu zonse, ndipo kumapeto kwa tebulo kumawonetsa kuchuluka kwa ndalama zonse zomwe zimachitika mwezi uliwonse. Tiyeni tiwone momwe mungapangire subtotals mu Microsoft Excel.
Zoyenera kugwiritsa ntchito
Koma, mwatsoka, si onse matebulo ndi madatabase omwe ali oyenera kutsatira mawu ang'onoang'ono kwa iwo. Miyezo yayikulu ikuphatikiza:
- tebulo liyenera kukhala momwe limakhalira lachilengedwe;
- mutu wa tebulo uyenera kukhala ndi mzere umodzi, ndi kuyikidwa pamzere woyamba wa pepalalo;
- tebulo siliyenera kukhala ndi mizere yopanda kanthu.
Pangani mawu ang'onoang'ono
Kuti mupange subtotals, pitani ku "Data" tabu ku Excel. Sankhani khungu lililonse pagome. Pambuyo pake, dinani batani la "Subtotal", lomwe lili pa riboni m'bokosi la "Stform".
Kenako, zenera limatseguka momwe mukufuna kukhazikitsa zomwe zimatuluka. Mu chitsanzo ichi, tiyenera kuwona ndalama zonse zomwe zimapezeka tsiku lililonse. Mtengo wa deti uli mgulu la dzina lomweli. Chifukwa chake, mu "Nthawi iliyonse mukasintha", sankhani "Date".
Pagawo la "Ntchito", sankhani "mtengo", popeza tifunika kugunda kuchuluka kwa tsikulo. Kuphatikiza pa kuchuluka, ntchito zina zambiri zilipo, zomwe ndi:
- kuchuluka;
- pazambiri;
- ochepa;
- ntchito.
Popeza mitengo yamisonkho imawonetsedwa mu "Revenue kuchuluka, pikirani.", Kenako mu gawo la "Onjezani ngongole ndi", timasankha pamndandanda wazipilala.
Kuphatikiza apo, muyenera kuyang'ana bokosi, ngati silinaikidwe, pafupi ndi "Sinthani matani apano". Izi zikuthandizani kuti mulinganizenso tebulo, ngati mukuchita kuwerengetsa nthawi yayitali, osati kubwereza zomwe zili m'matchulidwe omwewo mobwerezabwereza.
Ngati mungayang'ani bokosi "Mapeto a masamba pakati pa magulu", pomwe musindikiza, gawo lililonse la tebulo lokhala ndi mawu osindikizira lidzasindikizidwa patsamba lina.
Mukayang'ana bokosi moyang'anizana ndi mtengo "Totals under the data", mawu am'munsi adzaikidwa pansi pa mzere wa mizere, kuchuluka kwake kumayikidwa. Ngati simukutsatira bokosili, ndiye kuti zotsatira zake zikuwonetsedwa pamizereyo. Koma, ndiogwiritsa ntchito iye yemwe amasankha momwe angakhalire wabwino. Kwa anthu ambiri, ndikosavuta kuyika masanjidwewo pansi pa mizere.
Mukamaliza kusintha kwamtundu wamtundu wonse, dinani batani "Chabwino".
Monga mukuwonera, mawu ang'onoang'ono adawonekera patebulo lathu. Kuphatikiza apo, magulu onse a mizere yophatikizidwa ndi kamtunda kamodzi akhoza kuwonongeka ndikungodina zilembo zakumanzere kwa tebulo, moyang'anizana ndi gulu lenileni.
Chifukwa chake, ndizotheka kugwetsa mizere yonse patebulopo, kusiya zotsalira zapakatikati ndi zotsalazo.
Tiyeneranso kudziwa kuti posintha zosankha m'mizere ya tebulo, gawo lawo liziwonjezedwa zokha.
Fomula "INTERMEDIATE. RESULTS"
Kuphatikiza apo, ndizotheka kuwonetsa ma subtotals osati kudzera pa batani pa tepi, koma mwa kugwiritsa ntchito mwayi wokhoza kuyitanitsa ntchito yapadera kudzera pa batani la "Insert Function". Kuti muchite izi, mutatha kuwonekera pafoni momwe timawu tadzawonetsera, dinani batani lomwe lasonyezedwa, lomwe lili kumanzere kwa baramu yodula.
Wizard wa Ntchito akutsegulidwa. Zina mwa mndandanda wa ntchito zomwe tikuyang'ana "INTERMEDIATE. RESULTS". Sankhani, ndikudina batani "Chabwino".
Iwindo limatseguka pomwe muyenera kulowetsamo zotsutsana. Mu mzere "Nambala Yantchito" muyenera kuyika nambala ya imodzi mwasankhidwe khumi ndi imodziwo kosakanizira deta, ndiyo:
- masamu amatanthauza mtengo;
- kuchuluka kwa maselo;
- kuchuluka kwa maselo odzazidwa;
- mtengo wokwanira pazosankhazi zosankhidwa;
- mtengo wocheperako;
- zopangidwa ndi deta m'maselo;
- zitsanzo zopatuka;
- kuchuluka kwa anthu;
- Kuchuluka
- zitsanzo kusiyanasiyana;
- kusiyanasiyana ndi kuchuluka.
Chifukwa chake, timalowa m'mundamu nambala yomwe tikufuna kugwiritsa ntchito mwanjira inayake.
Mu gawo "Link 1" muyenera kutchulapo ulalo wa maselo omwe mukufuna kukhazikitsa mfundo zapakati. Kukhazikitsidwa kwa mipata inayi yosiyanayi ndikuloledwa. Mukawonjezera zogwirizira zama cell angapo, zenera limawonekera nthawi yomweyo kuti lingathe kuwonjezera mitundu ina.
Popeza kulowa mndandanda pamanja sikothandiza pa zochitika zonse, mutha kungodina batani lomwe lili kumanja kwa fomu yolowetsera.
Nthawi yomweyo, zenera la ntchito lidzachepetsedwa. Tsopano mutha kusankha zosankha zomwe mukufuna ndi chikhazikitso. Pambuyo kuti ingolowa mu mawonekedwe, dinani batani lomwe lili kumanja kwake.
Ntchito yotsutsana ndi ntchito imatsegulanso. Ngati mukufuna kuwonjezera mtundu umodzi kapena zingapo zazomwezo, ndiye kuti timawonjezera malinga ndi algorithm yomweyo monga tafotokozera pamwambapa. Kupatula apo, dinani batani "Chabwino".
Pambuyo pake, mawu am'munsi mwa magawo omwe asankhidwa adzapangidwa mu khungu momwe mapangidwe ake.
Kuphatikizika kwa ntchitoyi ndi motere: "INTERMEDIATE. RESULTS (function_number; ma adilesi a array_cell). M'malo mwathu, mawonekedwewo azitha kuwoneka motere:" INTERIM. RESULTS (9; C2: C6). "Ntchito iyi ikhoza kulowa maselo pogwiritsa ntchito syntax. ndipo pamanja, osatcha Wizard Yogwira Ntchito, muyenera kukumbukira kuyika chikwangwani cha "=" kutsogolo kwa formula yomwe ili mchipindamu.
Monga mukuwonera, pali njira ziwiri zazikulu zopangira zotsatira zapakatikati: kudzera pa batani pa riboni, ndi njira yapadera. Kuphatikiza apo, wogwiritsa ntchitoyo ayenera kudziwa phindu lomwe lidzawonetsedwa monga kuchuluka: kuchuluka, kuchuluka, kuchuluka, mtengo, ndi zina zambiri.
