Zamkatimu
Chimodzi mwazinthu zamphamvu kwambiri mu Excel ndikutha kupanga mafomula. Mutha kugwiritsa ntchito ma fomula kuti muwerengere zatsopano, kusanthula deta, ndi zina zambiri. Koma kugwira ntchito ndi mafomu kuli ndi zovuta zake - kulakwitsa pang'ono ndikokwanira kuti fomuyo ipereke zotsatira zolakwika.
Choyipa kwambiri, Excel sikuti nthawi zonse imanena zolakwika mu fomula. Monga lamulo, chilinganizo choterocho chikupitiriza kugwira ntchito ndi kuwerengera, kupereka zotsatira zolakwika. Udindo woti ndinu waulesi kwambiri kuti muyang'ane fomula uli ndi inu.
Talemba mndandanda wa malangizo omwe mungagwiritse ntchito kuti muwone ngati mafomu omwe adapangidwawo ali olondola. Malangizo awa sangathetse vuto lililonse lomwe mungakumane nalo, koma adzakupatsani chida chodziwira zolakwika zambiri.
Onani maulalo
Mafomu ambiri amagwiritsa ntchito selo limodzi. Ngati mudina kawiri pa fomula, ndiye kuti malire a ma cell onse omwe atchulidwa adzawonetsedwa. Mutha kuyang'ananso ulalo uliwonse kuti muwonetsetse kuti ndiwolondola.
Fufuzani zololeza
Kulakwitsa kofala ndiko kugwiritsa ntchito maumboni olondola a cell koma molakwika. Mwachitsanzo, ngati mukufuna kuchotsa C2 of C3, formula iyenera kukhala: =C3-C2, osati monga izi: =C2-C3.
Patulani
Ngati ndondomekoyi ndi yovuta kwambiri kuti muyesedwe, yesani kuigawa m'njira zingapo zosavuta. Chifukwa chake, mutha kuwona kulondola kwa fomula iliyonse, ndipo ngati pabuka mavuto, mudzadziwa komwe kuli.
Ganizirani zomwe zotsatira zake ziyenera kukhala
Mutha kugwiritsa ntchito zomwe mwakumana nazo, kuganiza mozama komanso mwanzeru kuti muwone zomwe zotsatira zake ziyenera kukhala. Ngati zotsatira mu Excel ndizokulirapo kapena zazing'ono kuposa momwe amayembekezera, pangakhale zolakwika mu fomula (kapena zolakwika m'maselo).
Mwachitsanzo, ngati muwerengera ndalama zonse 8 mayunitsi a katundu 98 masenti pa chilichonse, zotsatira zake ziyenera kukhala zochepa $8. Muchitsanzo chomwe chili pansipa, chilinganizochi chimapereka zotsatira zolakwika. $ 784,00. Chifukwa chake ndikuti mu cell A2 mtengo umalowetsedwa ngati 98, ndipo ziyenera kukhala 0,98. Monga mukuonera, zinthu zazing'ono zimatha kupanga kusiyana kwakukulu.
Kumbukirani kuti chinyengo ichi sichitha nthawi zonse. Nthawi zina, yankho lolakwika lingakhale loyandikira kwambiri kwa lolondola. Komabe, nthawi zambiri, kuwunika mwachangu koteroko kumawonetsa zolakwika mu fomula.
Onani Zotsutsana
Ngati mukugwira ntchito ndi ntchito, onetsetsani kuti mfundo zonse zofunika zaperekedwa. Mukalowa ntchito, chida chaching'ono chokhala ndi mfundo zofunikira chiyenera kuwonetsedwa.
Zothandizira ndizothandiza makamaka pamene mukuyesera kukonza chinthu chomwe sichikuyenda bwino. Mwachitsanzo, yang'anani ntchito ili m'munsiyi:
Mu chitsanzo mu chithunzi pamwambapa, ntchito MASIKU A NETWORK (NETWORKDAYS) imabweretsa zolakwika. Ngati tiyambitsa ntchito MASIKU A NETWORK (NETWORKDAYS) kupita ku selo lina, chifukwa chake chimakhala chodziwikiratu:
ntchito MASIKU A NETWORK (NETWORKDAYS) amafuna mikangano iwiri yosachepera − tsiku loyambira (start_date) ndi tsiku_lomaliza (tsiku_lomaliza). Muchitsanzo chapitachi, mkangano umodzi wokha unaperekedwa, kotero tiyeni tikonze ntchitoyi powonjezera mtsutso womwe ukusowa:
Tsopano chilinganizo chathu chimagwira ntchito bwino!
Onani mndandanda wonse wa ntchito (zotsatizana)
Kumbukirani masamu akusukulu momwe masamu amayendera? Ngati sichoncho (kapena ngati mukufuna kutsitsimutsa kukumbukira kwanu), mutha kuphunzira phunziro la kupanga mafomu ovuta. Excel nthawi zonse amagwiritsa ntchito dongosolo ili, ndiye kuti, ntchito sizimangochitika motsatana kuchokera kumanzere kupita kumanja. Muchitsanzo chotsatirachi, sitepe yoyamba ndikuchulutsa, zomwe sizomwe tinkafuna. Tiyeni tikonze ndondomekoyi pomaliza D2+D3 m'mabulaketi:
Yatsani chiwonetsero cha fomula
Ngati pali mafomu ndi ntchito zambiri pa pepala la Excel, ndiye kuti zingakhale zosavuta kuti musinthe mawonekedwe kuti muwone mafomu onse nthawi imodzi. Kuti muchite izi, muyenera kugwiritsa ntchito lamulo Mawonekedwe a formula (Onetsani mafomu), omwe ali pa tabu Mafomu (Mafomu) gawo Formula auditing (Kudalira ma formula).
Kuti mubwerere ku mawonekedwe odziwika, dinaninso lamulo ili.
Kumbukirani, luso la mafomula limatheka kudzera mukuchita mosalekeza. Ngakhale ogwiritsa ntchito odziwa zambiri a Excel amalakwitsa pama formula. Ngati fomula yanu sikugwira ntchito kapena imakupatsani mtengo wolakwika, musachite mantha! Nthawi zambiri, pali kufotokozera kosavuta chifukwa chake fomulayo imalephera. Mukapeza cholakwika ichi, mutha kupanga kuti fomulayo igwire ntchito moyenera.