Maitiro ekugadzirisa Microsoft Excel ikholamu uye mutsara

Mumwe wemibvunzo inozvibvunza vashandisi vazhinji kana vachishanda nema spreadsheet ndeye maitiro ekugadzirisa yakanakisa ikholamu. Uye kwete chete makoramu, asiwo mitsara nemasero. Mubvunzo unomuka kunyanya kana iwe uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchinge uchingeita nekuita yakawanda data uye iwe unofanirwa kudzokera uchidzokororazve kunongedzo ikholamu / mutsara / sero.

Kazhinji aya atinoda kuti aoneke nguva dzese ndiwo makoramu uye mitsara ine mazita kana misoro, kunyangwe hunyengeri uhu hunogona kushandiswa nemamwe mitsara nemakoramu (havafanirwe kunge vari vekutanga).

Pasina kushandisa iyo Excel ikholamu kugadzirisa nzira, kushanda nema spreadsheet kunogona kunonoka, kunetesa, uye kunonoka. Kunyangwe kutsamwisa dzimwe nguva. Isu tinomanikidzwa kuramba tichishandisa iyo mupumburu, kufambisa banga kumusoro uye pasi kana padivi, kutambisa nguva yakawanda. Uye nguva ndechimwe chinhu chisina munhu anofanira kusiya.

Saka isu ticha tsanangura maitirwo akareruka mashandiro uye simba nenzira iyi shanda mu Excel nenzira yakasununguka uye inoshanda.

Gadzirisa ikholamu muExcel

Iko kushanda kwekugadzirisa Excel ikholamu kuri muchirongwa ichi kubvira payakashandurwa yegore 2007. Kuisirwa kwaro kwaive kwekubatsira kukuru kune vashandisi vanoshanda neakakura maspredishiti uye vanobata yakawanda data. Uye nanhasi. Unyengeri hunowedzera kugadzirwa kwedu.

Kuita kuti ishumire nemazvo, aya matanho ekutevera:

Chekutanga pane zvese, tinodzvanya pane iyo tebhu "Kuona" iyo inowanikwa kumusoro kwespredishiti, uko maturusi ese anoratidzwa. Ikoko tine sarudzo nhatu:

• • Kusunungura mutsara wepamusoro. Nesarudzo iyi mutsara wekutanga wespredishiti "wakagwamba nechando", uyo unoramba wakamira uye uchioneka isu tichifamba takamira nemucheka.
  • Kusunungura yekutanga ikholamu. Iyo inoshanda senge yapfuura sarudzo, ichichengeta iyo yekutanga ikholamu yespredishiti yakamisikidzwa uye mukutarisa isu tichipururudza yakatwasuka kuburikidza negwaro.
  • Kusunungura mapaneru. Iyi sarudzo mubatanidzwa weaviri apfuura. Zvinotibatsira kugadzira kupatsanuka zvichibva pasero ratakatosarudza kare Iyo ndiyo yatinofanira kusarudza kana tichida kuita chando kana kugadzirisa mitsara nemakoramu panguva imwe chete. Zvakare muchiitiko chekuti mutsara kana ikholamu yatinotarisira kuseta haisi yekutanga.

Zvichienderana nebasa rauri kuzoita, unofanira kusarudza imwe yesarudzo nhatu.

Iyo mitsara nemakoramu anosara akagadziriswa anosiyaniswa ne mutsetse wakakora kwazvo wechitokisi unovamaka. Izvo zvakakosha kuti uzive kuti kugadzirisa Excel makoramu (kana mitsara kana mapaneru) inyanzvi yekuona. Mune mamwe mazwi, mitsara nemakoramu hazvichinje chinzvimbo chepakutanga mukati medespredishiti, ivo vanongoonekwa sevanoonekwa kuti vatibatsire.

Kana iro basa rapera, tinogona kudzokera ku "Sunungura" mitsara yakaoma nechando. Kune izvi, isu tichafanirwa kuwana iyo «Wona» hwindo zvakare uye kudzima sarudzo yatakatosarudza kare.

Kupatsanura hwindo muExcel

Sezvataona, chinangwa chekugadzirisa ikholamu yeExcel hachisi chimwe kunze kwekufambisa basa nema spreadsheet nenzira yekujekesa uye kugadzikana kwekuona gwaro. Asi uku handiko kwega hunyengeri hunotibatsira. Zvichienderana nerudzi rwegwaro kana basa, zvingave zvinoshanda iyo sarudzo yekuparadzanisa iyo Excel hwindo.

Chii chinoshanda ichi chine? Chaizvoizvo ndezve kupatsanura skrini yeparadheetete kuitira kuti tora maonero akasiyana egwaro rimwe chete. Semuenzaniso, pachiratidziri chimwe chete tingave tichiona ikholamu yekutanga neruzivo rwese irwo, nepo pachiratidziri chechipiri taigona kupururudza gwaro rese.

Ngatione kuti iyi sarudzo ingashandiswa sei muMicrosoft Excel:

1. Chinhu chekutanga kuita kuenda, senge yapfuura sarudzo, kune iyo tebhu "Kuona".
2. Ikoko iwe unongofanirwa kusarudza sarudzo "Govanisa". Iyo skrini inongozvikamurwa yakakamurwa kuita zvikamu zvina.

Nenzira iyi isu tichawana mana akasiyana maonero egwaro rimwe chete, kushanda mumwe nemumwe pane chimwe nechimwe chazvo. Uye pasina kushandisa iyo mupumburu kakawanda kuti uzere pamusoro payo.

Uye kana mana masikirini akawandisa (dzimwe nguva nekuyedza kuita kuti zvinhu zvive nyore tinopedzisira tavaomesa zvakanyanya), kune dzimwe nzira dzeku ingoshanda nescreen yakakamurwa kuita mbiri. Mune ino kesi tinofanirwa kuenderera seizvi:

1. Ngatidzokerei ku "Kuona", kunyangwe panguva ino isu takasarudza sarudzo ye "Hwindo idzva".
2. Panguva ino tinogona kusarudza nzira mbiri: "Kufanana maonero" kana zvimwe "Ronga zvese«. Mune ese ari maviri, iyo skrini ichaonekwa yakakamurwa kuita maviri, kunyangwe kana isu takasarudza iyo yechipiri sarudzo isu tinogona kusarudza pakati akatiwandei ekuratidzira modes yakatambarara, yakatwasuka, mosaic kana cascading. Kune zvatinoda.