Nigute washyiramo ishusho mumeza ya Excel. Shyiramo kandi ushireho ishusho muri Excel

Imirimo imwe ikorwa mumeza ya Excel Imbonerahamwe isaba kongeramo ibishushanyo hamwe namafoto kumakuru ya tabular. Porogaramu ifite ibikoresho byinshi bigufasha gushyiramo ishusho. Mu kiganiro, tuzasesengura uburyo bwinshi bwo gushyira mu bikorwa ubu buryo mu buryo burambuye: binyuze mu kurinda urupapuro rukora, uburyo bw'abaterankunga no kongera inyandiko ku rupapuro rw'akazi.

Ibiranga kwinjiza amashusho

Ongeraho neza urupapuro rwakazi rwumurimo wabigenewe, birakenewe ko ishusho ubwayo iherereye kuri disiki ikomeye ya PC cyangwa ku bitangazamakuru bivanwaho bihujwe nayo.

Shyiramo amashusho kurupapuro

Gutangira, tusobanura uburyo uburyo bwo kwinjiza buri kumwanya wakazi, hanyuma tumenye uburyo bwo kongeramo ifoto muri selile runaka. Intambwe ya On-Intambwe isa nkiyi:

1. Dutanga guhitamo selile duteganya kumenya igishushanyo. Twimukiye mu gice cyitwa "Shyiramo", riherereye hejuru yuruganda rutunganye. Turahasanga agace k'amategeko "ikigereranyo" no gukanda ikintu "ishusho".

imwe

1. Idirishya ryerekana idirishya ryitwa "kwinjizamo kwinjiza". Bisanzwe byahoraga byerekanwe mububiko bwishusho. Birashoboka kwimura mbere yububiko noneho ishusho duteganya kwinjiza ku rupapuro rwakazi rutunganya. Ubundi buryo - kuguma mumadirishya amwe, jya mububiko bwa mudasobwa yawe hamwe nibitangazamakuru byakuweho. Iyo umaze kurangiza amahugurwa, muguhitamo ishusho, kanda kuri buto "Paste".

2.

1. YITEGUYE! Ishusho yifuzwa yagaragaye kumpapuro zakazi zitunganya ibicuruzwa. Birakwiye ko tumenya ko igishushanyo kidafatanije na selile iyo ari yo yose yinyandiko. Tuzavuga kubijyanye ningingo nyuma gato.

Guhindura amashusho 3

Reka tuganire ku buryo bwo guhindura ishusho yinjijwe kugirango bigereranye neza, guhuza ureba urupapuro rwakazi rutunganya. Intambwe ya On-Intambwe isa nkiyi:

1. Kanda kuri PKM yinjije. Ecran yerekana ibikubiyemo, bigufasha guhindura imwe cyangwa ikindi gipimo. Hitamo ikintu cyitwa "Ingano n'umutungo".

Bane

1. Idirishya rito ryitwa "Imiterere yimiterere" yagaragaye kubyerekanwa. Hano hari umubare munini wibipimo bihinduka bikwemerera guhindura imitungo yishusho. Igenamiterere ryibanze: ingano, igicucu, gutemangira, ingaruka zitandukanye nibindi. Umubare munini wimiterere washyizweho kugirango uyikoresha ashobora guhindura ishusho yinjijwe kubikorwa bitandukanye.

bitanu

1. Niba bidakenewe kugirango uhindure irambuye ishusho yinjijwe, noneho ntituzakenera idirishya "ingano nimitungo". Ubundi buryo bwo guhindura amahitamo - Jya mu gice cyinyongera "Gukorana nibishushanyo", uherereye hejuru yumwanya wameza.

6.

1. Niba dushaka gushyiramo amashusho muri selire, ugomba guhindura ishusho kugirango ibipimo byayo bihure nubunini bwa selire ubwayo. Ingano yo guhindura ikorwa nuburyo bukurikira: binyuze muri "ingano na mira"; Kwimura imbibi zo gushushanya ukoresheje LKM; Ukoresheje ibikoresho bya kaseti, kimwe na menu.

7.

Gushushanya amashusho

Nyuma yo gukora manipiteri yose yasobanuwe haruguru, ishusho yinjijwe mugihe icyo aricyo cyose cyakomeje kuba intagondwa kugeza kuri selire. Kurugero, niba uyikoresha akoresha gutondekanya amakuru kurupapuro rwakazi, selile zizahindura ibibanza byazo, kandi ishusho izakomeza kuba ahantu hamwe yinjijwemo. Mubutungabutabwo hari uburyo bugufasha guhuza ishusho kuri selile yanditse. Reka tuganire kuri ibi muburyo burambuye.

