Mutsetse wekutumira chiratidzo muExcel. Maitiro ekuita tambo kuendesa muBexcel Cell - Nzira dzese

Kazhinji, vanhu vanoshanda mune yakapararira exprescel tab inosangana nemamiriro ezvinhu akadaro paunofanirwa kuendesa mutsara. Shandisa maitiro aya ari nyore anogona kusiyana. Munyaya yacho, isu tichazoongorora nzira dzese dzakadzama dzinobvumidza iwe kuti utamise mutsara pane iyo nzvimbo yekushanda yeganda reblack.

Maitiro ekubvisa mitsara yemitsetse kubva masero muEnakakura 2013, 2010 na2007

Kune nzira nhatu dzinobvumidza iwe kuti ubvise kudzoka kunotenga kubva kuminda. Vamwe vacho vanoita zvinhu zvekutamisa zvinhu. Masarudzo anokurukurwa pazasi anoshanda zvakaenzana mune zvakawanda shanduro dzeTabular mupepeti.

Poshi

Iko kuendesa kwemutsara murugwaro ruzivo kunomuka mune zvakasiyana siyana. Kune kazhinji zvikonzero zvinosanganisira nguva dzakadai sekushandisa iyo "alt + pinda" musanganiswa wekutamisa mavara kubva kuInternet peji kune yepace expular chirongwa cheTabular. Isu tinofanirwa kubvisa ngoro yekudzoka, sezvo pasina maitiro aya hazvigoneke kuita kuti tsvaga yakajairika yemitsara chaiyo.

Bvisa ngoro dzinodzoka pamunhu

Tichaongorora zvakadzama nzira yekutanga.

• Mukana: kukurumidza kuuraya.
• Zvishamiso: Hapana zvimwe zvinhu.

Mirayiridzo yakadzama inotaridzika seizvi:

1. Isu tinogadzira masero ese aunoda kushandisa iyi kuvhiyiwa kana kutsiva zviratidzo.

2.

1. Uchishandisa kabhodhi, tinya musanganiswa we "CTRL + H" mabhatani. Iwindo rakaonekwa pane skrini ine zita rekuti "Tsvaga uye kutsiva".
2. Edza pointer kune "tsvaga" mutsara. Uchishandisa kabhodhi, tinya musanganiswa we "Ctrl + J" mabhatani. Pfungwa diki yakaonekwa mumutsara.
3. Mu "kutsiva ku" mutsara, isu tinopinda mune imwe kukosha uko kunopfeka pane zvekutakura ngoro. Kazhinji kacho nzvimbo inoshandiswa, sezvo ichikubvumira kuti ubvise gluit ye ​​2 yepedyo mitsara. Kuti uite kubviswa kwemitsetse, zvinodikanwa kutsiva "kutsiva" ku "kutsiva" chero ruzivo.

3.

1. Nerubatsiro rweLKM, tinya pane "dzorera zvese". Kugadzirira! Isu takaita kudzvanywa kwekudzokerana ngoro.

4 Bvisa tambo trwfers uchishandisa Excel mafomula

• Inobatsira: mukana wekushandisa akasiyana-siyana mafomula anoita bvunzo yakaoma yeruzivo mumunda wakasarudzwa. Semuenzaniso, iwe unogona kuziva kubviswa kweiyo ngoro inodzoka, uye wozowana mapundu asina kukodzera.
• Zvishamiso: Izvo zvinodikanwa kuti ugadzire imwe ikholamu, pamwe nekuitwa kwehuwandu hukuru hwekunyengera.

Mirayiridzo yakadzama inotaridzika seizvi:

