Maitiro ekusefa data muExcel nemuvara

MuMicrosoft Office Excel, kutanga kubva muvhezheni 2007, zvakave zvinogoneka kuronga nekusefa maseru etafura akarongwa nemuvara. Iyi ficha inobvumidza iwe kukurumidza kufamba patafura, inowedzera kuoneka kwayo uye aesthetics. Ichi chinyorwa chichavhara nzira huru dzekusefa ruzivo muExcel nemuvara.

Zvimiro zvekusefa nemuvara

Usati waenderera mberi nekufunga nzira dzekusefa data neruvara, zvinodikanwa kuongorora mabhenefiti ayo maitiro akadaro anopa:

• Kuronga uye kurongeka ruzivo, izvo zvinokubvumira kuti usarudze chidimbu chinodiwa cheplate uye nekukurumidza kuchiwana muhuwandu hwakawanda hwemasero.
• Masero akaiswa pachena ane ruzivo rwakakosha anogona kuongororwa zvakare.
• Kusefa neruvara kunoratidza ruzivo runoenderana nezvinodiwa.

Maitiro ekusefa data neruvara uchishandisa Excel yakavakirwa-mukati sarudzo

Iyo algorithm yekusefa ruzivo nemuvara muExcel tafura array yakakamurwa kuita anotevera matanho:

1. Sarudza huwandu hunodiwa hwemaseru neruboshwe mbeva bhatani uye enda kune "Kumba" tebhu iri mubharu repamusoro rechirongwa.
2. Munzvimbo inoonekwa muchikamu cheKugadzirisa, unofanirwa kutsvaga bhatani rekuti "Ronga uye Sefa" woriwedzera nekudzvanya pamuseve uri pazasi.

3. Mune menyu inooneka, tinya pane "Filter" mutsara.

4. Kana iyo sefa yawedzerwa, miseve midiki ichaonekwa mumazita ematafura etafura. Panguva ino, mushandisi anofanirwa kudzvanya LMB pane chero miseve.

5. Mushure mekudzvanya museve uri muzita rekoramu, menyu yakafanana icharatidzwa, iyo yaunoda kudzvanya paSefa nemutsetse wemavara. Imwe tebhu yekuwedzera ichavhura ine maviri anowanikwa mabasa: "Sefa nerusero ruvara" uye "Sefa nerudzi rwemavara".

6. Muchikamu che "Sefa neruvara rwesero", sarudza mumvuri waunoda kusefa iyo tafura yekubva nekudzvanya pairi neLMB.
7. Tarisa mhinduro. Mushure mekuita manipulations ari pamusoro, maseru chete ane ruvara rwakambotaurwa anosara mutafura. Zvinhu zvakasara zvichapera, uye ndiro ichaderedzwa.

Iwe unogona kusefa nemaoko data muExcel array nekubvisa mitsara nemakoramu ane mavara asingadiwe. Nekudaro, mushandisi anozofanira kushandisa imwe nguva kuti apedze maitiro aya.

Kana ukasarudza mumvuri waunoda muchikamu che "Sefa neruvara rwemavara", ipapo mitsara chete iyo manyorerwo akanyorwa muvara wakasarudzwa icharamba iri mutafura.

Teerera! MuMicrosoft Office Excel, kusefa nekuita kwemavara kune yakakosha dhiraivha. Mushandisi anogona kusarudza mumvuri mumwe chete, iyo iyo tafura yetafura ichasefa. Hazvibviri kutsanangura mavara akawanda panguva imwe chete.

Maitiro ekurongedza data neakawanda mavara muExcel

Iko kazhinji hakuna matambudziko nekugadzirisa nemuvara muExcel. Inoitwa nenzira imwecheteyo:

1. Nekuenzanisa nendima yapfuura, wedzera sefa kune tafura yetafura.
2. Dzvanya pamuseve unoonekwa muzita rekoramu, uye sarudza "Ronga neruvara" mune yekudonha-pasi menyu.

3. Tsanangura rudzi rwekuronga rwunodiwa, semuenzaniso, sarudza mumvuri waunoda mu "Ronga nesero color" column.
4. Mushure mekuita manipulations apfuura, mitsara yetafura ine mumvuri wakambosarudzwa ichave iri munzvimbo yekutanga muhurongwa hwakarongeka. Iwe unogona zvakare kuronga mamwe mavara.

Mamwe Mashoko! Iwe unogona zvakare kugadzirisa iyo data patafura uchishandisa iyo "Custom kurongedza" basa, uchiwedzera akati wandei neruvara.

Maitiro ekusefa ruzivo mutafura nemuvara uchishandisa tsika yemaitiro

Kuti Microsoft Office Excel isarudze sefa kuratidza akawanda mavara patafura kamwechete, iwe unofanirwa kugadzira imwe yekumisikidza ine yekuzadza tint. Zvinoenderana nemumvuri wakagadzirwa, iyo data ichasefa mune ramangwana. Basa retsika muExcel rinogadzirwa maererano nemirairo inotevera:

1. Enda kune "Developer" chikamu, icho chiri pamusoro peiyo main menu yechirongwa.
2. Munzvimbo yetabhu inovhura, tinya bhatani re "Visual Basic".
3. Mupepeti akavakirwa muchirongwa achavhura, umo iwe uchada kugadzira module nyowani uye kunyora kodhi.

Kuti ushandise iyo yakagadzirwa basa, unofanirwa:

1. Dzokera kuExcel worksheet uye gadzira makoramu maviri matsva padivi petafura yekutanga. Vanogona kunzi "Cell Color" uye "Text Color" zvichiteerana.

2. Nyora fomura muchikamu chekutanga = ColorFill()». Nharo yakavharirwa mumaparentheses. Iwe unofanirwa kudzvanya pasero nechero ruvara mundiro.

3. Muchikamu chechipiri, ratidza nharo imwe chete, asi chete nebasa =ColorFont()».

4. Tambanudza mhedzisiro inoguma kusvika kumagumo etafura, uchiwedzera iyo fomula kune iyo yese renji. Iyo data yakagamuchirwa ine mutoro weruvara rwesero rega rega patafura.

5. Wedzera sefa kune tafura array zvinoenderana nechirongwa chiri pamusoro. Iyo data ichagadziriswa neruvara.

Zvinokosha! Kuronga muExcel uchishandisa mushandisi-inotsanangurwa basa inoitwa nenzira yakafanana.

mhedziso

Saka, muMS Excel, unogona kukurumidza kusefa tafura yepakutanga neruvara rwemasero uchishandisa nzira dzakasiyana. Nzira huru dzekusefa nekugadzirisa, dzinokurudzirwa kushandisa pakuita basa, dzakakurukurwa pamusoro apa.