Nzira 3 Dzakarongedzwa neMuvara muExpcel

01 of 03

Kuenzanisa neCheso Chimiro muExcel

Kuronga neMuvara muExcel

Mukuwedzera pakugadzirisa nehutsika - zvakadai semashoko kana nhamba - Excel ine sarudzo dzemhando dzetsika dzinobvumira kutarisa nemuvara.

Kuronga nemuvara kunogona kubatsira kana uchishandura mafungiro akangoita , anogona kushandiswa kuchinja mararamiro emumvuri kana mavara emhando yedhesi inosangana nemamwe mamiriro.

Sezvinoratidzwa mumufananidzo wepamusoro, kusarudza nemuvara kunogona kushandiswa kuunganidza deta iyi pamwe chete kuti ive nyore kuenzanisa uye kuongorora.

Iyi nyanzvi yezano rinoshandisa nzira dzakasiyana dzekusarudza data muExcel uchishandisa ruvara. Ruzivo rwakananga rwemarudzi akasiyana nemasarudza mavara anogona kuwanikwa pamapeji anotevera:

1. Rongedza neChina Chimiro Chivara (iyi peji iri pasi)
2. Ronga ne Font Font
3. Rongedza neChirongwa Chekugadzira Zvidhori

Kusarudza Dhidhiyo Kuti Ive Yakarongwa

Dare risati ragona kugadziriswa, Excel inoda kuziva ruzivo rwakananga ruchagadziriswa, uye kazhinji, Excel yakanaka chaizvo pakusarudza nzvimbo dzedunhu rakabatana-chero bedzi painenge rapinda,

1. hapana mitsara isina kana mahwendefa yakasara mukati memunharaunda yakabatana;
2. uye mitsetse isina kuvhara uye misoro yakasara pakati penharaunda ye data yakabatana.

Excel ichasarudza kunyange, zvakarurama chaizvo, kana nzvimbo ye data ine mazita emumunda uye isabvisa rutsara urwu kubva pane zvinyorwa zvinofanira kusarudzwa.

Kubvumira Excel kusarudza mararamiro okugadziriswa zvakanaka kune zviduku zvedunhu zvinogona kuongororwa kuti zvionekwe:

• kuti maruva akakodzera anosarudzwa;
• kuti hapana mahwendefa mukati maro;
• kuti pashure pemhando, zvinyorwa zvepa data hazvina kujeka uye zvakarurama.

Kune nzvimbo huru dze data, nzira iri nyore kuti uone kuti mararamiro akakodzera anosarudzwa ndeyekusimbisa iyo usati watanga mararamiro.

Kana rutivi rwakadaro rwuri kurongedzwa kakawanda, nzira yakanakisisa ndeyokupa Zita .

Kana zita rinotsanangurwa kuitira kuti urongwa hutsanangurwe, tanga zita racho muBhokisi Razita , kana kuti riisarudze kubva pane rakaderedzwa pasi-list uye Excel richakurumidza kujekesa mararamiro akaenzana ezvinyorwa mubhuku rekushanda.

Kuronga neMuvara uye Kuronga Mutemo

Kuronga kunoda kushandiswa kwekurongeka kwemhando .

Paunenge uchitarisa nehutsika, kune mairi maviri anokwanisa kutonga mazano - achikwira kana achiburuka. Kana uchitarisa nemirau, zvisinei, hapana urongwa hwakadaro huripo iyo iyo inoshandisa musarudzo inotsanangura mararamiro akarongeka mumutambo we dialog dialog .

Rongedza neClass Color Example

Mumufananidzo wepamusoro, nokuti mhando dzemasero H2 kusvika kuL12 maitiro akashandurwa akashandiswa kushandura ruvara rwemukati rekodhi yemabhuku zvichienderana nenguva yevadzidzi.

Panzvimbo yekushandura sero yevarairi yevanyori vevadzidzi, ivo chete avo vane makore makumi maviri kana kupfuura vakagadziriswa nekugadzirisa mafungiro pamwe chete nevamwe vakasara vasina kugadziriswa.

Aya marekodhi akazogadziriswa nekero-ruvara kuti aise mazita ezvinyorwa zvekufarira kumusoro kwezera kuitira nyore kuenzanisa uye kuongorora.

