Iwo akanakisa matipi ekushandisa mafirita muExcel
Mafirita muExcel Icho chinhu chakakosha chishandiso mukuongorora data uye inobvumidza iwe kurongedza uye kuronga ruzivo nemazvo. Muchinyorwa chino, ticha kuongorora mano akanakisa kushandisa mafirita muExcel zvinobudirira, nekudaro optimize manejimendi makuru makuru e data. Kubva pakushandisa mafirita ekutanga kusvika pakushandisa mafirita epamberi, tichawana matekiniki anozobvumidza iwe kuti uwane zvakanyanya kubva muchishandiso chine simba ichi.
Imwe yemaitiro ekutanga zvaunofanira kuziva ndizvo here kushandiswa kwemasefa otomatiki. Ichi chimiro chinokutendera iwe sefa data rako ne akasiyana maitiro, zvakaita semavara, mazuva, kana zvakakosha. Kuburikidza kudzvanya kamwe chete, unogona kudzivisa kutsvaga kunonetesa kwemaoko uye kungoratidza ruzivo rwakakosha pakuongorora kwako. Tsvaga maitiro ekuita zvakanyanya zveichi chimiro uye chengetedza yakakosha nguva mubasa rako rezuva nezuva neExcel.
Imwe nzira yakakosha ndeye kushandiswa kwemasefa epamusoro. Masefa aya anotendera iwe shandisa maitiro akawanda ekusefa panguva imwe chete, iyo inopa kunyanya kurongeka mukusarudzwa kwedata. Iwe unozogona kugadzira yakanyanya kuomarara uye yakananga mibvunzo, kusanganisa vanonzwisisika vanoshanda uye yakasarudzika maitiro. Iva nyanzvi mukushandisa mafirita epamberi uye uvandudze mhando yekuongorora kwako muExcel.
Zvakare, mune ino chinyorwa iwe uchaona kuti sei shandisa mafirita etsika. Kuburikidza nekushanda uku, uchakwanisa kutsanangura tsika yekusefa maitiro zvinoenderana nezvaunoda. Kubva pakusefa nematanho emazuva kana kukosha, kutsvaga data zvichienderana nemamiriro ezvinhu, unozodzidza kugadzirisa mafirita kune zvaunoda. Kana uchinge wagona hunyanzvi uhu, unozokwanisa kuita ongororo dzakadzama uye kuwana mhedzisiro chaiyo muExcel.
Mukupedzisa, mafirita muExcel chishandiso chakakosha kune chero nyanzvi inoshanda neakawanda mavhoriyamu edata zvinobudirira, iwe unozogona kuchengetedza nguva, kuvandudza mhando yekuongorora kwako uye kuwana mhedzisiro chaiyo. Usarasikirwe nechinyorwa ichi uye uve nyanzvi mukugadzirisa mafirita mu Excel!
Mhando dzakasiyana dzemafirita muExcel
Odha ma filters
Chimwe chezvinhu zvinonyanya kukosha zveExcel kugona kwayo kuronga data. Ronga mafirita chishandiso chakakosha kuronga maspredishiti ako nemazvo. Iwe unogona kushandisa mafirita ekuraira kuronga data rako mukukwira kana kudzika kurongeka zvinoenderana nezvaunoda. Semuyenzaniso, kana uine koramu ine mazita evashandi uye iwe uchida kuaronga nemaarufabheti, ingosarudza koramu woisa sefa yerudzi. Nenzira iyi, unogona kukurumidza kuwana ruzivo rwaunoda uye kuita sarudzo zvichienderana nedata. zvinobudirira.
Masefa otomatiki
Mafirita otomatiki ndeimwe mhando inobatsira yefirita muExcel. Masefa aya anokutendera kuti uratidze kana kuviga zviri nyore data rinoenderana nezvimwe zvinodiwa. Semuenzaniso, kana uine tafura ine ruzivo rwekutengesa uye uchida kuona data remumwe mutengesi chete, unogona kusefa sefa otomatiki kuratidza chete zvinyorwa zvine chekuita nekutengesa. nemutengesi iyeye. Otomatiki mafirita zvakare anobvumidza iwe kutsvaga chaiwo kukosha mukati mechikamu uye uvanze humwe hunhu. Izvi zvinonyanya kubatsira kana iwe ukashanda nemaseti makuru e data uye uchida kukurumidza kusefa ruzivo rwakakodzera.
Mafirita epamusoro
Mafirita epamberi chishandiso chine simba muExcel kuita zvakanyanya kuoma uye kutsvaga kwakananga. Nemasefa epamberi, unogona kuseta akawandacriteria yekusefa ruzivo rwako.Unokwanisa kusanganisa zvinhu zvine musoro, sekuti ”uye”, ”kana” kana “kwete” kuti uenderere mberi nekukwenenzvera kutsvaga kwako. Semuenzaniso, kana iwe uine spreadsheet ine ruzivo rwekutengesa uye iwe uchida kusefa zvinyorwa zvevatengesi vakawana chimwe chinangwa chekutengesa uye zvakare kuve nekambani nekambani kwemakore anopfuura mashanu, unogona kushandisa sefa yepamusoro kuita basa iri. . Nemasefa epamberi, unogona kuita tsvakiridzo dzakanyanya uye kuwana mibairo chaiyo mumaspredishiti ako eExcel.
Mashandisiro ekutanga mafirita muExcel
Mafirita chishandiso chinobatsira kwazvo muExcel chinokutendera kuti uronge nekuona data rako zvakanyanya. Nemasefa ekutanga, unogona kuongorora nekukasira wowana ruzivo rwaunoda mumaspredishiti ako. Kuti ushandise mafirita ekutanga muExcel, tevera matanho ari nyore:
1. Sarudza huwandu hwe data: Kutanga, sarudza dhata re data raunoda kuisa sefa. Unogona kuita izvi nekudzvanya nekukweva cursor kubva kumusoro kuruboshwe sero kuenda kuzasi kwerudyi sero yemhando yaunoda.
2. Shandisa sefa: Kana uchinge wasarudza rudzi rwe data, enda ku "Data" tab mubhari yemenyu uye chengeta pa "Filter" bhatani. Iwe uchaona miseve yekusefa ichiwedzerwa kumusoro kwekoramu yega yega mune yakasarudzwa.
3. Sefa data: Iye zvino unogona kusefa data rako nekudzvanya miseve yekusefa uye kusarudza sarudzo dzekusefa dzaunoda kushandisa. Semuyenzaniso, kana uchida kusefa mutsara wemazita nezita chairo, ingobaya museve wesefa wekoramu iyoyo wosarudza zita raunoda kubva pakarongwa rekudonhedza pasi. Excel inongoviga mitsetse yausingasangane nesefa yakasarudzwa. maitiro.
Rangarira kuti iwe unogona kuisa akawanda mafirita zvose uye zvakare batanidza nzira dzakasiyana dzekusefa kuti uwedzere kukwenenzvera mhedzisiro. Edza neakakosha mafirita uye tsvaga maitiro aungaita nguva uye kurerutsa yako yekuongorora data! data muExcel!
Mazano ekushandisa mafirita epamusoro muExcel
Excel chishandiso chinogoneka chinogona kubatsira kuronga uye kuongorora huwandu hukuru hwe data. Chimwe chezvinhu zvinobatsira zveExcel mafirita epamberi. Aya mafirita anotendera iwe kuti uite tsvakiridzo yemunhu pairi madhatabhesi yakakura, izvo zvinoita kuti zvive nyore kuziva maitiro akakodzera uye maitiro. Pazasi zvinoratidzwa Mamwe matipi ekushandisa epamberi mafirita muExcel uye shandisa zvakanyanya izvi basa.
1. Dzidza kushandisa mashandisirwo ane musoro nemazvo-Nekushandisa mafirita epamberi, unogona kusanganisa nzira dzakasiyana dzekutsvaga uchishandisa zvine musoro maopereta senge AND, OR, uye NOT. Izvi zvinokupa kuchinjika kuita tsvakiridzo dzakaoma uye kuwana mhinduro chaidzo. Izvo zvakakosha kuti unzwisise mashandiro anoita maopereta aya uye kuti ungaasanganisa sei kuti uwane mhedzisiro yaunoda.
2. Shandisa maitiro ekutsvaga nemazvo: Imwe yemabhenefiti epamberi mafirita ndeyekuti unogona kuseta akawanda maitiro ekutsvaga kuti unatse zvawawana. Kuti uite izvi zvakanaka, shandisa maitiro chaiwo uye akakodzera. Semuyenzaniso, kana iwe uchitsvaga kutengesa kune yakatarwa date, funga kumisa maitiro akaita se "chikuru pane" kana "chishoma pane" pane kungoisa zuva renji. Izvi zvichakubatsira kuti uwane mamwe echokwadi uye akakodzera mhinduro.
3. Tora mukana wepamusoro kusefa sarudzo: Excel inopa akati wandei ekuwedzera sarudzo kugadzirisa zvaunotsvaga. Semuenzaniso, unogona kushandisa mafirita epamberi kutsvaga yakasarudzika data, kusefa nefomati, kana kutotsvaga neyakajairwa mafomula. Ongorora sarudzo idzi uye ujairane nadzo kuti uwedzere ongororo yako uye uwane mamwe echokwadi uye akakodzera mhedzisiro.
Isa akawanda mafirita muExcel
Mafirita chishandiso chinobatsira kwazvo muExcel chinotitendera kuongorora nekuona data zvakanyanya. Nekudaro, kana isu tichida kuisa akati wandei mafirita panguva imwe chete, zvinogona kunetsa uye kuvhiringa. Sezvineiwo, kune mamwe manomano anogona kutibatsira kushandisa akawanda mafirita nenzira iri nyore uye inoshanda.
Iro rinobatsira zvakanyanya kushandisa iyo yepamusoro sefa basa muExcel. Basa iri rinotitendera shandisa maitiro akawanda ekusefa mutafura imwe chete.Kuishandisa, tinongofanira kusarudza huwandu hwedata hwatinoda kusefa tobva taenda kune "Data" tab wodzvanya pakanzi "Advanced Filter". Mufafitera richavhurika, tinogona kudoma nzira yekusefa yatinoda kushandisa uye, kana yangogadziriswa, Excel inozotiratidza chete data inosangana nemaitiro iwayo.
Imwe nzira inobatsira ndeye kushandisa matafura epivot muExcel. Matafura epivot anotibvumira kuongorora huwandu hwakawanda hwedata nekukurumidza uye zviri nyore. Kuti tiise mafirita akawanda tichishandisa matafura epivot, tinongofanira kusarudza tafura yedata, enda pakanzi “Isa” uye baya pakanzi «Pivot Table» . Tevere, tinogona kudhonza minda yatinoda kushandisa semasefa kune »Mafirita» chikamu chetafura yepivot uye Excel ichatiratidza data rakapepetwa zvinoenderana ne yakasarudzwa maitiro.
Maitiro ekushandisa mafirita etsika muExcel
MuExcel, mafirita chishandiso chine simba chinotitendera kuongorora uye kuronga huwandu hukuru hwe data nemazvo. Nepo Excel ichiuya nemafirita akasarudzika, zvinokwanisika kushandisa mafirita akagadzirwa kuti uwane zvakatonyanya uye zvemunhu mhinduro. Mune ino positi, tichakuratidza matipi akanakisa ekushandisa mafirita etsika muExcel uye optimize basa rako nedata.
Un tsika firita muExcel inokutendera kuti utsanangure nzira yako yekusefa kuti usarudze chete data inokufarira.Kushandisa mafirita ega, unofanira kutevedzera aya matanho:
- Sarudza chikamu chaunoda kusefa.
- Dzvanya iyo "Data" tab pane Excel toolbar.
- Muboka re “Ronga uye sefa”, tinya bhatani rekuti “Sefa” kuti uvhure mafirita.
- Dzvanya museve wesefa pane yakasarudzwa.
- Kubva pane yekudonha-pasi menyu, sarudza "Custom Filter."
- Iye zvino iwe unozogona kuisa yako wega yekusefa uchishandisa iyo iripo maopareta.
Shandisa mafirita akagadzirwa Excel inokupa iwe kuchinjika kuratidza chete data inoenderana nekuongorora kwako. Semuyenzaniso, unogona kusefa yakatarwa zuva renji, kusefa makoshero makuru kana asingasviki imwe nhamba, kana kutobatanidza maitiro ekusefa akawanda. Izvi zvinokutendera kuti uwane ruzivo rwaunoda nekukurumidza pasina kuongorora nemaoko dataset yako.
Maitiro ekurongedza data uchishandisa mafirita muExcel
Mafirita muExcel chishandiso chine simba chinokutendera kuti uronge uye uongorore huwandu hwakawanda hwedata nekukurumidza uye nemazvo.Kushandisa mafirita kunoita kuti zvive nyore kuona mafambiro, kutsvaga hunhu chaihwo, uye kuita ongororo yakadzama.
Paunoshandisa mafirita muExcel, unogona:
– Sefa data nehunhu chaihwo: Unogona kusarudza hunhu hwaunoda kuona uye kuvanza zvimwe. Izvi zvinobatsira kana uine runyorwa rurefu rwe data uye unongoda kuona ruzivo rwakakodzera pakuongorora kwako.
– Sefa data nemaitiro: Iwe unogona kusefa data uchishandisa tsika tsika. Semuenzaniso, unogona kusefa zvigadzirwa zvese zvine mutengo wakakura kupfuura imwe kukosha kana kutsvaga zvese zvinotengeswa zvakaitwa nemumwe mutengesi.
– Sefa data nemafomati: Iwe unogona kusefa data zvichienderana nemafomati akadai semasero mavara kana bold mavara. Izvi zvinobatsira kana iwe uchida kukurumidza kutsvaga maseru anosangana nemamwe maitiro ekuona.
Kuti ushandise mafirita muExcel, tevera matanho aya:
1. Sarudza ikolamu kana huwandu hwedata raunoda kusefa.
2. Enda kune "Data" tab paExcel ribhoni.
3. Baya “Sefa” bhatani kuti zviite masefa muspredishiti.
4. Miseve midiki yekudonhedza pasi ichaonekwa kumusoro kwekoramu yega yega.
5. Dzvanya pamuseve wechikamu chaunoda kusefa uye wosarudza zvaunoda kusefa.
6. Excel icharatidza chete data inosangana neyakasarudzwa yekusefa maitiro.
Rangarira kuti iwe unogona kusanganisa akawanda mafirita kuti uenderere mberi nekunatsa mibairo yako uye kuwana ruzivo chairwo rwaunoda. Edza neakasiyana ekusefa sarudzo dzinopihwa neExcel uye shandisa zvakanyanya iyi inobatsira data sangano chishandiso. Nemafirita muExcel, unogona kuita ongororo yakadzama pasina kutsvaga nemaoko kuburikidza neakakura rondedzero yedata. Gadzirisa basa rako uye uvandudze chigadzirwa chako uchishandisa ichi kiyi Excel mashandiro.
Maitiro ekushandisa mafirita kuratidza kukosha muExcel
Pane nzira dzakati wandei dzekushandisa mafirita muExcel kuratidza hunhu hwatinofarira. Mune ino positi, isu tichaongorora akanakisa matipi uye matekiniki ekuita zvakanyanya zveiyi mashandiro muspredishiti.
Basic filter: Iyo yakakosha sefa ndiyo iri nyore chishandiso kujekesa kukosha muExcel. Kuti tiishandise, isu tinongosarudza iyo data renji yatinoda kuisa iyo sefa tobva taenda kune iyo »Data» tebhu mubharebha rekushandisa. Ikoko tichawana bhatani reSefa, iro kana radzvanywa, rinotiratidzamuseve mudiki pamusoro pekoromo yega yega. Tinogona kudzvanya miseve iyi kusefa kukosha uye kuratidza chete iwo atinoda kuona.
Sefa yepamusoro: Kana isu tichida kuisa mamwe mafirita akajeka uye akaomarara, tinogona kushandisa iyo yepamusoro sefa. Iyi sarudzo inowanikwawo mu "Data" tab, asi mumenyu yekudonha tinosarudza "Advanced Filter" sarudzo. Pano isu tinogona kuseta yakadzama maitiro ekusefa iyo data, senge kuratidza chete kukosha kune yakakura kupfuura imwe nhamba kana kuratidza chete hunhu hune rimwe izwi.
Sefa neruvara uye fomati: Pamusoro pekusefa nehunhu, zvinogonekawo kushandisa mafirita eExcel kuratidza masero ane fomati chaiyo. Izvi zvinonyanya kukosha kana uchishanda nemaspredishiti ane mafomati anosungirwa. Kuti tiite izvi, tinosarudza huwandu hwe data uye tozoenda kune »Kumba» tab. In mudziyo wekushandisa Tichawana bhatani re "Mafirita" uye kana tikadzvanya pairi, isu tichava nesarudzo yekusefa nemavara emavara, kuzadza ruvara, nhamba fomati, pakati pezvimwe.
Nemanomano aya uye matekiniki ekushandisa mafirita muExcel, iwe unozogona kuratidza kukosha kwaunoda nenzira inoshanda uye inodzorwa. Edzai nesarudzo idzi uye muone kuti vangaite sei kuti basa renyu nemaspredishiti rive nyore. Usazeze kuzvishandisa!
Mazano ekushandisa otomatiki mafirita muExcel
Zvekuita wega mafilita muExcel chishandiso chine simba chinokubvumidza kusefa uye kuongorora huwandu hukuru hwedata nekukurumidza uye nemazvo.Nemasefa otomatiki, unogona ronga uye sefa yako data zvichienderana ne maitiro akasiyana, zvichikubatsira kuwana ruzivo rwaunoda zvakanyanya chaizvo.
Imwe yeakanakisa matipi ekushandisa otomatiki mafirita muExcel ndiko kugona gadzirisa masefa ako. Unogona kusarudza maitiro ekusefa akawanda kuti uwane mibairo chaiyo. Semuenzaniso, unogona kusefa data nemazuva, nehuwandu hwehuwandu, kana kunyangwe nemusanganiswa wezvikamu zvakasiyana. Uyezve, unogona kushandisa function advanced sefa kuita kusefa kwakaomarara, sekusefa data kunoenderana nezvakawanda zvakasanganiswa mamiriro.
Imwe nzira inobatsira ndiyo sarudzo sefa nefomati. Ichi chinokutendera kusefa data zvichienderana nechimiro chayo, sekusefa maseru ane duramazwi, maseru asina chinhu, kana maseru anosangana nemhando chaiyo, senge dzakashinga kana dzvuku. Iyi sarudzo inonyanya kubatsira paunenge uchishanda nehuwandu hwe data uye uchida kukurumidza kutsvaga maseru anosangana nemamwe maitiro ekufomatidza. Nekungodzvanya zvishoma, unogona kuwana nekusimbisa maseru aunoda.
Nezvizvi , unogona kuchengetedza nguva nekuvandudza kugona kwako paunenge uchishanda nedata. Kunyangwe iwe uri kusefa data kuti uite ongororo kana kungotsvaga ruzivo rwakananga, otomatiki mafirita chinhu chaunofanira-kuva nacho chekuwedzera kugona kweExcel. Tanga kuongorora uye shandisa zvakanyanya chishandiso ichi chine simba!
Maitiro ekubatanidza mafirita muExcel
Excel chishandiso chine simba kwazvo chekuronga nekuongorora data, uye chimwe chezvinhu zvinobatsira kugona kushandisa mafirita kumaspredishiti. Nekudaro, chii chinoitika kana iwe uchifanira kuisa inodarika sefa imwe panguva? Neraki, Excel inokutendera iwe batanidza mafirita kuti uwane mibairo yechokwadi.
Kubatanidza mafirita muExcel, unogona kutevera matanho aya:
- Isa sefa yekutanga: Sarudza iyo column yaunoda kuisa sefa uye tinya pane "Data" tab mune toolbar. Wobva wadzvanya pa "Sefa" uye sarudza maitiro aunoda kusefa.
- Wedzera sefa yechipiri: Kana wangoisa sefa yekutanga, sarudza iyo column yaunoda kuisa yechipiri sefa. Wobva wadzvanya museve wekudonhedza pasi mumusoro wekoramu uye wosarudza mamwe maitiro.
- Sanganisa ma filters: Zvino zvawashandisa ese mafirita, Excel ichabatanidza maitiro ekukuratidza chete iyo data inosangana nemamiriro ese ari maviri.
Kubatanidza mafirita muExcel ndeye nzira inoshanda ye natsa mhinduro dzako uye uwane ruzivo rwaunoda.Yeuka kuti unogona kusanganisa masefa akawanda sezvaunoda, ingotevera matanho aya pasefa imwe neimwe yaunoda kuisa. Uyezve, yeuka kuti iwe unogona zvakare bvisa mafirita mumwe nemumwe kana gadzirisa masefa ese kutanga zvakare.
Maitiro ekushandisa mafirita kugadzira machati muExcel
Mafirita chishandiso chine simba muExcel chinokutendera kusefa uye ongorora data zvinobudirira. Nemasefa, unogona kuratidza chete data inosangana nemamwe maitiro uye kuviga zvimwe zvese izvi zvinonyanya kubatsira kana iwe uchishanda nemahombe data seti uye uchida kutarisa pane imwe chikamu kana subset.
Kuti ushandise mafirita muExcel, unofanira kutanga wasarudza huwandu hwedata hwaunoda kuisa sefa.Izvi zvinogona kuitwa nekusarudza maseru kana nekudzvanya kumusoro kuruboshwe kwechikamu uye kudhonzera kuchikamu chepasi chekurudyi. Kana uchinge wasarudza rudzi, enda ku "Data" tab mubhari rekushandisa uye tinya bhatani re "Sefa". Iwe uchaona miseve madiki yakawedzerwa kumusoro kwekoramu yega yega, zvichiratidza kuti mafirita ari kushanda.
Kana wangobatidza mafirita, unogona kushandisa miseve iri mumusoro maseru kusefa data.Semuyenzaniso, kana uri kushanda netafura yekutengesa uye uchida kuona zvinotengeswa chete kwemwedzi wakati, tinya museve. zvinoenderana nekoramu yemwedzi uye sarudza mwedzi waunoda. Izvi zvinongozvivanza mitsara yese isingaite izvo uye zvinongoratidza data rakasefa. Iwe unogona zvakare kushandisa akawanda mafirita maitiro, uchisarudza akawanda sarudzo kubva kune iyo sefa runyorwa.
Ini ndiri Sebastián Vidal, injiniya wekombuta anofarira nezve tekinoroji uye DIY. Uyezve, ndini musiki we tecnobits.com, kwandinogovera zvidzidzo kuti tekinoroji iwanikwe uye inonzwisisika kumunhu wese.