Nigute ushobora gucamo inkingi ku nkingi muri excel

Ihitamo 1: Gutandukana nimibare

Reka dutangire hamwe numwuka woroshye winkingi muri excel, indangagaciro zirimo imibare imwe. Ku bitureba, ibyo ni ibihumbi n'ibihumbi, bitandukanijwe na koma - ibi biragaragara mu ishusho ikurikira.

Igikorwa ni ugugabana ibihumbi n'ibihumbi mu nkingi zitandukanye, zishobora gukenerwa no kubara muri ayo mafaranga. Hano urashobora rwose gukora udakora amayeri, ukabaza igikoresho cyubatswe muri gahunda.

1. Hitamo inkingi ushaka kugabana, hanyuma ujye kuri tab.



2. Kanda ahanditse "Inkingi. Nibyo, nubwo igikoresho gifitanye isano ninyandiko, ntizibuza ikintu cyose kubikoresha kumafaranga, amatariki cyangwa izindi mibare.



3. "Idirishya rikwirakwiza abapfumu" Idirishya rigaragara, aho uhitamo amahitamo "hamwe nabatandukana" hanyuma ujye ku ntambwe ikurikira.



4. Nkikimenyetso cyo gutandukanya, sobanura icyo kimenyetso gikoreshwa mu nkingi. Niba bidashoboka kubiranga hamwe na ikimenyetso, kora "ubundi" no gushyiramo iki kimenyetso.



5. Mucyitegererezo amakuru yicyitegererezo, reba uburyo inkingi zisa nyuma yo gutandukana.



6. Imiterere ya Data usige byose cyangwa gushiraho itariki yabyo niba ari kubigeraho.



7. Mburabuzi, inkingi nshya ishyirwa muri mugenzi wawe, ariko urashobora kwigenga uhitamo umwanya.



8. Intoki andika ako gace cyangwa ubitonde kumeza.



9. Iyo ibikorwa byo gukwirakwiza birangiye, kanda "Kurangiza" kugirango ushyire mubikorwa bishya.



10. Gusubira kumeza, uzabona ko byose bikorwa neza. Bizasigara kugirango uhindure bike - kurugero, komeza gutandukana cyangwa gushiraho formulaire kumeza.



11. Tuzagaragaza ko nta tandukaniro muburyo bwamagari, kandi kuri wewe mugihe cyo kurangiza aya mahitamo ukeneye gusa kwerekana neza ikimenyetso gitandukanya hamwe n'ahantu ushaka gushyira inkingi nshya. Ibindi bikorwa byose bikorwa mu buryo bwikora.

Niba ufite ameza ufite imibare ihinduka ushaka kugabana buri gihe ku nkingi, soma amabwiriza ukurikije amahitamo akurikira, asobanura kurema formula mugihe ugabanye inyandiko. Birakwiriye imibare, gusa ibisabwa bigomba guhindura bike kubwabo.

IHitamo 2: Gutandukana

Kugabanya inyandiko ku nkingi, amategeko amwe arakurikizwa, ariko hariho inzira ya kabiri - gukora formula igoye izakora inkingi ebyiri cyangwa nyinshi hamwe namakuru kandi azaba yuzuza mu buryo bwikora mugihe uhindura. Iki nikikorwa kitoroshye, kugirango ukemure bikenewe mubyiciro, nabyo byeguriwe indi ngingo.

Soma birambuye: Gutandukanya inyandiko muri Microsoft Excel