Nzira yekubvisa zvinyorwa mu Excel



Nzira yekubvisa zvinyorwa mu Excel

Nzira yekuwana zvidimbu muExcel, bvisa zvinyorwa zvinyorwa mu Excel, uye kubvisa zvinyorwa muExcel zvose zvakafanana, nebasa rimwe chete rakasanganiswa rinowanikwa muExcel kuti iite kudhevedzwa kwe data.

Pasi apa, tichazogadzirisa imwe sarudzo neExcel kubvisa zvinyorwa zvese, izvo zvingashandiswawo kuongorora zvidimbu muExcel uye kuvanza zvinyorwa muExpcel, kunze kwekunge zvichifanira kubvisa zvinyorwa muExcel.

Chimwe chekurumidza kugadzirisa nebhokisi nyore nyore kubvisa zvose zvinyorwa, uye imwe sarudzo uchishanda mabasa uye mazano, zvishoma zvakaoma kunzwisisa, kuzviratidza.

Nzira yekubvisa sei zvinyorwa mu Excel

Kurongedza runyora uye kubvisa zvinyorwa zvinowanzoshandiswa uye zvinobatsira, kana uchishanda nedata rezinotsanangudzo: kero ye email, nhamba yevovo, maitiro, ...

Imwe ingangodaro iri kushandisa Excel 2013 kubva kuMicrosoft Office 2013 suite.

Nzira yekubvisa zvinyorwa mu Excel

Kutanga necheti yako yedata, sarudza iyo column (s) iyo yaunoda kubvisa idzo.

Zvadaro, kubva pane DATA DATA, sarudza Bvisa zvinyorwa zvisarudzo.

Muzvinyorwa, sarudza kana data yako ine musoro kana kwete (kureva, mutsara wekutanga usingatarisirwi mubasa), uye mutsara waunoda kutarisa, uye enda OK. Iyi ndiyo nzira yokubvisa mitsetse miviri mu Excel!

Inoshandisa kunyange nemirasi miviri, misoro mitatu, kana kupfuura. Zvose zvaunofanirwa kuita, zvinosarudza mazamu akawanda ane data kana zvichidiwa, uye basa iri richabvisa zvinyorwa. Iyi ndiyo nzira yekufananidza mikoko miviri kuti uwane zvinyorwa mu Excel, uye inoshanda nemamwe mapuranga kana zvichidikanwa.

Iwe unofanirwa kuwana husimbiso nehuwandu hwezvinyorwa zvakabviswa uye zvakasiyana-siyana zvinosara.

Pakupedzisira, iwe unogona kutsvaga deta, ikozvino kuti zvinyorwa zvacho zvakabviswa, kuva nehuwandu hwekunatsa.

Iva excel Pro: Joinha kosi yedu!

Simudza hunyanzvi hwako kubva kuLovice kuenda kuHamba NeGamba Pedu 365 Basics Course, rakagadzirirwa kukuita iwe nyanzvi mune zvikamu zvishoma.

Nyoresa pano

Simudza hunyanzvi hwako kubva kuLovice kuenda kuHamba NeGamba Pedu 365 Basics Course, rakagadzirirwa kukuita iwe nyanzvi mune zvikamu zvishoma.

Kuchengetedza sarudzo yako, mune imwechete DATATU menu, sarudza kukwira kana kuburuka, uye voilà!

Rongedza kana kubva pamaduku kusvika kuhukuru, kana kubva kubva kuhukuru kusvika kune humwe, zvichienderana nedzimwe tsanangudzo, uye kudiwa kwayo.

Viga zvinyorwa muExcel