Uburyo 1: Kurinda urupapuro

Kurinda urupapuro rwakazi ruva muburyo butandukanye ni bumwe muburyo bwo gukurura ishusho kuri selile. Intambwe ya On-Intambwe isa nkiyi:

1. Dushyira mu bikorwa ikigo cyimiterere yishusho munsi yubunini bwa selire kandi tugasohozamo uburyo bwasobanuwe haruguru.

umunani

1. Kanda kumashusho yinjijwe. Ibikubiyemo bito biragaragara. Kanda kuri "Ingano n'umutungo".

icyenda

1. Mugaragaza "Imiterere yimiterere" yagaragaye kuri ecran. Twimukiye mu gice cya "Ingano" kandi tumenye neza ko ingano yishusho itarenze agaciro ka selile. Byongeye kandi, uremeza neza ko hari agasanduku kegereye igenzura "kubika ibipimo" kandi "ugereranije nubunini bwambere". Niba hari umutungo udahuye hejuru, uhindure.

10

1. Mu idirishya rimwe dusangamo igice "imiterere" hanyuma tukimukire. Niba nta bimenyetso biri hafi yibintu bya "Icapa Ikintu" n "ikintu kirengera", noneho bagomba gutangwa. Turabona "ikintu gihambiriye ku murongo" umutungo hanyuma ushire ikimenyetso hafi "kwimuka no guhindura ikintu hamwe na selile". Nyuma ya Manipulations, kanda kuri buto "gufunga", iherereye hepfo yidirishya ryimiterere.

cumi n'umwe

1. Ukoresheje urufunguzo rwo guhuza "CTRL +" Mwandikisho, dutanga gutanga urupapuro rwose rukora. Hamagara ibikubiyemo hanyuma ukande kumurongo wa selire ... ".

12

1. Idirishya ryagaragaye kuri ecran yitwa "imiterere ngendanwa". Jya ku gice cya "Kurinda" hanyuma ukureho ikimenyetso ku mitungo yakingiwe. Nyuma ya Manipulations yose, kanda kuri buto ya "OK", iherereye hepfo yidirishya.

13

1. Noneho tutanga guhitamo akagari aho ishusho yinjijwe iherereye, duteganya kwomeka. Uburyo bwasobanuwe haruguru bugenda mu idirishya "selire", ukoresheje menu. Na none kandi, twimukira mu gice "Kurinda" kandi iki gihe dushyira akamenyetso iruhande rw'umutungo "urinzwe". Nyuma yo gukora manipulations zose, kanda kuri "Ok".

cumi na bine

1. Jya kuri "gusubiramo", uherereye hejuru yimbonerahamwe yameza. Shakisha aho bita "impinduka" hanyuma ukande kuri "urupapuro rweruye".

cumi na batanu

1. Idirishya ryerekana idirishya ryitwa "kurinda urupapuro". Muri "ijambo ryibanga kugirango uhagarike uburinzi bwibibabi", utware ijambo ryibanga. Kanda kuri buto ya "OK". Irindi dini ryagaragaye kubyerekanwa, aho ukeneye kongera kwinjira ijambo ryibanga.

cumi na gatandatu

1. YITEGUYE! Twishimiye selile hamwe nishusho yinjizwa mubihinduka byose. Muyandi magambo, igishushanyo cyometse kuri selire.

Uburyo 2: Shyiramo ishusho mu nyandiko

Ukoresheje ICYITONDERWA, Urashobora kandi guhambira amashusho. Intambwe ya On-Intambwe isa nkiyi:

1. Tugasanduku kuri PKM ku kigari dushaka gushyiramo ishusho. Ibikubiyemo bito byagaragaye. Kanda ku kintu cyitwa "Shyiramo Icyitonderwa".

17.

1. Idirishya rito rigaragara kuri ecran, rikwemerera kwandika inyandiko. Himura icyerekezo kuri Windof ikadiri hanyuma ukande kuri yo. Ecran yerekana menu nshya. Kanda kuri "Inyandiko Imiterere".

cumi n'umunani

1. Idirishya rishya ryagaragaye kuri Explow, ryagenewe gushiraho inyandiko. Twimukira mu gice cya "amabara n'imirongo". Turabona umutungo "wuzuze" kandi uhishure urutonde rwigicucu mumabara "ibara". Ku rutonde rwahagaritswe, kanda uburyo bwo kwandika "bwo kuzura ...".

cumi n'icyenda

1. Idirishya ryerekanwe aho ushobora guhitamo uburyo bwuzuye. Himura igice cya "Igishusho", hanyuma ukande ku kintu "gishushanya ...".

makumyabiri