Aya matanho anotevera akateverwa kuti agadzire deta nemusero weruva remukati.

1. Simbisa mhando yemasero ekugadziriswa - H2 kusvika kuL12
2. Dzvanya paImba yebhu yebhoni
3. Dzvanya paChirangaridzo & Firiza icon paibhoni kuti uzarure pasi rezasi
4. Dzvanya pa Custom Custom Sort in the down-list list kuti uburise Hurongwa hwebhokisi yebhokisi
5. Pasi Porudzi Paanotungamirira mubhokisi rebhokisi, sarudza Cell Color kubva pakaderera pasi
6. Apo Excel inowana mavara akasiyana-siyana emisasa mu data yakasarudzwa inowedzera iyo mavara kune zvingasarudzwa zviri pasi peChirongwa cheKurongwa mubhokisi rebhokisi
7. Pasi pemutungamiri weChirongwa, sarudza muvara mutsvuku kubva pakaderera pasi
8. Kana zvichidikanwa, sarudza On Top pasi pechirongwa chaiyo kuitira kuti ruvara rwebhuruu ruchave riri pamusoro pezita
9. Dzvanya OK kuti urongedze data uye uvhare bhokisi rebhokisi
10. Zvinyorwa zvina zvine red cell mavara zvinofanira kuiswa pamwe chete pamusoro pehuwandu hwemashoko

02 of 03

Rongedza Dhina Nemafaira Akaisa muExcel

Ronga ne Font Font

Iyo yakafanana chaizvo nekusarudzwa neseroti, kuronga nemhando yepavara kunogona kushandiswa kukurumidza kusarudza deta nemagwaro akasiyana-siyana.

Kushandurwa mumutambo wepavara kunogona kuitwa kuburikidza nekugadzirisa mafungiro kana sechikonzero chekugadzirisa nhamba - sekuita apo kuratidza nhamba dzisina kunaka muzvitsvuku kuitira kuti zvive nyore kuwana.

Ronga ne Font Font Example

Mumufananidzo wepamusoro, nokuti marefu emasero H2 kusvika kuL12 maitiro akashandurwa akashandiswa kuchinja mararita emhando yevadzidzi zvinyorwa kubva purogiramu yavo yekudzidza:

• Red font - vadzidzi vakanyoresa purogiramu yekuyamwisa
• Blue font - vadzidzi vakanyoresa purogiramu yesayenzi

Aya marekodhi akazogadziriswa nemuvara wepavara kuti aise mapepa ezvinyorwa kumusoro kwepamusoro kuti zvive nyore kuenzanisa uye kuongorora.

Kurongeka kworudzi rwevaraidzo rwakanga rutsvuku uye kuteverwa nebhuruu. Dhiyabhorosi nechokutsvaga mutsvuku mutsvuku hauna kusarudzwa.

Aya matanho anotevera akateverwa kuti agadzire deta nemuvara wepavara.

1. Simbisa mhando yemasero ekugadziriswa - H2 kusvika kuL12
2. Dzvanya paImba yebhu yebhoni .
3. Dzvanya paChirangaridzo & Firiza icon paibhoni kuti uzarure pasi rezasi.
4. Dzvanya pa Custom Custom Sort in the down-list list kuti uburise Hurongwa hwebhokisi yebhokisi
5. Pasi Porudzi Paanotungamira mubhokisi rebhokisi, sarudza Rudzi rweMafuta kubva pakaderera pasi
6. Apo Excel inowana mavara emhando yakasiyana mumasarudzo akasarudzwa inowedzera iyo mavara kune zvingasarudzwa zviri pasi peKurongwa kweDare mubhokisi rebhokisi
7. Pasi pemutungamiri weChirongwa, sarudza muvara mutsvuku kubva pakaderera pasi
8. Kana zvichidikanwa, sarudza On Top pasi pechirongwa chaiyo kuitira kuti ruvara rwebhuruu ruchave riri pamusoro pezita
9. Pamusoro pebhokisi rebhokisi, tanga pane Bhokisi Rokuwedzera kuti uwedzere rutivi rwechipiri rwehutano
10. Nokuda kwechipiri chechipiri, pasi pekutungamirirwa kweMutungamiri, sarudza ruvara rwebhuruu kubva pakaderera pasi
11. Sarudza On Top pasi pechirongwa chakadaro kuitira kuti ruvara rwebhuruu rwuve pamusoro pezvinyorwa izvi nekutadza mutsvuku
12. Dzvanya OK kuti urongedze data uye uvhare bhokisi rebhokisi
13. Zvinyorwa zviviri zvine tsvuku tsvuku yemuvara dzinofanira kuiswa pamwe chete pamusoro pezvenhau dzakatevedzerwa nemazita maviri epepuru yemavara emifananidzo