1. Isu tinoita kuti tiwedzere imwe ikholamu pakupera kweruzivo rwemashoko. Mumuenzaniso uyu, ichawana zita rekuti "1 mutsara"
2. Mumunda 1st denderedzwa remamwe mhou (C2), isu tinotyaira formula hunoziva kubviswa kana kutsiva kwemitsetse. Mifananidzo yakati wandei inoshandiswa kuita izvi kushanda uku. Fomula, yakakodzera kushandiswa nemusanganiswa wekutakura kwekutakura uye kuendesa, zvinoita kunge izvi: = chinotsiva (chinotsiva (b2; ""); chiratidzo (10); "").
3. Fomula, yakakodzera kutsiva kuendesa kuStitching kuendesa nechiratidzo, zvinoita kunge izvi: = szhenbel (chinotsiva (chinotsiva (chinomukira (B2; ")." "). Zvakakodzera kuti Pane izvi zvacho hazvizosanganisane mitsara.
4. Iyo formula inokutendera kuti ubvise zvese zvisiri zviratidzo zvisingaitwe kubva kune data data, inotaridzika seiyi: = Grisimv (B2).

shanu

1. Isu tinoburitsa kutevedzera formula, tobva taisa muchitokisi chimwe nechimwe cheimwe ikholamu.
2. Pamusoro pezvo, iwe unogona kutsiva iyo yekupedzisira denderedzwa yeiyo itsva, iyo mitsara yekutumira ichabviswa.
3. Isu tinoburitsa kugovera masero ese ari muS. C. tinya mubatanidzwa we "Ctrl + C" pane kabhodhi yekushandisa kutevedzera ruzivo.
4. Isu tinoburitsa kusarudzwa kweB2 munda. Dzvanya iyo musanganiswa we "Shift + F10" mabhatani. Muchinyorwa chidiki cheLKM, chinhu chine zita "isa".
5. Isu tinoita kubviswa kweiyo aubhilari.

Bvisa tambo trwfers uchishandisa vba macro

• Mukana: Chisiko chinoitika chete 1 nguva. Mune ramangwana, iyi macro inogona zvakare kushandiswa mune mamwe magwaro eTabular.
• Zvishamiso: Izvo zvinodikanwa kuti unzwisise iro basa remufungo weVba hurongwa.

Kuita nzira iyi, iwe unofanirwa kupinda muhwindo rekupinda macros uye pinda iyi kodhi ikoko:

6.

Kuendesa mameseji muchitokisi

Iyo EXEL TAX EDPOR inoita kuti utamire ruzivo rwemavara mumunda. Izvi zvinoitwa kuitira kuti zvinyorwa zvemavara zvinoratidzwa pamitsetse yakati wandei. Iwe unogona kuita maitiro ekuseta kune imwe neimwe shamba kuitira kuti zvinyorwa zve data kuendesa kugadzirwa. Pamusoro pezvo, zvinokwanisika kuita bvudzi remuziro nenzira yebhuku racho.Otomatiki zvinyorwa kuendesa

Isu tichaongorora zvakadzama maitiro ekushandisa maitiro ekutambisa otomatiki emavara ezvinyorwa. Nhanho neNhanho Algorithm inotaridzika seizvi:

1. Isu tinoburitsa kusarudzwa kwesero rakakodzera.
2. Mu "imba" "repamba, tinowana block yemirairo ine zita rekuti" kuwirirana ".
3. Nekubatsirwa kweLCM, sarudza iyo "Yekutumira mameseji" chinhu.

Kurongedza kukwirira kwetambo kuratidza iwo mavara ese

Isu tichaongorora zvakadzama maitiro ekutaridza kuti kukwidziridzwa kuisirwa maitiro ezvinyorwa zvese zvinyorwa zvemavara. Mirayiridzo yakadzama inotaridzika seizvi:

1. Isu tinoburitsa kusarudzwa kwemasero anodiwa.
2. Mu "imba" repamusha, tinowana block yemirairo ine zita rekuti "masero".
3. Uchishandisa lcm, sarudza iyo "fomati" chinhu.
4. Mu "saizi saizi" hwindo, iwe unofanirwa kuita imwe yesarudzo dzinotevera. Sarudzo yekutanga ndeyekuti otomatiki kuregedza kukwirira kweiyo lkm kune chinhu cheiyo mutsara wemutsara wekureba. Sarudzo yechipiri - yekumisikidza kukwirira kwemitsetse, iwe unofanirwa kudzvanya pane iyo "tambo yekureba", uye wobva watyaira chiratidzo chaunoda mumutsara usina chinhu.

Kupinda tambo kupwanya

Isu tichaongorora zvakadzama maitiro ekuita maitiro ekupinda mitsetse kupwanya. Mirayiridzo yakadzama inotaridzika seizvi:

1. Nekutsikirira kaviri kuLkm, isu tinosarudza munda watinoda kutyaira mitsara. Izvo zvakakosha kucherechedza kuti iwe unogona kusarudza iyo inodiwa munda, wobva wadzvanya paF2.
2. Kaviri-kudzvanya LKM, isu tinosarudza nzvimbo iyo mitsara yekuzorora ichawedzerwa. Dzvanya musanganiswa we "Alt + Pinda". Kugadzirira!

Maitiro ekuita mutsara kuendesa muExcel Forpula Cell

Kazhinji vhesi yetafura yekuwedzera inowedzera akasiyana emadhiraipi uye girafu kune iyo basa rekushandira. Kazhinji maitiro aya anoda kuendeswa kwemitsetse mumunda werugwaro ruzivo. Isu tinonzwisisa zvakadzama maitiro ekuziva nguva ino.

Formula yekuendesa tambo mune excel cell

Semuenzaniso, isu tine histogram yakaitwa muchirongwa cheTabular. PaAxis X kune mazita evashandi, pamwe neruzivo nezvekutengesa kwavo. Rudzi urwu rwekusaina runonyanya nyore, sezvo rwunoratidza zvakajeka chiyero chebasa rakaitwa nevashandi.

7.

Shandisa maitiro aya ari nyore kwazvo. Iwe unofanirwa kuwedzera anoshanda kune iyo madhiri efomula. Zvinokubvumira iwe kuti uite chizvarwa chechiratidzo muminda yekusaina ruzivo mune chati.

sere

Ehezve, mumunda, unogona kuita iyo nzira yekushambadzira yekushambadzira chero kupi zvako, nekuda kwekubatanidzwa kwe "Alt + pinda" mabhatani. Nekudaro, nzira iyi haina kunaka mune zviitiko apo pane yakawandisa data.

Mashandiro anoita basa racho paunenge uchichinjisa mitsara muchitokisi

Chirongwa ichi chinoshandisa makodhi kubva kuAscii zviratidzo. Iyo ine masaini masaini inoratidzwa pane iyo kuratidzwa muO OS. Iyo ndiro ine mazana maviri nemakumi mashanu neshanu manhamba manhamba.

Mushandisi wemharidzo yetafura, ndiani anoziva aya makodhi, anogona kuvashandisa muchiratidzo chekushandisa kuisa chero chiratidzo. Mumuenzaniso wakurukurwa pamusoro, chiratidzo chekuendeswa kwemutsara, izvo zvinobatanidza kubva kumativi ese e "&" pakati pezviratidzo zveC2 uye A2 minda. Kana iyo munda isina kugadziriswa ne "kutumira mameseji" mumunda, ipapo kuvapo kwemushandisi wemararamiro anotama haazoonekwa. Izvi zvinoonekwa pamufananidzo uri pazasi:

pfumbamwe

Kupatsanura pane tambo yekuendesa tambo

Kana mushandisi mu "Data" Subsection ichasarudza iyo "zvinyorwa pamakoramu" chinhu, zvichakwanisa kuita kuti kuendesa kwemitsetse uye kupatsanura ruzivo rwekuyedza mumasero akati wandei. Maitiro acho anoitwa achishandisa iyo "alt + kupinda" kusanganisa. Mu "Column Distriution Wizard" hwindo, iwe unofanirwa kuisa tick padhuze ne "imwe" kunyorwa uye pinda musanganiswa we "Ctrl + j".

10

Kana iwe ukaisa tick nezvezvakanyorwa "kuti ufunge zvinoenderana nekuparadzaniswa kune mumwe", saka unogona kuita "kupuruzira" zvezvidhori zvakati wamitsetse mumutsara mumutsara mumutsara mumutsara mumutsara mumutsara mumutsara mumutsara mumutsara mumutsara mumutsara. Panguva yakapera, tinya pane "inotevera". Nekuda kweizvozvo, tichawana:

gumi neimwe

Kupatsanurana kumitsara neAlt + Enter kuburikidza nemagetsi query

Pane mamiriro ezvinhu apo mushandisi anofanirwa kupatsanura iyo yakawanda-line zvinyorwa zvinyorwa haisi pane imwe ikholamu, asi pane mutsara.

12

Kuita izvi maitiro, "query query" mashura anoitwa, iyo yakaonekwa mumupepeti weTafura kubva pa 2016. Mirayiridzo yakadzama inotaridzika seizvi:

1. Uchishandisa iyo "CTRL + T" kusanganisa, isu tinotsanangura iyo sosi data mune "Smart" chiratidzo. Imwe sarudzo - inofamba mu "Imba" Subsection uye tinya LKM kuti "fomati seye tafura" chinhu.
2. Kufambisa mu "Data" Subsection uye tinya pane "kubva kuTafura / Range" chinhu. Uku kuvhiyiwa kuchakubvumidza iwe kuendesa chiratidzo muSope query chishandiso.

13

1. Isu tinogadzira kusarudzwa kwekorumu ine akawanda-mutsara mameseji ruzivo. Kufamba mu "imba". Ratidza rondedzero yeiyo chiratidzo "Sparl column" uye tinya LKM pane chinhu "nekuparadzanisa".

gumi neina

1. Dzvanya pane "ok" kuratidza shanduko dzakaitwa. Kugadzirira!

gumi neshanu

Macro kuti utsivike pamitambo pane alt + pinda

Funga maitiro ekuita izvi maitiro achishandisa macro anokosha. Isu tinogadzira iyo VBA yekutanga uchishandisa iyo "Alt + F11" Keyboard keyboard. Mukuonekwa kwewindo, tinya "Insert" uyezve "module". Pano tinowedzera iyo kodhi:

gumi nenhanhatu

Isu tinodzokera kuimba yekushandira uye tasarudza minda iyo iyo iyo yakawanda-mutsara ruzivo rwunowanikwa. Dzvanya iyo musanganiswa we "Alt + F8" pane kabhodhi kuti uite macro yakagadzirwa.

Mhedziso

Zvichienderana nerugwaro rwechinyorwa, zvinogona kucherechedzwa kuti pane huwandu hukuru hwenzira dzinoita kuti kuendesa kwetsetse mugwaro reTabular. Iwe unogona kuita maitiro aya uchishandisa mafomula, mashandiro, zvishandiso zvakakosha uye macros. Mumwe nemumwe mushandisi anozogona kusarudza nzira yakanyanya nyore pachayo.

Mharidzo mutsara chiratidzo muExcel. Maitiro ekuita mutsara kuendesa muExcel Cell - Nzira dzese dzakaratidzika kutanga tekinoroji.