Kuvanza zvinyorwa muExcel, uye kuva nededuplication yedhesi iyo ichachengetedza data yose pane kubvisa zvinyorwa, ita zvinotevera. Ndiyo imwe nzira nzira yekuziva nayo zvinyorwa muExpcel nemafomu, panzvimbo yekushandisa yakagadzirwa basa. Ichawanawo hutano hwakasiyana muExcel mazamu akawanda, mumatanho mashomanana uye nyore nyore:

  • Wedzera imwe korombo mumutsetse wepa data, kana musati wasvika kana mushure mematare,
  • Raira dhidhiyo neyo column. Kana mikoko miviri kana yakawanda yakakosha nokuda kwechipiri chekuongorora, tanga imwe koromo nekutarisana kweizvi mbiri kana kupfuura, uye urongedze nekutaura ikoko,
  • Muchikamu chisingabatsiri, wedzera iri rondedzero inotevera (kana chinyorwa A uye chekutanga chine chinhu chisina chinhu chiri A2, uye B2 ndiyo yekutanga seki kuti uongorore kudzokorora).

Fomu yekuwana zvidimbu mu Excel

Simbisa mitsetse miviri mu Excel

Iye zvino, sarudza mitsara yose nehuwandu hweDuplicate muchitsauko A, uye uise pachena!

Ziva zvinyorwa muExcel

Zvose zvinowanikwa zvino zvinozivikanwa, uye iwe unogona kuita zvaunoda navo: kuisa zvinyorwa zvinyorwa, kuvhara zvinyorwa, kana kuona kuti ungabvisa sei mitsetse inonzi Excel, ...

Excel bvisa zvinyorwa kubva kune imwe column

Kuti ubvise zvinyorwa, kana kuvanza zvinyorwa muExcel, shandisai firimu pane imwe nhare A kukosha kwakaenzana neDuplicate, uye ita basa rinotevera. Iyi ndiyo nzira yokubvisa zvinyorwa muExpcel 2013, kuitira kuti Excel ibvise zvinyorwa kubva pane zvakanyorwa, asiwo kuti ungabvisa sei zvinyorwa muExpcel 2013.

Verenga zvinyorwa muExcel

Kuti uverenge zvinyorwa, mune peji iripo, wedzera chikamu chisingabatsiri kurudyi rwekoromeri nemuenzaniso wekuenzanisa, firiji pane chinyorwa A yakaenzana Chekutanga, uye wedzera iri rinotevera mushure b. Bhuku raunofanira kunge uine kiyi mumutsara C :

Uye tambanudza fomu kusvika kune imwe koromo. Izvozvo zvicharatidza kuverenga kwezvidimbu kune imwe neimwe inokosha!

Mibvunzo Inowanzo Bvunzwa

Matanho api anofanirwa kuteverwa kuti abate zvinobudirira kudzokorora kwekunyora kubva kune dataset muExcel, ichivimbisa kutendeka kwedata?
Kuti ubvise madhiri muExcels Excel ichazoita kuti mushandisi asarudze iyo makoramu ekutarisa zvidzitiro, achichenesa dataset yezviripo zvinodzokororwa.

Zadzisa 2019 Excel yeVatanga mune vhidhiyo


Yoann Bierling
Nezvemunyori - Yoann Bierling
Yoann Bierling ibhusaiti yekushambadzira & Dhijitari Kukurukurirana Professional, kugadzira kukanganisa kwepasi rose kuburikidza nehunyanzvi uye hunyanzvi mune tekinoroji. Passionate nezve kupa simba vanhu uye masangano kuti akubudirire muzera redhijitari, anofambiswa kununura mhedzisiro yakasarudzika uye yekufambisa ichipfuura kuburikidza nedzidziso yezvinyorwa zvemukati.

Iva excel Pro: Joinha kosi yedu!

Simudza hunyanzvi hwako kubva kuLovice kuenda kuHamba NeGamba Pedu 365 Basics Course, rakagadzirirwa kukuita iwe nyanzvi mune zvikamu zvishoma.

Nyoresa pano

Simudza hunyanzvi hwako kubva kuLovice kuenda kuHamba NeGamba Pedu 365 Basics Course, rakagadzirirwa kukuita iwe nyanzvi mune zvikamu zvishoma.




Comments (0)

Siya mhinduro