03 of 03

Rongedza Dhigirii neChirongwa Chekugadzira Zvidhori mu Excel

Rongedza neChirongwa Chekugadzira Zvidhori

Imwe nzira yekutarisa nemuvara ndeye kushandisa shanduko yakagadziridza mafaira ekugadzirisa kurongeka .

Izvi zviratidzo zvinopa humwe humwe humwe hunoenderana nehuwandu hunoenderana nemafungiro ekugadzirisa mafungiro ayo anotarisa pafonti uye sero maitiro ekuchinja.

Sezvo nekusarudza nesero mavara, kana kusarudzwa nemuvara mavara mudzidzi anogadzirisa mararamiro ari muChirongwa chebhokisi yebhokisi.

Rongedza neIcon Color Muenzaniso

Mumufananidzo wepamusoro, mazamu emasero ane dhizha yekushisa yeParis, France yakave yakagadziridzwa mafungiro nemirairo yerima yokuisa yakagadziriswa inotarisana nekupisa kwezuva nezuva munaJuly 2014.

Izvi zvishandise zvakashandiswa kugadzirisa dheta nerekodhi dzinoratidza zvisikwa zvemavara zvakasanganiswa zvakatevera zvichitevedzwa nemifananidzo yemamber, uyezve zvitsvuku.

Aya matanho anotevera akateverwa kuti agadzire deta nemifananidzo yevaravara.

1. Simbisa huwandu hwemasero okugadziriswa - I3 kusvika J27
2. Dzvanya paImba yebhu yebhoni .
3. Dzvanya paChirangaridzo & Firiza icon paibhoni kuti uzarure pasi rezasi.
4. Dzvanya pa Custom Custom Sort in the down-list list kuti uburise Hurongwa hwebhokisi yebhokisi
5. Pasi Pemhando Pokutungamirira mubhokisi rebhokisi, sarudza Cell Icon kubva pakaderera pasi
6. Apo Excel inowana cell icons mu data yakasarudzwa inowedzera iyo zviratidzo kune zvingasarudzwa zviri pasi peChirongwa cheDare mubhokisi rebhokisi
7. Pasi pemutungamiri weChirongwa, sarudza vhidhiyo yega yega kubva pakaderera pasi
8. Kana zvichidikanwa, wakasarudza On Top pasi pechirongwa chakanaka kuitira kuti data nedhizha icons ive iri pamusoro pezvenyu
9. Pamusoro pebhokisi rebhokisi, tanga pane Bhokisi Rokuwedzera kuti uwedzere rutivi rwechipiri rwehutano
10. Nokuda kwechipiri chechipiri, pasi pekutungamirirwa kweMutungamiri, sarudza maiti kana machioni icon kubva pakaderera pasi
11. Zvakare, vakasarudza On Top pasi pemutambo wakadaro kana zvichidiwa - izvi zvichaisa boka rechipiri rezvinyorwa pasi pevaya vane zvivara zvemavara, asi pamusoro pezvimwe zvose zvinyorwa zviri kurongwa
12. Sezvo pane zviratidzo zvitatu chete zvarudzo mumutambo uyu, hapana chikonzero chekuwedzera yechitatu yezinga kuti uenzanise zvinyorwa nezvidhori zvitsvuku, sezvo zvaro chete zvinyorwa zvakasara uye zvichave zviri pasi pehutano
13. Dzvanya OK kuti urongedze data uye uvhare bhokisi rebhokisi
14. Zvinyorwa zvine ruvara rwemagetsi zvinofanira kuiswa pamwe chete pamusoro pehuwandu hwemashoko hunoteverwa nerekodha neyember icon, uye ipapo avo vane red icon