Nigute ushobora gukora ikadiri mubuhungiro

Anonim

Nigute ushobora gukora ikadiri mubuhungiro

Ihitamo rya 1: Ongeraho imbibi

Benshi mubakoresha bashishikajwe no kongeramo imipaka kumeza muri Excel. Ibi birashobora kandi gufatwa nkubwoko bwimiterere ibonwa hamwe numubare munini wibipimo biboneka. Shakisha bose hanyuma uhitemo icyifuzo gikwiye mumabwiriza atandukanye kurubuga rwacu.

Soma birambuye: Gutanga imbibi z'ameza muri Excel

Gukora imipaka kumeza mugihe wongeyeho ikadiri muri Excel

Niba ubu buryo bwo kongeramo imipaka kumeza ntibikwiranye, uhite ujya muburyo bwa 3 kugirango ukemure ibyaremwe imiterere ngendanwa, nyuma ishobora guhagarara ahantu heza.

Ihitamo rya 2: Ongeraho impapuro

Imirima yamababi irashobora kandi kwitirirwa ikadiri, ariko ntabwo ifite ibara ryashushanyije, kandi ibikorwa bireba inyandiko yose. Ihitamo rikwiranye no kurangiza gutegura ameza ryo gucapa kandi birakenewe mugihe ushyira imirima biterwa nibisabwa mumushinga.

  1. Kugirango turusheho gukora ibindi bikorwa, turabisaba guhita tujya ahagarariye "Page Page".
  2. Hindura kugirango urebe urupapuro rwa page kugirango ukore amakadiri mumirima muri Excel

  3. Muri yo, fungura ka tab hamwe nizina rimwe.
  4. Gufungura Urupapuro rwamakuru kugirango ukore imirima nkurupapuro kurupapuro rwa Excel

  5. Kwagura imirima kugirango uhitemo igenamiterere rihari.
  6. Gufungura menu hamwe nimirima iboneka kugirango ubeho nk'urupapuro kurupapuro rwa Excel

  7. Koresha uburyo busanzwe cyangwa ujye kuri "imirima yihariye" kugirango ukore igenamiterere ryawe.
  8. Jya kumirima yihariye kugirango ubeho nkurupapuro kurupapuro rwa Excel

  9. Idirishya rishya rizakingura, aho ushobora gushyiraho intoki ingano yumurima kuri buri ruhande rwurupapuro, hanyuma ukoreshe impinduka.
  10. Gushiraho imirima ya Custom kubakora nk'urupapuro kurupapuro rwa Excel

  11. Reba uko byagenze, hanyuma usubire muburyo busanzwe niba ukeneye gukora indi mbonerahamwe yo guhindura imbonerahamwe. Muri ubu buryo, imirima ntizizarerwa, izarokora akazi.
  12. Ikiremwa cyiza cyo kurema nkikibabi muri excel

Ihitamo rya 3: Gukora ikadiri

Ibara ridasanzwe rikubiyemo kongerera ibintu byose biboneka utujuje imbonerahamwe, ariko hamwe numuzunguruko wihariye. Mugihe kizaza, urumuri rushobora kwimurwa ahantu hose kurupapuro kugirango tugaragaze ibikubiye cyangwa dutanga ikindi gishushanyo.

  1. Ibindi bikorwa byose bikorwa kuri tab "shyiramo", kugirango uhite ubimukire.
  2. Jya kuri menu yo kwinjiza kugirango ukore ikadiri idasanzwe muri Excel

  3. Kwagura "ikigereranyo", aho urutonde rwimiterere ya geometrike ihari.
  4. Gufungura menu kugirango ushiremo mugihe ukora akarere kidasanzwe muri excel

  5. Fungura "imibare" yamanutse.
  6. Gufungura urutonde rwa geometrike kugirango ukore ikadiri ukogabisha muri excel

  7. Muri yo, shakisha imwe mumibare ikwiranye nawe, imiterere yacyo igomba gufata ikadiri kazaza.
  8. Guhitamo imiterere kugirango ukore ikadiri idasanzwe muri Excel

  9. Shiraho ingano kuri yo no gushira ahantu heza kumeza.
  10. Ikibanza cyishusho mbere yo gukora ikadiri kidasanzwe muri Excel

  11. Kanda ku gishushanyo hamwe na buto yimbeba iburyo hanyuma ufungure "Imiterere Imiterere".
  12. Jya ku gishushanyo cyo gukora ikadiri kidasanzwe muri excel

  13. Muri ibipimo, guhagarika ibyuzuye, biranga ikintu kijyanye.
  14. Kureka kuzuza ikadiri kidasanzwe kuva ku gishushanyo muri Excel

  15. Kuri "ibara", shiraho igicucu cyikadiri.
  16. Gushiraho ibara ryikadiri yumuzunguruko uhereye ku gishushanyo iyo ubishyiremo neza

  17. Ongera ubugari bwayo kugirango ubone byinshi bigaragara.
  18. Guhindura ingano yumuzenguruko kugirango uyishyireho neza

  19. Garuka kumeza hanyuma wimure ikadiri aho ukeneye.
  20. Kurenza ibyiza byerekana imiterere ya geometrike muri Excel

Aho kugirango urukiramende, urashobora guhitamo rwose imiterere ya geometrike hanyuma ukureho kuzuza kugirango ubone akantu wifuza.

Ihitamo 4: Ongeraho ikadiri yishusho

Mu bwuzuye, tuzasesengura ihame ryo kongeramo ikadiri ishusho, niba gitunguranye ari ngombwa gukora. Ibikorwa bisa nabyo twaganiriye mugihe ukora igishushanyo mbonera.

  1. Binyuze kuri tab imwe, ongeraho ishusho, niba ibi bitakozwe kare.
  2. Jya gushyiramo amashusho kugirango wongere ikadiri kugirango wirinde kuri yo

  3. Guhuza mubunini hanyuma uhitemo ahantu kurupapuro.
  4. Shyiramo amashusho kugirango wongere ikadiri kuri yo muri Excel

  5. Kora Kanda iburyo ku ishusho ku ishusho hanyuma ujye iburyo bwa "imiterere yishusho".
  6. Jya kuri icyitegererezo kugirango wongere ikadiri kugirango uyikesheho.

  7. Ntugomba gukoraho igice cyuzuye, ariko mumurongo ", reba" umurongo ushikamye ".
  8. Guhindukira kuri kontour kuva kumurongo kugirango wongere ikadiri kumashusho muri excel

  9. Hitamo ibara rikwiye n'ubugari bwumurongo kumurongo.
  10. Guhindura imiterere kugirango wongere ikadiri kumashusho muri excel

  11. Igisubizo kizahita kigaragara mumeza, ushobora kubona, ugaruka kureba ishusho.
  12. Guhindura imiterere kugirango wongere ikadiri kumashusho muri excel

Soma byinshi