1. Tumenyereye muburyo bwavuzwe haruguru bwo gushiramo ishusho yasobanuwe haruguru. Duhitamo icyitegererezo. Nyuma yo gufata manipuline zose, kanda kuri buto "Paste", iherereye hepfo ya "Shirceon Shyiramo" idirishya.

21.

1. Ishusho yatoranijwe yerekanwe muburyo bwa "Ubuntu". Dushyira akamenyetso kuruhande rwanditse "tubika ibipimo byo gushushanya". Nyuma y'ibikorwa byose, kanda kuri "Ok".

22.

1. Tugarutse kuri "Inyandiko Imiterere". Twimukiye mu gice cya "Kurinda". Kuraho ikimenyetso hafi yo kwandika "ikintu kirengera".

23.

1. Twimukiye mu gice cya "Umutungo". Muri "guhuza ikintu kuri inyuma" guhagarika, dushyira akamenyetso kuruhande "kwimuka no guhindura ikintu hamwe na selile". Nyuma yo gukora manipulations zose, kanda kuri "Ok".

24.

1. YITEGUYE! Tumaze gushyira mu bikorwa inzira zose zasobanuwe haruguru, ishusho ntiyari yongewe gusa ku nyandiko, ahubwo yometse ku kagari. Birumvikana ko ubu buryo budakwiriye rwose imirimo yose yakemuye ukoresheje ameza, kuko bifite aho bigarukira.

25 Uburyo 3: Uburyo bwabatezimbere

Urashobora guhambira ishusho kumurongo ukoresheje uburyo budasanzwe "abatezimbere", ihujwe muburyo bwo gutunganya. Ingorane nyamukuru - uburyo burahari. Mu ntangiriro, tuzabikora. Intambwe ya On-Intambwe isa nkiyi:

1. Jya mu gice cya "dosiye", hanyuma uhitemo "ibipimo".

26.

1. Mu idirishya ryagaragaye, jya ku gice cya "Kase. Twashyize akamenyetso iruhande rw'abatezimbere ". Nyuma ya Manipulations, kanda "OK".

27.

1. Dutanga guhitamo akarere twifuza gushyiramo icyitegererezo. Jya ku gice cyiterambere, cyagaragaye hejuru yimbonerahamwe yameza. Muri "Ongeraho" guhagarika, kanda "Paste". Kurutonde rwo gukanda kuri "ishusho", iherereye mubice bya Actix.

28.

1. Imyenda mike yubusa ubwoko bwubusa bwagaragaye muri selire. Dutanga umusaruro uhindura ingano kugirango ishusho ikwiranye na selire yatoranijwe. Guhindura tubishyira mubikorwa byimuka imbibi na LKM. Kanda PCM kumurongo. Ibikubiyemo bito byagaragaye, muri kanda "imiterere".

29.

1. Ecran yerekana idirishya. Kuruhande rwibitabo "hashyirwaho" shyira igice. Mu murongo "ifoto" dusangamo igishushanyo muburyo bwingingo eshatu hanyuma ukande kuri buto yimbeba yibumoso.

mirongo itatu

1. Idirishya ryongeraho ishusho. Turabona igishushanyo twifuza gushyiramo. Turabigaragaza, hanyuma ukande kuri buto "fungura", iherereye hepfo yidirishya.

31.

1. Iyo umaze kurangiza inzira zose, funga idirishya. Ishusho yifuzwa yinjijwe muri kasho. Ibikurikira, birakenewe kubyara inzira yo guhambira ishusho kuri selile. Dushyira mu bikorwa uburyo bwo guhitamo icyitegererezo no kwimukira ku gice cya "page Mariko", giherereye hejuru y'ameza. Turahasanga "gutunganya" kandi duhitemo "guhuza". Kurutonde rwurutonde, kanda kuri "Ihambiriye kuri gride" hanyuma wimuke gato mumahanga.

32.

1. YITEGUYE! Nyuma yo gushyira mubikorwa inzira yavuzwe haruguru, twagiye duhuza ishusho muri selire.

Umwanzuro

Mu mbonerahamwe yameza, excel hari uburyo bwinshi bwo kwinjizamo ishusho no kuyihuza na selile, ariko ntabwo buri buryo bukwiye gukemura imirimo yose. Kurugero, uburyo bushingiye ku gukoresha inoti ahubwo hashyizweho hapi, kandi "uburyo bwa" Utezimbere "n" "Kurinda urupapuro" - Uburyo rusange bukwiriye kubakoresha bose.

Ubutumwa uburyo bwo gushiramo ishusho mumeza ya Excel. Shyiramo kandi ushyireho ishusho kuri Excel wagaragaye mbere kugirango ubone amakuru yamakuru.