Maitiro Ekupedzisira Dhivha yekukudza muvara

MuMicrosoft Office Excel, kutanga muna 2007, ine mukana wekugadzirisa uye kuseya masero etite ye tafura yakarongedza muvara. Iri basa rinobvumira nekukurumidza kuti ufambe patafura, inowedzera kuratidzira kwayo uye aesthetics. Chinyorwa ichi chichaongorora nzira dzekutanga dzekufa dzeruzivo muExcel muruvara.

Kusefa kucheka

Usati wachinjana kuti uongororwe nenzira dzekuputira data muvara, zvakafanira kuongorora zvakanakira zvinopihwa nemaitiro aya:

• Kuronga uye kusiyanisa ruzivo, izvo zvinokutendera kuti usarudze chidimbu chaunoda chivharo uye nekukurumidza kuiwana mumasero makuru emasero.
• Masero-anosemerwa masero ane ruzivo rwakakosha runogona kuongororwa mune ramangwana.
• Kufefetera muruvara kunogovera ruzivo runogutsa nzira yakatarwa.

Maitiro Ekunze Kunze kweDhivha yedata uchishandisa iyo yakavakirwa-muExcel sarudzo

Ruvara ruvara rwelgorithm muhurongwa hwekunyorera dzakakamurwa mune inotevera nhanho:

1. Sarudza iyo yaunoda mhando yemasero ine kiyi yekuruboshwe yeanipulator uye uende ku "Imba" tab iri kumusoro kwechirongwa chekushandisa chirongwa.
2. Munzvimbo yacho inoonekwa mumugodhi, kurongedza iwe unofanirwa kuwana iyo "rudzi uye bhatani" bhatani uye kuendesa iyo nekudzvanya museve pazasi.

Sarudzo dzekugadzirisa uye kufefetera tabular data muExcel

1. Mumenyu yakaratidza, tinya pamutsetse wefaira.

MuWindows Window, tinya pane "Filter" bhatani

1. Kana firita rikawedzerwa, ipapo miseve midiki ichaonekwa mumakoramu etafura. Panguva ino, ne chero yemiseve, mushandisi anofanira kudzvanya LKM.

Arrogo yakaonekwa muTafura Misoro yemusoro mushure mekuwedzera firita

1. Mushure mekumanikidza museve muzita rekamuri, menyu yakafanana inoratidzwa, umo iwe unofanirwa kudzvanya pamutambo wetsetse wedhara. Iyo yekuwedzera tab ine zvinhu zviviri zviripo zvicharatidzwa: "Ruva reruva rekufa" uye "Font Colice Filter".

Sarudzo dzeFILTRUAL MUKURU. Pano iwe unogona kusarudza chero ruvara kuti iwanikwe pamusoro petafura

1. Mu "cell color filter" chikamu, sarudza mumvuri waunoda kuendesa tafura yekudonha nekudzvanya lkm pairi.
2. Tarisa uone mhedzisiro yacho. Mushure mekupedza manipulations iri pamusoro, masero chete ane ruvara rwakataurwa rwakatarwa rucharamba riri patafura. Izvo zvinhu zvasara zvichanyangarika, uye ndiro iyi yakaderedzwa.

Kutaridzika kweiyo ndiro inoshandurwa mushure mekushowa data mazviri

Dhipatimendi yefaira mune yekunyorera array inogona kuve yakagadzirirwa, kudzima tambo uye makoramu nemavara asina basa. Nekudaro, mushandisi anozofanira kushandisa nguva yekuwedzera kuitira chiitiko ichi.

Kana iwe ukasarudza iyo yaunoda mumvuri mune font color chikamu chikamu, mitsara chete icharamba iri patafura, iwo mavara eFont mune iyo yakanyorwa nemavara akasarudzwa.

Maitiro ekugadzirisa data pane akawanda mavara muExcel

Nekurongedza mumavara muExcel, pane kazhinji hapana matambudziko. Zvinoitwa nenzira imwe chete:

1. Ne fananidzo neiyo yapfuura poindi, wedzera dhizaini kune tafura yakarongeka.
2. Dzvanya pane museve wakaonekwa muZita reColum, uye mune yekudonha-pasi menyu sarudza "Ronga neruvara".

Kusarudza kurongedza ruvara

1. Taura rudzi rwaunoda rwekuronga, semuenzaniso, sarudza mumvuri waunoda mune "cell column" ikhoramu.
2. Mushure mekupedza iyo yakapfuura manipulations, iyo tafura mitsara ine iyo yakambosarudzwa yeTint ichave iri munzvimbo yekutanga yehurongwa hwekurongeka. Iwe unogona zvakare kugadzirisa mavara akasara.

Mhedzisiro yekupedzisira yemasero ekurongedza muruvara muTafura Array

Maitiro Ekuita Ruzivo rweFilter muTafura NEMAHARA uchishandisa mushandisi basa

Kuti usarudze firita muMicrosoft Office Excel kuti uratidze mavara akati wandei kamwe patafura, iwe unofanirwa kuumba mamwe ma paramita ane mumvuri wekuzadza. Sekureva kwemumvuri wakasikwa, iyo data iri mune ramangwana ichave yakashandurwa. Basa remushandisi muExcel rinogadzirwa zvinoenderana nemirairo inotevera:

1. Enda kune "yekuvandudza" chikamu, icho chiri pamusoro pemenyu huru yechirongwa.
2. Munguva yepari parizvino yakavhurwa tab, tinya pane "bhatani rekutanga" bhatani.
3. Chirongwa chakavakirwa-muchirongwa chakavhurwa, chauchazoda kugadzira module nyowani uye kunyoresa kodhi.

Chirongwa kodhi ine mabasa maviri. Yekutanga inosarudza ruvara rwekuzadza kweiyo chinhu, uye yechipiri ine mutoro weruvara mukati mechitokisi

Kuti ushandise basa rakagadzirwa, iwe unoda:

1. Dzokera kuExcel Syd Speet sheet uye gadzira maviri matsva emakoramu padivi pemuviri tafura. Ivo vanogona kunzi "cell color" uye "mavara mavara", zvichiteerana.

Akagadzira auxiliary colums

1. Muchikamu chekutanga, nyora fomula "= ruvara ()". Mabhureki anoratidza kupokana. Iwe unofanirwa kudzvanya pachiteshi chine chero ruvara mundiro.

Formula mu column "color color"

1. Muchikamu chechipiri, taura nharo imwe chete, asi chete ne "= ruvara ()" basa.

Fomula muColumn "Ruvara Ruvara"

1. Tambanudza tsika dzinoguma kusvika kumagumo etafura, uchidzima fomula yeiyo huwandu hwese. Iyo data inowanikwa ine mutoro werudzi rwechitokisi chega chega patafura.

Iyo data inokonzeresa mushure mekutambanudza fomula

1. Wedzera dhizaini kune tafura yakarongedzwa maererano nechirongwa chiri pamusoro. Iyo data ichagadziriswa neruvara.

Mhedziso

Nekudaro, muMS Excel, unogona kukurumidza kuseya iyo sosi tafura yebhuruu yakarongedzwa muruvara rwemasero mumhando dzakasiyana siyana. Nzira huru dzekuputira uye kurongedza, dzinokurudzirwa kushandisa kana uchiita basa racho, dzakatariswa pamusoro.

Mharidzo Maitiro Ekupedzisira Kunze Data Mukuratidzira Mune Ruvara Rwakaratidzika Kutanga kune Technology Technology.