Nigute ushobora gukora imbonerahamwe yinkingi muri excel

Guhitamo no kongeramo imbonerahamwe yinkingi kurupapuro

Kugeza ubu, nta bwoko butandukanye bwo gushushanya muri excel, ugomba rero guhitamo uburyo bukwiye uhereye kurutonde rusange, witondera ibintu bisa gusa. Kugirango ukore ibi, bizakenerwa kugirango ufungure urutonde rwimbonerahamwe yose kandi uzimenyerewe kubiganiro byabo.

1. Nibiba ngombwa, byerekana ameza hafi ya gahunda yubatswe, kandi niba ari wenyine kurupapuro, ahita ujya kuri tab "shyiramo".



2. Kanda kuri "Imbonerahamwe Yasabwe" kugirango werekane urutonde rwifuzwa.



3. Ako kanya ufungure "imbonerahamwe zose", kubera ko urutonde rusabwa rutagaragaza inyandikorugero. Mbere ya byose, reba ubwoko bwa "Histogramu", nikihe.



4. Menya ubwoko bwubwubatsi no guhitamo niba bizaba ishusho nini cyangwa imirongo yoroshye.



5. Himura indanga hejuru yimwe mu mbonerahamwe yo kureba imikorere yayo no guhitamo niba bikwiranye n'ameza.



6. Kanda inshuro ebyiri buto yibumoso ukurikije amahitamo, nyuma yaho bizahita byongerwa kurupapuro, kandi urashobora gukomeza gukomeza kwerekana igishushanyo.

Mugihe uhitamo igishushanyo, witondere kandi uburyo agaciro kameza kazerekanwa kugirango iyo iyo wize ikintu, ibiyirimo bihita byumvikana kandi biboneka. Kugira ngo ibyo bishoboke, birashobora kuba ngombwa guhitamo ubundi bwoko bw'imbonerahamwe, urugero, "Guhana", bizagaragaza amasomo yo kuzamurwa cyangwa amafaranga.

Ibi birimo kandi ubwoko "guhuzwa" - niba gitunguranye igishushanyo kitagomba kuba inkingi gusa, ahubwo yerekana izindi mashusho, nk'ingingo cyangwa imirongo itambitse.

Guhindura ibikubiye mu gishushanyo

Muri make, tuzasesengura igenamiterere rusange ryigishushanyo nyuma yo kongerwa kurupapuro, urebye guhindura ibirimo. Mubisanzwe byubaka amashoka ya auxique cyangwa videwo yo guhindura ibice ntabwo ari ngombwa, ariko niba ari ngombwa, uzaba uzi ibikorwa byose nkenerwa kugirango bicwe.

1. Kuyigaragaza hamwe nizina rihuye risobanura intego rusange yigishushanyo. Shyira ahagaragara guhagarika hamwe nanditse, ukureho inyandiko iriho hanyuma ukande.



2. Niba ukeneye guhindura imwe mubisho, kanda kuri yo kabiri kugirango werekane menu. Ngaho urashobora guhindura ingano yumupaka n'amacakubiri, ongeraho axis ya auxiliary cyangwa gutunganya igiciro cyimibare kugirango ugaragaze neza indangagaciro.



3. Iyo ukanze inshuro ebyiri kumwanya nyamukuru, iboneza ryuzuye bizagaragara, aho ushobora gushiraho ibara iryo ariryo ryose, Gradient nkinyuma, cyangwa no gukuramo ishusho.

Niba ejo hazaza uzakenera gukora andi mashusho, koresha kuriyi ngingo murwego rwa menu na menu byasobanuwe nibipimo. Birahagije gusa kumenyera ibikorwa biboneka kugirango wumve icyo umuntu akwiriye.

Guhindura imiterere yimiterere itatu

Hanyuma, tubona ko imiterere yimiterere itatu yigishushanyo mbonera cyibishushanyo byinkingi yuburi bwoko, hiyongereyeho tumaze kuvuga haruguru. Mburabuzi, ishusho nkiyi ni urukiramende rukwiranye nabakoresha bose. Guhindura imiterere, kora gukanda couple:

1. Banza ukemure umurongo wo guhindura kugirango ugaragare ingingo hafi ya buri nkingi ku mbonerahamwe.



2. Kanda imwe muribo hamwe na buto yimbeba iburyo no muri menu, kanda kuri "Imiterere yamakuru".



3. Urutonde rwibishushanyo bihari bizagaragara, aho biguma gusa kwerekana amahitamo yifuzwa.



4. Garuka kumeza kandi urebe neza ko impinduka zitangira gukurikizwa.

Mu zindi ngingo kurubuga rwacu uzasangamo amakuru menshi ashobora kuba ingirakamaro mugihe ukorana n'imbonerahamwe y'inkingi. Kanda imwe mumitwe kugirango usome amabwiriza arambuye.

Soma Byinshi:

Gukora igishushanyo muri Microsoft Excel Imbonerahamwe

Kubaka imbonerahamwe kumeza muri Microsoft Excel

Uburyo bwo gukuraho Imbonerahamwe muri Microsoft Excel